Course curriculum

  • 1

    Welcome to the course!

  • 2

    Understanding Pivot Tables

    • What are Pivot Tables?
    • Why do we use Pivot Tables?
    • Pivot Table Basics
  • 3

    Creating Pivot Tables

    • Preparing your data
    • Quiz : Preparing your data
    • Creating your first Pivot Tables
    • Quiz : Creating Pivot Tables
  • 4

    Intermediate Pivot Tables

    • Adding and rearranging columns and rows
    • Available functions
    • Quiz: Available functions
    • Sort and filter
    • Quiz : Sort and filter
    • Slicers FREE PREVIEW
    • Quiz: Slicers
    • Drilling down into your Pivot Table
  • 5

    Advanced Pivot Tables

    • Calculated fields
    • Group data
    • Summarize by date - Year, month, quarter, etc.
    • Get Data using GETPIVOTDATA Function
    • Before you go...

Course Information

  • Experienced Instructor

    I'm Adam Steinfurth (AKA Prolific Oaktree) and I work on different clients' spreadsheets on a daily basis. This course is drawn from this experience and from feedback on the videos and articles that I have created about spreadsheets over the years.

  • Video Based

    The ideas in this course are conveyed through screencast videos supplemented with notes and quizzes. We'll walk through the exact steps needed to create and customize your Pivot Tables and discuss the "how" and the "why" along the way.

  • Shared files

    The spreadsheet files shown in the video are made available to everyone that purchases the course. You can copy them into your own Google Drive and you will have unlimited access to them.



To the point


Excellent tutorial. Straight to the point. Thanks!
 Lindsey J

Google Educator

Lindsey J

Just passed my google educator level 2 exam! Your videos really helped me to prepare. Thanks!
Chris R

Clear and Concise

Chris R

Thank you! Solved my problem very clearly and concisely.