Course Overview

In this Advanced PivotTables in Excel course, we teach you how to make the most of this powerful data analysis function.

In this course, we give a PivotTable refresher before moving onto some of the advanced features of this tool. Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting are just a few of the subjects included in this PivotTable deep-dive.

This course is perfect for intermediate users of Excel who are comfortable using the PivotTable function. We don't recommend this course for people brand new to Excel.

Learning Objectives:

In this course you will learn:

  • How to do a PivotTable (a quick refresher)
  • How to combine data from multiple worksheets for a PivotTable
  • Grouping, ungrouping and dealing with errors
  • How to format a PivotTable, including adjusting styles
  • How to use the Value Field Settings
  • Advanced Sorting and Filtering in PivotTables
  • How to use Slicers, Timelines on multiple tables
  • How to create a Calculated Field
  • All about GETPIVOTDATA
  • How to create a Pivot Chart and add sparklines and slicers
  • How to use 3D Maps from a PivotTable
  • How to update your data in a PivotTable and Pivot Chart
  • All about Conditional Formatting in a PivotTable

This course has a minimum of 25 learner registrations for us to provide a quotation.

Request a Quotation
Language
UK
Date last updated
5/29/2023
Duration
7 Hours 30 Minutes
Suitable Devices
  • PC
  • Tablet
Audio is Required
  • Yes
Includes Video
  • Yes
Downloadable Resources
  • Accessibility Files
  • Exercise Files
Completion Criteria
  • Visit all pages
Pass Mark
  • None
Course Technology
  • HTML5
  • SCORM 1.2
Can be customised
  • No
Accreditation or Endorsements
  • No
Languages
  • English
Image of a SkillStation dashboard

Let's get started

with a demo and a 30-day free trial.