Auldhouse Anywhere

Auldhouse Anywhere

Our range of Auldhouse Anywhere courses enable you to join live classroom training online – saving you time and money on travel.

Find out More
E-Learning

E-Learning

Discover the benefits of taking a course online at your own pace.

Find out More
Webinars

Webinars

Auldhouse deliver a number of vendor specific webinars. Webinars give you an effective training option with the freedom to attend from virtually anywhere.

Find out More

Excel Data Analysis with PivotTables

Code:
EXLPT
Days:
3 Hours
Price:
$250 excl GST
Code:
EXLPT
Days:
3 Hours
Price:
$250 excl GST
CPD Eligible
3 cpd hour(s)
Overview:
Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever.

You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Download Course Outline
Course Outline (PDF)

Objectives:

Upon successful completion of this course, you will be able to use Excel 2016 advanced PivotTable functionality to analyse your raw data.


You will:
• Prepare data for PivotTable reporting and create PivotTables from various data sources.
• Analyze Data Using PivotTables.
• Work with PivotCharts.

Prerequisites:

To ensure your success in this course, it is recommended that you have completed courses Microsoft Excel - Data Analysis and Reporting or possess equivalent knowledge.

Register now for this course

Please take special note of the course prerequisites as it is important that you meet these requirements before attending the course. If you have any questions about dates or locations please dont hesitate to make an enquiry contact us on 0800 835 835.

Auckland

Wellington

No classes currently scheduled in your location?Enquire about this course

Interested in a private class? Enquire about a private class