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.
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
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.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
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.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
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 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.