Download our guide to end user applications

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

Prerequisites

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.