Location: Online
Available Spaces: 18
Contact Details: Marc Watson: marc.watson@nhs.net
Description
Understanding the process behind the creation of charts to graphically represent pivot table data.
Prerequisites
A good working knowledge of Excel.
Ideally, previous attendance of “Introduction to Creating Charts” and “Introduction to Pivot Tables” courses or equivalent experience.
Course outline
- Getting your raw data right
- Adding a Pivot Chart
– From raw data
– From existing pivot table - PivotChart vs PivotTable fields
- Filtering your PivotChart
- Formatting your chart
The session will take between 30-40 minutes to complete and is followed by a Q & A which is optional to attend.