Pivot Tables in Google Sheets (learn Fast!): Tutorial

Learn Pivot Tables in Google Sheets in this Tutorial (and do it on your coffee break). Here are the things you will learn in this video:

1. Creating a table for your data first
2. Inserting a blank Pivot Table
3. Pivot Table Field areas
4. Pivot Table Filters
5. Value Filters (advanced Filter option)
6. Slicers (Interactive Data Selections)

If you learn just one thing, please comment below!

[deliawilson]

Was at the point of crying. BUT you have made Google sheets and slicers a reality for me. Thank you.

[whyworksmarternotharder]

Let me know if you learned something! I'd also like to know how you are using Pivot Tables in Google Sheets!

[yourface]

Excellent! Everything about this video is perfect. Thank you

[muhammadfaraz]

very helpful and informative. but first im gonna try!

[DonCaskey]

Good video. Thank you.
Question: in a simple pivot table with a half-dozen columns and a Grand Totals column, is there a way to move the Grand Total column to the left? (So that it becomes the 2nd column instead of the right-most column)

[OmerMan]

Hi, thanks for the video! Can you share a link to the DataSet for practice? Thanks!

[biggynbp]

Great info...Can i make pivot tables that update automatically when the data source is updated?

[caracurphey]

Great tutorial. This helped me sort and total over 8000 cells of data by department and month. It saved my sanity! Now all I need to do is figure out if I can create a pivot table that will count the non-zero cells by department and month...any tips?

[Drty]

Great video, can you go into how to filter top 10...i.e show only top ten QB passing yard all time only in Google sheets

[andresantoniocastroperez]

Great presentattion concise and illustrative, thanks. two questions how many register can manage google sheets? and is it another database softwares ( Access, SQL server, ie) compatible with? If so, how can I import data from external databsse?

[alphabeta]

When you defined a pivot range, you remove all cell references and made it pick up all data from A:V. This range when specified in a PIVOT takes into account all the blank rows which are yet to be filled but present in the sheet and these are shown as a "0" in the 1row of the Pivot. How do you take care of this?

[joannrosinski]

Hi. Just learned how to do a pivot table and have a working on. I created a Summary sheet that only includes certain data to present to my client. How do I share a link to that sheet only and not the rest of the data? I appreciate your help. Thank you

[MrMosoani]

The problem I encountered is the COUNTA. The name of the column is Number of Errors. When I selected this under Value and selected COUNTA on the dropdown, I am expecting it to ONLY show how many of the contacts have errors (the zeros and ones). Instead it calculated the total numbers of the contacts so both zeros and ones were counted.

Can you help?

[elizabethcoates]

I have a pivot table on Google Docs that is not properly pulling information I have set it to obtain. How can I fix this? EXAMPLE: I have 10 tabs for different dates in January, I have combined these into 1 tab for January. I have created a pivot table that is suppose to pull the information from the combined tab. However, while it should pull all columns labeled "date", it is only pulling one date while there are several in the combined table. I have tried everything and cannot make this work. Any advice?

[aliciaduarte]

how do I hide the pivot table editor to manipulate and present a dashboard in a cleaner version?

[CraigRippon]

thanks for making this video and sharing

#FatDad #Canberra #Australia 🦘🇦🇺🦘

[minimaggot]

Hi. Why didn't you use a slicer for the year ? much easier than changing a filter.

[coldavenue]

Again someone talking in 1.5 speed. Beside that, the intro musc waists an actually good video. Speak slowlier and take out the scary music. We are not five year olds. Then you will get a thumbs up.