The PivotTable, introduced into Excel in the 1990s, allows for the dynamic cross tabulation of data from within workbooks and from external data sources to allow for the easy aggregation and analysis of data by end-users. This session covers all the fundamental knowledge about how PivotTables work, how to build and manage them, how to add calculations and control the outputs from the analysed data.

It covers important issues which are not well understood by many users which address problems with the formatting and analysis of data in the PivotTables. Improvements in the PivotTable engine in the more recent versions of Excel are covered. Useful filtering and sorting techniques are demonstrated. It also covers the use of Slicers, introduced in Excel 2010 and Timelines that were introduced in Excel 2013.