Got a question? Call 02 8286 9429   |   
Download our guide to end user applications

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

  • Length 3 hours
Course overview
View dates &
book now
  • Register interest

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

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.

What you’ll learn

At the completion of 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 DDLS

DDLS 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 First and largest Microsoft Gold Learning Solutions Partner. All DDLS Microsoft courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.

Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Quality instructors and content

Expert instructors with real world experience and the latest vendor- approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world’s leading vendors as preferred training partner.

Ahead of the technology curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

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 completed a Microsoft Excel intermediate-level course such as Excel 2019/365 Part 2 or Excel 2016 Part 2 or Excel Data Analysis and Reporting, or possess the equivalent knowledge.

Terms & Conditions

The supply of this course by DDLS 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

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.