Google Sheets Pivot Table (BASIC to ADVANCED)

Download Practice file - bit.ly/33j0nQy
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.
👉 Join now our QnA Community - bit.ly/335Fic7
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
Pivot Table - Google Sheets for Excel Users Series - • Playlist
#pivottable #googlesheetspivottable #googlesheets
Let's Connect:
👉 Follow us on Instagram / yodalearning
👉 Follow our boards at / pins

[@Yodalearning]

*_Download Practice file_* - bit.ly/33j0nQy

[@theonematthew]

Excellent education. Helps level-up my skills.

[@SingFoolsSing]

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

[@AndyVarghese]

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

[@yaelsela6275]

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

[@thebhaskarjoshi]

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

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

[@TheAlwaysGoel]

Very informative video sir....

[@PavaniDoddigari]

Thank youuuu very much for your video It helped me alot

[@TheUmaiz]

Excellent 👍

[@elenahk7315]

Thank you

[@PradeepKumar-hd1ty]

Great Great Video ❤❤❤

[@user-ts7cq9oy6y]

Excelente!

[@ekramhossain7014]

Thank u

[@luiztoledo4052]

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?

[@mdhasanuzzamanshohel9409]

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

[@trishtisharma4092]

Sir can we add a hyperlink to the pivot table?

[@saanigudemsecretariat2870]

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

[@StevenAhmodu]

Z0

[@surfman88]

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