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 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.

View all Microsoft Apps courses

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

Prerequisites

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.