Course curriculum

  • 1

    Welcome to the course!

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

    Create a Spreadsheet

    • Create a Spreadsheet - Video
    • Create a Spreadsheet - Text
  • 4

    Use Cell References

    • Use Cell References - Video
    • Use Cell References - Text
    • Use Cell References - Quiz
  • 5

    Create Formulas

    • Create Formulas - Video
    • Create Formulas - Text
    • Create Formulas - Quiz
  • 6

    Sort and Filter

    • Sort and Filter - Video
    • Sort and Filter - Text
    • Sort and Filter - Quiz
  • 7

    Share and Protect

    • Share and Protect - Video
    • Share and Protect - Text
  • 8

    Pivot Tables

    • Pivot Tables - Video
    • Pivot Tables - Text
    • Pivot Tables - Quiz
  • 9

    Top 10 Functions

    • Top 10 Functions - Video
    • Top 10 Functions - Text
    • Top 10 Functions - Quiz
  • 10

    Protect, Hide, and Edit Sheets

    • Protect, Hide, and Edit Sheets - Video
    • Protect, Hide, and Edit Sheets - Text
  • 11

    Wrapping up

    • Copy of Before you go...

Course Information

  • Experienced Instructor

    I'm Adam Steinfurth (AKA Prolific Oaktree) and I work on different clients' spreadsheet 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 quizes. 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.

Reviews

 wounsel

To the point

wounsel

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.