You Won't Believe These Crazy PIVOT TABLE Hacks!

[@LeilaGharani]

Tired of wasting hours in Excel? Pivot Tables can cut your work in half 👉 www.xelplus.com/course/excel-pivot-tables/ 👈My Pivot Table Essentials course will teach you how. Grab the file I used in the video 👉 pages.xelplus.com/pivottable-pro-tips-file

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

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

[@Kiyoshi_9606]

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!

[@Seftehandle]

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

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

[@mariyastefanova4336]

Tip #4 is indeed by far the coolest one! Thank you for sharing, Leila!

[@stopthink7202]

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

[@silversolver7809]

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

[@artistgirish4974]

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

[@JUDGEmoreDollars]

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

[@LeilaGharani]

Glad you like it!

[@dilip1able]

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

[@fonzireyes]

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

[@LeilaGharani]

It never ends, Alfonso :)

[@FrikkieMuller]

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

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

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

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

[@VeretenoVids]

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

[@MariaHäggström]

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?

[@sukumarthatiparthi9691]

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

[@Lalindra_Fernando]

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

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

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

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

[@ysr88888]

Excellent. The way you explain it is crystal clear.

[@LeilaGharani]

Glad you think so!

[@knowitallproductions]

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

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

[@patrickpointer8380]

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

[@danielbell6044]

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

[@RahulGohrani]

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

[@MichaelBrown-lw9kz]

At 3:32, how did you get your slicers to have that slick, professional appearance?

[@davidtomasgaitanrodriguez1356]

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

[@anbua9792]

No 8 is my favourite. Thank you

[@tatianazanon2322]

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

[@nikden76]

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

[@pc-doctor1416]

Wow. The learning curve for Excel seems endless. How much more is there to learn? Brilliant video as always.

[@LeilaGharani]

There's always more to learn 😉

[@gaganmathur1488]

I loved 'Merge Pivot Cells' Tip. Desperately wanted to use it. Thanks 🙂

[@LeilaGharani]

Glad it was helpful!

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

[@cpage1122]

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

[@tutorials--1234]

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

[@humansizedaperture]

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

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

[@KamuiChanX]

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

[@JoseFelixCartayaTorres]

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

[@clevercoworker]

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

[@ianl1052]

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?

[@RMG4112]

Liked all of them😊

[@Unobelomafia]

Tip 8 is quite handy. Thanks for sharing, Leila

[@rouellanchesr.4248]

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

[@jphusereau]

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

[@mustafaabuelhasan6922]

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

[@andrewgeorge2853]

Thanks for the tips! No. 9 would've saved me a ton of work on a report I had to do.

[@pgcsec]

Number 8 - will be using that one for sure.

[@fabianrobertobencomo6884]

My favourite tip was # 9. Adding more calculations. Thanks

[@georgemensah2292]

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

[@jeanong9693]

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

[@LeilaGharani]

You're so welcome!

[@2012worship]

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

[@asamokla1]

Most loved tip is no. 7, it's a such good look for my data, and no need to disturbing merg cells

[@evamariatv48]

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

[@dfwsig]

Timeline was immediately useful for what I am currently playing with. Thanks for the videos

[@LeilaGharani]

Glad it was helpful!

[@nelsonrioux5555]

My favorite one is the Timeline. Thank you for your tips

[@nabiledelbi5502]

Although very obvious, I never noticed the options explained in number 2. Indeed, this one will be a good help for me.

[@limlydia7138]

A good recap of PT tip, Big Thanks, so clear in the steps.

[@yasserabdelgawad480]

Almost all tips have a new details for me , I like your work.

[@soroush.1983]

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

[@apamwamba]

My Fav is No.4 because of its useful applications. I did something similar just last week to use one slicer to control a chart. Say a slicer has three regions A,B,C. You click on A and it graph shows data from A only with a dynamic header using =UPPER(TEXTJOIN(",",TRUE,4:4)). But it would be nice if you could do a much more detailed video to show various ways in which you can customise to solve different scenarios.

[@thepalmi5982]

Yes, my thoughts exactly - a more detailed video of how Tip #4 was created from scratch would be epic. Thanks, Leila!

[@anhsingh5789]

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

[@billhart5746]

All the tips are great. My favorite is the custom sorting.

[@LuisCarlosChavez717]

Hi Leila, I appreciate your tips on how to use the PIVOT TABLE more effectively. You have shown me many features that I was unaware of. I can't pick a single tip as my favorite because they are all extremely useful. Thank you for sharing your knowledge.

[@LeilaGharani]

My pleasure, Luis!

[@ptgreen70]

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

[@kaniakowalska]

Tip No 3, 4 and repeat all item labels. I always had to create a formula to do it:) You are the best!!!! Thank you. By the way, is there any video showing me how to automatically insert data into cells based on start date & finish date? I have a calendar per day (in columns) and need to automatically divide the amount from one cell and insert it into the days (multiple cells) between a start and finish day. Many thanks! Kania

[@iskanderium]

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

[@kayrealist9793]

Thank you for tip number 9 Leila. Love you!

[@AalimOnlineOfficial]

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

[@desireewesson5140]

Tip #4 was my favorite!! Please do a detailed video on that one.

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

[@Eisakhan-ed7dp]

love to watch you every single time

[@epca_aq6511]

Fantastic! Thank you Leila!

[@electrifyny]

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

[@marianopacheco613]

Tip 9 was my favorite. Thank you.

[@jeppevissing7502]

Hi. Thanks for this video. Regarding no. 6 - how do I revert back to original text if I regret later on?

[@chirpybhoy]

Number 9 for me. Do you have a video to calculate the sales performance vs target? Thanks in advance.😊

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

[@susiekim7333]

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

[@anupandhi1430]

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

[@alperkins66]

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

[@TheMavlikan25]

Num 4 was pretty slick and given me some ideas, thanks :)

[@tomshannon6251]

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

[@LeilaGharani]

Gad to hear it, Tom!

[@nosoynadie5987]

Definitely 3 for me. Great lesson, I learned a lot.

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

[@ynotedaw6960]

I'll go with Tip 8. I've always had a little trouble dragging the fields. The typeover option will save me time and frustration.

[@Zafar.CXB_Blog]

Hi Leila, I like them all, Can you please advise how can I make certain formatting (adding and deleting rows and columns) to a downloaded excel sheet with same heading?

[@stresslaxing.]

Superb work. Thanks for everything,Leila

[@MrKalyankb2000]

My favourite was Tip No 9. Very useful.

[@trietluong8144]

Tip #5, I love it. Thanks so much

[@LeilaGharani]

Glad it was helpful!

[@alysevillarreal4719]

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

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

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

[@rameshradhanambi544]

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