AMAZING...There are lot channels boring with repetitive stuff, yours is packed with tons of new stuff within a short time of 14 minutes, THANKS A LOT...
Over 20 years I ended up having learned and taken time to use most of these ones. The one missing though was when you sorted the elements by "renaming" them. Very nice and to the point video, as always with Goodly.
hence the name! Good job by GOODLY! Thanks for this tipps. Didactically well done. You are definitely a great and sympathic teacher. Kind regards from Berlin
The best ever video on Pivot Tables. I have been using them for years and never new some of these tricks. Thanks so much. Sending love and greetings from South Africa.
Great video. The filter trick really was awesome. Also didn't know about re-ordering by typing. In a follow up video I'd like to learn about calculation fields and calculation items.
I didn't know about the repeat just for a specific column and how to remove the plus and minus signs. Thank you so much! And special thanks for making it fun too.
The first one was dope. I did not think about using filters outside the range to filter values. The only other one was the repeat values in field setting. Learn something new every day 😊
Though I am an advanced user of Excel, many of the tricks you mentioned are not known to me. Thank you very much. My knowledge of excel has gone up many notches higher. Excellent. Would like to hear more from you....
#1 , #2, and #8: new to me and did blow my mind! Thank you for sharing. Also for #1: if there is white space to the left of the PT, will need to click outside left of the PT to get filters inside the PT. Also for #3: alternative way to get to custom list is: Home / Sort & Filter / Custom Sort / Order drop down choose Custom List. Keep the goodly content coming! I tell all my coworkers to check out your channel.
Fantastic video! #1, #2, #3, #5 and #7 were new to me. Great stuff. More pivot table tricks are always welcome. Also it would be great if you could provide info for each trick on the behaviour after refreshing the pivot table or the underlying data set. Differences/limitations in comparison between pivot table vs power pivot table would be very helpful. Also pointing out that some of the tricks involve computer specific settings. If your colleague would be to open the same file on their computer, not all custom settings would appear in the same way for them. e.g. Custom Lists Finally, #10 is intended for collaboration with others. It'd be nice to top it off with an info on how you protect the workbook, what sub-setting you would have to have enabled in order to prevent them from changing the "show details" option back to default.
Big thanks for this! Clicked your video thinking "I guess its only basic stuff I already know" but actually I didnt know about these ways, I did my own time consuming solutions. Now I will save s*t loads of time. Thanks again!
Great Stuff, thank you. I thought I knew all of the tricks, but a matter of fact, there are 3 that I haven't known before which will come in handy in the future. Thanky you very much
I'm a newbie in pivot table. All the tips you have shared are very helpful to me and will make my work easier. Plase do share more tutorials like this and other tips to maximize the use of Excel and Google Sheets. Thank you so much.. Maraming salamat! 😊🇵🇭
Applying Filters on Calculations, Re-Ordering by Typing, Saving Custom Sort Order, and repeating labels for the selected column are the tricks new to me. Thank you very much and expecting next video with more Pivot table tricks.
Simple Awesome! All the tricks were really good however, the one that blew my mind was #2 - re-order by typing. Additionally, your communication skills are also quite noteworthy.
Nice! I thought I knew Pivot tables.. but alway had to do work around to get filtering to work or % ect. All of these were new and exciting to to see for me! Thank you so very much for sharing!
I have been using pivot tables for a few years, but you have presented some very helpful tips. After watching your videos, I realize that there more that I don't know than what I do know. Thank you for sharing such well-presented and useful information. one of our top surgeons often asks me for data and what you have shared will help me serve him better. Thank you. I will credit you to him.
Wow...😎 Mind blowing teaching skills... Point with point not wasting any time ...1st time watched your video and subscribed your channel...Greater work 👏👏
Great video! Thanks for sharing your knowledge. New to me: #2 - Re-Ordering by Typing; #7 - Storing the Default Layout of the Pivot Table; #8 - Repeat Labels for a selected column; #10 - Disable double click on the Pivot Table.
1,2 8 were new to me and very appealing - apply filters on calc by clicking outside pvt tbl , re-order by typing and repeat labels for a selected col. good job. i did not believe there was anything left to surprise me, however thumbs up for the wonderful video.
10 More Pivot Table Tricks - ua-cam.com/video/jj0hLi4v3IY/v-deo.html
Woah! Excel is like a Ocean. The deeper we dive the more we discover. Thanks Chandeep for such nifty tricks🙏
An ocean
I've been using pivot tables for so long and and you've hit the nail on the head on all the pain points I had. Brilliant stuff.
Glad it was helpful!
Likewise, awesome.
AMAZING...There are lot channels boring with repetitive stuff, yours is packed with tons of new stuff within a short time of 14 minutes, THANKS A LOT...
Over 20 years I ended up having learned and taken time to use most of these ones. The one missing though was when you sorted the elements by "renaming" them. Very nice and to the point video, as always with Goodly.
hence the name! Good job by GOODLY! Thanks for this tipps. Didactically well done. You are definitely a great and sympathic teacher. Kind regards from Berlin
I didn't know just the number 1.... But it was what I had been looking for for years... thank you Chandeep... I'll follow you
Glad it was helpful Tony!
The best ever video on Pivot Tables. I have been using them for years and never new some of these tricks. Thanks so much. Sending love and greetings from South Africa.
Glad you like them!
I know almost all the tricks but the way teach and yours is awesome. You deserve more than 5 stars
Great video. The filter trick really was awesome. Also didn't know about re-ordering by typing. In a follow up video I'd like to learn about calculation fields and calculation items.
I didn't know about the repeat just for a specific column and how to remove the plus and minus signs. Thank you so much! And special thanks for making it fun too.
reordering by typing is the trick I didn't know ... so nice , thank you
The first one was dope. I did not think about using filters outside the range to filter values. The only other one was the repeat values in field setting. Learn something new every day 😊
You win. Best new excel video I've seen in a while.
sorting by typing was my favorite!
Wow, thanks Michael!
AWESOME! #s 2, 3, 4 & 7 were new to me. PLEASE KEEP THESE VIDEOS COMING! You're GREAT!
Great PT Tricks to save time and improve presentations.
Very well presented too. Clear and concise.
Thanks.
Geez! I thought I was pretty good with Excel, but many (most) of these were new to me. Fantastic stuff! Thank you!
Though I am an advanced user of Excel, many of the tricks you mentioned are not known to me. Thank you very much. My knowledge of excel has gone up many notches higher. Excellent. Would like to hear more from you....
Tricks 1 to 3 are outstanding ones! As always, your videos are really helpful. Congrats!!!!!
Brilliant stuff, all the tips were new to me despite using Pivots for decades, thank you!!❤
Happy to help Guruprasad!
❤all the tricks covered in this video are new to me. I'm excited to watch next videos and learn from this channel.😊
Videos like these reminds me that I still have alot to learn in excel even though I have used it for many years. Thanks man.
Great to hear!
That was very useful . Great video on Pivot tables . Would love to have a series on advanced Pivot table tricks
Excellent. Clear and direct !!!
Thanks!
Finally I land up on the one I was searching for.
It's awesome. Would like to know more on dashboard and data management.
This was so awesome! 7 Tricks I learnt today - Thanks
Sir, your tricks help me a lot in my daily work. Thank you very much. Kindly upload such useful things in Excel.
#1 , #2, and #8: new to me and did blow my mind! Thank you for sharing.
Also for #1: if there is white space to the left of the PT, will need to click outside left of the PT to get filters inside the PT.
Also for #3: alternative way to get to custom list is: Home / Sort & Filter / Custom Sort / Order drop down choose Custom List.
Keep the goodly content coming! I tell all my coworkers to check out your channel.
nice, I watch plenty of these Excel/pivot tips... this is one of the best...lots of great info... thx
1,2, and 8 are new one to me. Also learnt on PIVOT setting information thanks
Good explanation, straight to the point.
#1,2,4,8,9,10
All these tips were great!
Yes, please make that follow up video.
10 More Pivot Table Tricks - ua-cam.com/video/jj0hLi4v3IY/v-deo.html
Awesome 👍. Repeating only a field is something I learnt today !.
Great to hear!
#7 is a game changer. didn't know about that. huge time saver!!
Fantastic video! #1, #2, #3, #5 and #7 were new to me. Great stuff. More pivot table tricks are always welcome.
Also it would be great if you could provide info for each trick on the behaviour after refreshing the pivot table or the underlying data set. Differences/limitations in comparison between pivot table vs power pivot table would be very helpful.
Also pointing out that some of the tricks involve computer specific settings. If your colleague would be to open the same file on their computer, not all custom settings would appear in the same way for them. e.g. Custom Lists
Finally, #10 is intended for collaboration with others. It'd be nice to top it off with an info on how you protect the workbook, what sub-setting you would have to have enabled in order to prevent them from changing the "show details" option back to default.
#powerbinareal
Maybe the most useful video I have seen on pivot tables!
Over and over again awesome what you present on your channel! Thank you!
Glad you like them!
#1, #2, #3 were new to me. Thanks a lot for sharing this.
Welcome!
I appreciated the review! I knew about all of them, but I liked hearing your explanations.
Knew only one out of 10 explained by you Thank you !
I did not know about the saving of print layout and removing the + / - signs. Thanks a bunch!
Big thanks for this! Clicked your video thinking "I guess its only basic stuff I already know" but actually I didnt know about these ways, I did my own time consuming solutions. Now I will save s*t loads of time. Thanks again!
Thanks again, this is really going to help with my excel test. 👍🏽
❤outstanding. I was not aware of 8 possibilities you demonstrated!
Glad it was helpful Jai !
Sort by typing was a new one for me! I didn't know about the setting for preventing double-click either. Great stuff as always Chandeep.
Thank❤ yet again. Point 5 to 9 is new and learned .
Great video. I use pivot tables regularly and I didn't know any of these tricks. Very to the point and informative.
Glad it was helpful!
Love your tutorial especially on showing field heading for selected column only! Awesome!!
Great to hear Rosie!
Great Stuff, thank you. I thought I knew all of the tricks, but a matter of fact, there are 3 that I haven't known before which will come in handy in the future. Thanky you very much
Simply great tricks! Few are awesome!
Short and straight to the point! I enjoyed learning more pivot table features, Thank you!
Glad you enjoyed Donna!
I've been using pivots and the like for years .... and there's some simple QoL stuff here I didn't even know I needed or wanted! Great vid. :)
What a legend! Thank you so much!
So awesome. This has really help me to be more efficient at work
I know most of them but now I am refreshing. You are no1.
Only first two were awesome enough to blow my mind!! Keep up the good work!
Thanks Kishorelal !
Never knew about #1, 2, 3, 7, 10! Thank you!
Glad it was helpful!
Wow, Almost 4 New Tricks learnt today!!! Pls publishe more Tricks on Pivot Tables...
10 More Pivot Table Tricks - ua-cam.com/video/jj0hLi4v3IY/v-deo.html
7,8,10 were only ones I DID know. THANKS!
Super helpful Tricks Most Tricks I didn‘ t know. Please make ab Pivot-Table Tricks Part II
10 More Pivot Table Tricks - ua-cam.com/video/jj0hLi4v3IY/v-deo.html
Hey ! I did not know the fill only the particular column down.. it made my life easier
Superb thanks, Trick No. 1,2,&8..new learning for me.
I'm a newbie in pivot table. All the tips you have shared are very helpful to me and will make my work easier. Plase do share more tutorials like this and other tips to maximize the use of Excel and Google Sheets. Thank you so much.. Maraming salamat! 😊🇵🇭
Wonderful list, Chandeep! I didn't know about fill down labels in one column only. Please keep the tips coming!
10 More Pivot Table Tricks - ua-cam.com/video/jj0hLi4v3IY/v-deo.html
Awesome tricks... Loved it 👍🏻 excellent teaching method, unlike many others, not dragging and wasting time. 👌👌👌
A big thank from Singapore 🙏
Most welcome 😊
Excellent as always! Calculations is the best part to me!
Great to hear!
Applying Filters on Calculations, Re-Ordering by Typing, Saving Custom Sort Order, and repeating labels for the selected column are the tricks new to me. Thank you very much and expecting next video with more Pivot table tricks.
10 More Pivot Table Tricks - ua-cam.com/video/jj0hLi4v3IY/v-deo.html
Thanks the first few was new to me. Really enjoyed it thanks
Simple Awesome! All the tricks were really good however, the one that blew my mind was #2 - re-order by typing. Additionally, your communication skills are also quite noteworthy.
I have been an user of excel for a long time and I didn't know 3 of the features. Thank you. Waiting for additional features
10 More Pivot Table Tricks - ua-cam.com/video/jj0hLi4v3IY/v-deo.html
What I liked the most about this video was feeling like I was learning pívot tables from Ice Cube. Pretty cool!
Great to hear!
Nice! I thought I knew Pivot tables.. but alway had to do work around to get filtering to work or % ect. All of these were new and exciting to to see for me! Thank you so very much for sharing!
Great to hear!
Adding filters to totals is new to me… among others ‘. Can’t wait to see more!!
The layout function I didn’t know. This was awesome. The calculations were also good and something that I can utilize more.
Great to hear!
Thank you so much I didn’t think I could learn any more tricks, but I always do
Great to hear!
I have been using pivot tables for a few years, but you have presented some very helpful tips. After watching your videos, I realize that there more that I don't know than what I do know. Thank you for sharing such well-presented and useful information.
one of our top surgeons often asks me for data and what you have shared will help me serve him better. Thank you. I will credit you to him.
Great to hear!
Incredibly explained, i didn't knew trick number 2 and trick no 8..learnt new
#7 is just soooo awesome, thanks a thousand!!!
Glad you think so!
I loved the repeat item headers for the specific column
Superb video. I think all are amazing even we are using this Pivot every time but all these techniques are awasome.
Thanks For update.
Great to hear!
Superb! Mind blowing tricks!
Really liked it and learned some new things. Also liked the speed of your presentation, your pace is perfect
I rarely get to hear that.. thanks a lot!
The video is just WOW,a rapturous applaud.i would like to request you to make a video on pivot chart.
Thanks a bunch!
How awesome was that! 😊. Did not keep an accurate count, but I would say about half were new.
Thanks for sharing.
Glad you like it Nick!
Great learning...out of 10 ...9 were not known ..thank you..🙏
Glad it was helpful!
Did not know any of them. Awesome! Thanks for sharing
Glad it was useful Sivaram!
mind blowing indeed, 60% was new to me. thanks for the insight
Glad to hear it!
Amazing.. Whooping all 10 mind blowing tricks..
Glad you like them!
Wow...😎 Mind blowing teaching skills... Point with point not wasting any time ...1st time watched your video and subscribed your channel...Greater work 👏👏
Thank you so much Suraj :)
Great video! Thanks for sharing your knowledge.
New to me:
#2 - Re-Ordering by Typing;
#7 - Storing the Default Layout of the Pivot Table;
#8 - Repeat Labels for a selected column;
#10 - Disable double click on the Pivot Table.
Great Video Chandeep- a few I don’t know- like typing to reorder!- genius!
Thank You!
Very informative and useful video. Special thanks to keep it to the point.
Glad you liked it Atul!
Thank you for making such videos to share your skill.
Pleasure Shahid!
fantastic video , trick no. 2 3 4 all are new for me
Very good and helpful video--thank you! #3 and 4 were new to me, and most appreciated!
Glad it was helpful Kevin!
1,2 8 were new to me and very appealing - apply filters on calc by clicking outside pvt tbl , re-order by typing and repeat labels for a selected col. good job. i did not believe there was anything left to surprise me, however thumbs up for the wonderful video.
Glad you like it !
Thanks man! Almost all of these were new to me, so I have learned a lot! Thank you really
Glad to hear it Gazmaszk!
I'm pretty new to pivot tables and all of these tricks were new to me :) Thanks a lot for sharing :):)
Happy to help Appu!
Thank you Chandeep. I did not know trick number 8 and 10. Looking forward to learning more tricks from you :)
10 More Pivot Table Tricks - ua-cam.com/video/jj0hLi4v3IY/v-deo.html
Excellent one. All 10 are new