Pivot Tables in Google Sheets
Gain crucial insights by mastering Google Sheets' most powerful tool, Pivot Tables.
Ever wondered what the heck a Pivot Table is, and why you should care about them?
This course is designed to teach you the ins and outs of pivot tables using real-world datasets, and it's a fit for beginner and intermediate level Google Sheets users.
Through a series of video tutorials, you'll learn techniques and best practices for working with pivot tables to analyze and report on your data -- saving you hours of tedious, repetitive work, and helping you get accurate results with your work.
Learn how to use Pivot Tables and get insights from your data efficiently.
This course will set you up to:
- Understand what Pivot Tables are
- Understand why you should use Pivot Tables
- Understand when to use Pivot Tables
- Create your own Pivot Tables to answer questions about your data
- Best practices for doing all of this...
- ...and much, much more!
Pivot Tables are much faster and much easier than formulas in many cases!
Each lesson is taught through bite-sized, action-oriented 5 - 10 minute-long videos, covering practical techniques you can apply to your own work.
Working with real-world examples, including example datasets from industries like sales, human resources and real-estate, you'll learn how to make the most of your business data today.
Now you can learn Pivot Tables, using the same techniques and best practices I’ve spent the past 15 years learning.
This comprehensive course will teach you the key techniques in Pivot Tables, even if you’re new to this topic.
"Now I know how to create Pivot Tables.
I’ve been making “Pivot Tables” wrong for years, entering all of the raw data myself. I am now able to make a Pivot Table that will update as needed.
I will definitely be on the lookout for additional courses from Ben."
- Rachelle L.
"My pivot table knowledge was pretty basic before this course and I am confident to say that I am now going to be able to implement them into my data analysis workflow.
This course also took my efficiency to the next level which is exactly what I needed as more of my time and analysis is starting to take place in sheets. I can't recommend this enough."
- John R.
"I am an academic librarian who has worked for years with massive raw data sets and pivot tables, and even gives related presentations at our regional conferences, and yet I learned from Ben's course several very useful tips and techniques that I didn't already know about and that will save me a lot of work."
- Melissa B.
What are Pivot Tables?
Pivot tables are a tool inside Google Sheets that lets you quickly and easily analyze, explore, summarize and present your data. They are arguably the most powerful feature of Google Sheets.
Using a familiar drag-and-drop interface, you can answer vital business questions by exploring your data interactively.
Pivot tables transform huge datasets, with potentially thousands or tens of thousands of rows, into meaningful, simple reports, giving you insight into your data.
Why should you care?
Pivot tables are THE fastest way to get insight into your data in Google Sheets.
To replicate what pivot tables can do with formulas alone is tedious, time-consuming and error prone. And should you need to make any changes, you'll be sorry you didn't learn how to use a pivot table.
They are simply the quickest and most flexible way to explore your data and create nicely formatted reports.
This training course runs through professional techniques and best practices with pivot tables, to analyze your data in Google Sheets.
Once you've grasped these concepts, you (and your boss!) will feel confident that your conclusions are based on sound data.
What this course covers
- Pivot Tables!
- This course covers Pivot Tables from top-to-bottom. Even if you've never seen a Pivot Table before, you'll soon be creating your own with confidence.
- Advanced techniques like calculated fields and data extraction with special formulas.
- Best practices for working with pivot tables in Google Sheets.
- Tips and tricks, such as shortcut keys, to make your workflow more efficient.
I'm confident you won't find a more comprehensive course on Google Sheets Pivot Tables anywhere else.
What this course does not cover:
- How to analyze your datasets or how to build dashboard reports (see my dashboard course if that's what you want to learn).
- How to use the scripting language, Apps Script, to work with data.
- How to create data visualizations or charts from your data.
Enroll now to get:
✅ Actionable, bite-size video lessons teaching Pivot Table topics
✅ All the datasets for you to follow along
✅ Access to the private course Facebook group for Q&A
✅ Certificate upon completion
Resources you get with this class:
💡 Access to the private course Facebook group
Your enrollment is backed up with support.
There’s a private Facebook group for students, where you can ask questions, share your insights and knowledge, share your wins, and connect with other students.
I’ll be hanging out there to answer your questions.
💡 Lifetime access to the course
Your enrollment in the Pivot Tables in Google Sheets course comes with lifetime access to the materials.
That way you can take a break from the material if you’re out of town, on vacation, or just swamped for a few days.
Interruptions happen, and your course videos will ALWAYS be here for you when you’re ready. This lifetime access also includes all future updates and upgrades at no extra charge.
This is my way of ensuring that Pivot Tables in Google Sheets remains an excellent long-term investment for you and your business.
💡 Certificate of Completion
Want to show off your newly acquired skills?
You’ll automatically get a certificate upon completing the course, which you can share or post on Linkedin.
Who is this course for?
- Anyone who works with data in Google Sheets -- maybe you're a data analyst, a marketer, an educator, a scientist or someone in between.
- Anyones curious to learn more about working with data and Pivot Tables.
- Anyone who wants to learn best practices and how to be efficient with data.
- Anyone who wants to add new skills that will help you advance your career.
What are the prerequisites?
- A Google account.
- Access to Google Sheets.
- Basic familiarity with Google Sheets and spreadsheets.
- No assumptions are made about prior knowledge of functions or pivot tables -- all the topics are covered comprehensively from scratch, at a comfortable pace.
Hi! I'm an experienced data analytics instructor and freelance spreadsheet developer.
I help individuals and businesses better understand their data through analytical insights and visualizations.
Over 20,000 professionals from 1,000+ companies have enrolled in my training courses, including employees from PwC, Netflix, Verizon, Google, Capital One and other Fortune 500 companies.
My training has helped 1,000’s of people advance their careers. I’ve also helped small and large organizations migrate from Microsoft Excel and Office to Google Sheets and G Suite.
Google recognized me as a Google Developer Expert for G Suite Technology in 2019, one of only a handful worldwide.
I work primarily with Google Sheets and Apps Script, and also have extensive experience with Google Data Studio, Microsoft Excel, SQL and Tableau. I've previously taught data courses and workshops for General Assembly in Washington, D.C..
StartLesson 8: Working with Dates (2:48)
StartLesson 9: Calculated Fields (2:37)
StartLesson 10: Show As Percentage (5:38)
StartLesson 11: Pivot Table Options (5:32)
StartLesson 12: Getting data out of Pivot Tables the right way (7:57)
StartLesson 13: Using Pivot Tables to check data accuracy (5:29)
StartLesson 14: Other uses for Pivot Tables (8:58)