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.

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

---




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.

#simpletivity #pivottable #googlesheets

[mirrorreflection]

I think everyone will agree with me that we need more videos on pivot table to familiarize ourselves as well get to see other options in Google sheets.
Please like if you agree...

[takingcareofbiz]

Perfect timing! Today I need to create a pivot table in Google Sheets and didn't know how. Thanks for all the useful videos.

[hiraya]

Im literally hired now and only learning about this. Thank you soo much. It's such a big help

[blovermore]

Most helpful pivot table tutorial I've seen on YouTube! Thanks so much!

[mahhinshahzad]

God this is such an amazing turtorial, Been watching an 8 course specialization and in that they made used Pivot tables 4 diffrent table but never was I able to gasp the the actual concept thank you

[dangerouslygoodstorieswith]

This helped me finish my 2022 bookkeeping -- thank you so much!

[LadyGlobalChic]

Thanks for sharing very simple and easy. Glad I found your channel 👌

[laurataylor]

This was very helpful! I see links all the time, but never saw an explanation for how pivot tables work.

[andresession]

That's it... Jeez man. It's all over every job I search. Great explaination! Thank you

[Teholimau]

Hi, thanks for sharing! I wonder if you could share an exercise google sheet to practice with? Perhaps the same one you used as the example in this video. Thanks :)

[ProductivePM]

Very well done and easy to understand. I appreciate your work . . .

[rohitbhargava]

Pinpoint explanation to every thing important, even you will wonder that 9 minutes are already over.

Nice exercise! 👌👌

[rosalynhollidge]

Thank you, this is so helpful and clear!

[JayByrd]

Great video this helped a lot! If only sheets could do as much as excel like create calculated fields and allow you to change field settings.

[muhammadfaraz]

very useful and helpful Thank you Scott and the team simpletivity :)

[codeintherough]

Moved Pivot Table From data tab to Insert tab. for those from the future

[adriaflorea]

Wow What a tutorial. Thanks. This was very helpful!

[nddcmul]

This video was super helpful. Thank you very much.

[xXSummonNightXx]

Very easy to understanding!! Thank you 😊

[RedMoon]

Thank you for the video, It was explained very well.