A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!

Update a PivotTable When Data Changes If you make any changes to the data in the original list from which you created the PivotTable, you need to update the PivotTable to reflect these changes.

If you are getting the Data source reference is not valid while trying to create a pivot table in Microsoft Excel, see this post for the fix.

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.