End User Applications Category Banner Image

Microsoft Excel - Data Analysis with PivotTables (EXLPT) - 3 hours

  • Length 3 hours
  • Price  NZD 350 exc GST
Course overview
View dates &
book now

Why study this course

This 3-hour course is intended for Microsoft Excel users who already have some experience of basic PivotTables.

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyse that data and gain actionable insight is greater than ever. Excel is capable of much more than basic data presentation. You will not only be able to summarise data for you to analyse, but also organise the data in a way that can be meaningfully presented to others. Harness the power of advanced PivotTable features and create PivotCharts to gain a competitive edge. This leads to data-driven business decisions that have a better chance for success for everyone involved.

This course can be utilised for all recent versions of Excel including 365, 2019, and 2016.

Request Course Information

What you’ll learn

After completing this course you should be able to:

  • Use Excel's advanced PivotTable functionality

  • Prepare data for PivotTable reporting

  • Create PivotTables from various data sources

  • Analyse data using PivotTables

  • Work with PivotCharts

Microsoft Partner Cloud Logo

Microsoft Apps at Lumify Work

Lumify Work is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. Join more than 5,000 students who attend our quality Microsoft courses every year.

Who is the course for?

This course is designed for existing users of Microsoft Excel who wish to expand their knowledge and learn advanced techniques for PivotTables and data analysis.

Course subjects

Preparing Data and Creating PivotTables

  • Prepare Data

  • Create a PivotTable from a Local Data Source

  • Create a PivotTable from Multiple Local Data Sources

  • Create a PivotTable from an External Data Source

Analysing Data Using PivotTables

  • Summarise PivotTable Data

  • Organise PivotTable Data

  • Filter PivotTable Data

  • Format a PivotTable

  • Refresh and Change PivotTable Data

Working with PivotCharts

  • Create a PivotChart

  • Manipulate PivotChart Data

  • Format a PivotChart


It is recommended that you have already completed a Microsoft Excel intermediate-level course such as Excel - Intermediate or possess equivalent knowledge.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.