This session assumes you are familiar with basic functions, basic data manipulation functions (Sort, Filter, etc.) and need to analyse complex spreadsheets including multiple columns and rows.

This session will take you through the basics of creating a Pivot Table and Pivot Chart and developing this to modify them to extract relevant information.  It will help you to understand when to use a Pivot Table and format the result to assist with reporting.  It will also show the use of the “drill down function” to detail data, the use of “Slicer” and how to adjust the Field Settings to modify the format of the data.