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
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...
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.
#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.
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 😊
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.
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.
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....
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! 😊🇵🇭
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 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
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.
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!
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.
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.
Wow...😎 Mind blowing teaching skills... Point with point not wasting any time ...1st time watched your video and subscribed your channel...Greater work 👏👏
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.
Very nice tricks and useful as well few of them didn't explore so didn't know about them but after watching your video it opens the eyes so pritty cool all those.. Please such kind of videos it really helps end user.. Thanks for sharing Happy Learning
Awesome!!! Love this ❤❤. Was going through excel help to learn more about pivot tables. Have learnt a great deal watching this, just shows that there are so much more to learn. 👌👌
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!
Very nice, some great tips there. Non which I need to know now, but I just know one of teams I work with will have questions/request where I can use them. Thanks so much
10 More Pivot Table Tricks - th-cam.com/video/jj0hLi4v3IY/w-d-xo.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.
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
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...
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.
#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.
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 😊
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
I know almost all the tricks but the way teach and yours is awesome. You deserve more than 5 stars
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!
AWESOME! #s 2, 3, 4 & 7 were new to me. PLEASE KEEP THESE VIDEOS COMING! You're GREAT!
#7 is a game changer. didn't know about that. huge time saver!!
Tricks 1 to 3 are outstanding ones! As always, your videos are really helpful. Congrats!!!!!
Sir, your tricks help me a lot in my daily work. Thank you very much. Kindly upload such useful things in Excel.
❤all the tricks covered in this video are new to me. I'm excited to watch next videos and learn from this channel.😊
Great PT Tricks to save time and improve presentations.
Very well presented too. Clear and concise.
Thanks.
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,4,8,9,10
All these tips were great!
Yes, please make that follow up video.
10 More Pivot Table Tricks - th-cam.com/video/jj0hLi4v3IY/w-d-xo.html
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! 😊🇵🇭
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!
Geez! I thought I was pretty good with Excel, but many (most) of these were new to me. Fantastic stuff! Thank you!
This was so awesome! 7 Tricks I learnt today - Thanks
Brilliant stuff, all the tips were new to me despite using Pivots for decades, thank you!!❤
Happy to help Guruprasad!
reordering by typing is the trick I didn't know ... so nice , thank you
1,2, and 8 are new one to me. Also learnt on PIVOT setting information thanks
That was very useful . Great video on Pivot tables . Would love to have a series on advanced Pivot table tricks
nice, I watch plenty of these Excel/pivot tips... this is one of the best...lots of great info... thx
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.
You win. Best new excel video I've seen in a while.
sorting by typing was my favorite!
Wow, thanks Michael!
Awesome tricks... Loved it 👍🏻 excellent teaching method, unlike many others, not dragging and wasting time. 👌👌👌
A big thank from Singapore 🙏
Most welcome 😊
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
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.
झकास 👏🏿
Like Your Communication too👌🏿
YES . . MORE TRICKS are WELCOME!
Best Wishes!
Thanks Ankur!
10 More Pivot Table Tricks - th-cam.com/video/jj0hLi4v3IY/w-d-xo.html
So awesome. This has really help me to be more efficient at work
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!
Only first two were awesome enough to blow my mind!! Keep up the good work!
Thanks Kishorelal !
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.
I appreciated the review! I knew about all of them, but I liked hearing your explanations.
Superb thanks, Trick No. 1,2,&8..new learning for me.
Thanks again, this is really going to help with my excel test. 👍🏽
Over and over again awesome what you present on your channel! Thank you!
Glad you like them!
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!
Very informative and useful video. Special thanks to keep it to the point.
Glad you liked it Atul!
Good explanation, straight to the point.
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. :)
Very good and helpful video--thank you! #3 and 4 were new to me, and most appreciated!
Glad it was helpful Kevin!
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 - th-cam.com/video/jj0hLi4v3IY/w-d-xo.html
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 !
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!
Awesome 👍. Repeating only a field is something I learnt today !.
Great to hear!
Thank❤ yet again. Point 5 to 9 is new and learned .
I know most of them but now I am refreshing. You are no1.
Thanks the first few was new to me. Really enjoyed it thanks
Awsome video as always. Did not know most of the tricks. Thank you so much.
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 :)
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!
Bro Thankyou .....
I didn't know any of these but all these were the options that I was looking for since using pivot tables ♥️🎈
Maybe the most useful video I have seen on pivot tables!
All tricks are awesome 👍 and I am already aware about all these tricks but thanks for the awesome tutorial.
Super helpful Tricks Most Tricks I didn‘ t know. Please make ab Pivot-Table Tricks Part II
10 More Pivot Table Tricks - th-cam.com/video/jj0hLi4v3IY/w-d-xo.html
Simply great tricks! Few are awesome!
Very nice tricks and useful as well few of them didn't explore so didn't know about them but after watching your video it opens the eyes so pritty cool all those.. Please such kind of videos it really helps end user.. Thanks for sharing Happy Learning
Great !
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!
#1, #2, #3 were new to me. Thanks a lot for sharing this.
Welcome!
Finally I land up on the one I was searching for.
It's awesome. Would like to know more on dashboard and data management.
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 - th-cam.com/video/jj0hLi4v3IY/w-d-xo.html
Super awesome. Didn’t know many of these. Thanks buddy
Glad it was helpful Vicky!
❤outstanding. I was not aware of 8 possibilities you demonstrated!
Glad it was helpful Jai !
This was a great video. Thank you so much. And I didn't know half of the tricks. I will be ues these tips daily.
Glad it was helpful, Courage!
Excellent. Clear and direct !!!
Thanks!
Hey ! I did not know the fill only the particular column down.. it made my life easier
Sooooo fantastic , it is really important to know these skills.
I am really thankful for you.
I just know #9 .
Glad it was helpful Ahmed!
Wow, Almost 4 New Tricks learnt today!!! Pls publishe more Tricks on Pivot Tables...
10 More Pivot Table Tricks - th-cam.com/video/jj0hLi4v3IY/w-d-xo.html
Boom!
It was 10/10 man, keep it up.
Excellent as always! Calculations is the best part to me!
Great to hear!
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!
Knew only one out of 10 explained by you Thank you !
Love your tutorial especially on showing field heading for selected column only! Awesome!!
Great to hear Rosie!
The video is just WOW,a rapturous applaud.i would like to request you to make a video on pivot chart.
Thanks a bunch!
Thanks man! Almost all of these were new to me, so I have learned a lot! Thank you really
Glad to hear it Gazmaszk!
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!
Awesome!!! Love this ❤❤. Was going through excel help to learn more about pivot tables. Have learnt a great deal watching this, just shows that there are so much more to learn. 👌👌
Glad it was helpful!
Did not know any of them. Awesome! Thanks for sharing
Glad it was useful Sivaram!
Amazing thanks for share knowledge. it helps me a lot.
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!
Awesome video! I don't think I know the #2 until I went thru yr video. I love to learn more. Thanks,
Glad to hear it!
I did not know about the saving of print layout and removing the + / - signs. Thanks a bunch!
7,8,10 were only ones I DID know. THANKS!
Great video, well presented and helpful.
Thanks Shane!
Hi, All the points are very nice. You have presented interestingly too
Glad you like them!
Wow. Great video. Also like the pace of your videos...!😀
Glad you like them!
Very nice, some great tips there. Non which I need to know now, but I just know one of teams I work with will have questions/request where I can use them. Thanks so much
Thank you for making such videos to share your skill.
Pleasure Shahid!
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 - th-cam.com/video/jj0hLi4v3IY/w-d-xo.html
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 - th-cam.com/video/jj0hLi4v3IY/w-d-xo.html
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!
mind blowing indeed, 60% was new to me. thanks for the insight
Glad to hear it!