You Won't Believe These Crazy PIVOT TABLE Hacks!

Подписаться 2,6 млн

Просмотров 665 тыс.

50% 1

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

Опубликовано:

15 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 689

@LeilaGharani 9 месяцев назад

Try it yourself! Grab the file I used in the video from here 👉 pages.xelplus.com/pivottable-pro-tips-file

@dutrades444 6 месяцев назад

Hi Leila, Have you moved the file? it's not there.

@Dan_In_Detroit Год назад

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.

@blue-oceandreamer2756 Год назад

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.

@Chastonicity Год назад

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.

@silversolver7809 Год назад

Great video Leila! #3 Timeline Slicer I didn't know and it could be very handy for ad hoc 'browsing' thru reports. Thanks :)

@kiyoshimatsutsuyu1931 Год назад

I'd love to know more Pivot hacks --- particularly with complicated calculated fields, multi-pivots, etc 🎉

@shannonnelson8829 Год назад

Number 8 and 9. Those are going to be very helpful!

@LeilaGharani Год назад

Thanks for the suggestion

@nomatusi7514 Год назад

@@LeilaGharani Where is that excel sheet to practice?

@laurawidener9659 Год назад

Number 4 was genius!

@Optix-Code 11 месяцев назад

Super useful information 👌 I really appreciate it you explain it so perfectly!

@Zero2CFO_cliveangel Год назад

Hi Leila, your videos are excellent - simple but thorough, insightful and engaging. Thank you for sharing your knowledge and tips

@stopthink7202 4 месяца назад

Your voice is so calming and relaxing to listen too. It's almost like a meditation video.

@philipmanalu3028 10 месяцев назад

It's so useful. Love it. Thanks Leila.

@FrikkieMuller Год назад

Thank you! I will also have to say no. 4 is my favorite. I had no idea you could do that.

@anhsingh5789 Год назад

Thank you Leila for always showing new Excel tips & tricks! I like #7. Thx!

@PharmalinaPharmacy 3 дня назад

All the tips are really useful

@AAA-ok4qw Месяц назад

Amaizing. Thank you!

@epca_aq6511 Год назад

Fantastic! Thank you Leila!

@2012worship Год назад

I love #3 and #7. Always learning something new. Thank you so much!

@davidtomasgaitanrodriguez1356 Год назад

Your voice, the content, the value... everything is just in sync. Thank you for your videos :)

@olliehopnoodle4628 11 месяцев назад

Really great video! Thanks

@cochi2203 7 месяцев назад

Very good tips!!! Thanks!

@rameshradhanambi544 9 месяцев назад

All the tips are amazing - Thank you Leila Gharani. Waiting for the next step of tips :)

@narayanaprasadbabu6983 11 месяцев назад

All are best tips. Thank you

@mustafaabuelhasan6922 Год назад

Tip 7 and 9 are amazingly new to me. Love it! Thanks a lot

@danielbell6044 Год назад

Thank you for putting time stamps in for easy reference and navigation!

@positivewordalex9575 11 месяцев назад

Such a great learning, i love your video always

@lisagurr5037 6 месяцев назад

Great video, thank you for creating awesome content!

@souravkumarnanda2609 11 месяцев назад

Amazing one again!!!!

@stresslaxing. Год назад

Superb work. Thanks for everything,Leila

@mayankkhandelwal3854 3 месяца назад

Loved all the tips

@JUDGEmoreDollars Год назад

I prefer No. 9. As always your video very informative, clear and easy to grasp. 👍

@LeilaGharani Год назад

Glad you like it!

@kayrealist9793 Год назад

Thank you for tip number 9 Leila. Love you!

@Lalindra_Fernando Год назад

Tip 3 is Valuable as your preferred. However all the tips useful. Thanks Leila... Keep following you.

@DebiSenGupta 10 месяцев назад

Great tips as always. Thanks

@kevinarvisais6814 Год назад

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

@indrajeetchouhan4655 4 месяца назад

Thanks Leila, really informative!

@Srimaym Год назад

Like the tip#3 .. Thank you for sharing

@othmarlippuner3197 Год назад

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

@rouellanchesr.4248 7 месяцев назад

My favorite is EVERYTHING! Thank you so much for sharing!

@Ommbye 7 месяцев назад

Thanks your videos are so cool👌

@ysr88888 8 месяцев назад

Excellent. The way you explain it is crystal clear.

@LeilaGharani 8 месяцев назад

Glad you think so!

@alfredtomiamubiaya3330 Год назад

Amazing,many thanks for all this tips

@avitalpol5389 Год назад

Thank you,time line is great

@anupandhi1430 11 месяцев назад

Very useful tips. Quite effective in huge data handling. Thanks

@jhors7777 11 месяцев назад

Thank you for posting this helpful video

@Unobelomafia Год назад

Tip 8 is quite handy. Thanks for sharing, Leila

@alperkins66 Год назад

I think #10 will be very useful. Thank you, Leila!!

@Mm-Ha-69 7 месяцев назад

All of them are amazing

@iskanderium Год назад

The timeline function is great! Thank you for the video! 🙂

@deshanchathura 10 месяцев назад

Cool features. Thanks for sharing

@RahulGohrani Год назад

I loved Tip#9. It takes a lot of time to do that manually, which is VERY useful for EDA. Thanks!

@charityoly809 Год назад

I love all your videos. They are very helpful. Thanks alot for your ideas. Love them all

@giorgizhorzholiani4739 Год назад

THNX

@Freedomfastlane100 10 месяцев назад

Thank you for sharing, great tips!

@JoseFelixCartayaTorres Год назад

Tip #9 is my favorite. It save a lot of time. Thanks !!

@rouellanchesr.4248 Год назад

So useful -- EVERYTHING!

@mikebrook8500 Год назад

Great video as always. Tip 9 was my favourite, I'll definitely use that now.

@prathameshbile5865 Год назад

Thank You , Ma'am ! I loved it 👍

@user-lh7bn1kr3c Год назад

Thank you so much. I can't wait for your next structured course! Personally I am looking forward to seeing the one with Power Automate, and Excel Dashboard collaborating with both Power Query and Power Pivot. Again, thanks a lot!

@banamthegreat 2 месяца назад

Great stuff Leila❤

@byronstutorialspage2134 Год назад

I knew all of them ... except tool settings sort a-z... so that is my fave. Love it!😍

@aravinddevisetti 7 месяцев назад

Very nice. My favorite is Tip 10.

@knowitallproductions Год назад

Very helpful! I've been centering labels manually for about a million years. You've probably saved me hours!

@georgemensah2292 Год назад

Loved #7 for sure! I've always done the centering manually.

@ronyorobio7096 6 месяцев назад

Great video. My favourite was also number 4.

@artistgirish4974 Год назад

Shrink fit in pivot table...I use to do it manually all these years..loved it..time saving..you are a saviour 🙌

@KamuiChanX Год назад

Number 4 & 7 are great! Haven’t thought about it before. Thanks a lot!

@ashishsharma9563 Год назад

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

@amykondo4903 11 месяцев назад

Thank you! Love Tip#9!

@lisahochhauser5176 Год назад

All great tips. My favorite was the "type to sort". I'm always trying to drag items, and find it very cumbersome because it doesn't always move well. This is a much more exact method!

@RMG4112 Год назад

Liked all of them😊

@vijayarjunwadkar Год назад

Thank you Leila! I was revising my Pivot table skills recently and this video is just-in-time! I liked the Pivot table without using Pivot table tip! It's really cool! 😎

@LeilaGharani Год назад

That's great to hear, Vijay! Perfect timing then.

@joshuaramcharan9735 Год назад

Thank you for this information

@Eisakhan-ed7dp 26 дней назад

love to watch you every single time

@susiekim7333 Год назад

I love this channel and it’s so useful! My favorite is no.9!

@anniemichalik3834 Год назад

Tip #9 🎉 very cool. Had been creating Calculated Field formulas.

@nikden76 Год назад

Nr 3 is something I didn't know, so it becomes favorite :) Thanks for everything you do!

@mahmoudasad3348 Год назад

Great! As always 😊

@marianopacheco613 Год назад

Tip 9 was my favorite. Thank you.

@wannabedal-adx458 Год назад

Tips 3, 7, & 9 are my favorite and ones I could see using most often for what I do. Great video Leila.

@LeilaGharani Год назад

Glad you liked it!

@hughraftery 10 месяцев назад

Thanks for showing us these tips. I like #3.

@David_K_Dickson Год назад

No. 7 is my favourite. Thank you.

@user-bo8ou9ws5z Год назад

#9 was very helpful, thanks!

@adesh465 Год назад

Awesome, Leila. Mast

@soroush.1983 Год назад

Thanks Leila for the informative tips ✌🏻🙏🏻 My favorite tips are 8 & 10

@dantemaese8316 Год назад

All of them were my favorite ones, thank you for sharing these nice tips :)

@vernacularbarnarchitecture Год назад

I love the drag and drop tip! Gotta keep an eye on that Justin!

@clevercoworker Год назад

Centering Items from tips #7 is my favorite! Thanks for sharing

@bharathau8085 10 месяцев назад

Hi, it was awesome... Centering items is my favorite.

@luisllontopbarahona3188 6 месяцев назад

8 through 10... thank you for sharing

@25363971 10 месяцев назад

Love them all❤

@user-rq6sg9cu3l Год назад

Great video, learning a lot and enjoying your videos, #4 was my favorite, too......

@andreslh Год назад

great video! number 9 and 2 are my favourite

@user-bu4pg6vq9w Год назад

Like many already have said, you’re a great teacher! 🌟 I liked all your tips 😊 but this “compare to previous month”, is there any trick to also compare January with December?