Library

Course: Learn Excel Pivot Tables in under an hour!

Learn Excel Pivot Tables in under an hour!

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

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 you will 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
Curriculum
Lectures quantity: 6
Common duration: 00:56:07
Introduction to Pivot Tables
  • Course Outline  
Creating Pivot Tables
  • Creating a Pivot Table  
  • Analysing Data  
  • Grouping Fields  
  • Using Slicers  
  • Adding Pivot Charts  
Reviews (0)