Tired of duplicates messing up your Excel spreadsheet? Learn how to find and remove duplicates in Excel using multiple methods.

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.

Want to perform powerful data analysis and create complex data models in a spreadsheet? Learn how to use the Power Pivot feature in Excel.

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

This was a particular problem as the PivotTables were being sent out to individual salespeople reporting on their own data - but because the pivot tables had previously been looking at the whole data ...