Objectives
• Recognize the underlying concepts and conventions that drive PivotTable operation.
• Recall four important components used when creating and working with PivotTables.
• Recognize the benefits of using Excel tables, not only with PivotTables but as stand-alone objects.
• Indicate ways to improve data presentation in PivotTables.
• Recognize calculations including calculated fields and calculated items, and
• Indicate how to create and modify Pivot Charts.
Major Topics
This session is taught using a Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor for a greatly improved learning experience. The topics discussed in this session include:
• Introducing PivotTables.
• Working with tables.
• Connecting PivotTables to external data.
• Creating calculations in PivotTables.
• Using PowerPivot and creating Pivot Charts.
