Course Details
Excel Pivot Tables
Dates will be avalible shortly
Professional Development
Computer Skills / Applications
Victoria University Professional and Executive Development
Level 2, Rutherford House, 23 Lambton Quay, Wellington City
Half Day
9:00am - 12.30pm
9:00am - 12.30pm
$258.75
PivotTables equip you with a way to analyse, report and present data professionally. This course looks at this useful Excel tool and provides you with the skills to use it with your data.
Who Should Attend:
This course is suitable for people who are experienced in using Excel spreadsheets and want to produce PivotTables. It assumes you have good/intermediate Excel skills (for example, you should be confident sorting and filtering data, and creating formulas).
Please note - we are currently using Office 2007 software.
Course Objectives:
* Understand the use of PivotTables to analyse and present data Create and format a PivotTable Report from data
Course Outline:
Getting Started with Pivot Tables
* Why Use a Pivot Table?
* Begin With Data
* Prepare the Pivot Table
* Complete the Pivot Table
Customising the Pivot Table
* Format the Data Area
* Format the Row and Column Areas
* Format the Page Area
* Showing and Hiding Information
* Changing Table Options
* Automatic Formatting
Additional Pivot Table Features
* Refreshing the Pivot Table
* Pivot Charts
Course Format:
This hands-on 1/2 day course is in our Computer Training Suite. Participants will be encouraged to practice and apply the skills covered in the session. You will receive course materials to take away. There will be a maximum of 12 participants. The course is designed to allow for questions and individual focus with participants.
Who Should Attend:
This course is suitable for people who are experienced in using Excel spreadsheets and want to produce PivotTables. It assumes you have good/intermediate Excel skills (for example, you should be confident sorting and filtering data, and creating formulas).
Please note - we are currently using Office 2007 software.
Course Objectives:
* Understand the use of PivotTables to analyse and present data Create and format a PivotTable Report from data
Course Outline:
Getting Started with Pivot Tables
* Why Use a Pivot Table?
* Begin With Data
* Prepare the Pivot Table
* Complete the Pivot Table
Customising the Pivot Table
* Format the Data Area
* Format the Row and Column Areas
* Format the Page Area
* Showing and Hiding Information
* Changing Table Options
* Automatic Formatting
Additional Pivot Table Features
* Refreshing the Pivot Table
* Pivot Charts
Course Format:
This hands-on 1/2 day course is in our Computer Training Suite. Participants will be encouraged to practice and apply the skills covered in the session. You will receive course materials to take away. There will be a maximum of 12 participants. The course is designed to allow for questions and individual focus with participants.
Edwin Hermann