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: pipedrive.thld.co/simpletivit...
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: kzbin.info...
► Get your FREE productivity guide: www.simpletivity.com/free
► Visit the website: www.simpletivity.com
Let's Connect!
Facebook: / simpletivity
LinkedIn: / scottdfriesen
Twitter: / scottdfriesen
Instagram: / scottdfriesen
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 www.flaticon.com
#simpletivity #pivottable #googlesheets

[@Simpletivity]

Want more ways to get more out of Google Sheets? Watch this playlist: kzbin.info/www/bejne/aXbEkISOf9GahJo Optimize your business and boost your sales with Pipedrive (get 25% off): pipedrive.thld.co/simpletivityoct

[@hiraya5769]

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

[@mirrorreflection3479]

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...

[@Simpletivity]

Thanks for sharing!

[@takingcareofbiz1]

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

[@Simpletivity]

You are most welcome! So glad for the perfect timing!

[@b5lovermore]

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

[@Simpletivity]

Wow, thanks!

[@mahhinshahzad1273]

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

[@Simpletivity]

I'm so glad that you found this helpful! Thanks for sharing your experience.

[@muhammadfaraz960]

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

[@andresession2235]

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

[@rosalynhollidge6200]

Thank you, this is so helpful and clear!

[@dangerouslygoodstorieswith9732]

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

[@Simpletivity]

You are most welcome. So glad that this video could help!

[@ProductivePM]

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

[@Simpletivity]

Thanks, Greg.

[@LadyGlobalChic]

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

[@Simpletivity]

Thanks for watching! I'm so glad you found this channel as well.

[@laurataylor8150]

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

[@Simpletivity]

All the best as you explore this essential feature!

[@MarcCastellsBallesta]

Great! Learning what are pivot tables was in my todo list. Not anymore! Now I just need to see if & how I can use them with my sheets.

[@adriaflorea9848]

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

[@xXSummonNightXx]

Very easy to understanding!! Thank you 😊

[@Simpletivity]

Glad to hear that!

[@rohitbhargava2648]

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

[@Simpletivity]

Thanks so much. Glad you enjoyed this video!

[@RedMoon814]

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

[@Simpletivity]

Glad it was helpful!

[@jenipherakuku7326]

thanks, saved a life today

[@Jay91Byrd]

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.

[@Simpletivity]

Glad you found this video helpful! What kind of data or work do you use spreadsheets for mostly?

[@AnggeV]

wow! very clear explanation! thank you! 😊

[@Simpletivity]

You're very welcome!

[@user-nd9dc2mu4l]

This video was super helpful. Thank you very much.

[@Simpletivity]

You're very welcome!

[@fatemajowarder1736]

Thank you. Simple and awesome!

[@Jess-kj8jx]

This is so so helpful- thank you so much!

[@Simpletivity]

You're welcome, Jess!

[@Anikvikram]

Thank you for the valubale information.

[@spacefolder]

This is an amazing breakdown.. Thank you!

[@Simpletivity]

You're very welcome!

[@yamanimadi]

Perfect! Thank you

[@matthewlay4939]

Great explanation. thanks

[@Simpletivity]

You are welcome!

[@Hav3nMaina]

Thank you so much. This was so valuable

[@Simpletivity]

You're so welcome! Thanks for watching!

[@MikkosFree]

What an incredibly informative video!

[@Simpletivity]

Glad you think so!

[@parentingchildhoodocd]

Thank you so much. This was very helpful. 😀

[@Simpletivity]

You are very welcome. Thanks for watching!

[@anatzamberg7471]

Thank you. It is very helpful.

[@Simpletivity]

You are welcome!

[@rickharold7884]

Cool. I love pivot tables thx

[@allysaudya]

thanks a lot! I have an exam tomorrow about this

[@Simpletivity]

You're very welcome. All the best on your test!

[@MrLithuanian91]

thanks very helpful

[@jcepri]

Great tutorial. I had no idea what pivot tables are. FYI - the main table showed no one sold any desks, but the filter brought up these reps sold desks. :-)

[@BarkatulAlam]

Fantastic Love this video..

[@transparent91]

Amazing work. Pivot to you!

[@Simpletivity]

Thanks a lot!

[@Italjamer]

Thank you so much!

[@Simpletivity]

You're welcome!

[@rohanayush]

Really helpful. Thanks :)

[@Simpletivity]

You're welcome!

[@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 :)

[@MMz_AlMasri]

+1

[@japossert]

+1

[@pamelalim2350]

is there any way to sort the MMM-YYYY column accordingly or we could only sort by ascending/ descending order?

[@pjavier]

Hi. Thank you very much for the video, it helps a lot. Just for you to know that for some reason now the Pivot Table is in insert and not in Data.

[@justsurfin5013]

Had no idea Google Sheets had Pivot Tables..neat

[@aatifrashid5413]

Perfect!

[@carlisefarren4236]

Great video

[@alamgerhossain8069]

Many Many Thanks

[@Simpletivity]

Many many welcomes!

[@tomrettig]

Thank you! Very helpful! Question: on google sheets, once I set up my pivot table, and go back to my main sheet & update it with new values, will my pivot table update accordingly?

[@Simpletivity]

Great question. Yes, a pivot table is dynamic. So any changes you make within the selected area will be reflected in the table.

[@sallywiebe2060]

I'm curious where the More Sorting Options is for ways to sort by month since a basic Ascending > Descending does not put the months in order. Do you have a video or instruction for how to navigate to this? Thank you

[@mirrorreflection3479]

We need to do something to have more sales on the desks ;)

[@Simpletivity]

Agreed!

[@killjeffrey]

Great video!

[@Simpletivity]

Thanks!

[@abhilashmumadwar2079]

Thank you

[@Simpletivity]

You're welcome

[@wilmamaglapuz4010]

Good to know pivot. Can i get a copy of the sample sheet

[@Nevir202]

It's not directly related, but I have a question I'd hoped I might be able to use a pivot table to solve. Unfortunately it looks like not. I have a bunch of paired columns in my data and I want to SUMIF all of them simultaneously. Using example date, I wrote a formula to do what I want, but it's already bulky when only including three of the pairs then there are like 20: I even managed to make an array that can merge the data into two columns and then allow me to run a regular SUMIF, but then I need to have that data present somewhere in my sheet So is there a way to do this within an ARRAYFORMULA or some other function to keep things looking clean and keep the formula from being half a page long?

[@terrafalcon9165]

Hey, loved the video, the issue I have is that my chart is not working because there are blanks in some cells, I can't figure out how to make blanks 0 on sheets pivot tables, been driving me crazy.

[@triciaboyd5459]

can you highlight via custom formatting AND have an active pivot table?

[@mwwhatever]

Is there a tutorial video that includes links for the sheet that you're working on?

[@jainnitin640]

Can I keep the filter as a slicer on the head of the Pivot?

[@davidjackson7675]

How can I pivot a table longer i.e. one row for salesperson and each item?

[@MrMosoani]

I like to have the pivot table on the same sheet and not creat a new sheet is that possible?

[@panama1942]

When I use Sheets the pivot table option is under Insert. Did they just change that?

[@zxccxz164]

nice.....but how can you set a fields FORMATTING , ie percentage.....each time i move around my pivot table the formmating gets screwed up!!

[@SpeakToTheGame]

Hey, when I click "ADD" on any of the options(Rows, Columns, etc) I do not get a drop down, any idea why? Thanks!

[@stri06]

Easy to understand but no 'calculated field' overview and pivot chart?

[@pglhonda2924]

Need help why google sheet showing a subtract symbol in every cell, need a solution to it, how can I hide it.

[@rachelrafael8002]

hey , if i dont have that option ? how can i add it ??

[@erindaseafoodsupplier7921]

why my pivot editor does not show up ?

[@marinadanilina3275]

I have two two versions of Excel 2013 and Microsoft 365 and neither one of them has the option in Data tab. I have Pivot Table in Insert tab. What version do you use?

[@Simpletivity]

This tutorial is for Google Sheets.

[@marinadanilina3275]

@@Simpletivity Thank you

[@anatoliistepaniuk8217]

woudbe useful to get this dataset example available

[@Simpletivity]

Thanks for the suggestion. I'll see if I can find it and share it.

[@somanathbiswal6725]

How to hide editor and move around the pivot table????

[@munawarhussain1400]

How i can hide or lock pivot table editor?

[@ShowBizJunkie]

You did not start with a question. What is it you are trying to achieve? Your tutorial would be much more understandable if you give the context. In your example, the rows section is about "what you want to measure". The column specifies "whether you want to measure it across the nation, across the state or across the globe like total sales per region", the values measures the actual unknown like avg(sales), sum(sales) you pick the data you want to apply aggregate functions to.

[@friendzhub]

I do not have the option of pivot table in DATA tab. any reasons why?

[@madangel676]

How to do If i need to add text in values?

[@sandipkhelukar1816]

Empty cell me zero kaise add kare

[@erey9230]

Do you know how to get rid of the #DIV/0!

[@gwendolyngilleyconstructio3265]

its not there anymore

[@spacewar]

Grand total is always empty for me.

[@rosemariedelda3932]

can i have two or more pivots on one sheet??

[@Keepit100Dre]

Google sheets changed around a bit so the video may need to be updated

[@REEL_TROLLAN]

How to change that blank cells to zero

[@tripaffleck]

No "Pivot Table" under Data tab in Ggle Sheets. anymore. now what

[@tripaffleck]

Pivot Tables are under the Insert tab now.

[@NemesisConfirmed]

Lol

[@PDCRFoundation]

No

[@heiroot]

Thank you so much!

[@Simpletivity]

You're welcome!