Location: Online
Available Spaces: 10
Contact Details: Marc Watson: marc.watson@nhs.net
Description
Demonstration of advanced functionality when using Pivot Tables.
Prerequisites
A good to advanced working knowledge of Excel.
Ideally, previous attendance of “Introduction to Pivot Tables” course or equivalent experience.
Course outline
- Calculated fields
- Grouping
– Included
– Manual - Options
– Sorting
– Column widths - Linking pivot tables
- Using Timelines
- Slicers
The session will take between 45-55 minutes to complete and is followed by a Q & A which is optional to attend.