It has been literal YEARS since I last learned something entirely new about Excel. Don't get me wrong you know your stuff, but I'm reasonably well versed in it too. This video though is a game changer. I'll be including this on my dashboard and squeeze a bit more data out of my screen real estate. 100% on the knowledge, clarity of the explanation and usefulness of the video. Earned my subscription :)
You are the only one giving magic in excel. I never seen any other you tube channel like your channel. You are magician in excel. Thanks a lot for your efforts.
Such an elegant solution! I love that you always drop in small tips and tricks adjacent to the topic at hand. In this one, I learned SWITCH as a more flexible alternative to CHOOSE. Thanks!
It’s just simply mind blowing what you can do with Excel and you explain it in such an engaging and simple to understand manner. Then you even let us download a free workbook. I’ll certainly sign up to a paid for course because it’s going to make me an excel genius
Thank you Leila, what was new for me was the grouping of the option buttons. I've been using option buttons for a long time and never knew you can group them on one sheet. This is definitely a game changer for me.
Thank you for explaining EASILY 🥰 I have been spending my 2 days to find a video that really demonstrate interactive excel dashboards for beginners. I will present a slide in office and It will save my life
During my very brief lunch breaks I simply sit on UA-cam and watch your videos, even if I don't have a current need I love the ideas that you inject into my brain for upcoming projects. :)
If I had to do this data presentation my first thought would probably have been a pivot table, slicers and a pivot chart, but this solution is indeed very inspiring. I learnt many new formulas, which I did not use so far. In addition I also included radio buttons to choose how I want the values to be sorted (so I put the Grouping function you explained at the beginning) instead of hard coding it into the formula. And I named most of the ranges you used. Thanks for sharing
Awesome video!! Even when I used the FILTER formula, I used the OFFSET function to create a named range. Didn't know I could use the '#" in there. Thanks!!
Thank you very much for the great video. A very good alternative to using slicers since slicers only work with pivot table and tables. Spill arrays unfortunately don't work in tables. Thanks again
That dynamic data source is next level. 👏🏼 I wish there was a way to dynamically associate underflow and overflow histogram bins to cells calculating outlier thresholds (quartile 1 - 1.5 interquartile range or quartile 3 + 1.5 interquartile range).
Thanks a million Leila, I loved this. May you also do something on "pasting in selection" I have been battling with this my entire life. Thanks once again for saving lives, one spreadsheet at a time ;)
"Switch" function? Who knew" I didn't ... Will interactive excel dashboards with radio buttons work in Excel Online? Once again you've opened another door in the Excel House of Leila ... thank you ... thank you ... thank you.
This is incredible, I’m going to use this so much! I learned INDEX, SWITCH and hashes in this video, super useful formulas which will help massively cut down some of my IF-based formulas :)
too good.. I can't stop myself to Subscribe to your channel. I was thinking I am good at Excel but looks like it's yet to learn a lot.. this will surely help in day-to-day work.
Grab the file I used in the video from here 👉 pages.xelplus.com/radio-buttons-file
I had no idea that you can use the # to automatically grab the data range, despite the size. Game changer.
I have watched so many of your videos for work 🙈 Thank you very much :D
Glad you like them!
did you get caught by boss?
My team thinks I know Excel stuff. Really, I just subscribe to Leila 'cause she knows stuff!
Same here.
My team: "how do you (insert impossible function here) in excel?
Me: (Sends link to Leila's video).
@@austinc124 Exactly
Thats me too😊
Same here, LOL.
Same here lol
It has been literal YEARS since I last learned something entirely new about Excel. Don't get me wrong you know your stuff, but I'm reasonably well versed in it too.
This video though is a game changer. I'll be including this on my dashboard and squeeze a bit more data out of my screen real estate. 100% on the knowledge, clarity of the explanation and usefulness of the video. Earned my subscription :)
That's great to hear. Glad to have you aboard, Thierry!
You are the only one giving magic in excel. I never seen any other you tube channel like your channel. You are magician in excel. Thanks a lot for your efforts.
This will take decades for me if i try to build this on my own. This Radio button template is so cool. Kudos to Leila for sharing her knowledge!
Such an elegant solution! I love that you always drop in small tips and tricks adjacent to the topic at hand. In this one, I learned SWITCH as a more flexible alternative to CHOOSE. Thanks!
Kojpko
Coool!!! The wonderwoman in Action!! Grettings Leila
Yet another great tutorial 👍🏻
Funny you mention wonderwoman cos i thought Gal Gadot do look almost as beautiful as Leila
Seriously, Leila and Chandoo, these 2 legends changed the way I think and use data in excel. You helped me crack a new job even. Thank you so much!
It’s just simply mind blowing what you can do with Excel and you explain it in such an engaging and simple to understand manner.
Then you even let us download a free workbook.
I’ll certainly sign up to a paid for course because it’s going to make me an excel genius
Brilliant Microsoft programmer who created this Excell so functionable.we just have to learn how to make use that.
Thank you Leila, what was new for me was the grouping of the option buttons. I've been using option buttons for a long time and never knew you can group them on one sheet. This is definitely a game changer for me.
Not only you really know what you are talking about, but the way you explain is awesome! My sincere congratulations...
This is going to be a game changer. Thank you for sharing this Leila :)
Thank you for explaining EASILY 🥰 I have been spending my 2 days to find a video that really demonstrate interactive excel dashboards for beginners. I will present a slide in office and It will save my life
Amaaaaazing functions Leila !!! You impress me every day! I become addicted to your videos. I learn a new thing every day almost. Thank you so much!
Your english is wonderful and well pronounced, it makes listening to your lessons wonderful. Great job!
Can't thank you enough, the company I'm working in doesn't have Power BI, I needed this so much.
Glad I could help!
You're honestly way to smart with Excel... I'll be watching more of your videos, they already helped me alot, thank you so much!😂😁
During my very brief lunch breaks I simply sit on UA-cam and watch your videos, even if I don't have a current need I love the ideas that you inject into my brain for upcoming projects. :)
Thank you for spending your lunch with me :)
Every time I watch your videos, I feel like an Excel newbie. Thanks for these great lessons.
You're very welcome!
simply perfect - your teaching skills are great - thank you
Thank you so much !! I start my day by watching one of your videos, and this makes me feel that I have learnt something new today.
REALLY FALL in love with this amazing technique and you are already in my heart
Wow.. this is badass.. I thought I was good and efficient with Excel but this is so so so elegant!!!
If I had to do this data presentation my first thought would probably have been a pivot table, slicers and a pivot chart, but this solution is indeed very inspiring. I learnt many new formulas, which I did not use so far. In addition I also included radio buttons to choose how I want the values to be sorted (so I put the Grouping function you explained at the beginning) instead of hard coding it into the formula. And I named most of the ranges you used. Thanks for sharing
Thank you... I have been learning a lot from you! You're excel knowhow is mind-blowing!
Thank you for this! There are lots of things here I didn't know before and I will find really useful.
Awesome video!! Even when I used the FILTER formula, I used the OFFSET function to create a named range. Didn't know I could use the '#" in there. Thanks!!
OMG! I learn so much from you every video I watch. You are always clear and make things easy to understand!
Thank you very much for the great video. A very good alternative to using slicers since slicers only work with pivot table and tables. Spill arrays unfortunately don't work in tables. Thanks again
¡Gracias!
Thank you so much Daniel!
Leila, you always impress me with the simplicity to create a dashboard. Please continue these vlogs. I am sure that you have big fans
I have been looking for those option buttons forever, thank you so much!
Our pleasure!
Very clever. I love the way you say "developer"
You never stop surprising us with those MS Office tips, I've never find it boring
Just subscribed! Respect to all excel gurus 🙏
Gosh.. you make it look so simple.. just simply, awesome!
Out of her many great videos, this is certainly one of the best. Maybe using the SWITCH function can ease my spreadsheet management.
Glad you like it, Terrence!
each tutorial is an other level of knowledge. Thank you Leila. PS: my daughter is Leila too
Je t'aime 💜 💜💕💙💘can't even express how grateful I'm for this feature... I've been looking for it for so long... Thank you from Congo 🇨🇬
My pleasure, Claude!
Great video! Good reminder about using the SWITCH function. Also, clever use of named ranges for chart data ranges. Thank you!
Glad you liked it, Andy!
wow learnt so many things in just a short 13 minute video!
radio buttons
chart
fiter formula
dynamic named ranges
dynamic chart titles
Glad you enjoyed it!
That dynamic data source is next level. 👏🏼 I wish there was a way to dynamically associate underflow and overflow histogram bins to cells calculating outlier thresholds (quartile 1 - 1.5 interquartile range or quartile 3 + 1.5 interquartile range).
Absolutely brilliant tip on Radio buttons
I thought I am good at this stuff, but you probably beat me easily! Thanks for the video!
Thanks!
I REALLY appreciate your content Lelia!! You save me so much time 🙏💞
Thank you so much! Really glad to hear the videos are helpful.
This is some alien level stuff!
Absolutely 😂🛸🛸🛸🛸
Abshir elmi is my name guys.
Exactly!
This is awesome! I learn so many new functions watching your channel!!!
Great to hear, Steve!
@@LeilaGharani Wow...thanks for your reply. I'm humbled as you a UA-cam star!!!
I thought I am good at excel, however you really impressed me with new stuff, Leila.. Well done, and thanks a lot for the amazing functions. 👏🏻
Thank you Leila!
This is so helpful, don't need to manually select the chart data range is so powerfull!
Glad you like it!
Oh my! I am impressed what Excel can do! Thanks to you!
Great to hear!
اي شو هاد .. المرأة الخارقة ؟ ابداع ما بعده إبداع .. تسلم ايديك يا ليلى
These things you do here are great! Thanks a lot!
Amazing Vido. I thought I have seen a lot on Excel, but this one it outstanding. Right pace, very well presented. Awesome!
Glad you liked it, Marc!
Excellent! Very smart. Hats off 🙌… I really learn a lot here…
Thank you Leila .... it's another way to present a dashboard and i like it 👍👍👍
You're welcome 😊
Thanks so much. Awsome trick with SWITCH and clever use of Name
I wish I had discovered your channel a long time ago. Never fail to amaze me.
Glad to have you aboard!
Wow!, It's awesome and for real life practical use. It uses new functions and the silent radio buttons to look very professional and simple
Awsome technique ..... I Never regret stopping by to learn
Glad you liked it, Abraham!
You always amazed me with innovative ideas and techniques to use formula.
Superb technique!! Thanks a lot Ms. Leila
My pleasure!
Wow... Amazing technique.... Thank you
My pleasure 😊
Very good, you explain every point in detail.
That is really clever - I'll definately be using this as inspiration. Thanks!
You are wonderful mam....Your teaching style is stunning....thanks my dear teacher
Thanks a million Leila, I loved this. May you also do something on "pasting in selection" I have been battling with this my entire life. Thanks once again for saving lives, one spreadsheet at a time ;)
Great video Leila! So many useful tips covered in a short video.
Glad you liked it, Savio!
Perfect! Informational stuff. Love it
Wooow.. That was exactly what I was looking for!! Thanks Leila.
Glad it was helpful!
Outstanding video's - completely transformed the way that I work. 😁👍
Great to hear!
Always comes up with smart tips. Thanks a billion😊
My pleasure!
Thanks Leila! Your videos are amazing and very helpful!
Glad you think so, Adriano!
Love you always, you explain very well. Anyone can be a master. Thanks you
I appreciate that!
you are amazing, I learn so much from you!
Thank you for this fantastic solution Leyla!
You're very welcome, Iván!
Amazing knowledge you have and passionate for Excel... 👍👍👍
"Switch" function? Who knew" I didn't ...
Will interactive excel dashboards with radio buttons work in Excel Online?
Once again you've opened another door in the Excel House of Leila ... thank you ... thank you ... thank you.
Thanks for showing us creative ways to do stuff in Excel, very inspiring!
My pleasure!
Pretty nifty tutorial. New learned today = Switch. Love it!!!
Glad to hear it!
Thanks Leila. There are lots of great methods in this one. Thanks for sharing.
You’re welcome 😊
This is incredible, I’m going to use this so much! I learned INDEX, SWITCH and hashes in this video, super useful formulas which will help massively cut down some of my IF-based formulas :)
Glad you enjoyed it!
Ciao Jack, I am wondering if this is really a good solution. I wonder why anyone would opt to use radio buttons instead of quick pivots and slicer?
Thank you Leila. Learning a lot from your videos.
Happy to hear that!
I learn so much from up you! Thank you!
I always watch your videos as I like to learn from the Best
I appreciate that!
so many quick little things I never knew where a thing. never would've thought that you could have a dynamic title
Glad you found something new, Niels.
thank you very much for the switch function ,..
Wow! Your videos are wonderful, thank you!
Before watching this, I didn't even know this function exist... Cool! Love the switch formula as well.
Great to hear!
too good.. I can't stop myself to Subscribe to your channel. I was thinking I am good at Excel but looks like it's yet to learn a lot.. this will surely help in day-to-day work.
Thanks and welcome!
I am out of words. simple amazing. kudos
Super clear (as usual) and will make my work that much easier!
Am gonna make a career out of your training, Thanks Leila. Love from Vizag,India
Wonderful!
This level of knowledge sharing is awesome and thank you
You are awesome, Leila! I was thrilled with the solution 😁👍
Glad you enjoyed it, Omar!
I love the way you combine different functions. Thanks for sharing with us.
You are so welcome!
Wonderful Trick Leila, Grate !!!
This is so satisfying!!!