Course Topics
Creating and setting up a PivotTable
- Understanding PivotTables
- Preparing data for PivotTable creation
- Creating a PivotTable
- Defining rows and values in a PivotTable
- Rearranging the fields of a PivotTable
- PivotTable: Adding items from a field as columns
- Moving and deleting PivotTables
Filtering and grouping data
- PivotTable: Grouping data
- Adding a global filter to a PivotTable
- Filtering a PivotTable with a slicer
- PivotTable: Inserting a timeline
Changing the look
- Formatting a PivotTable
- PivotTable: Inserting a blank row after each group item
- Splitting page field items onto separate sheets
- Applying report layouts to a PivotTable
Performing calculations
- PivotTable: Defining the calculation function
- PivotTable: Defining a function for subtotals
- PivotTable: Adding a calculated field
Refreshing PivotTable data
- Updating a PivotTable
- Changing the data source of a PivotTable
Creating and setting up a PivotChart
- Understanding PivotCharts
- Creating a PivotChart
- Selecting and arranging PivotChart fields
Customising a PivotChart
- Changing the calculation function of a PivotChart
- Changing the chart style for a PivotChart
- Changing the chart type of a PivotChart
- Changing the data source of a PivotChart