Thanks, that you are really back! Just the best channel for Excel & Google Sheets.
@ExcelGoogleSheets3 ай бұрын
Thank You!
@HildaVolkmann2 ай бұрын
This is absolutely the best training video ever. I have roamed around KZbin looking for clear and thorough trainings, and gone through many many videos, and nothing matches this. Thanks for providing!
@ExcelGoogleSheets2 ай бұрын
Thank You!
@garthferrante25 күн бұрын
I totally agree!
@tannerbobanner94533 ай бұрын
What did we do to deserve the return of the google sheets magician
@ExcelGoogleSheets3 ай бұрын
Sometime I get too busy :)
@essamkhalifa43753 ай бұрын
Sir , your English ,Voice & Explaination are EXCELLENT Thanks & best regards
@ExcelGoogleSheets3 ай бұрын
Thank You!
@arctichawk35023 ай бұрын
Another excellent tutorials and thank you for coming back!!!
@ExcelGoogleSheets3 ай бұрын
Thanks!
@lapneto3 ай бұрын
Cristal clear, as usual. Thanks for sharing - your videos are the best! Cheers from 🇧🇷
@ExcelGoogleSheets3 ай бұрын
Thank You!
@shinhoyoung84263 ай бұрын
Happy to comeback from korea 🇰🇷
@ExcelGoogleSheets3 ай бұрын
Thank You!
@mercyfrs3 ай бұрын
Really the great master!
@ExcelGoogleSheets3 ай бұрын
Thank You!
@NourishMoveRestReflect3 ай бұрын
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. 👏
@ExcelGoogleSheets3 ай бұрын
Is that the Silicon Valley guy? :)
@NourishMoveRestReflect3 ай бұрын
@@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!
@amardeepsingh57143 ай бұрын
Thanks for great session on Pivot 👌👌
@krishnatate47653 ай бұрын
Thank u sir, u comeback 🎉❤😊
@s.s.malagi2752 ай бұрын
Very nicely explained.
@ExcelGoogleSheets2 ай бұрын
Thank you! 🙂
@patpat81413 ай бұрын
Fuck yes you are back! Instant like , and now watching this video..Curious what I‘ll learn while watching it :)
@ExcelGoogleSheets3 ай бұрын
Thank You!
@rytis31418 күн бұрын
great one
@ExcelGoogleSheets15 күн бұрын
Thanks!
@HildaCV3 ай бұрын
Awesome trainings! Thank you!
@muraly35233 ай бұрын
Thank you sir.Simple teachi g.Very easy to understand❤
@ExcelGoogleSheets3 ай бұрын
👍
@ajadsingh16523 ай бұрын
Pls make the tutorial app sheet.
@MarcoFaragalliАй бұрын
very usefull! If I would like to get a customized layout for the pivot table? How i can proceed?
@vrmagician10 күн бұрын
Would it be possible to share sample spreadsheet using in video so subscribers can do and follow whatever you taught, pls?
@crishamnimalasooriya2 ай бұрын
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
@chanmeida17262 ай бұрын
Same for me. May I know where to find the link to your Google spreadsheet?
@ExcelGoogleSheets2 ай бұрын
I think it's this data docs.google.com/spreadsheets/d/1m-MQuvwGNkRQW8YEKqNXHI07KHzwEdoChiQTjTbK-yc/edit?usp=sharing
@crishamnimalasooriya2 ай бұрын
@@ExcelGoogleSheets Thank you. This is really helpful
@djla_2 ай бұрын
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.
@lpanebr3 ай бұрын
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.
@ExcelGoogleSheets3 ай бұрын
I'm too old for sparklines and text now 🧐
@lpanebr3 ай бұрын
@@ExcelGoogleSheets maybe in a pivot table, sure. But in general I still like sparklines to get a glace at tendencies.
@johnrumm47863 ай бұрын
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?
@ExcelGoogleSheets3 ай бұрын
Sure, Pivot Tables should work with arrays with no issues. Never tried to use a UDF to be honest. Curious if anybody tried it.
@ashamael3 ай бұрын
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?
@ExcelGoogleSheets3 ай бұрын
I don't think you can do that directly in the pivot table.
@ashamael3 ай бұрын
@@ExcelGoogleSheets Thank you for the response.
@jamesepace2 ай бұрын
@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?
@jamesepace2 ай бұрын
LOL. 20 seconds later, I've got my answer. Oops! Thanks for the thorough walk through of pivot tables!
@ExcelGoogleSheets2 ай бұрын
For a second I was like, "did a part of the video get cut"? :)
@ashwintyagi2 ай бұрын
Can you share this data so we can practice. Please!🙏
@Lucy-r8o3 ай бұрын
do you have any channel for python or web development?
@saifulislamik72702 ай бұрын
May We have the exercise sheet?
@marychan-e1t2 ай бұрын
Can you please shar the google sheet for us to practice along?
@ExcelGoogleSheets2 ай бұрын
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-e1t2 ай бұрын
@@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: kzbin.info/www/bejne/mIiZgWWPq7GskMk