Course curriculum

  • 1

    Welcome to the course!

    • Intro and how to use this course
    • Before we begin...
  • 2

    Understanding Pivot Tables

  • 3

    Creating Pivot Tables

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

    Intermediate Pivot Tables

    • Available functions
    • Quiz: Available functions
    • Adding and rearranging columns and rows
    • Sort and filter
    • Quiz : Sort and filter
  • 5

    Advanced Pivot Tables

    • Calculated fields
    • Group data
    • Summarize by date - Year, month, quarter, etc.
    • Before you go...

Course Information

  • Experienced Instructor

    I'm Adam Steinfurth (AKA Prolific Oaktree) and I have been working with clients' spreadsheet since the dawn of time (almost). 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. 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 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.