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.


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.

Your Instructor


Ben Collins
Ben Collins

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 50,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 Google Workspace.

Google recognized me as a Google Developer Expert for Google Workspace 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 Looker Studio, Microsoft Excel, BigQuery, SQL, and Tableau. I've previously taught data courses and workshops for General Assembly in Washington, D.C..


Course Curriculum



Get started now!



Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
I would never want you to be unhappy! If you are unsatisfied with your purchase, contact me in the first 14 days and I will give you a full refund.
Will I get copies of the datasets?
Yes! All the raw data templates are provided, so you'll have your own copies. The raw data file links are underneath the videos for each lecture.
What if I discover a mistake or want to comment on the material?
Great, I'd really love to hear from you. Drop me a line here.
Why am I being charged VAT?
In order to comply with EU regulations, buyers in the EU will be charged VAT at checkout. This money is passed on to the relevant EU tax collection agency.
Can you provide an invoice for my company?
Yes, of course! After the purchase is complete, please forward me your receipt and the name/address you'd like to see on the invoice and I'll send one right back to you.
Do you offer Parity Purchasing Power discounts?
Yes, I want my courses to be affordable to folks overseas in developing countries, who would otherwise not be able to purchase them. How does it work? Drop me a line with proof of where you're based and which course you're interested in, and I'll be glad to offer you a PPP discount on the course.
Any other questions?
You can reach me here: https://www.benlcollins.com/contact/