Тёмный

Pivot Tables in Google Sheets A-Z Tutorial 

Learn Google Sheets & Excel Spreadsheets
Подписаться 277 тыс.
Просмотров 15 тыс.
50% 1

Опубликовано:

 

4 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 61   
@DIN-Norm
@DIN-Norm 3 месяца назад
Thanks, that you are really back! Just the best channel for Excel & Google Sheets.
@ExcelGoogleSheets
@ExcelGoogleSheets 3 месяца назад
Thank You!
@HildaVolkmann
@HildaVolkmann 2 месяца назад
This is absolutely the best training video ever. I have roamed around RU-vid looking for clear and thorough trainings, and gone through many many videos, and nothing matches this. Thanks for providing!
@ExcelGoogleSheets
@ExcelGoogleSheets 2 месяца назад
Thank You!
@garthferrante
@garthferrante 25 дней назад
I totally agree!
@tannerbobanner9453
@tannerbobanner9453 3 месяца назад
What did we do to deserve the return of the google sheets magician
@ExcelGoogleSheets
@ExcelGoogleSheets 3 месяца назад
Sometime I get too busy :)
@essamkhalifa4375
@essamkhalifa4375 3 месяца назад
Sir , your English ,Voice & Explaination are EXCELLENT Thanks & best regards
@ExcelGoogleSheets
@ExcelGoogleSheets 3 месяца назад
Thank You!
@arctichawk3502
@arctichawk3502 3 месяца назад
Another excellent tutorials and thank you for coming back!!!
@ExcelGoogleSheets
@ExcelGoogleSheets 3 месяца назад
Thanks!
@lapneto
@lapneto 3 месяца назад
Cristal clear, as usual. Thanks for sharing - your videos are the best! Cheers from 🇧🇷
@ExcelGoogleSheets
@ExcelGoogleSheets 3 месяца назад
Thank You!
@shinhoyoung8426
@shinhoyoung8426 3 месяца назад
Happy to comeback from korea 🇰🇷
@ExcelGoogleSheets
@ExcelGoogleSheets 3 месяца назад
Thank You!
@mercyfrs
@mercyfrs 3 месяца назад
Really the great master!
@ExcelGoogleSheets
@ExcelGoogleSheets 3 месяца назад
Thank You!
@NourishMoveRestReflect
@NourishMoveRestReflect 3 месяца назад
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
@ExcelGoogleSheets 3 месяца назад
Is that the Silicon Valley guy? :)
@NourishMoveRestReflect
@NourishMoveRestReflect 3 месяца назад
@@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!
@amardeepsingh5714
@amardeepsingh5714 3 месяца назад
Thanks for great session on Pivot 👌👌
@krishnatate4765
@krishnatate4765 3 месяца назад
Thank u sir, u comeback 🎉❤😊
@s.s.malagi275
@s.s.malagi275 2 месяца назад
Very nicely explained.
@ExcelGoogleSheets
@ExcelGoogleSheets 2 месяца назад
Thank you! 🙂
@patpat8141
@patpat8141 3 месяца назад
Fuck yes you are back! Instant like , and now watching this video..Curious what I‘ll learn while watching it :)
@ExcelGoogleSheets
@ExcelGoogleSheets 3 месяца назад
Thank You!
@rytis314
@rytis314 19 дней назад
great one
@ExcelGoogleSheets
@ExcelGoogleSheets 16 дней назад
Thanks!
@HildaCV
@HildaCV 3 месяца назад
Awesome trainings! Thank you!
@muraly3523
@muraly3523 3 месяца назад
Thank you sir.Simple teachi g.Very easy to understand❤
@ExcelGoogleSheets
@ExcelGoogleSheets 3 месяца назад
👍
@ajadsingh1652
@ajadsingh1652 3 месяца назад
Pls make the tutorial app sheet.
@MarcoFaragalli
@MarcoFaragalli Месяц назад
very usefull! If I would like to get a customized layout for the pivot table? How i can proceed?
@vrmagician
@vrmagician 10 дней назад
Would it be possible to share sample spreadsheet using in video so subscribers can do and follow whatever you taught, pls?
@crishamnimalasooriya
@crishamnimalasooriya 2 месяца назад
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
@chanmeida1726 2 месяца назад
Same for me. May I know where to find the link to your Google spreadsheet?
@ExcelGoogleSheets
@ExcelGoogleSheets 2 месяца назад
I think it's this data docs.google.com/spreadsheets/d/1m-MQuvwGNkRQW8YEKqNXHI07KHzwEdoChiQTjTbK-yc/edit?usp=sharing
@crishamnimalasooriya
@crishamnimalasooriya 2 месяца назад
@@ExcelGoogleSheets Thank you. This is really helpful
@djla_
@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.
@lpanebr
@lpanebr 3 месяца назад
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
@ExcelGoogleSheets 3 месяца назад
I'm too old for sparklines and text now 🧐
@lpanebr
@lpanebr 3 месяца назад
@@ExcelGoogleSheets maybe in a pivot table, sure. But in general I still like sparklines to get a glace at tendencies.
@johnrumm4786
@johnrumm4786 3 месяца назад
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
@ExcelGoogleSheets 3 месяца назад
Sure, Pivot Tables should work with arrays with no issues. Never tried to use a UDF to be honest. Curious if anybody tried it.
@ashamael
@ashamael 3 месяца назад
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
@ExcelGoogleSheets 3 месяца назад
I don't think you can do that directly in the pivot table.
@ashamael
@ashamael 3 месяца назад
@@ExcelGoogleSheets Thank you for the response.
@jamesepace
@jamesepace 2 месяца назад
@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
@jamesepace 2 месяца назад
LOL. 20 seconds later, I've got my answer. Oops! Thanks for the thorough walk through of pivot tables!
@ExcelGoogleSheets
@ExcelGoogleSheets 2 месяца назад
For a second I was like, "did a part of the video get cut"? :)
@ashwintyagi
@ashwintyagi 2 месяца назад
Can you share this data so we can practice. Please!🙏
@Lucy-r8o
@Lucy-r8o 3 месяца назад
do you have any channel for python or web development?
@saifulislamik7270
@saifulislamik7270 2 месяца назад
May We have the exercise sheet?
@marychan-e1t
@marychan-e1t 2 месяца назад
Can you please shar the google sheet for us to practice along?
@ExcelGoogleSheets
@ExcelGoogleSheets 2 месяца назад
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
@marychan-e1t 2 месяца назад
@@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bW6P2YvLyZg.html
@sam_safari
@sam_safari 3 месяца назад
am gonna be active
@ExcelGoogleSheets
@ExcelGoogleSheets 3 месяца назад
Thank You!
@ajjuchandrawanshi
@ajjuchandrawanshi 3 месяца назад
1st Viewer
Далее
Google Sheets Pivot Table with KPI & Bar Graphs
15:26
Master Pivot Tables in 10 Minutes (Using Real Examples)
11:33
КОГДА НАКРОШИЛ НА ПОЛ #shorts
00:19
Google Sheets Tables & Formulas
16:22
Просмотров 13 тыс.
QUERY Function in Google Sheets - 2024 Tutorial ✏️
14:33
Excel Pivot Tables Tutorial
2:22:38
Просмотров 41 тыс.
Advanced Excel - Creating Pivot Tables in Excel
13:11
КОГДА НАКРОШИЛ НА ПОЛ #shorts
00:19