How to rename fields in a pivot table
In this video, we show you how to rename fields in your pivot table, to tidy things up.
Dave Bruns
How to control subtotals in a pivot table
In this video, we show you how to enable and disable the subtotals that appear in pivot tables.
How to control grand totals in a pivot table
In this video, we show you how to enable and disable the Grand Totals that appear in a pivot table.
How to change the math used for pivot table values
In this video, we show you how to change the math used for value fields.
How to format numbers in a pivot table
In this video, we show you how to format value fields with number formatting, something you'll do often...
How to access field settings in a pivot table
In this video, we show you how to get to the field settings dialog box, the key to controlling fields.
How to rearrange fields in a pivot table
In this video, we show you how to move fields around in your pivot table.
How to add fields to a pivot table
In this video, we show you how to add fields and start building out your pivot table.
Why you should use a table for your pivot table
In this video, we show you how and why to use a table as a data source for your pivot table.
Pivot Table Terminology
In this video, we review (in a mercifully brief fashion) the most important terminology associated with pivot tables.