10 Expert Level PIVOT TABLE TRICKS you cannot miss! 🤩
Vložit
- čas přidán 24. 07. 2024
- Here are 10 Pivot Table techniques that can make working with Excel easier!
Join this channel to get access to the perks:
/ @goodlychandeep
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/mind-blowing-piv...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers! - Věda a technologie
10 More Pivot Table Tricks - czcams.com/video/jj0hLi4v3IY/video.html
Woah! Excel is like a Ocean. The deeper we dive the more we discover. Thanks Chandeep for such nifty tricks🙏
An ocean
reordering by typing is the trick I didn't know ... so nice , thank you
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
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!
I appreciated the review! I knew about all of them, but I liked hearing your explanations.
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!
#1,2,4,8,9,10
All these tips were great!
Yes, please make that follow up video.
10 More Pivot Table Tricks - czcams.com/video/jj0hLi4v3IY/video.html
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.
❤all the tricks covered in this video are new to me. I'm excited to watch next videos and learn from this channel.😊
Sir, your tricks help me a lot in my daily work. Thank you very much. Kindly upload such useful things in Excel.
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.
I did not know about the saving of print layout and removing the + / - signs. Thanks a bunch!
1,2, and 8 are new one to me. Also learnt on PIVOT setting information thanks
Adding filters to totals is new to me… among others ‘. Can’t wait to see more!!
Thanks again, this is really going to help with my excel test. 👍🏽
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 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
Awesome 👍. Repeating only a field is something I learnt today !.
Great to hear!
Knew only one out of 10 explained by you Thank you !
Brilliant stuff, all the tips were new to me despite using Pivots for decades, thank you!!❤
Happy to help Guruprasad!
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.
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.
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 😊
This was so awesome! 7 Tricks I learnt today - Thanks
Awesome tricks... Loved it 👍🏻 excellent teaching method, unlike many others, not dragging and wasting time. 👌👌👌
A big thank from Singapore 🙏
Most welcome 😊
Hey ! I did not know the fill only the particular column down.. it made my life easier
Wow, Almost 4 New Tricks learnt today!!! Pls publishe more Tricks on Pivot Tables...
10 More Pivot Table Tricks - czcams.com/video/jj0hLi4v3IY/video.html
Never knew about #1, 2, 3, 7, 10! Thank you!
Glad it was helpful!
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. :)
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!
Maybe the most useful video I have seen on pivot tables!
#1, #2, #3 were new to me. Thanks a lot for sharing this.
Welcome!
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 .
Thanks for the tips. I didn't know about the individual right-click field setting options. I was always applying the global settings to all to all the pivot fields. I also didn't know how to add the filters to the calculated columns. very cool.
So awesome. This has really help me to be more efficient at work
Only first two were awesome enough to blow my mind!! Keep up the good work!
Thanks Kishorelal !
Tricks 1 to 3 are outstanding ones! As always, your videos are really helpful. Congrats!!!!!
The video is just WOW,a rapturous applaud.i would like to request you to make a video on pivot chart.
Thanks a bunch!
❤outstanding. I was not aware of 8 possibilities you demonstrated!
Glad it was helpful Jai !
Super helpful Tricks Most Tricks I didn‘ t know. Please make ab Pivot-Table Tricks Part II
10 More Pivot Table Tricks - czcams.com/video/jj0hLi4v3IY/video.html
#1, 2 & 10. Other than being detriment to my ego, great video, Chandeep! And yes, give us more! Lol. Thanks!
Will do!
Boom!
It was 10/10 man, keep it up.
Superb thanks, Trick No. 1,2,&8..new learning for me.
Thanks the first few was new to me. Really enjoyed it thanks
2:23 Wow, that is awesome! I did not know #2.
nice, I watch plenty of these Excel/pivot tips... this is one of the best...lots of great info... thx
Good explanation, straight to the point.
Incredibly explained, i didn't knew trick number 2 and trick no 8..learnt new
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.
Geez! I thought I was pretty good with Excel, but many (most) of these were new to me. Fantastic stuff! Thank you!
Amazing.. Whooping all 10 mind blowing tricks..
Glad you like them!
What a legend! Thank you so much!
Simply great tricks! Few are awesome!
झकास 👏🏿
Like Your Communication too👌🏿
YES . . MORE TRICKS are WELCOME!
Best Wishes!
Thanks Ankur!
10 More Pivot Table Tricks - czcams.com/video/jj0hLi4v3IY/video.html
I loved the repeat item headers for the specific column
WOW! Very helpful, thank you!
AWESOME! #s 2, 3, 4 & 7 were new to me. PLEASE KEEP THESE VIDEOS COMING! You're GREAT!
Superb! Mind blowing tricks!
mind blowing indeed, 60% was new to me. thanks for the insight
Glad to hear it!
Great PT Tricks to save time and improve presentations.
Very well presented too. Clear and concise.
Thanks.
I think just the first one I knew, all the rest were almost knew to me! Thanks Goodly
All tricks are awesome 👍 and I am already aware about all these tricks but thanks for the awesome tutorial.
Very good and helpful video--thank you! #3 and 4 were new to me, and most appreciated!
Glad it was helpful Kevin!
#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.
Very informative and useful video. Special thanks to keep it to the point.
Glad you liked it Atul!
Thank you so much I didn’t think I could learn any more tricks, but I always do
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 ♥️🎈
Reordering by typing over labels… news to me. YoY calculations I could use that too. Subscribed !
Amazing thanks for share knowledge. it helps me a lot.
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
Most of these tricks are new to me. I knew 1 or 2 tricks. Keep posting new tricks it is really going to be helpful
Sure!
Awsome video as always. Did not know most of the tricks. Thank you so much.
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!
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 - czcams.com/video/jj0hLi4v3IY/video.html
Awesome!! thanks for the tips
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 )))
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 - czcams.com/video/jj0hLi4v3IY/video.html
Love your tutorial especially on showing field heading for selected column only! Awesome!!
Great to hear Rosie!
Awesome, awesome awesome tricks sir. Almost I don't know 7 of these tricks.
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!
with use of just simple typing, we can change the Order of the Pivot Table, was awesome.
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 - czcams.com/video/jj0hLi4v3IY/video.html
almost 5 new tricks from this video, many thanks
Great !
Super awesome. Didn’t know many of these. Thanks buddy
Glad it was helpful Vicky!
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!
Thank you for making such videos to share your skill.
Pleasure Shahid!
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!
Excellent. Clear and direct !!!
Thanks!
That was very useful . Great video on Pivot tables . Would love to have a series on advanced Pivot table tricks
Did not know any of them. Awesome! Thanks for sharing
Glad it was useful Sivaram!
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 :)
Excellent tricks. Didn't know any one of these 10.
Glad it was useful!
Finally I land up on the one I was searching for.
It's awesome. Would like to know more on dashboard and data management.
Awesome, thanks
Very interesting. Thanks.
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!
Over and over again awesome what you present on your channel! Thank you!
Glad you like them!
It was a great video! I knew about 1,8,9 : the rest was new for me. Thank you! My favourite are the second one and the seventh 👍. I'm looking forward for the follow up video.
10 More Pivot Table Tricks - czcams.com/video/jj0hLi4v3IY/video.html