Excel: Analysing your data with pivot tables

  • course pack | Oxford only | v. 2010

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