10 Expert Level PIVOT TABLE TRICKS you cannot miss! 🤩
ฝัง
- เผยแพร่เมื่อ 31 พ.ค. 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! - วิทยาศาสตร์และเทคโนโลยี
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
Saving template for every time getting the same design.
reordering by typing is the trick I didn't know ... so nice , thank you
7,8,10 were only ones I DID know. THANKS!
Adding filters to totals is new to me… among others ‘. Can’t wait to see more!!
2:23 Wow, that is awesome! I did not know #2.
Knew only one out of 10 explained by you Thank you !
I loved the repeat item headers for the specific column
Never knew about #1, 2, 3, 7, 10! Thank you!
Glad it was helpful!
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.
What a legend! Thank you so much!
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!
I appreciated the review! I knew about all of them, but I liked hearing your explanations.
Maybe the most useful video I have seen on pivot tables!
I did not know about the saving of print layout and removing the + / - signs. Thanks a bunch!
Awesome 👍. Repeating only a field is something I learnt today !.
Great to hear!
❤all the tricks covered in this video are new to me. I'm excited to watch next videos and learn from this channel.😊
Good explanation, straight to the point.
with use of just simple typing, we can change the Order of the Pivot Table, was awesome.
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
Boom!
It was 10/10 man, keep it up.
This was so awesome! 7 Tricks I learnt today - Thanks
Thanks again, this is really going to help with my excel test. 👍🏽
#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
1,2, and 8 are new one to me. Also learnt on PIVOT setting information thanks
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.
Hey ! I did not know the fill only the particular column down.. it made my life easier
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!
Thank❤ yet again. Point 5 to 9 is new and learned .
I think just the first one I knew, all the rest were almost knew to me! Thanks Goodly
Thank you so much I didn’t think I could learn any more tricks, but I always do
Great to hear!
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...
Thanks the first few was new to me. Really enjoyed it thanks
❤outstanding. I was not aware of 8 possibilities you demonstrated!
Glad it was helpful Jai !
WOW! Very helpful, thank you!
Only first two were awesome enough to blow my mind!! Keep up the good work!
Thanks Kishorelal !
almost 5 new tricks from this video, many thanks
Great !
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
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!
#1, #2, #3 were new to me. Thanks a lot for sharing this.
Welcome!
Sir, your tricks help me a lot in my daily work. Thank you very much. Kindly upload such useful things in Excel.
Simply great tricks! Few are awesome!
10:35 Wow! I had no idea about #7!
Brilliant stuff, all the tips were new to me despite using Pivots for decades, thank you!!❤
Happy to help Guruprasad!
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
Excellent. Clear and direct !!!
Thanks!
#7 is just soooo awesome, thanks a thousand!!!
Glad you think so!
Amazing. Want more. Didn't know 1 & 2.
10 More Pivot Table Tricks - th-cam.com/video/jj0hLi4v3IY/w-d-xo.html
Incredibly explained, i didn't knew trick number 2 and trick no 8..learnt new
So awesome. This has really help me to be more efficient at work
The re-ordering by typing blew my mind!
Likewise.. when I accidently discovered it 😁
Excellent tricks. Didn't know any one of these 10.
Glad it was useful!
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.
Awesome, awesome awesome tricks sir. Almost I don't know 7 of these tricks.
Geez! I thought I was pretty good with Excel, but many (most) of these were new to me. Fantastic stuff! Thank you!
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. :)
mind blowing indeed, 60% was new to me. thanks for the insight
Glad to hear it!
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
Amazing.. Whooping all 10 mind blowing tricks..
Glad you like them!
All tricks are awesome 👍 and I am already aware about all these tricks but thanks for the awesome tutorial.
The video is just WOW,a rapturous applaud.i would like to request you to make a video on pivot chart.
Thanks a bunch!
repeat values in one column , gr8 video
Fantastic video, sir!
#2, #8, and #10 were new to me.
Superb! Mind blowing tricks!
Several ones was not aware of - useful!
Glad it was useful!
Did not know any of them. Awesome! Thanks for sharing
Glad it was useful Sivaram!
Reordering by typing over labels… news to me. YoY calculations I could use that too. Subscribed !
nice, I watch plenty of these Excel/pivot tips... this is one of the best...lots of great info... thx
Thanks for tip with filter🤗
I didn't know any of these tricks. Thanks!
Happy to help !
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!
Super awesome. Didn’t know many of these. Thanks buddy
Glad it was helpful Vicky!
Great learning...out of 10 ...9 were not known ..thank you..🙏
Glad it was helpful!
Thank you for making such videos to share your skill.
Pleasure Shahid!
All of that is new stuff for me . Thank you !
Glad it was helpful Patricio!
झकास 👏🏿
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
Thanks for sharing the tips, I was not aware of the #1, #2, and #3
Glad it was helpful Nicolas!
Thanks man! Almost all of these were new to me, so I have learned a lot! Thank you really
Glad to hear it Gazmaszk!
Excited for the next video, rich content but for me i am familiar with all the shown tricks
Thank you! The most of them are new to me
Glad it was useful !
Awesome tricks... Loved it 👍🏻 excellent teaching method, unlike many others, not dragging and wasting time. 👌👌👌
A big thank from Singapore 🙏
Most welcome 😊
Thanks for sharing. Pls post more tricks
#powerbinareal Sempre! Sou do Brasil e acompanho todo dia! showwwwwww
Retype to order is amazing 😍😍
fantastic video , trick no. 2 3 4 all are new for me
👍Most of the tricks known already... Go ahead with other tricks.
Very informative and useful video. Special thanks to keep it to the point.
Glad you liked it Atul!
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!
Great Video Chandeep- a few I don’t know- like typing to reorder!- genius!
Thank You!
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!
Superb thanks, Trick No. 1,2,&8..new learning for me.
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 knew some of these but not all! Definitely want to see the extra ones you have up your sleeve.
10 More Pivot Table Tricks - th-cam.com/video/jj0hLi4v3IY/w-d-xo.html
Very good and helpful video--thank you! #3 and 4 were new to me, and most appreciated!
Glad it was helpful Kevin!
Amazing thanks for share knowledge. it helps me a lot.
It‘s a shame they only allow me to give you one thumbs-up. I wanted to give you ten! Thank you!
Wow, Glad you like this Yolanda!
Excellent Tricks
Thanks very good tricks