Excel users that manipulate, analyze or present data can improve their productivity with PivotTables. Many avoid them, believing they’re confusing and hard to use. Others don’t realize the depth of their capabilities.
Gain an understanding of PivotTable conventions, overcome your intimidation, and master robust features. Also, discover Excel Tables as both a stand-alone feature and as a means to enhance PivotTable reporting.
Recognize the underlying concepts and conventions that drive PivotTable operation
List four important components used when creating and working with PivotTables
Identify the benefits of using Excel Tables, not only with PivotTables but as stand-alone objects
Explain ways to improve data presentation in PivotTables with:
Recognize automatic and custom groups
Identify PivotTable options
Identify the Design tab of the PivotTable tools ribbon add-In
Recognize formatting, sorting and filtering features in Excel
Understand calculations including calculated fields and calculated items
Create and modify PivotCharts
Working with Excel tables
Connecting PivotTables to external data
Extended PivotTable functionality
Creating calculations in PivotTables
Using PowerPivot and creating PivotCharts
An understanding of Excel conventions.