This is the second part of our Excel Intermediate classes, and it is focused on presenting and analyzing data using PivotTables. We cover PivotTables from the ground up teaching all the fundamental concepts. Then we go into more advanced topics like PivotTable calculations, PivotCharts, and integrating PivotTables and PivotCharts into robust dashboards. After taking this class, we highly recommend you take the third part of this class which is Excel Intermediate Part 3.

For the best results, participants should be familiar with the topics covered in the Excel Introduction and Excel Intermediate Part 1 classes.

• Preparing the Data
• Anatomy of a PivotTable
• Slicing and Dicing with a PivotTable
• Grouping Data
• Sorting Data
• Custom PivotTable Field Names
• PivotTable Slicers
• PivotCache
• Refreshing Data

• Customize Subtotals
• Showing Values as Calculations
• Calculated Fields
• Calculated Items

• Creating a PivotChart
• PivotChart Control Buttons
• PivotChart and PivotTable Filters