You Won't Believe These Crazy PIVOT TABLE Hacks!
Vložit
- čas přidán 30. 05. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Elevate your Excel skills with our top 10 Pivot Table Pro Tips! Perfect for anyone looking to streamline their data analysis in Excel. Discover shortcuts, hidden features, and expert tricks to save time and boost your efficiency with Pivot Tables.
⬇️ Download the file I use in the video from here: pages.xelplus.com/pivottable-...
✅ What You'll Learn:
▪️ Quick Pivot Table Creation: Create a Pivot Table in just a few clicks.
▪️ Customizing Field Settings: Explore hidden settings for better data organization.
▪️ Utilizing Timeline Slicers: Efficiently filter data by date.
▪️ Pivot Table Slicers on Non-Pivot Data: Innovative ways to use slicers for data control.
▪️ Top N Analysis: Focus on top-performing data easily.
▪️ Custom Sorting: Personalize data sorting to meet your specific needs.
▪️ Label Formatting: Enhance your Pivot Table's presentation with label formatting.
▪️ Calculating Percentage Changes: Quickly compare data over different periods.
▪️ Disabling Double-Click for Details: Control your Pivot Table's interactivity.
In this video I'll share my Excel Pivot Table pro tips to make the best use of Pivot Tables in Microsoft Excel. You'll discover hidden productivity tips as well as pivot table hidden tricks for example using a hidden pivot table so you can use Slicers on formulas as well. There is a lot of Excel tips and tricks that many Excel experts don't know yet.
00:00 Best Tips & Tricks for Pivot Tables in Excel
00:23 No 1: Fast PivotTable
01:06 No 2: Adjust Field Settings
01:59 No 3: Timeline slicer
03:17 No 4: Pivot Table Without Using a PivotTable 🤔
04:56 No 5: Top N Analysis
06:36 No 6: Type Over Sorting
07:12 No 7: Repeating VS Centering Labels
08:15 No 8: Custom Sorting Pivot Table Fields
08:54 No 9: Easy %-Change Calculations in Pivot Tables
10:31 No 10: Disable Double-Click for Details
🎬 LINKS to related videos:
Excel Pivot Tables EXPLAINED in 10 Minutes: • Excel Pivot Table EXPL...
Advanced Pivot Table Techniques: • Advanced Pivot Table T...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #pivottable
Try it yourself! Grab the file I used in the video from here 👉 pages.xelplus.com/pivottable-pro-tips-file
Hi Leila, Have you moved the file? it's not there.
I loved number 7, Centering Labels. I thought it would be less helpful, but in the end it does make it look nice. Surprised me a little.
I love tip 3 - the timeline functions and I would love to explore more similar illustrations! Thanks Leila, always love your video - adds value and work productivity.
Superb work. Thanks for everything,Leila
It's so useful. Love it. Thanks Leila.
I love #3 and #7. Always learning something new. Thank you so much!
Great video Leila! #3 Timeline Slicer I didn't know and it could be very handy for ad hoc 'browsing' thru reports. Thanks :)
Fantastic! Thank you Leila!
Amaizing. Thank you!
Hi Leila, your videos are excellent - simple but thorough, insightful and engaging. Thank you for sharing your knowledge and tips
Loved them all. No matter how much experience one has in Excel, there is always so much to learn since we only learn enough to get our job done and miss out on other possibilities within excel, especially pivot tables. You are a great teacher.
Thank you Leila for always showing new Excel tips & tricks! I like #7. Thx!
Your voice is so calming and relaxing to listen too.
It's almost like a meditation video.
Tip 7 and 9 are amazingly new to me. Love it! Thanks a lot
Cool features. Thanks for sharing
My favorite is EVERYTHING! Thank you so much for sharing!
Thank you! I will also have to say no. 4 is my favorite. I had no idea you could do that.
Very good tips!!! Thanks!
Thank you for tip number 9 Leila. Love you!
Really great video! Thanks
All are best tips. Thank you
I loved all tips and tricks; Tip number 8 was most useful for me
Thank you for putting time stamps in for easy reference and navigation!
Loved all the tips
Amazing one again!!!!
Tip 3 is Valuable as your preferred. However all the tips useful. Thanks Leila... Keep following you.
Great video. My favourite was also number 4.
Tip 8 is quite handy. Thanks for sharing, Leila
All the tips are amazing - Thank you Leila Gharani. Waiting for the next step of tips :)
Your voice, the content, the value... everything is just in sync. Thank you for your videos :)
Thank you! Love Tip#9!
Great tips as always. Thanks
I think #10 will be very useful. Thank you, Leila!!
Centering Items from tips #7 is my favorite! Thanks for sharing
Thanks Leila, really informative!
Amazing,many thanks for all this tips
Very useful tips. Quite effective in huge data handling. Thanks
Thank you,time line is great
Thank you for sharing, great tips!
Such a great learning, i love your video always
So useful -- EVERYTHING!
I love tip #3. I had no idea we culd do this in excel.
The timeline function is great! Thank you for the video! 🙂
My favorite is #9!! Mindblowing! I just shared this video with the team!
Like the tip#3 .. Thank you for sharing
Tip #9 is my favorite. It save a lot of time. Thanks !!
Thank you for posting this helpful video
I knew all of them ... except tool settings sort a-z... so that is my fave. Love it!😍
Show Difference options are most important for me !
I loved Tip#9. It takes a lot of time to do that manually, which is VERY useful for EDA. Thanks!
Loved #7 for sure! I've always done the centering manually.
Love Tip 9 going to make life a little easier.
Very nice. My favorite is Tip 10.
I prefer No. 9. As always your video very informative, clear and easy to grasp. 👍
Glad you like it!
Great video, thank you for creating awesome content!
Thank You , Ma'am ! I loved it 👍
Excellent. The way you explain it is crystal clear.
Glad you think so!
I'd love to know more Pivot hacks --- particularly with complicated calculated fields, multi-pivots, etc 🎉
Number 8 and 9. Those are going to be very helpful!
Thanks for the suggestion
@@LeilaGharani Where is that excel sheet to practice?
Number 4 was genius!
Super useful information 👌 I really appreciate it you explain it so perfectly!
Thanks Leila for the informative tips ✌🏻🙏🏻
My favorite tips are 8 & 10
Great! As always 😊
#9 was very helpful, thanks!
8 through 10... thank you for sharing
love to watch you every single time
All of them are amazing
Number 4 & 7 are great!
Haven’t thought about it before. Thanks a lot!
Thanks for share
Great video as always. Tip 9 was my favourite, I'll definitely use that now.
No. 7 is my favourite.
Thank you.
Tip 9 was my favorite. Thank you.
wow all tips are extremely cool. As you said No.4 is amazing
Tip #7, in past used my vba rolldown to do that. Missed this since 12 years. Very useful after inserting as values to filtering it, or just using it as normal flat base table for further processing. Thanks for your emphatic instructions
I love this channel and it’s so useful! My favorite is no.9!
These are all great tips. The most intriguing one was the timeline feature. Never knew you could have that as a separate choice and dynamically change it. Thanka for sharing these. I'll keep this video handy. 😊
great video! number 9 and 2 are my favourite
Tip #9 is very useful for me, thanks so much!
Thank you for this video, my favorites tip are 4 and 7.
Top N is my favorite. Thank you.
THNX
Nr 3 is something I didn't know, so it becomes favorite :) Thanks for everything you do!
Shrink fit in pivot table...I use to do it manually all these years..loved it..time saving..you are a saviour 🙌
Thanks a lot ma'am. My favourite is timeline.
Thanks your videos are so cool👌
Thanks for showing us these tips. I like #3.
Great stuff Leila❤
Thanks indeed
Thank you for this information
No 8 is my favourite. Thank you
Beautiful, I can learn about Excel all day with you! :)
I love all your videos. They are very helpful. Thanks alot for your ideas. Love them all
I love the drag and drop tip! Gotta keep an eye on that Justin!
Love tip #10❤ always thought it’s impossible…
Glad you found something new.
Tip #9 🎉 very cool. Had been creating Calculated Field formulas.
Thank you ❤
My favorite are 9 and 10, in fact they are all cool!
Thank you
Tips 3, 7, & 9 are my favorite and ones I could see using most often for what I do. Great video Leila.
Glad you liked it!
Thank you.
i've enjoyed the tips, only few tips i didn't know, however i like when you give an idea how a tip can be useful
Hi Leila, Tip 9 is amazing for me. I had never use the same. Now I'll use the tip 9 in my reports. Thank You !!!!
Thank you- Really helpful tips...I found no 4- interesting
#9 is my favorite. I never knew about this before. Thanks for sharing!!!