PivotTables

This course dives deep into one of the most powerful data presentation tools available to Excel. There are no pre-requisites prior to taking this course. At the end of this course, you should be very confident in producing quality PivotTables and PivotTable dashboards that will efficiently provide solutions for data analysis.

This course presents the key points in building PivotTables in interactive slides, video guides and in 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.

The course covers what is a PivotTable, how to format and set value fields, apply filters, grouping and slicers, create PivotCharts and develop an interactive dashboard.

Learning outcomes:

• See how PivotTables turn data into information
• Master creating formulae out of PivotTables in seconds
• Understand how to sort, group and filter elements others tell you can’t be done
• PivotTable Formatting
• Understand how Calculated Fields and PivotCharts can make great interactive dashboards.