How to use Pivot Tables in Google Sheets (Tutorial)

Using pivot tables in Google Sheets is one of the best ways to analyze your spreadsheet data. You can learn what all those rows and columns really mean no matter how much data is in your Google Sheet. In this video, Scott Friesen shows you how to get started with pivot tables even if you are a beginner.

Get more sales with Pipedrive:

0:00 Why using Pivot Tables is important
0:45 How to start a Pivot Table in Google Sheets
1:35 Understanding the layout of a Pivot Table
2:29 Adding Rows to your Pivot Table in Sheets
4:00 Adding Columns to your Pivot Table in Sheets
4:44 Selecting Values for your Pivot Table in Sheets
5:40 Changing Values in the Pivot Table
7:04 Adding & Editing Filters in the Pivot Table

► SUBSCRIBE to the Simpletivity channel:

► Get your FREE productivity guide:

► Visit the website:

Let’s Connect!

Scott Friesen is a productivity specialist and founder of Simpletivity training and consulting. He is also a prolific public speaker, workshop leader, and time management coach.

​​Icons made by Freepik from
#simpletivity #pivottable #googlesheets

Related Posts

Google Sheets: Getting Started

Google Sheets: Getting Started

Facebook0Twitter0Google PLuse00Shares 1 Views In this video, you’ll learn more about getting started with Google Sheets. Visit for our text-based lesson. We hope you enjoy!

Google Sheets: Create Pivot Tables and Charts

Google Sheets: Create Pivot Tables and Charts

Facebook0Twitter0Google PLuse00Shares 794 Views A step-by-step example of how to create a pivot table and associated chart in Google Sheets. To visit our Google Workspace blog, click…

Language »
Thanks !

Thanks for sharing this, you are awesome !