Download our guide to end user applications

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 Apps at Lumify Work

Lumify Work has been delivering effective training across all Microsoft products for over 30 years. We are proud to be both Australia's and New Zealand’s first Microsoft Gold Learning Solutions Partner and the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers (MCTs) in ANZ. Join more than 5,000 students who attend our quality Microsoft courses every year.

View all Microsoft Apps at Lumify Work courses

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 Power Pivot and data analysis.

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

Prerequisites

It is recommended that you have already completed a Microsoft Excel intermediate-level course such as Excel - Intermediate 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.