Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions. Sometimes you need to know the number of actual data points without counting blank cells.

How sparklines plot values in Excel Sparklines evaluate numerical data and as we all know (all too well), sometimes there are other values other than non-numeric.

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Automating with macros saves time and ensures consistency in repetitive tasks. Cleaning data in Excel is essential for accurate and ready-for-analysis data.

How to Calculate a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.