You Won't Believe These Crazy PIVOT TABLE Hacks! 

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

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.

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.

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.

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

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

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

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

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

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

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.

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

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

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!

Excellent. The way you explain it is crystal clear.

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

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

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

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

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

No 8 is my favourite. Thank you

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

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.

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

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

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

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

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

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

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

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

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

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?

Liked all of them😊

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.

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

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

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

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

Tip 8 is quite handy. Thanks for sharing, Leila

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

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

Number 8 - will be using that one for sure.

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

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

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

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

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

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

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

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

THNX

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

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

Tip 9 was my favorite. Thank you.

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

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

Fantastic! Thank you Leila!

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

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

All of them are amazing

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

Top N is my favorite. Thank you.

8 through 10... thank you for sharing

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

Thank you for tip number 9 Leila. Love you!

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

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

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

No. 7 is my favourite. Thank you.

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

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

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

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

Superb work. Thanks for everything,Leila

Thanks indeed

I LOVED 4 & 10

great video! number 9 and 2 are my favourite

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

Such a great learning, i love your video always

I like the timeline and that merge and center in #7

My favourite was Tip No 9. Very useful.

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

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

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

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

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

love to watch you every single time

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

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

Tipp number 9 is the best for me!

thank you @LeilaGharani on tip# 9 how to present the sales as a percentage out of the direct parent sub-total and also as a percentage of the grand total and one more question: lets say i have drivers and count of dispatched orders column and count of delivered orders column in the pivot table how to present the delivered count as a count AND one more time as a percentage

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

Really great video! Thanks

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

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.

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 :)

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

I loved 7 thru 10. These were all new to me.

Thank you.