You Won't Believe These Crazy PIVOT TABLE Hacks!

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

[@LeilaGharani]

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

[@dutrades444]

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

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

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

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

[@silversolver7809]

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

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

[@Seftehandle]

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

[@artistgirish4974]

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

[@FrikkieMuller]

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

[@Lalindra_Fernando]

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

[@stopthink7202]

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

[@knowitallproductions]

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

[@dilip1able]

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

[@2012worship]

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

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

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

[@RahulGohrani]

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

[@Mark.Rustin]

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.

[@piggybankaccountant]

I love that layout "Field list" that is more in a column rather than in a square. What I also like is the b utton "Defer Layout Update" so you dont mess your data next to your pivot table!!! Gr8 video thank you!!!

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

[@davidtomasgaitanrodriguez1356]

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

[@Zero2CFO_cliveangel]

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

[@gusmolina4659]

I agree with you, Leila, with Tip # 4 as being the most useful. It is hard to identify a single tip since tip #10 was just as useful at least in my line of work. Thank you very much for sharing this information.

[@VeretenoVids]

I've used hidden pivot tables before, but not managed to make it as pretty as yours. New things to learn! Thanks!

[@anhsingh5789]

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

[@byronstutorialspage2134]

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

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

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

[@tjones7070]

Your content is awesome, keep it up! My favorite feature (because I didn't know about it) was the center labels feature! Question: For Top N filtering, is there a way to collapse the remainder of the items into an "all other" label, or show a Sub-Total, and Grand Total of all the data? I currently do this with grouping, but it does not allow for dynamic updates. I suppose i could add a column in the data, but ideally would not have to do this.

[@patrickpointer8380]

My favorite is #3, the timeline. that may save me hours of work! Thank you Leila

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

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

[@rameshradhanambi544]

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

[@JUDGEmoreDollars]

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

[@LeilaGharani]

Glad you like it!

[@georgemensah2292]

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

[@mrrhinoinhouse]

Always a great video & knowledge from you! My favorite is number 7, though I know the function of % differences, I never know we can pull same fields for two or three times. Will definitely use this method from now on. Since we are on this topic, I’d love to get your help - is there a way to get sales value field to be a calculation of 12-month rolling basis (or year-to-date) with a click of a button? I’ve explored many ways (like Calculated Fields, Slicer, etc) but to no avail. Hope you can help on this!

[@kayrealist9793]

Thank you for tip number 9 Leila. Love you!

[@evamariatv48]

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

[@mustafaabuelhasan6922]

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

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

[@KamuiChanX]

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

[@matthewsjardine]

As someone that lives in Excel at work, I already knew most of these. That said, thank you for the last tip! The number of times I have had that explore data thing create another sheet is too much for me to want to admit haha 😂 It may just have driven me into the madhouse at one point.

[@rouellanchesr.4248]

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

[@nikden76]

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

[@tiffanym8720]

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.

[@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]

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

[@HenricAndersen]

I have been using pivot tables for many years but newertheless I learned a few new tricks. It's difficult to pin point a specific one but I really like the way you use pivot tables creative to make a slicer value (# 4)

[@alperkins66]

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

[@mikebrook8500]

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

[@cpage1122]

Tip #9 was my favorite! I've been looking for an easy way to show that information! 😊

[@philipmanalu3028]

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

[@alysevillarreal4719]

I just saw your store! Awesome items. I'd love the option to buy the coffee mugs in tumbler form.

[@ryanshuell]

#9 is my favorite. I never knew about this before. Thanks for sharing!!!

[@Unobelomafia]

Tip 8 is quite handy. Thanks for sharing, Leila

[@_logicking]

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

[@danielbell6044]

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

[@sukumarthatiparthi9691]

Im from India...you always learning to more in Excel... love you madam keep rocking...😊😊

[@liching35]

Thanks SO MUCH. I love #10. I often had to copy/paste the pivot table info into a new table so that users don't click on to get extra worksheet that would confuse them.. This tip is GREAT!!! I mean, all 10 tips are great! Thanks so much :)

[@LeilaGharani]

You're welcome!

[@JoseFelixCartayaTorres]

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

[@noohinaaz183]

I can't be partial to other tips if m going to choose one of them but seriously THE VIDEO WAS HIGHLY USEFUL like waaaaay too much.. Thnq so so sooo much really🎉🎉🎉🎉

[@steveyoung4420]

I was not aware that you could do tip number 9! Thanks for bringing us this useful content!

[@stresslaxing.]

Superb work. Thanks for everything,Leila

[@lisagurr5037]

Great video, thank you for creating awesome content!

[@soroush.1983]

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

[@positivewordalex9575]

Such a great learning, i love your video always

[@timbrykkk]

I loved the merge and center option. Always struggled with looking at the default layout.

[@susiekim7333]

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

[@clevercoworker]

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

[@dantemaese8316]

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

[@anniemichalik3834]

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

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

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

[@iskanderium]

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

[@anupandhi1430]

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

[@WitoldWiniarczyk]

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

[@piotrwidarski]

Thank You for this video. I know most of these features but the 9'th one was new to me and will be very useful.

[@epca_aq6511]

Fantastic! Thank you Leila!

[@jphusereau]

My favorite tip was #3, the time slicer. Thank you!

[@charityoly809]

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

[@souravkumarnanda2609]

Amazing one again!!!!

[@tarikuwodajo1019]

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

[@deshanchathura]

Cool features. Thanks for sharing

[@SaskiaJacobsen_Toels-PC]

I like #4 most because of the creative idea behind it! But most of all I am very happy that I can add my own default pivot table layout since a few months...! Now waiting for a default number format setting in pivot tables (most of the times I change it into 0 decimals and thousand separator!)

[@alfredtomiamubiaya3330]

Amazing,many thanks for all this tips

[@ishtiyaquesayyed7092]

Hi Leila, hope you doing well!! Thank you for the above 10 tips. Would like to see video on Calculaton Field examples. Thank you.

[@rajeshaytha3678]

Loved it, i have been watching your videos and applying at my work station and got appreciated Thanks a lot @Leila I love Tip#4 but I like all TIPS.

[@LeilaGharani]

That's great to hear, Rajesh!

[@rajeshaytha3678]

@@LeilaGharani It would be a great, If you take classes online one by one

[@Srimaym]

Like the tip#3 .. Thank you for sharing

[@lppadua2047]

Thanks for sharing such helpful tips. I'd like to use the #7

[@user-rq6sg9cu3l]

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

[@ptgreen70]

Number 3 is a great function I didn't know about. Thanks Leila

[@deebaxley7800]

As always, great information! My favorite(s) = #3 & #9.

[@Ommbye]

Thanks your videos are so cool👌

[@tomshannon6251]

Thanks for another great video! #4 was my favorite, too.

[@LeilaGharani]

Gad to hear it, Tom!

[@jeanong9693]

#9 Easy % Change Calculation is my fav! Thanks Leila !

[@LeilaGharani]

You're so welcome!

[@wirts_other_leg]

Tip #9 is very useful for me, thanks so much!

[@amateurhour-solderingelect345]

Great tips as always! Thank you. For me, it was tip #9

[@Freedomfastlane100]

Thank you for sharing, great tips!

[@sebastienemir151]

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

[@avitalpol5389]

Thank you,time line is great

[@alman7628]

I liked 5 and 9. Amazing video by the way. Thank you.