Pivot Tables in Google Sheets A-Z Tutorial

No video

Pivot Tables in Google Sheets A-Z Tutorial

Рет қаралды 10,567

Learn Google Sheets & Excel Spreadsheets

Күн бұрын

Пікірлер: 57

@DIN-Norm 2 ай бұрын

Thanks, that you are really back! Just the best channel for Excel & Google Sheets.

@ExcelGoogleSheets 2 ай бұрын

Thank You!

@user-dc1mx7ry7e Ай бұрын

This is absolutely the best training video ever. I have roamed around KZfaq looking for clear and thorough trainings, and gone through many many videos, and nothing matches this. Thanks for providing!

@ExcelGoogleSheets Ай бұрын

Thank You!

@tannerbobanner9453 2 ай бұрын

What did we do to deserve the return of the google sheets magician

@ExcelGoogleSheets 2 ай бұрын

Sometime I get too busy :)

@essamkhalifa4375 2 ай бұрын

Sir , your English ,Voice & Explaination are EXCELLENT Thanks & best regards

@ExcelGoogleSheets 2 ай бұрын

Thank You!

@shinhoyoung8426 2 ай бұрын

Happy to comeback from korea 🇰🇷

@ExcelGoogleSheets 2 ай бұрын

Thank You!

@arctichawk3502 2 ай бұрын

Another excellent tutorials and thank you for coming back!!!

@ExcelGoogleSheets 2 ай бұрын

Thanks!

@NourishMoveRestReflect 2 ай бұрын

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 2 ай бұрын

Is that the Silicon Valley guy? :)

@NourishMoveRestReflect 2 ай бұрын

@@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!

@lapneto 2 ай бұрын

Cristal clear, as usual. Thanks for sharing - your videos are the best! Cheers from 🇧🇷

@ExcelGoogleSheets 2 ай бұрын

Thank You!

@mercyfrs 2 ай бұрын

Really the great master!

@ExcelGoogleSheets 2 ай бұрын

Thank You!

@amardeepsingh5714 2 ай бұрын

Thanks for great session on Pivot 👌👌

@krishnatate4765 2 ай бұрын

Thank u sir, u comeback 🎉❤😊

@patpat8141 2 ай бұрын

Fuck yes you are back! Instant like , and now watching this video..Curious what I‘ll learn while watching it :)

@ExcelGoogleSheets 2 ай бұрын

Thank You!

@ajadsingh1652 2 ай бұрын

Pls make the tutorial app sheet.

@s.s.malagi275 29 күн бұрын

Very nicely explained.

@ExcelGoogleSheets 28 күн бұрын

Thank you! 🙂

@HildaCV 2 ай бұрын

Awesome trainings! Thank you!

@MarcoFaragalli 2 күн бұрын

very usefull! If I would like to get a customized layout for the pivot table? How i can proceed?

@muraly3523 2 ай бұрын

Thank you sir.Simple teachi g.Very easy to understand❤

@ExcelGoogleSheets 2 ай бұрын

👍

@djla_ Ай бұрын

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.

@johnrumm4786 2 ай бұрын

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 2 ай бұрын

Sure, Pivot Tables should work with arrays with no issues. Never tried to use a UDF to be honest. Curious if anybody tried it.

@Lucy-r8o Ай бұрын

do you have any channel for python or web development?

@lpanebr 2 ай бұрын

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 2 ай бұрын

I'm too old for sparklines and text now 🧐

@lpanebr 2 ай бұрын

@@ExcelGoogleSheets maybe in a pivot table, sure. But in general I still like sparklines to get a glace at tendencies.

@crishamnimalasooriya Ай бұрын

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

@chanmeida1726 Ай бұрын

Same for me. May I know where to find the link to your Google spreadsheet?

@ExcelGoogleSheets Ай бұрын

I think it's this data docs.google.com/spreadsheets/d/1m-MQuvwGNkRQW8YEKqNXHI07KHzwEdoChiQTjTbK-yc/edit?usp=sharing

@crishamnimalasooriya Ай бұрын

@@ExcelGoogleSheets Thank you. This is really helpful

@ashamael 2 ай бұрын

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 2 ай бұрын

I don't think you can do that directly in the pivot table.

@ashamael 2 ай бұрын

@@ExcelGoogleSheets Thank you for the response.

@saifulislamik7270 Ай бұрын

May We have the exercise sheet?

@jamesepace Ай бұрын

@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 Ай бұрын

LOL. 20 seconds later, I've got my answer. Oops! Thanks for the thorough walk through of pivot tables!

@ExcelGoogleSheets Ай бұрын

For a second I was like, "did a part of the video get cut"? :)

@ashwintyagi Ай бұрын

Can you share this data so we can practice. Please!🙏

@marychan-e1t Ай бұрын

Can you please shar the google sheet for us to practice along?

@ExcelGoogleSheets Ай бұрын

I think it's this data. Let me know if it's a different docs.google.com/spreadsheets/d/1m-MQuvwGNkRQW8YEKqNXHI07KHzwEdoChiQTjTbK-yc/edit?usp=sharing

@marychan-e1t Ай бұрын

@@ExcelGoogleSheets Thank you. May I also know when I can find your other google sheets? I am also trying to learn your query playlist videos here: kzfaq.info/get/bejne/mL1mg5WK27Ldips.html