This half-day course is intended for all Microsoft Excel users to better understand how PivotTables can help you to make sense of large data sets.
We will cover how to create Pivot Charts from your data, how to use field grouping techniques to extract meaningful summaries of your data, and how to analyse data with conditional formatting techniques.
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:
Work with data tables
Work with subtotals
Create and work with PivotTables
Analyse data with Conditional Formatting
Microsoft Office Applications 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 would like to expand their knowledge and learn more of the techniques associated with PivotTables and Data Analysis.
Course subjects
Lesson 1: Working with Data Tables
Creating a data table
Adding data to a data table
Creating formulas in a data table
Applying filters to a data table
Lesson 2: Subtotals
Creating subtotals
Expanding and collapsing detail in subtotalled data
Removing subtotals
Lesson 3: Creating and Working with PivotTables and Charts
Creating a PivotTable
Removing fields from a PivotTable
Filtering in a PivotTable
Using slicers and timeline in a PivotTable
Sorting in a PivotTable
Applying number formatting to a PivotTable
Adjusting PivotTables
Extracting data from a PivotTable
Creating and modifying Pivot Charts
Lesson 4: Conditional Formatting
Applying data bars
Applying basic conditional formatting
Removing conditional formatting
Prerequisites
This course assumes the user has completed a Microsoft Excel intermediate-level course such as Excel 2019/365 Part 2 or Excel 2016 Part 2, or has 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.