PivotTables

This course presents the key points in building PivotTables using video guides and Excel walkthrough files. It will highlight key mistakes and design aspects to avoid when creating PivotTables, and give insight on the design approaches to take to ensure that your PivotTables are not only robust, but efficiently highlight trends in data.

We also give you tips on what sort of tables to create depending on the type of data you are working with. This course covers what a PivotTable is, how to format and set value fields, apply filters, grouping and slicers, create PivotCharts and develop an interactive dashboard.