Contact details: Paul Atwell @ paul.atwell1@nhs.net
Description
Demonstration of advanced functionality when using PivotTables.
Prerequisites
A good to advanced working knowledge of Excel. Ideally, previous attendance of “Introduction to PivotTables” course or equivalent experience.
PLEASE NOTE: This is the 12th course in a suggested series of the 14 Excel sessions available.
Course outline
- Formatting data for a PivotTable
- Importance of cleansing data for accuracy
- Benefit of using Format as Table command
- Format as Table using keyboard shortcut
- Creating a PivotTable
- Using the Table Design ribbon
- Multi-level row information
- Collapsing and expanding fields
- Selecting specific row information
- Creating a Calculated field
- Using Grouping
- Automatically included
- Creating manually
- Using Filtering
- Creating a Slicer
- Creating a Timeline
- Linking to multiple PivotTables
The session will take between 30-40 minutes to complete and is followed by a Q & A which is optional to attend.