Pivot Tables in Google Sheets A-Z Tutorial
Pivot Tables in Google Sheets A-Z.
In this tutorial we'll cover:
00:00 How Google Sheets Pivot Tables Work
03:31 How to Create a Pivot Table in Google Sheets
15:07 Multiple Value Fields in Pivot Tables
16:52 Using Different Functions
17:53 Display Percent of Total in a Pivot Table
19:22 Group By Year, Month, Date in a Pivot Table
25:00 Slicers & Filters in Google Sheets Pivot Tables
27:46 Automatically Update Pivot Tables when You Update Your Data
34:57 Calculated Fields in Google Sheets Pivot Tables
39:20 How to Use External References in Calculated Fields
#pivottables
Пікірлер: 44
What did we do to deserve the return of the google sheets magician
@ExcelGoogleSheets
17 күн бұрын
Sometime I get too busy :)
Thanks, that you are really back! Just the best channel for Excel & Google Sheets.
@ExcelGoogleSheets
17 күн бұрын
Thank You!
Sir , your English ,Voice & Explaination are EXCELLENT Thanks & best regards
@ExcelGoogleSheets
17 күн бұрын
Thank You!
Happy to comeback from korea 🇰🇷
@ExcelGoogleSheets
17 күн бұрын
Thank You!
Another excellent tutorials and thank you for coming back!!!
@ExcelGoogleSheets
17 күн бұрын
Thanks!
Really the great master!
@ExcelGoogleSheets
17 күн бұрын
Thank You!
Cristal clear, as usual. Thanks for sharing - your videos are the best! Cheers from 🇧🇷
@ExcelGoogleSheets
17 күн бұрын
Thank You!
Thanks for great session on Pivot 👌👌
Thank u sir, u comeback 🎉❤😊
Awesome trainings! Thank you!
Im so glad you're back! Ive learned so much from you. Your teaching style is so clear and simple and I love your voice. Fun fact: Every time I hear your voice, I picture Kumail Nanjiani. Might just be weird me. 😂 Awesome energy. 👏
@ExcelGoogleSheets
18 күн бұрын
Is that the Silicon Valley guy? :)
@NourishMoveRestReflect
17 күн бұрын
@@ExcelGoogleSheets Yes! I know they're not exactly the same, but I keep hearing a lot of similarities. He's done a bunch of cool stuff since Silicon Valley. Thanks for your helpful videos!
Fuck yes you are back! Instant like , and now watching this video..Curious what I‘ll learn while watching it :)
@ExcelGoogleSheets
17 күн бұрын
Thank You!
Pls make the tutorial app sheet.
Thank you sir.Simple teachi g.Very easy to understand❤
@ExcelGoogleSheets
17 күн бұрын
👍
Nice video. Thanks for uploading this. Is it possible to send the link to the google spread sheet, you used here ? so that people can follow your instructions while watching the video
Thanks for the video. But regarding the table creation itself not the pivot table, is there a way to create the table without the row height changing? I find it cringe and unorganized when the row height increases. especially when you made the table here and it increased the row height for the first part of the table, but not for the last part.
Nice intro, thanks. Does it cope with pulling in source data using a query function or some external data source? Can you use a user defined (apps script) function in the custom calculated field?
@ExcelGoogleSheets
17 күн бұрын
Sure, Pivot Tables should work with arrays with no issues. Never tried to use a UDF to be honest. Curious if anybody tried it.
Great content as always. You only missed how to create a calculated field to show text and sparkline like you've shown in an older video.
@ExcelGoogleSheets
18 күн бұрын
I'm too old for sparklines and text now 🧐
@lpanebr
17 күн бұрын
@@ExcelGoogleSheets maybe in a pivot table, sure. But in general I still like sparklines to get a glace at tendencies.
Hey man, thank you so much. This is fantastic information. I have one question: What if I only care about the sum of each Sales' Rep's top 3 (or 5 or whatever number) sales? Is there a quick way to filter that in the pivot table?
@ExcelGoogleSheets
18 күн бұрын
I don't think you can do that directly in the pivot table.
@ashamael
17 күн бұрын
@@ExcelGoogleSheets Thank you for the response.
@30:33 You discuss how the pivot table doesn't update to added rows. Now that GSheets has Tables, if your source data is in a table, will pivot tables update with new rows automatically?
@jamesepace
6 күн бұрын
LOL. 20 seconds later, I've got my answer. Oops! Thanks for the thorough walk through of pivot tables!
@ExcelGoogleSheets
3 күн бұрын
For a second I was like, "did a part of the video get cut"? :)
do you have any channel for python or web development?
May We have the exercise sheet?
am gonna be active
@ExcelGoogleSheets
17 күн бұрын
Thank You!
Can you share this data so we can practice. Please!🙏
1st Viewer