Introduction
  • Course Promo Video!
  • What You Can Expect To Get Out Of This Course
  • Meet The Instructor (Former Googler; Now Data Skills Bootcamp Founder)
  • Why I’m Confident You’ll Enjoy This Course
  • Real World Examples Using Pivot Tables To Surface Data Insights
  • Glossary Of Data Terms We'll Be Using In The Course
  • What Is A Pivot Table?
  • Questions? Feedback? => Message me or see the the course Q&A
Pivot Table Data Insights Process
  • Overview: 5 Key Steps To Generate A Pivot Table
  • Step 1: Load In Data - 4 Common Ways To Load Data Into Google Sheets
  • Ideal Input Data Structure To Make Generating Pivot Tables Easier
  • Step 2: Orient & Trust Your Input Data
  • Orient & Trust Your Input Data
  • Step 3: Draw Your Goal Output Table
  • Draw Your Goal Output Table
  • Step 4: Use The Pivot Table Editor To Configure Goal Output
  • Pivot Table Configuration
  • Step 5: Iterate On Pivot Table Configuration
  • Iterate On Pivot Table Configuration
  • Friendly Reminder! Questions or Feedback? Message the instructor
Applying The Pivot Table Data Insights Process
  • Dataset We’ll Be Using For The Exercises & Lecture Examples
  • Titanic Dataset Questions
  • Titanic Dataset Link (for follow along examples & upcoming exercises)
  • Calculate An Average For A Dataset Variable
  • Basic Summary Statistics For A Dataset Variable
  • Splitting Metrics By A Dataset Category
  • Filter Stats For Only A Segment Of A Dataset
  • Grouping Stats By Multiple Dataset Categories
  • Customer Metrics
  • Adjusting Table Appearance (number formats, sorting, showing totals)
Practice Exercises: Set 1 (Titanic Dataset)
  • Titanic Dataset Link (in case you missed it)
  • Titanic Pivot Table Exercises Quiz
Solution Videos for Practice Exercises: Set 1 (Titanic Dataset)
  • Exercise 1 Solution (Titanic Dataset Exercises)
  • Exercise 2 Solution (Titanic Dataset Exercises)
  • Exercise 3 Solution (Titanic Dataset Exercises)
  • Exercise 4 Solution (Titanic Dataset Exercises)
  • Exercise 5 Solution (Titanic Dataset Exercises)
  • Exercise 6 Solution (Titanic Dataset Exercises)
  • Exercise 7 Solution (Titanic Dataset Exercises)
Practice Exercises Set 2 (Red Wine Dataset)
  • Red Wine Dataset Link for Exercises Set 2
  • Red Wine Pivot Table Exercises Quiz
Solution Videos for Practice Exercises: Set2 (Red Wine Dataset)
  • Exercise 1 Solution (Red Wine Dataset Exercises)
  • Exercise 2 Solution (Red Wine Dataset Exercises)
  • Exercise 3 Solution (Red Wine Dataset Exercises)
  • Exercise 4 Solution (Red Wine Dataset Exercises)
  • Exercise 5 Solution (Red Wine Dataset Exercises)
Course Conclusion
  • Combing Pivot Tables with Charts / Graphs in Google Sheets
  • Using Pivot Tables To Power An Executive Reporting Dashboard
  • Course Wrap Up
  • Continued Learning Resource: Google Sheets Function List (by Google)
  • Continued Learning Resource: 5 Career Building Articles From The Instructor