Pivot Tables are one of the most revered – and feared – elements Of Excel. In this one-hour session we explode some of the myths of creating a Pivot Table and cover Preparing the data, Inserting a Pivot Table, Data Analysis, Grouping and Customising the Pivot Table (including adding Slicers). Intermediate level.