Excel - Pivot Table Specialist

Build and customise Pivot Tables

Group and sort information

Filter information

Use slicers and the timeline filter

Add different summary calculations

Create Pivot Charts

Add calculated fields and items

Using a Pivot Cache

Building a Pivot Table

The Pivot Table interface

Refreshing the Pivot Table

Adding column, row, page and data fields

Changing data orientation

Showing data fields in columns or rows

Drilling down to underlying data

Format options

Totals and filters options

Display and printing options

Data options

Modifying field names

Data formatting

Changing field layout options

Changing summary calculations

Working with subtotals

Filtering items

Sorting data

Value and label filters

Creating top 10 reports

Using the Search filter

Using the Slicer tool

Use the Timeline filter

Grouping date fields

Grouping numeric fields

Adding your own groups

Running totals

Differences year on year, month on month

% Differences year on year, month on month

% of Row, Column, Total and other fields

Pivot Chart rules

Creating a Pivot Chart

Working with your Pivot Chart

Adding calculated fields

Adding calculated items