You Won't Believe These Crazy PIVOT TABLE Hacks!

Рет қаралды 657,717

Күн бұрын

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

Пікірлер: 685

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

@JA-hy8nu 8 күн бұрын

Beautiful, I can learn about Excel all day with you! :)

@banamthegreat 2 ай бұрын

Great stuff Leila❤

@AAA-ok4qw Ай бұрын

Amaizing. Thank you!

@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 11 ай бұрын

Number 4 was genius!

@Optix-Code 11 ай бұрын

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

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

@guruduttphadke8291 11 ай бұрын

I loved all tips and tricks; Tip number 8 was most useful for me

@ronyorobio7096 5 ай бұрын

Great video. My favourite was also number 4.

@tatianazanon2322 24 күн бұрын

Leila, tip nº 4 is amazing! I was wondering if you have a video teaching how to create a report on this format?

@mayankkhandelwal3854 3 ай бұрын

Loved all the tips

@user-cs5th2qx4n 2 ай бұрын

Hi Leila, my favorite is No 8: Custom Sorting Pivot Table Fields. 😉 Pivot table are so quick that i need to build up my confidence in trusting it ...that is... is it going what I want it to do... is it including all my data. etc.

@tarikuwodajo1019 11 ай бұрын

wow all tips are extremely cool. As you said No.4 is amazing

@aravinddevisetti 6 ай бұрын

Very nice. My favorite is Tip 10.

@fonzireyes Жыл бұрын

oh the excel rabbit hole goes deeper. I love it. thank you!!

@LeilaGharani Жыл бұрын

It never ends, Alfonso :)

@anniemichalik3834 11 ай бұрын

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

@cochi2203 6 ай бұрын

Very good tips!!! Thanks!

@tiffanym8720 10 ай бұрын

I like the slicer the most:) it has given me some idea of how to improve my current reporting template:), the change in previous month/year is also liked.

@dilip1able 11 ай бұрын

I love 3 & 9 Tips.Timeline Slicer,Easy %-Change Calculations in Pivot Tables.

@silversolver7809 Жыл бұрын

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

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

@Ah90med Жыл бұрын

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

@hajasahib8943 Ай бұрын

Awesome features, well explained 👏 thank you 🎉

@LeilaGharani Ай бұрын

My pleasure 😊

@stopthink7202 3 ай бұрын

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

@letras93 11 ай бұрын

Love Tip 9 going to make life a little easier.

@narayanaprasadbabu6983 11 ай бұрын

All are best tips. Thank you

@Eisakhan-ed7dp 12 күн бұрын

love to watch you every single time

@lisagurr5037 6 ай бұрын

Great video, thank you for creating awesome content!

@Hari-wb5ds 10 ай бұрын

Good one 👏🏻👏🏻. Congrats from India 😎👍🏻

@philipmanalu3028 10 ай бұрын

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

@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

@FrikkieMuller Жыл бұрын

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

@Zero2CFO_cliveangel Жыл бұрын

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

@AalimOnlineOfficial 11 ай бұрын

Great tips as usual 🎉. Which office version are you using?

@stresslaxing. Жыл бұрын

Superb work. Thanks for everything,Leila

@2012worship Жыл бұрын

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

@pgauthier5274 Жыл бұрын

Hi Leila, tip #7 for me as it makes it look professionnal !

@deshanchathura 10 ай бұрын

Cool features. Thanks for sharing

@Nitish_Rautela 4 ай бұрын

Show Difference options are most important for me !

@avitalpol5389 Жыл бұрын

Thank you,time line is great

@anhsingh5789 Жыл бұрын

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

@anbua9792 Жыл бұрын

No 8 is my favourite. Thank you

@Srimaym Жыл бұрын

Like the tip#3 .. Thank you for sharing

@andreslh Жыл бұрын

great video! number 9 and 2 are my favourite

@olliehopnoodle4628 11 ай бұрын

Really great video! Thanks

@ianl1052 11 күн бұрын

Great video. I learned so much from you again. I was going to choose #7 at first, but then changed my mind. #4 is super cool. I keep seeing Don Johnson creeping up. Are you another Miami Vice fan?

@mohammedsalem8154 Жыл бұрын

My favorite are 9 and 10, in fact they are all cool! Thank you

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

@WitoldWiniarczyk Жыл бұрын

Thank you for this video, my favorites tip are 4 and 7.

@sebastienemir151 6 ай бұрын

Thanks for those tips. Could present the option to get a nice template by adding some borders and customize the proposed layouts.

@JUDGEmoreDollars Жыл бұрын

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

@LeilaGharani Жыл бұрын

Glad you like it!

@kayrealist9793 11 ай бұрын

Thank you for tip number 9 Leila. Love you!

@positivewordalex9575 10 ай бұрын

Such a great learning, i love your video always

@rameshradhanambi544 8 ай бұрын

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

@Lalindra_Fernando Жыл бұрын

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

@mustafaabuelhasan6922 Жыл бұрын

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

@rouellanchesr.4248 7 ай бұрын

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

@davidtomasgaitanrodriguez1356 Жыл бұрын

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

@artistgirish4974 11 ай бұрын

Difference from previous month and year was interesting and useful which I was looking

@hyderabadmillennial7126 Жыл бұрын

Thanks a lot ma'am. My favourite is timeline.

@souravkumarnanda2609 11 ай бұрын

Amazing one again!!!!

@9Xeroo Жыл бұрын

I will give thumbs to you for #9 which helps to see the Growth over Last Month or Year, which is much used in sales Analysis like GOLM and GOLY

@JustMe-sh8nd Жыл бұрын

😮 And yet again a few surprises, the more i know about exel the more i see how less i already know hahaha The sorting in the field list... that is my favorite

@hengzhang3431 Жыл бұрын

Love #9! Wish I have learned this sooner

@epca_aq6511 Жыл бұрын

Fantastic! Thank you Leila!

@Unobelomafia Жыл бұрын

Tip 8 is quite handy. Thanks for sharing, Leila

@danielbell6044 Жыл бұрын

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

@gapdk1976 7 ай бұрын

I LOVE you so much!!! Kisses from Greece... You are my master-woman (in Excel)

@Kunalindia3 Жыл бұрын

Nice. All 'Power-Pivot' to you

@clevercoworker Жыл бұрын

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

@artistgirish4974 11 ай бұрын

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

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

@evamariatv48 10 ай бұрын

My favorite is #9!! Mindblowing! I just shared this video with the team!

@georgemensah2292 Жыл бұрын

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

@ysr88888 8 ай бұрын

Excellent. The way you explain it is crystal clear.

@LeilaGharani 8 ай бұрын

Glad you think so!

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

@DPaquette Жыл бұрын

I do like the disable double click and the change % to the previous item in the list when looking at months and years.

@Seftehandle Жыл бұрын

7,8,9 are my top ones: custom sorting by writing in the cell, show values as - base item: previous Great job!

@iskanderium Жыл бұрын

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

@tedljong2280 3 ай бұрын

Thanks for a great video, my favorite is nr 3 Timeline

@alperkins66 Жыл бұрын

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

@nchola2003 3 ай бұрын

I liked all of them and it is hard to pick one of them :) . thanks for such nice videos

@DebiSenGupta 10 ай бұрын

Great tips as always. Thanks

@carloszelaya5359 Жыл бұрын

Tip #9 was for me the coolest. Girl Boss!!!

@byronstutorialspage2134 Жыл бұрын

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

@vernacularbarnarchitecture Жыл бұрын

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

@RahulGohrani Жыл бұрын

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

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

@luisllontopbarahona3188 6 ай бұрын

8 through 10... thank you for sharing

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

@hansangb 11 ай бұрын

Thanks! So very useful!

@LeilaGharani 9 ай бұрын

Glad to hear that!

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

@LearnExcelwithRafi Жыл бұрын

you are a great teacher in Microsoft excel. I have learn a lot from your videos. Now i have my own channel and i am trying to publish the videos in regular basis in my own language.