Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Complete Introduction to Google Sheets Pivot Tables
Rating: 4.7 out of 5(3,564 ratings)
9,614 students

Complete Introduction to Google Sheets Pivot Tables

Summarize thousands of rows in Google Sheets with pivot tables, charts, filters and slicers - no formulas needed
Created byIan Littlejohn
Last updated 8/2026
English
English [Auto],French [Auto],

What you'll learn

  • Structure your data so pivot tables work first time - the step most people skip
  • Build pivot tables in Google Sheets that summarize thousands of rows in seconds
  • Aggregate with Sum, Count, Unique Count, Average, Median, Max and Min, and combine them in one table
  • Write custom calculated fields that answer questions the standard aggregations cannot
  • Create comparison, stacked, line and area charts straight from your pivot table data
  • Analyze trends over time using custom date fields, then chart them
  • Filter and slice your data with text, number and date filters, and with interactive slicers
  • Run contribution analysis to show what each product, region or customer is worth as a percentage of the whole
  • Group and analyze HR data by age and salary band, and highlight what matters with conditional formatting

Course content

10 sections • 58 lectures • 2h 50m total length

  • Introduction to the Course1:54

    An overview and introduction to the course

  • About the Course1:23

    Improve your learning experience by ensuring high‑quality, full‑HD video and reliable internet, use the Udemy support site for certificate questions, and adjust video speed to your pace.

  • Download the Training Data Sets0:04
  • Setup the Training Data Files2:53

Requirements

  • A free Google account. Google Sheets is free and nothing in this course needs a paid Google Workspace plan.
  • You should be able to enter data into a spreadsheet and sort a column. No formula experience is needed - the point of pivot tables is that you do not write any.
  • Works in any browser, on Windows, Mac or Chromebook.

Description

This course contains the use of artificial intelligence.

Every lesson in this course is written, created and recorded by me. AI is used only to help produce supporting images and written materials around the lessons.

Every month you rebuild the same report by hand. Sales by region. Headcount by department. Spend by category. You copy, you sort, you total, and next month you do it all again.

Pivot tables are how you stop. In Google Sheets you can summarize thousands of rows into an answer in about four clicks, chart it, filter it, and rebuild it next month without writing a single formula.

This course teaches that from start to finish in under three hours. It is for people who want Google Sheets to do the work for them.

WHAT YOU WILL BE ABLE TO DO

  • Structure your data so pivot tables work first time

  • Build pivot tables that summarize thousands of rows in seconds

  • Aggregate with Sum, Count, Unique Count, Average, Median, Max and Min

  • Write your own custom calculated fields

  • Create comparison, stacked, line and area charts from pivot table data

  • Analyze trends over time with custom date fields

  • Filter and slice your data with text, number and date filters, and with slicers

  • Run contribution analysis - what each product or region is worth as a percentage

  • Group and analyze HR data by age and salary band

  • Apply conditional formatting with rules and colour scales

HOW THE COURSE WORKS

Nine short sections, each opening with a one-minute overview. Teaching videos run four to seven minutes. Every section ends with a practical activity - a written brief you work through on the training data, followed by a walkthrough video showing you how I would do it. Download the training data in section one and build along with me.

You work on real sales and transaction data for most of the course, and a separate human resources data set for the frequency, age and salary grouping section. Both are provided.

ABOUT THE TRAINER

I have been training business people to work with data since 2008 and publishing on Udemy since 2013. I now have 16 courses on Udemy, more than 460,000 enrolments and more than 139,000 reviews, at an average rating of 4.6. This course is rated 4.7 from more than 3,500 ratings.

I specialise in teaching business users the analysis rather than just the tool - the methods that turn data into information you can act on - using Microsoft Excel, Google Sheets, Microsoft Power BI, Google Data Studio, Amazon QuickSight and Copilot in Excel.

WHAT STUDENTS ARE SAYING

  • "This course is really amazing i would say it's easy to understand and to follow"

  • "The size of the lessons are perfect, the instructor moves very clearly throughout each topic"

  • "Ian is a phenomenal trainer. The course is easy to follow, digest, and provides practical hands on experience"

Ready to stop rebuilding that report by hand? Start with section one and let's build your first pivot table.


Who this course is for:

  • Google Sheets users who can enter data and sort a column, and now need to summarize thousands of rows without writing formulas
  • Excel PivotTable users moving to Google Sheets, who want to know what is the same, what is different and what is missing
  • Analysts, managers and business owners who keep their data in Sheets and rebuild the same report by hand every month
  • Not sure this is the right course? If you want these skills in Excel rather than Google Sheets, take Complete Introduction to Excel Pivot Tables instead.
  • If you want to build shareable dashboards on top of your Sheets data, take Complete Introduction to Google Data Studio next.

Report abuse