Almost every month, I suggest the Subtotal feature to a reader. It's an easy-to-use feature that summarizes data by groups. You define the group and the summarizing function; Excel does the rest. This ...

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...

Have you ever felt overwhelmed staring at a massive Excel spreadsheet, unsure how to extract the exact data you need? Whether you’re managing sales figures, tracking inventory, or analyzing project ...

In this video, you'll learn three methods to SUM and COUNT cells in Excel based on cell color, as Excel does not have a built ...