Building on Module A05 - PivotTable Fundaments, this session explores advanced calculations and data analysis settings available in the PivotTable interface which are not utilised by many users, but which provide essential analytical outputs. It also demonstrates some useful solutions to common date-related issues in summarising and collating data by quarter, half year & financial year.

The extraction of data from PivotTables using the GETPIVOTDATA function is demonstrated, including how to make the references more dynamic, enabling the use of a standard block of formulas for a range of reporting needs. Custom sorting and formatting of the PivotTable outputs is demonstrated.