Spreadsheets: Summarising data using pivot tables

  • course pack | Publicly viewable | v. 2013

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.

 

Topics include:

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