Download the practice file I used in the video 👉 pages.xelplus.com/pivot-table-hidden-features 👉 Join Pivot Table Essentials course 👉 www.xelplus.com/course/excel-pivot-tables/
😁😁😁 ... Leila's back! ... Leila's Back! ... Leila's BACK!!! Morning light has yet to arrive, but with a mug of hot black coffee (and pound cake), I stare intently at the monitor and try to hang on every word ... repeatedly hitting the back arrow key to repeat what Prof Leila just mentioned ... with Pivot Table ideas popping in my head like flashbulbs. I will run out of coffee long before I will fully digest all suggestions presented in this terrific video ( ... ANOTHER terrific video ... but no surprise). I'm a long way from Pivot Table mastery (still need master the 'basics') but always look forward to the lessons taught in Prof Leila's class ... 😍😍😍 ... thank you ... thank you ... thank you. PS At the 5:20 mark: " ... he probably has to work in his language skills and tone ...". Gee ... 🤔... I wonder who could help him with that? ... 🤭
This should be the official breakfast for champions: black coffee, cake and some serious Pivot Table action.😊 Thank you as always for the kind words and your ongoing support! 🙏
This was great! I have been creating pivot tables for the past 15 years and have taken three PT courses. I still learned a couple of new things in this video. I am compelled to subscribe. Thank you!
Thank you Leila, always learn something new by watching your videos. Conditional formatting came as an unexpected surprise. I’ll make sure to use it on my next reports :) Appreciate your valuable lessons
Some of these i learned but most I didn't. I've been training for over 35 years and using PivotTables since they first came out. Absolutely amazing! I thought I knew everything there was to know. Thank you!
great highlights Leila! I use pivot tables every single day and there a lot of tricks and shortcuts that I just learned. Massive thank you, keep up the fantastic advisory and teaching lessons. Bravo!
Another great video Leila thanks. If you could make some video about building some reports/dashes using for example multiple date calendars (Ex: open_tickets_date and close_tickets_date) and good practices with slicers and pivot tables is going to be awesome.
Thanks for this informative video. Two features is totally new for me while I'm using the Excel in every single day. 1. Set default Pivot table setting. 2.Report filter pages. I'll start using them immediately. Thanks once again.
Love the dynamic formatting idea! Love the settings for the default. Love the FILTERS worksheet. I’ll be applying these things immediately to my work product. Thank you
Another amazing video, Leila! I found myself doing Excel pivot table work the same way year after year and always acquiescing to the few moments of added formatting work. Changing the defaults will make a nice difference! Thank you for so expertly explaining it!! I also love how you incorporate your sense of humor and fun into them, like the use of the BB character names and clip, and how you creatively and gently invite people to like and subscribe to your channel, e.g. the text pop-up in this one. I'm curious if you, or anyone of your followers can help. About the Report Filter Pages, once created, what's the most efficient way to copy or export each resulting tab (and the individual's underlying data) to new Excel files (not PDF) so they can be sent to the individual reps, without access to the other reps data?
Is there a way to keep default settings for slicers? I like to go into properties > Don't move or size with cells. Also defaulting the slicer connections to all pivot tables? Thank you! Love your channel! I learn something new all the time from your videos!
Hi Lelia, I had subscribed your channel more than 4years, your video is very useful and I learned a lot of equations of excel, but could you please teach me how to hide the worksheet and don’t let other people to see it in google sheet? Thanks
I wanted to express my admiration for your exceptional teaching skills and ability to simplify complex concepts. Thank you for your dedication. I'm reaching out for guidance on creating unique count options in pivot tables. Could you please assist me with this? Best regards, kumar P
i am information technology students everday i advance my self with excel word powerpoint access forms docs also learning new features in AI i listen to all my tech supporters. SO far this course is also the best continue making more videos i love this channel
Thank you, Leila. Even though I’ve been using Pivot Tables for over 10 years, I still find something new to learn from you. I have a question that’s been a headache for me in Pivot Tables: I have to apply number formatting to each column separately. Is there a way to format the entire table in one move or set it as a default? Thanks in advance.
Hmm, you can predefine formatting for measures in Power Pivot. But even then you have to apply it for every measure separately. There is no option to do it for the entire table.
I learned a lot from you, especially about Microsoft Office. It really helps me in my work. Thank you very much for the knowledge you share. May your good deeds be rewarded by God. Always be healthy and successful!
I find the default settings for Pivot Table options, particularly the "Show in Tabular Form" option and the unchecked "Autofit Column Widths on Update" option, to be highly beneficial in reducing the risk of repetitive strain injury (RSI).
Happy Teacher's Day!🎉 my favourite pt features are label/value filters and show values as. Not sure if anything changed but the audio of this video is great!!!
Many features were there that I overlooked 🤣🤣🤣. You've been my best source of learning for years ‼️ Then I act like I'm a genius that's helping people. For those who are eager to learn, I have your channel to point them to... Thank you for your great content!
Many people still underestimate excel, as if excel only has standard formula features. In fact, excel is now very good and capable of doing various things. Not only pivot tables, but excel even has a strong connection with power query which is also very strong in helping you process data. Sometimes people who underestimate excel may not know the new excel features and think it is still like excel 2003/2007.
Interesting and useful video yet again (though after a gap!), thank you Leila! Looking forward eagerly to your new Pivot Table course. I am sure it will be a great value add just like your other ones! All the best! 🙂
Thank you so much for your always very useful tutorials! if I highlight the cell and then click on update all, every now and then this formatting is deleted even if I have flagged "maintain cell formatting when updating" in the options: do you know why? thanks in advance
The last tip is something I should try... For two years I got used to using functions that literally made pivot tables redundant. (Except for cases where I needed a refresh to be manual and not automatic, or controlled by a controller) Then I started working in a new place and with Office 16, I don't have any of these functions, and I'm rediscovering the pivots... Bottom line? I learned during this time how important it is to get to know as many features and functions as possible. Suddenly I found out what the hell a function like "address" for example is needed for...😂
Nice video Leila as always. May i ask what do you use to record your screen and what do you use to edit them.? I mean those zoom in and out, highlighted boxes . I saw that there are some tools that do all this using only shortcuts and save a lot of post production time and wonder if you are using one of those tools
Great tips! Thanks, Leila! Does the Report Filter Pages add new sheets upon refresh if the source data gets updated and there's a new Responsible Person?
Leila. Amazing! I'm on a multi mil $ project and am a mainframe coder. I need to come up with a compare strategy between 2 sheets. 3 columns make up the index that I need to use to do ' join' on 2 sheets. Then I want to auto highlight every non index field in left sheet that matches the non index fields in right sheet based on index (join). Any tips? Thanks!
Download the practice file I used in the video 👉 pages.xelplus.com/pivot-table-hidden-features
👉 Join Pivot Table Essentials course 👉 www.xelplus.com/course/excel-pivot-tables/
Changing the default pivot table was so BIG!!! Thanks for that!
When I discovered that I did a dance
The smile on my face needed to be seen, when I saw that.
Me too!
Filter options that replicate to each tab is one I overlooked and will find so useful in the future. Thanks Paul
We miss you madam these days, Happy Teacher's day
Thank you!
Default settings was a game changer for me. Thanks a lot Leila!!
Our pleasure! It's one of those things that can really make a difference.
For some reason default layout settings changed are not working for me. Excel is still giving default layout.
😁😁😁 ... Leila's back! ... Leila's Back! ... Leila's BACK!!!
Morning light has yet to arrive, but with a mug of hot black coffee (and pound cake), I stare intently at the monitor and try to hang on every word ... repeatedly hitting the back arrow key to repeat what Prof Leila just mentioned ... with Pivot Table ideas popping in my head like flashbulbs. I will run out of coffee long before I will fully digest all suggestions presented in this terrific video ( ... ANOTHER terrific video ... but no surprise).
I'm a long way from Pivot Table mastery (still need master the 'basics') but always look forward to the lessons taught in Prof Leila's class ... 😍😍😍 ... thank you ... thank you ... thank you.
PS
At the 5:20 mark: " ... he probably has to work in his language skills and tone ...". Gee ... 🤔... I wonder who could help him with that? ... 🤭
This should be the official breakfast for champions: black coffee, cake and some serious Pivot Table action.😊
Thank you as always for the kind words and your ongoing support! 🙏
@@LeilaGharani 😂🤣😂
This was great! I have been creating pivot tables for the past 15 years and have taken three PT courses. I still learned a couple of new things in this video. I am compelled to subscribe. Thank you!
Never Is too late to learn something that was in front of your face for such a long time.
Thank you so much!
You're a great and generous teacher.
When you think you know stuff, you always learn from Leila. Brilliant videos always. God bless!
Thank you. I'm always learning myself
Brilliant! Especially changing defaults. You are a star Leila!
Wish you happy Teachers Day.
Keep teaching
Thank you!
I would request a deep dive into ‘insert calculated field’ feature for pivot tables where you can insert various formulae inside pivot tables
Thank you! As much as I use Pivot Tables, I didn’t know about that conditional format button on the side! I’ll be playing around with that soon!!
It's easily overlooked. Hope it will come in handy for you.
Really we appreciate you because you are one of few people give us benefit content 🎉🎉🎉
Glad you posted again, we missed you!
As always great tips
Thank you Leila, always learn something new by watching your videos. Conditional formatting came as an unexpected surprise. I’ll make sure to use it on my next reports :) Appreciate your valuable lessons
Thanks for the Filter advice. Perfect for my needs
Some of these i learned but most I didn't. I've been training for over 35 years and using PivotTables since they first came out. Absolutely amazing! I thought I knew everything there was to know. Thank you!
This was so great, Leila - thank you!
My favorite is Report filter pages
A great set of tips that I’ll put into use, first thing I’ll fix is that annoying auto resize option that I can turn off forever!
Thanks!
All of these were new to me!! Great post
Thank you!
Excellent Leila!!
Thank you! Cheers!
Happy teacher day dear madam...
Excel teacher ki... Jai
It is truly amazing how technology keeps transforming essential Excel features by making them more user friendly. Great video.....
Thanks, great content as always...whenever I need to update my office package knowledge you're my favorite teacher ❤
Thank you for the Report Filter Pages. So much time will be saved.
Our pleasure!
great highlights Leila! I use pivot tables every single day and there a lot of tricks and shortcuts that I just learned. Massive thank you, keep up the fantastic advisory and teaching lessons. Bravo!
Default settings and report filters are both great additions to my pivot knowledge. Many thanks Leila!
Thanks!
Really useful thanks!
Glad it was helpful!
Brilliant as always.. You are my go to excel person!
For me too!!!
Thank you so much!
Default pivot table as well as filter pages made my day. I also didn't know you could hide the numbers.
Thank you for the wonderful tips
Glad you like them!
Great tips!
Filter pages! What an awesome feature!! Thank you!
It really is!
Great help thanks. I do a fair bit of data analysis and use pivot tables alot. I'll try these features.
Great! I hope they'll come in handy for you.
Another great video Leila thanks. If you could make some video about building some reports/dashes using for example multiple date calendars (Ex: open_tickets_date and close_tickets_date) and good practices with slicers and pivot tables is going to be awesome.
Thank you for this.
And many other more!!!!
@@fredi1356 She's a blessing.
Our pleasure. Hope it's helpful.
Thanks for this informative video. Two features is totally new for me while I'm using the Excel in every single day.
1. Set default Pivot table setting. 2.Report filter pages.
I'll start using them immediately. Thanks once again.
Glad it was helpful!
You are one of my best teachers ❤
Love the dynamic formatting idea! Love the settings for the default. Love the FILTERS worksheet. I’ll be applying these things immediately to my work product. Thank you
really great channel to learn excel.
Amazing video! Thanks a lot! Can't wait for the course 🙂
Awesome...Bless You 🎉
This is very useful information. Thank you so much for this video.
You're very welcome!
Another amazing video, Leila! I found myself doing Excel pivot table work the same way year after year and always acquiescing to the few moments of added formatting work. Changing the defaults will make a nice difference! Thank you for so expertly explaining it!! I also love how you incorporate your sense of humor and fun into them, like the use of the BB character names and clip, and how you creatively and gently invite people to like and subscribe to your channel, e.g. the text pop-up in this one.
I'm curious if you, or anyone of your followers can help. About the Report Filter Pages, once created, what's the most efficient way to copy or export each resulting tab (and the individual's underlying data) to new Excel files (not PDF) so they can be sent to the individual reps, without access to the other reps data?
The report filter pages 😍
Is there a way to keep default settings for slicers? I like to go into properties > Don't move or size with cells. Also defaulting the slicer connections to all pivot tables? Thank you! Love your channel! I learn something new all the time from your videos!
Thank you, this was a great video.
Very informative! Thank you!
Yup! Several I was unaware of! Many thanks!
wonderful refresher
Fabulous... that final tip is great
Report filter pages! I didn't know that one existed! Thank you! 😁👍🏼
Happy to help!
Wow! Thanks a lot ! I dont know why I haven’t thought about but the presetting for pivot are time saver.
Thanks Leila, these are some good tools that I was somewhat unaware of.
Changing the default Pivot Options! 👍👍
Oh yeah!
Hi Lelia, I had subscribed your channel more than 4years, your video is very useful and I learned a lot of equations of excel, but could you please teach me how to hide the worksheet and don’t let other people to see it in google sheet? Thanks
Thank you Leila! Great tips as always! I wonder how to use conditional formatting to compare values in two columns on Pivot table. 🤔
Really very useful to me 🎉
I like so much the way you teach, because English it isn't my first language but I can still understand your teachings 😊.
I like the last trick. It helps me a lot.
Thanks a lot. You are just awsome
I wanted to express my admiration for your exceptional teaching skills and ability to simplify complex concepts. Thank you for your dedication. I'm reaching out for guidance on creating unique count options in pivot tables. Could you please assist me with this?
Best regards, kumar P
i am information technology students everday i advance my self with excel word powerpoint access forms docs also learning new features in AI i listen to all my tech supporters. SO far this course is also the best continue making more videos i love this channel
Amazing, thank you to share these tricks.❤
Great video. Thank you. I am a small business owner and use pivot tables all the time. Setting defaults will help a lot.
That's great to hear!
Thanks so much for this; i've been looking for ways to change default pivot table settings. This is so good...Thanks 👍
Great stuff! Thanks!
Layout feature is my favourite one
I didn’t know about report filter page. This is awesome
One feature I use is the cube function, great for changing the layout of your pivot, still works with your slicers
Thank you, Leila. Even though I’ve been using Pivot Tables for over 10 years, I still find something new to learn from you. I have a question that’s been a headache for me in Pivot Tables: I have to apply number formatting to each column separately. Is there a way to format the entire table in one move or set it as a default? Thanks in advance.
Hmm, you can predefine formatting for measures in Power Pivot. But even then you have to apply it for every measure separately. There is no option to do it for the entire table.
Great video Leila! What microphone is the one you're using? Audio sounds amazing!
I learned a lot from you, especially about Microsoft Office. It really helps me in my work. Thank you very much for the knowledge you share. May your good deeds be rewarded by God. Always be healthy and successful!
Excellent video, Laila. I forgot about the Report Filter feature.
Leila very good. Thank you
And, did you mention about Cube functions inside your PT course?
Wow... I wasn't aware of any of those features. Impressive! I may need to consider the upcoming masterclass. 🙌
I find the default settings for Pivot Table options, particularly the "Show in Tabular Form" option and the unchecked "Autofit Column Widths on Update" option, to be highly beneficial in reducing the risk of repetitive strain injury (RSI).
Dynamic formatting, the Report filter pages, didn’t know that! Thanks @LeilaGharani
Our pleasure. Glad you found something new.
Happy Teacher's Day!🎉 my favourite pt features are label/value filters and show values as. Not sure if anything changed but the audio of this video is great!!!
All of these especially the Report filter pages are awesome!!... are this features available in Google Sheet? Can you teach us please... Thank you...
Many features were there that I overlooked 🤣🤣🤣.
You've been my best source of learning for years ‼️ Then I act like I'm a genius that's helping people. For those who are eager to learn, I have your channel to point them to...
Thank you for your great content!
Thank you for the kind feedback and support. 🙏
Many people still underestimate excel, as if excel only has standard formula features. In fact, excel is now very good and capable of doing various things. Not only pivot tables, but excel even has a strong connection with power query which is also very strong in helping you process data. Sometimes people who underestimate excel may not know the new excel features and think it is still like excel 2003/2007.
Loved the conditional formatting of the bars, just what I was looking for for my next report, thank you!! The Jesse comment 5:13 killed me 😂😂
Thank you
Thank you! :) Is there a way to activate Show Report Filter Pages while working with Power Pivot Tables?
Interesting and useful video yet again (though after a gap!), thank you Leila! Looking forward eagerly to your new Pivot Table course. I am sure it will be a great value add just like your other ones! All the best! 🙂
Thank you, Vijay! I appreciate the kind feedback. 🙏
Thank you so much for your always very useful tutorials! if I highlight the cell and then click on update all, every now and then this formatting is deleted even if I have flagged "maintain cell formatting when updating" in the options: do you know why? thanks in advance
Damn ! How didn't I know all of these features till I came across this video!😅
Yes!!! That's me too!
There is always more to learn. :)
i like that we can change the pivot table defaults
Big improvement 👍
The last tip is something I should try...
For two years I got used to using functions that literally made pivot tables redundant. (Except for cases where I needed a refresh to be manual and not automatic, or controlled by a controller) Then I started working in a new place and with Office 16, I don't have any of these functions, and I'm rediscovering the pivots...
Bottom line?
I learned during this time how important it is to get to know as many features and functions as possible. Suddenly I found out what the hell a function like "address" for example is needed for...😂
Nice video Leila as always. May i ask what do you use to record your screen and what do you use to edit them.? I mean those zoom in and out, highlighted boxes . I saw that there are some tools that do all this using only shortcuts and save a lot of post production time and wonder if you are using one of those tools
Looks like you were crooked when recording the video(NZ slang words for sick).
Thanks for this video it’s a game changer.
Great tips! Thanks, Leila!
Does the Report Filter Pages add new sheets upon refresh if the source data gets updated and there's a new Responsible Person?
no - if a new person gets added, then we have to trigger the report filter pages. But everything else is refreshable.
Love this channel. I've learned so much. I plan on registering for some these classes in the near future!
Awesome! Thank you!
@@LeilaGharani Does the site offer any training on PowerQuery, PowerPivot, VBA coding?
Leila. Amazing! I'm on a multi mil $ project and am a mainframe coder. I need to come up with a compare strategy between 2 sheets. 3 columns make up the index that I need to use to do ' join' on 2 sheets. Then I want to auto highlight every non index field in left sheet that matches the non index fields in right sheet based on index (join). Any tips? Thanks!
conditional formatting is gonna be fun