Google Sheets Pivot Table (BASIC to ADVANCED)

In this video, I'm going to show you how to make a pivot table in Google Sheets and create a dashboard from it. You can use this for making reports or doing some data analysis with it.

0:00 Introduction to Google Sheet's Pivot Table
1:02 What is Pre-requisite in Google Sheets
1:12 What is Cross Tab and Flat File in Google Sheets
1:40 How to Transform Data in Google Sheets
2:03 How to use Unpivot Column feature in Google Sheets
3:27 Press Ctrl + / (To Open Keyboard Shortcut Panel)
3:59 How to create Pivot Table in Google Sheets
5:15 How to add Data in Google Sheets Pivot Table
6:15 How to use Filter in Pivot Table in Google Sheets
8:16 How to Sort the Data in Pivot Table in Google Sheets
9:26 How to use Values (Aggregate - SUM) in Google Sheets Pivot Table
10:32 How to use Values (% of) in Google Sheets Pivot Table
15:32 How to Rename Headings in Google Sheets
15:44 What Happens when you double click on numbers in Google Sheets
16:17 How to use Filter Layout in Pivot Table in Google Sheets
18:17 How to use Expand and Collapse (+/- buttons) Pivot Table in Google Sheets
19:02 Change the sequence of Field items in Google Sheets
19:24 How to Repeat Row Labels in Google Sheets Pivot Table
19:52 How to Show Totals in Pivot Table
21:15 How to use Date Grouping in Pivot Table Google Sheets
24:08 How to Create Pivot Group Rule for Numbers in Google Sheets
26:08 How to Create Pivot Group for Text in Google Sheets
27:56 How to use Slicers in Google Sheets Pivot Table
30:01 How to use Design and Formatting in Pivot Table in Google Sheets
30:12 How to add Color Scale for Heatmap in Google Sheets
30:54 Sparkline Trick for Dynamic Data Bars in Pivot Table in Google Sheets
35:46 Calculated Field Concept in Google Sheets Pivot Table
39:08 How to Convert Cross Tab to Flat Data in Pivot Table in Google Sheets

#pivottable #googlesheetspivottable #googlesheets

Let's Connect:

[theonematthew]

Excellent education. Helps level-up my skills.

[SingFoolsSing]

A complete understanding from basics to advanced concepts in Pivot tables. Thank you!!!

[yaelsela]

The best video I've seen about Pivot tables. Thanks a lot! :)

[AndyVarghese]

Hi, Thanks for the crystal clear training tutorial. It is very clear that even a lay man can easily understand.

[Hymnoz]

Thank you for this in depth tutorial! I am used to Microsoft Excel, so this is an excellent way for me to learn how things work in google.

[thebhaskarjoshi]

39:08
In Excel way,
=FILTERXML("<a><b>"&TEXTJOIN("</b><b>", TRUE, TRANSPOSE(A3:A5&"|"&B2:D2&"|"&B3:D5))&"</b></a>", "//b") then Text to Column or Left, Mid & Right.

[PavaniDoddigari]

Thank youuuu very much for your video
It helped me alot

[luiztoledo]

hi. thanks for the video. I have a problem: in Excel, we create slices where we can connect many pivot tables. How can I create a slice in google spreadsheet using the date that can be closen and it will impact refreshing 3 different pivot tables based on this date chosen?

[mdhasanuzzamanshohel]

how show 0 in black cell in google pivot table???

[trishtisharma]

Sir can we add a hyperlink to the pivot table?

[saanigudemsecretariat]

HOW TO ADD ZEROS TO THE BLANKS OF THE PIVOT TABLE IN GOOLE SHEETS

[surfman]

The slicers look so ugly in sheets compared with what is possible in excel. A pity!