​Pivot Tables

Creating a pivot table

Fields to create row headings

Fields to create column headings

Data in the summary area

Dynamically building a pivot table

Rearranging fields in a pivot table

Number formatting of the data area

Moving pivot tables from one sheet to another or around the same sheet

Deleting a pivot table

Summarising Pivot Table Data

Managing subtotals and grand totals

Changing the data field calculation (Sum, Count, Average etc.)

Sort and Filter

Drilling down to the raw data

Building and using Report Pages

Grouping Pivot Data

Grouping Date Fields

Including Years when Grouping by Months

Grouping Date Fields by Week

Multi Grouping

Pivot Charts

Building Pivot Charts

Editing Pivot Chart Layouts

Editing Pivot Chart Styles

Using the built in chart filter buttons for presentation

Macros

Recording a Macro

Absolute References and Relative References

Run a Macro

Delete a Macro

Assign a Macro to a Button

Viewing the Code behind a Macro

Macro Security