The training covers these topics:
Creating Pivot Tables
- What is a PivotTable?
- Scrubbing the Data
- Creating the PivotTable on a Range of Cells
- Creating a Pivot Table Based on an Excel Table
- Creating a Pivot Table Based on a Microsoft Access Table
- Changing Data and the Pivot Cache
Drilling Down
- Drilling Down on a Value
- Drilling Down on a Row or Column Label
Sorting in Pivot Tables
- How PivotTable Sorting Works
- Sorting a Pivot Table with Row Labels
- Sorting Values in a Pivot Table
- Manually Override a Sort Order
- Filtering in Pivot Tables
Filtering a Pivot Table by Row
- Filtering a Pivot Table by Column
- Filtering a Pivot Table by Filter Section in the Field List
- Using Report Filter Pages
- Using Slicers to Filter Data
- Setting up a Timeline
Grouping in Pivot Tables
- What is Grouping in a Pivot Table?
- Grouping Based on Dates
- Grouping Based on Labels
- Un-Grouping Pivot Table Data
- Issues with Groupings
Setting Pivot Table Field and Global Options
- Displaying Items with No Data
- Displaying Blank Cells with Other Text
- Setting and Modifying Subtotals
- Setting Custom Subtotal Options
- The Global Options Feature
Report Layout Features
- Adding Blank Rows within your Pivot Table
- Exploring the Three Layout Options
- Setting a Default Layout and Repeating Items
- The Grand Totals Feature
- Using Styles in a Pivot Table
Working with Calculations in a Pivot Table
- Field Calculations in Pivot Tables
- Modifying Field Calculations
- List the Pivot Table Calculations
- Creating a Function Outside of a Pivot Table
Pivot Charts
- What is a Pivot Chart?
- Creating a Pivot Chart
- Filtering and Grouping in Pivot Charts
Enhancing Pivot Charts
Working with the Show Commands
- Showing and Hiding the Field List
- Showing and Hiding Expand/Collapse Buttons and Headers