Pivot Tables allow you to summarize large tables of data in seconds. This course will give you the knowledge to create powerful pivot tables that bring new insight to your data. You will start off with understanding the purpose of pivot tables and how to prepare raw data to be pivoted. Then, work your way toward grouping data, summarizing it by date, adding calculated fields, and more.

Description

• This course is for any spreadsheet user who needs to create Intermediate to Advanced level Pivot Tables.

Course content

• Understanding Pivot Tables
  • What are Pivot Tables?
  • Why do we use Pivot Tables?
  • Pivot Table Introduction
  • Pivot Table Basics
• Creating Pivot Tables
  • Preparing your data
  • Preparing your data
  • Creating your first pivot tables
  • Creating Pivot Tables
  • Creating Pivot Tables
• Intermediate Pivot Tables
  • Adding and rearranging columns and rows
  • Available functions
  • Available functions
  • Sort and filter
  • Sort and filter
  • Slicers
  • Slicers
  • Drilling down into your pivot table
  • Intermediate Pivot Tables
• Advanced pivot tables
  • Calculated fields
  • Calculated fields - Notes
  • Group data
  • Group data - Notes
  • Summarize by date - Year, month, quarter, etc.
  • Summarize by date - Year, month, quarter, etc. - Notes
  • Get Data using GETPIVOTDATA Function
  • Get Data using GETPIVOTDATA Function - Notes