Learn Excel Pivot Tables in under an hour!

Features Includes:
  • Self-paced with Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App

Course Preview Video

  • Categories

    Productive Expertise & Efficiency

  • Duration


  • 69 Students Enrolled


If you've been tasked with summarising a large amount of data, or need to know how to create Pivot Tables, look no further. This course will take you from the basics of what is a Pivot Table, to creating visually impressive reports with ease. 

You'll be able to quickly analyse data from large worksheets into manageable reports. The course will take you through creating a Pivot Table and best practices, Grouping data to help when summarising, using powerful filtering with Slicers and illustrating your data with Pivot Charts.

Pivot Tables are a great tool to master for any situation or any role where reporting is required. 

Who is the target audience?

  • Any Excel user who requires an introduction to Pivot Tables. You should already be familiar with the basics used to working with large amounts of data.

Basic knowledge
  • You'll need Excel 2010, 2013 or 2016 installed and a desire to learn about how Pivot Tables can work for your large data set

What will you learn
  • Understand what Pivot Tables are and when to use them
  • Create a Pivot Table report
  • Utilize the tools available for summarising data
  • Work with Slicers and Create Pivot Charts
Course Curriculum
No of Lectures: 6 Total Duration: 00:56:07
Derrall Farmer – April 19, 2021

Kelley KyleHoover – February 10, 2020