End User Applications Category Banner Image

Microsoft Excel - Data Analysis with Power Pivot (EXLPP) - 3 hours

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

Why study this course

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyse large amounts of data quickly.

Fortunately, Excel provides Power Pivot to help you organise, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximise your effectiveness when analysing data.

Request Course Information

What you’ll learn

After completing this course you should be able to:

  • Get started with Power Pivot

  • Visualise Power Pivot data

  • Work with advanced functionality in Power Pivot

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?

Course subjects

Getting Started with Power Pivot

  • Enable and Navigate Power Pivot

  • Manage Data Relationships

Visualising Power Pivot Data

  • Create a Power Pivot Report

  • Create Calculations in Power Pivot

Working with Advanced Functionality in Power Pivot

  • Create a Key Performance Indicator

  • Work with Dates and Time in Power Pivot


It is recommended that you have already completed a Microsoft Excel intermediate-level course such as Excel - Managing Data and Large Workbooks or Excel - Data Analysis with PivotTables, 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.