10 Expert Level PIVOT TABLE TRICKS you cannot miss! 🤩

[@GoodlyChandeep]

10 More Pivot Table Tricks - kzbin.info/www/bejne/oJuTmX-fadtmf7s

[@arjundev4908]

Woah! Excel is like a Ocean. The deeper we dive the more we discover. Thanks Chandeep for such nifty tricks🙏

[@agus.darmaputra]

An ocean

[@DhruvDua88]

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.

[@GoodlyChandeep]

Glad it was helpful!

[@davidtomasgaitanrodriguez1356]

Likewise, awesome.

[@LionelCHAVEZfromBE]

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.

[@MegaTrickykid]

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

[@NS-eg7hs]

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.

[@cristianravalli]

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.

[@joedi]

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 😊

[@thangaveluraj]

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...

[@tony586ful]

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

[@GoodlyChandeep]

Glad it was helpful Tony!

[@ExcelWithChris]

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.

[@GoodlyChandeep]

Glad you like them!

[@guruts]

Brilliant stuff, all the tips were new to me despite using Pivots for decades, thank you!!❤

[@GoodlyChandeep]

Happy to help Guruprasad!

[@govindkumardasamantarao562]

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....

[@mconte77]

Tricks 1 to 3 are outstanding ones! As always, your videos are really helpful. Congrats!!!!!

[@francois-xavierr.2710]

reordering by typing is the trick I didn't know ... so nice , thank you

[@scottcha03]

#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.

[@viktormodis9791]

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]

#powerbinareal

[@MichaelGreen831]

You win. Best new excel video I've seen in a while. sorting by typing was my favorite!

[@GoodlyChandeep]

Wow, thanks Michael!

[@karimallahwala7022]

Super helpful Tricks Most Tricks I didn‘ t know. Please make ab Pivot-Table Tricks Part II

[@GoodlyChandeep]

10 More Pivot Table Tricks - kzbin.info/www/bejne/oJuTmX-fadtmf7s

[@drewbny78]

#7 is a game changer. didn't know about that. huge time saver!!

[@davidsonsunny2886]

That was very useful . Great video on Pivot tables . Would love to have a series on advanced Pivot table tricks

[@muhammadauwalibrahim9440]

I know almost all the tricks but the way teach and yours is awesome. You deserve more than 5 stars

[@tommybrown397]

AWESOME! #s 2, 3, 4 & 7 were new to me. PLEASE KEEP THESE VIDEOS COMING! You're GREAT!

[@rameshpotti4551]

1,2, and 8 are new one to me. Also learnt on PIVOT setting information thanks

[@anillpatel]

Great PT Tricks to save time and improve presentations. Very well presented too. Clear and concise. Thanks.

[@Jathulhu]

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. :)

[@MrHugawa]

nice, I watch plenty of these Excel/pivot tips... this is one of the best...lots of great info... thx

[@morganselvam6924]

Good explanation, straight to the point.

[@RG-sr4wb]

Awesome tricks... Loved it 👍🏻 excellent teaching method, unlike many others, not dragging and wasting time. 👌👌👌 A big thank from Singapore 🙏

[@GoodlyChandeep]

Most welcome 😊

[@gfred2007]

#1,2,4,8,9,10 All these tips were great! Yes, please make that follow up video.

[@GoodlyChandeep]

10 More Pivot Table Tricks - kzbin.info/www/bejne/oJuTmX-fadtmf7s

[@srinivasannarayanan3362]

❤all the tricks covered in this video are new to me. I'm excited to watch next videos and learn from this channel.😊

[@jainairmdp]

❤outstanding. I was not aware of 8 possibilities you demonstrated!

[@GoodlyChandeep]

Glad it was helpful Jai !

[@michellinesmith4122]

This was so awesome! 7 Tricks I learnt today - Thanks

[@anandv3814]

Awesome 👍. Repeating only a field is something I learnt today !.

[@GoodlyChandeep]

Great to hear!

[@PriyaRajvanshHR]

Finally I land up on the one I was searching for. It's awesome. Would like to know more on dashboard and data management.

[@eliovalcin9888]

I did not know about the saving of print layout and removing the + / - signs. Thanks a bunch!

[@SakthivelS77]

Sir, your tricks help me a lot in my daily work. Thank you very much. Kindly upload such useful things in Excel.

[@kamalshrestha1276]

Thank❤ yet again. Point 5 to 9 is new and learned .

[@devdas8204]

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.

[@GoodlyChandeep]

Great to hear!

[@nickt2159]

How awesome was that! 😊. Did not keep an accurate count, but I would say about half were new. Thanks for sharing.

[@GoodlyChandeep]

Glad you like it Nick!

[@kishorelalrana9111]

Only first two were awesome enough to blow my mind!! Keep up the good work!

[@GoodlyChandeep]

Thanks Kishorelal !

[@rosbas9485]

Excellent. Clear and direct !!!

[@GoodlyChandeep]

Thanks!

[@amosnliz]

Really liked it and learned some new things. Also liked the speed of your presentation, your pace is perfect

[@GoodlyChandeep]

I rarely get to hear that.. thanks a lot!

[@shirleymoreman6725]

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.

[@imranisshack9828]

So awesome. This has really help me to be more efficient at work

[@surajbhardwaj428]

Wow...😎 Mind blowing teaching skills... Point with point not wasting any time ...1st time watched your video and subscribed your channel...Greater work 👏👏

[@GoodlyChandeep]

Thank you so much Suraj :)

[@andreashermle2716]

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

[@ankursharma6157]

झकास 👏🏿 Like Your Communication too👌🏿 YES . . MORE TRICKS are WELCOME! Best Wishes!

[@GoodlyChandeep]

Thanks Ankur! 10 More Pivot Table Tricks - kzbin.info/www/bejne/oJuTmX-fadtmf7s

[@cg24356]

Over and over again awesome what you present on your channel! Thank you!

[@GoodlyChandeep]

Glad you like them!

[@j0akim123]

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!

[@AmanKhajanchi]

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.

[@napstergdl]

Maybe the most useful video I have seen on pivot tables!

[@vnvipindasyt]

Hey ! I did not know the fill only the particular column down.. it made my life easier

[@critterstocosmos]

Geez! I thought I was pretty good with Excel, but many (most) of these were new to me. Fantastic stuff! Thank you!

[@Nitinpaste-k5l]

I know most of them but now I am refreshing. You are no1.

[@kevindaniel7333]

Very good and helpful video--thank you! #3 and 4 were new to me, and most appreciated!

[@GoodlyChandeep]

Glad it was helpful Kevin!

[@CMdJafar]

#1, #2, #3 were new to me. Thanks a lot for sharing this.

[@GoodlyChandeep]

Welcome!

[@michaelkoster8412]

I appreciated the review! I knew about all of them, but I liked hearing your explanations.

[@carmscabang4319]

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! 😊🇵🇭

[@anthonyalbuquerque5422]

Thanks the first few was new to me. Really enjoyed it thanks

[@karenboatwright]

Great video. I use pivot tables regularly and I didn't know any of these tricks. Very to the point and informative.

[@GoodlyChandeep]

Glad it was helpful!

[@gingermo]

I loved the repeat item headers for the specific column

[@devangthakkar6847]

Superb video. I think all are amazing even we are using this Pivot every time but all these techniques are awasome. Thanks For update.

[@GoodlyChandeep]

Great to hear!

[@balrajvirdee1087]

Thanks again, this is really going to help with my excel test. 👍🏽

[@akhileshtiwari8887]

Simply great tricks! Few are awesome!

[@tablaproo8405]

Excellent one. All 10 are new

[@Rosiechen2018]

Love your tutorial especially on showing field heading for selected column only! Awesome!!

[@GoodlyChandeep]

Great to hear Rosie!

[@atulp7826]

Very informative and useful video. Special thanks to keep it to the point.

[@GoodlyChandeep]

Glad you liked it Atul!

[@marcusmcnabb6978]

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!

[@GoodlyChandeep]

Great to hear!

[@kamranshaikh688]

The video is just WOW,a rapturous applaud.i would like to request you to make a video on pivot chart. Thanks a bunch!

[@GrainneDuggan_Excel]

Wonderful list, Chandeep! I didn't know about fill down labels in one column only. Please keep the tips coming!

[@GoodlyChandeep]

10 More Pivot Table Tricks - kzbin.info/www/bejne/oJuTmX-fadtmf7s

[@mohdmuzammil3059]

Superb thanks, Trick No. 1,2,&8..new learning for me.

[@ulrickt]

The layout function I didn’t know. This was awesome. The calculations were also good and something that I can utilize more.

[@GoodlyChandeep]

Great to hear!

[@vmmohan08]

Wow, Almost 4 New Tricks learnt today!!! Pls publishe more Tricks on Pivot Tables...

[@GoodlyChandeep]

10 More Pivot Table Tricks - kzbin.info/www/bejne/oJuTmX-fadtmf7s

[@atyuinnegi]

Follow-up video👍👍 Last disable double click detail is a new find for me...

[@GoodlyChandeep]

10 More Pivot Table Tricks - kzbin.info/www/bejne/oJuTmX-fadtmf7s

[@vinodkamath2057]

Great learning...out of 10 ...9 were not known ..thank you..🙏

[@GoodlyChandeep]

Glad it was helpful!

[@donnaf.9715]

Short and straight to the point! I enjoyed learning more pivot table features, Thank you!

[@GoodlyChandeep]

Glad you enjoyed Donna!

[@maurobsn1873]

Excellent as always! Calculations is the best part to me!

[@GoodlyChandeep]

Great to hear!

[@appucyt]

I'm pretty new to pivot tables and all of these tricks were new to me :) Thanks a lot for sharing :):)

[@GoodlyChandeep]

Happy to help Appu!

[@emilmubarakshin49]

Thank you so much I didn’t think I could learn any more tricks, but I always do

[@GoodlyChandeep]

Great to hear!

[@Amank3107]

All tricks are awesome 👍 and I am already aware about all these tricks but thanks for the awesome tutorial.

[@gazmaszk]

Thanks man! Almost all of these were new to me, so I have learned a lot! Thank you really

[@GoodlyChandeep]

Glad to hear it Gazmaszk!

[@gandhisunil3]

Incredibly explained, i didn't knew trick number 2 and trick no 8..learnt new

[@martyc5674]

Great Video Chandeep- a few I don’t know- like typing to reorder!- genius!

[@GoodlyChandeep]

Thank You!

[@romolaraman8114]

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. 👌👌

[@GoodlyChandeep]

Glad it was helpful!

[@couragetamakloe4621]

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.

[@GoodlyChandeep]

Glad it was helpful, Courage!

[@chandrasekharnigam7607]

Superb! Mind blowing tricks!

[@shahidmuhammad8491]

Thank you for making such videos to share your skill.

[@GoodlyChandeep]

Pleasure Shahid!

[@att6098]

Awesome video! I don't think I know the #2 until I went thru yr video. I love to learn more. Thanks,

[@GoodlyChandeep]

Glad to hear it!

[@wimmosterdijk]

mind blowing indeed, 60% was new to me. thanks for the insight

[@GoodlyChandeep]

Glad to hear it!

[@visakha425]

Did not know any of them. Awesome! Thanks for sharing

[@GoodlyChandeep]

Glad it was useful Sivaram!

[@subbu_ca]

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

[@GoodlyChandeep]

10 More Pivot Table Tricks - kzbin.info/www/bejne/oJuTmX-fadtmf7s

[@hashtag_pete7304]

#7 is just soooo awesome, thanks a thousand!!!

[@GoodlyChandeep]

Glad you think so!

[@vickyng1356]

Super awesome. Didn’t know many of these. Thanks buddy

[@GoodlyChandeep]

Glad it was helpful Vicky!

[@MrA7mdfars]

Sooooo fantastic , it is really important to know these skills. I am really thankful for you. I just know #9 .

[@GoodlyChandeep]

Glad it was helpful Ahmed!

[@ScottPerley]

Never knew about #1, 2, 3, 7, 10! Thank you!

[@GoodlyChandeep]

Glad it was helpful!

[@amitpatel75]

fantastic video , trick no. 2 3 4 all are new for me

[@AnbarasuAnnamalai]

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.

[@GoodlyChandeep]

10 More Pivot Table Tricks - kzbin.info/www/bejne/oJuTmX-fadtmf7s

[@Seftehandle]

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.

[@GoodlyChandeep]

Glad you like it !

[@donniemcgee7523]

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.

[@GoodlyChandeep]

Great to hear!