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
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.
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.
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 :)
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!
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! 😎
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.
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!!!
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?
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.
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🎉🎉🎉🎉
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.
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?
Proud to say that I knew ALL of them! 🎉 It was nice to be reminded of #9 because I usually create explicit measures in PowerPivot, but this would be faster in many ad hoc situations. Thank you , Leila! 👍
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.
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.
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
Tip #1 is my fav! It helps to quickly preview the recommended pivot tables or even inspire you to review other better reporting formats. Tip #9 is a close second! So many times i needed mom% and yoy% quickly and I had to do clumsy edits but not anymore!
#10, but only because I didn’t know you could just double-click for details!! We use the show details function almost daily, and we always right-click and select Show Details…this will be a nice change!
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.
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.
7,8,9 are my top ones: custom sorting by writing in the cell, show values as - base item: previous Great job!
Tip #4 is indeed by far the coolest one! Thank you for sharing, Leila!
I'd love to know more Pivot hacks --- particularly with complicated calculated fields, multi-pivots, etc 🎉
Number 8 and 9. Those are going to be very helpful!
Thanks for the suggestion
@@LeilaGharani Where is that excel sheet to practice?
Number 4 was genius!
Super useful information 👌 I really appreciate it you explain it so perfectly!
Great video Leila! #3 Timeline Slicer I didn't know and it could be very handy for ad hoc 'browsing' thru reports. Thanks :)
I love 3 & 9 Tips.Timeline Slicer,Easy %-Change Calculations in Pivot Tables.
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 🙌
Your voice is so calming and relaxing to listen too.
It's almost like a meditation video.
I prefer No. 9. As always your video very informative, clear and easy to grasp. 👍
Glad you like it!
Im from India...you always learning to more in Excel... love you madam keep rocking...😊😊
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 :)
You're welcome!
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!
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! 😎
That's great to hear, Vijay! Perfect timing then.
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.
I've used hidden pivot tables before, but not managed to make it as pretty as yours. New things to learn! Thanks!
Tip 3 is Valuable as your preferred. However all the tips useful. Thanks Leila... Keep following 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!!!
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?
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.
I loved Tip#9. It takes a lot of time to do that manually, which is VERY useful for EDA. Thanks!
Tips 3, 7, & 9 are my favorite and ones I could see using most often for what I do. Great video Leila.
Glad you liked it!
My favorite is #3, the timeline. that may save me hours of work! Thank you Leila
I loved 'Merge Pivot Cells' Tip. Desperately wanted to use it. Thanks 🙂
Glad it was helpful!
I love the drag and drop tip! Gotta keep an eye on that Justin!
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🎉🎉🎉🎉
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 !!!!
Excellent. The way you explain it is crystal clear.
Glad you think so!
Number 4 & 7 are great!
Haven’t thought about it before. Thanks a lot!
Loved #7 for sure! I've always done the centering manually.
Very helpful! I've been centering labels manually for about a million years. You've probably saved me hours!
My favourite tip was # 9. Adding more calculations. Thanks
My favorite tip was #3, the time slicer. Thank you!
oh the excel rabbit hole goes deeper. I love it. thank you!!
It never ends, Alfonso :)
Leila, tip nº 4 is amazing! I was wondering if you have a video teaching how to create a report on this format?
Tip #9 was my favorite! I've been looking for an easy way to show that information! 😊
My favorite is #9!! Mindblowing! I just shared this video with the team!
Thank you for putting time stamps in for easy reference and navigation!
Tip 8 is quite handy. Thanks for sharing, Leila
Your voice, the content, the value... everything is just in sync. Thank you for your videos :)
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.
Yes, my thoughts exactly - a more detailed video of how Tip #4 was created from scratch would be epic. Thanks, Leila!
I knew all of them ... except tool settings sort a-z... so that is my fave. Love it!😍
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?
Nr 3 is something I didn't know, so it becomes favorite :) Thanks for everything you do!
#9 Easy % Change Calculation is my fav! Thanks Leila !
You're so welcome!
Thanks Leila for the informative tips ✌🏻🙏🏻
My favorite tips are 8 & 10
Great tips as usual 🎉. Which office version are you using?
No 8 is my favourite. Thank you
Tip #9 is my favorite. It save a lot of time. Thanks !!
I love #3 and #7. Always learning something new. Thank you so much!
Number 3 is a great function I didn't know about.
Thanks Leila
Wow. The learning curve for Excel seems endless. How much more is there to learn? Brilliant video as always.
There's always more to learn 😉
My favorite is EVERYTHING! Thank you so much for sharing!
Centering Items from tips #7 is my favorite! Thanks for sharing
All the tips are great. My favorite is the custom sorting.
Timeline was immediately useful for what I am currently playing with. Thanks for the videos
Glad it was helpful!
My favorite one is the Timeline. Thank you for your tips
Tip 7 and 9 are amazingly new to me. Love it! Thanks a lot
Proud to say that I knew ALL of them! 🎉 It was nice to be reminded of #9 because I usually create explicit measures in PowerPivot, but this would be faster in many ad hoc situations. Thank you , Leila! 👍
Same, but usually use calculated items/fields which really slows down the file. Great tips from Leila!
Thanks for watching! No surprise you knew all of them 😊
Most loved tip is no. 7, it's a such good look for my data, and no need to disturbing merg cells
I just saw your store! Awesome items. I'd love the option to buy the coffee mugs in tumbler form.
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.
Tip #4 was my favorite!! Please do a detailed video on that one.
Thanks for the tips! No. 9 would've saved me a ton of work on a report I had to do.
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.
My pleasure, Luis!
Very useful tips. Quite effective in huge data handling. Thanks
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
Thanks for another great video! #4 was my favorite, too.
Gad to hear it, Tom!
Hi Leila,
hope you doing well!!
Thank you for the above 10 tips. Would like to see video on Calculaton Field examples. Thank you.
Thank you for tip number 9 Leila. Love you!
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
I love this channel and it’s so useful! My favorite is no.9!
The timeline function is great! Thank you for the video! 🙂
My favourite was Tip No 9. Very useful.
Number 8 - will be using that one for sure.
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.
I think #10 will be very useful. Thank you, Leila!!
Thank you Leila for always showing new Excel tips & tricks! I like #7. Thx!
Tip #1 is my fav! It helps to quickly preview the recommended pivot tables or even inspire you to review other better reporting formats. Tip #9 is a close second! So many times i needed mom% and yoy% quickly and I had to do clumsy edits but not anymore!
Glad you found something helpful!
No 3 for me. Thanks for sharing. Good tips to remember to use
Glad you found it helpful.
Tip 9 was my favorite. Thank you.
Number 7 by far... this going to save time and make excel life so much better. I copy and paste and tidy this up manually 🤦🤦🤦
I loved the merge and center option. Always struggled with looking at the default layout.
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.
That's great to hear, Rajesh!
@@LeilaGharani It would be a great, If you take classes online one by one
Thanks for those tips. Could present the option to get a nice template by adding some borders and customize the proposed layouts.
Tip #9 🎉 very cool. Had been creating Calculated Field formulas.
Thanks for sharing such helpful tips. I'd like to use the #7
A good recap of PT tip, Big Thanks, so clear in the steps.
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.
Although very obvious, I never noticed the options explained in number 2. Indeed, this one will be a good help for me.
#10, but only because I didn’t know you could just double-click for details!! We use the show details function almost daily, and we always right-click and select Show Details…this will be a nice change!
Great! Glad it will come in handy.
Definitely 3 for me. Great lesson, I learned a lot.
Num 4 was pretty slick and given me some ideas, thanks :)
Nice tips! My favorites are #7 and #9.
Going with #3 - nice touch with "Back To The Future" clip.
Love all these tips, but I particularly liked the timeline one. Thank you 😊😊
Awesome! Thank you!