If you’ve ever been handed a spreadsheet with thousands of rows and asked to produce a summary report, you’ll know the sinking feeling that comes with it.
Pivot Tables are Excel’s answer to that problem and in this episode, Mike shows just how quick and powerful they really are.
Using his fictional ice cream company as a demo dataset, Mike walks through creating a Pivot Table from scratch, rearranging fields to get different views of the data, and switching between totals, averages, and percentages, all without writing a single formula.
The episode also covers Pivot Charts, how to refresh your Pivot Tables when the source data changes, slicers for visual filtering, and the slightly quirky Show Report Filter Pages feature.
Whether you’ve been avoiding Pivot Tables or just never quite got to grips with them, this episode makes the case that they’re one of Excel’s most valuable and most approachable features.
Resources