This is an advanced course in working with large data sets and producing pivot tables to summarise information. It provides a detailed look at the uses for pivot tables and producing graphs from them.
Creating and formatting pivot tables
Expanding and collapsing pivot table data
Filter sort and group pivot table data
Use report filters with pivot table data
Using calculated fields in pivot tables
Creating pivot charts
Using slicers to analyse pivot table data