Description
COURSE OBJECTIVE:
This course will furnish you with the skills to be able to create and
modify a Pivot Table in order to analyse your data in the most
appropriate manner. You will also be able to change the automatic
calculations and format the datausing the automatic formatting features.
COURSE FORMAT:
The course involves explanation, demonstration and hands-on practice,
working through exercises that build on your existing skills and enhance
the functionality of spreadsheet data.
PREREQUISITES:
As the course involves creating calculations, participants should be
experienced in creating basic formulas. This course is not suitable for
Excel beginners.
CONTENT
• Understand the purpose of a Pivot Table
• Create a Pivot Table
• Work with Pivot Fields
• Filter Pivot data
• Change the calculation in a Pivot Table
• Show data as percentage calculations
• Group Pivot Table Data
• Refreshing Pivot Table data
Duration: 2 hrs
Cost: Free
Suitability: Staff
|
