Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

In this video, you’ll learn how to alphabetize a list in Excel using simple built-in sorting tools. We cover the correct way ...

In this video, you’ll learn how to make a dropdown list in Excel quickly and easily using built-in tools. We walk through the ...

Adding a timeline to a project tracking spreadsheet gives you a visual overview of your project’s major stages, including how ...

Handle millions of rows by loading queries into Power Pivot, building relationships, and creating measures for fast variance ...

During the holidays I often write about do-it-yourself projects, and I hear from readers who both compliment and complain. I appreciate the compliments and am happy to consider the complaints (or ...

State lawmakers should respond swiftly to a recent Pennsylvania Supreme Court ruling that would allow elected boards to potentially hide high-profile items from the public agenda. Late last month, the ...