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

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

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

[@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 😊

[@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!

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

[@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

[@eliovalcin9888]

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

[@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!

[@francois-xavierr.2710]

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

[@drewbny78]

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

[@SakthivelS77]

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

[@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

[@guruts]

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

[@GoodlyChandeep]

Happy to help Guruprasad!

[@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

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

[@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!

[@critterstocosmos]

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

[@davidsonsunny2886]

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

[@MichaelGreen831]

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

[@GoodlyChandeep]

Wow, thanks Michael!

[@anillpatel]

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

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

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

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

[@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!

[@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!

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

[@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

[@mconte77]

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

[@muhammadauwalibrahim9440]

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

[@gingermo]

I loved the repeat item headers for the specific column

[@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!

[@kishorelalrana9111]

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

[@GoodlyChandeep]

Thanks Kishorelal !

[@vnvipindasyt]

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

[@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!

[@anandv3814]

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

[@GoodlyChandeep]

Great to hear!

[@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

[@MrHugawa]

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

[@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 😊

[@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!

[@srinivasannarayanan3362]

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

[@CMdJafar]

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

[@GoodlyChandeep]

Welcome!

[@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

[@michellinesmith4122]

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

[@morganselvam6924]

Good explanation, straight to the point.

[@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!

[@donnaf.9715]

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

[@GoodlyChandeep]

Glad you enjoyed Donna!

[@cg24356]

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

[@GoodlyChandeep]

Glad you like them!

[@jainairmdp]

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

[@GoodlyChandeep]

Glad it was helpful Jai !

[@imranisshack9828]

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

[@kamalshrestha1276]

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

[@rosbas9485]

Excellent. Clear and direct !!!

[@GoodlyChandeep]

Thanks!

[@kevindaniel7333]

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

[@GoodlyChandeep]

Glad it was helpful Kevin!

[@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!

[@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

[@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!

[@atulp7826]

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

[@GoodlyChandeep]

Glad you liked it Atul!

[@michaelkoster8412]

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

[@balrajvirdee1087]

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

[@ScottPerley]

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

[@GoodlyChandeep]

Glad it was helpful!

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

[@emilmubarakshin49]

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

[@GoodlyChandeep]

Great to hear!

[@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

[@daniell.8000]

What I liked the most about this video was feeling like I was learning pívot tables from Ice Cube. Pretty cool!

[@GoodlyChandeep]

Great to hear!

[@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!

[@anthonyalbuquerque5422]

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

[@wimmosterdijk]

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

[@GoodlyChandeep]

Glad to hear it!

[@Rosiechen2018]

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

[@GoodlyChandeep]

Great to hear Rosie!

[@shahidmuhammad8491]

Thank you for making such videos to share your skill.

[@GoodlyChandeep]

Pleasure Shahid!

[@mohdmuzammil3059]

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

[@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!

[@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!

[@srinaga1975]

Hi, All the points are very nice. You have presented interestingly too

[@GoodlyChandeep]

Glad you like them!

[@napstergdl]

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

[@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!

[@donnataylor8715]

The resorting by typing in the fields and applying it to the other rows (customers) with same sorting. Cool. I will share this with my students.

[@martyc5674]

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

[@GoodlyChandeep]

Thank You!

[@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

[@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 :)

[@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 !

[@hashtag_pete7304]

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

[@GoodlyChandeep]

Glad you think so!

[@JJ_TheGreat]

2:23 Wow, that is awesome! I did not know #2.

[@sandraivancho9388]

Adding filters to totals is new to me… among others ‘. Can’t wait to see more!!

[@adamm6733]

7,8,10 were only ones I DID know. THANKS!

[@michaeldavidson7]

Most of these I didn’t know about. Very helpful. Thank you!

[@GoodlyChandeep]

Glad it was helpful!

[@gandhisunil3]

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

[@nicolaslefftz6290]

Thanks for sharing the tips, I was not aware of the #1, #2, and #3

[@GoodlyChandeep]

Glad it was helpful Nicolas!

[@Amank3107]

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

[@muhammadtambawala6379]

Thank you Chandeep. I did not know trick number 8 and 10. Looking forward to learning more tricks from you :)

[@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!

[@visakha425]

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

[@GoodlyChandeep]

Glad it was useful Sivaram!

[@natam1595]

Awesome as always! Of all the tricks I already I knew only how to hide + signs. I knew that you can do YoY calculations, etc, but never actually used it, so it was a nice refresher. And I didn't know that if you double click on a cell you will see details )))

[@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

[@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!

[@SATHISHKUMAR-dx2bu]

Wow, what a trick. I loved it and learned a lot of kudos

[@GoodlyChandeep]

Glad it was helpful Sathish!