Google Sheets - Pivot Tables from Beginner to Expert
4.5 (14 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,000 students enrolled

Google Sheets - Pivot Tables from Beginner to Expert

Master everything you need to know to create engaging pivot tables with real-world scenarios
Highest Rated
4.5 (14 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,000 students enrolled
Created by Adam Steinfurth
Last updated 6/2020
English
English
Current price: $16.99 Original price: $24.99 Discount: 32% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 7 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Bring your data to life with easy-to-use pivot tables
  • Summarize large tables of data in seconds
  • Sort, filter, and SLICE the pivot table!!!
  • Prepare raw data for use in a pivot table
  • Add, average, perform statistical analysis, and more
  • Use calculated fields
  • Group your data inside your pivot table
  • Summarize your pivot table by week, month, year, etc.
  • Pull data back out of your pivot table with the GETPIVOTDATA function
Requirements
  • Laptop or desktop computer with an internet connection
  • You should have a beginner to intermediate level understanding of how to use spreadsheets.
Description

Pivot Tables allow you to summarize large tables of data in seconds. This course will give you the knowledge to create powerful pivot tables that bring new insight to your data. You will start off with understanding the purpose of pivot tables and how to prepare raw data to be pivoted. Then, work your way toward grouping data, summarizing it by date, adding calculated fields, and more.

Who this course is for:
  • This course is for any spreadsheet user who needs to create Intermediate to Advanced level Pivot Tables.
Course content
Expand all 20 lectures 59:21
+ Understanding Pivot Tables
3 lectures 05:51

What are pivot tables?

Preview 03:55

Learn why you would want to use a Pivot Table.

Preview 01:35

A quick reference guide to creating and using Pivot Tables.

Pivot Table Introduction
00:21

Basic knowledge about Pivot Tables

Pivot Table Basics
3 questions
+ Creating Pivot Tables
3 lectures 12:25

Learn how to get your data ready for a Pivot Table

Preview 06:26

Test your knowledge of preparing data for a pivot table

Preparing your data
3 questions

Create your first pivot table

Creating your first pivot tables
05:38
Creating Pivot Tables
00:21

Test your knowledge of how to create a pivot table

Creating Pivot Tables
2 questions
+ Intermediate Pivot Tables
6 lectures 24:07

Learn how to add and rearrange columns and rows inside a pivot table

Adding and rearranging columns and rows
03:12

The list of functions that can be used inside a pivot table

Available functions
03:39

Test your knowledge of the functions available inside Sheets pivot tables

Available functions
4 questions
Sort and filter
05:27

Test your knowledge of sorting and filtering pivot tables

Sort and filter
2 questions

Learn how to use slicers to filter data on the fly

Slicers
08:26

Test your slicer knowledge

Slicers
2 questions

Learn to see the data that comprises the pivot table amounts

Drilling down into your pivot table
02:09
Intermediate Pivot Tables
01:14
+ Advanced pivot tables
8 lectures 16:55

How to add calculated fields to a pivot table

Calculated fields
03:57
Calculated fields - Notes
00:12

Group data inside a pivot table

Group data
01:56
Group data - Notes
00:08

Summarize data inside of a pivot table

Summarize by date - Year, month, quarter, etc.
02:27
Summarize by date - Year, month, quarter, etc. - Notes
00:06

Get data back out of a pivot table with this handy formula

Get Data using GETPIVOTDATA Function
07:44
Get Data using GETPIVOTDATA Function - Notes
00:24