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.
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 :)
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!
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 TH-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. :)
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
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).
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!!
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 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
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 ;)
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 :)
I wish I could not only put one "like" but 10 for this very helpful dynamic graphic trick. Therefore the nine others "like" are here 👍👍👍👍👍👍👍👍👍 Many thanks
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.
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.
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!
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?
Not only you really know what you are talking about, but the way you explain is awesome! My sincere congratulations...
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!😂😁
Your english is wonderful and well pronounced, it makes listening to your lessons wonderful. Great job!
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!
Brilliant Microsoft programmer who created this Excell so functionable.we just have to learn how to make use that.
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!
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!
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
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!
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!
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
Wow.. this is badass.. I thought I was good and efficient with Excel but this is so so so elegant!!!
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.
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!
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 TH-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!
I have been looking for those option buttons forever, thank you so much!
Our pleasure!
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.
simply perfect - your teaching skills are great - thank you
Just subscribed! Respect to all excel gurus 🙏
OMG! I learn so much from you every video I watch. You are always clear and make things easy to understand!
¡Gracias!
Thank you so much Daniel!
اي شو هاد .. المرأة الخارقة ؟ ابداع ما بعده إبداع .. تسلم ايديك يا ليلى
REALLY FALL in love with this amazing technique and you are already in my heart
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!
You are wonderful mam....Your teaching style is stunning....thanks my dear teacher
Thank you... I have been learning a lot from you! You're excel knowhow is mind-blowing!
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
You never stop surprising us with those MS Office tips, I've never find it boring
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 so much !! I start my day by watching one of your videos, and this makes me feel that I have learnt something new today.
Thank you for this! There are lots of things here I didn't know before and I will find really useful.
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!
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 TH-cam star!!!
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).
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!!
I thought I am good at this stuff, but you probably beat me easily! Thanks for the video!
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
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 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
Thank you Leila!
This is so helpful, don't need to manually select the chart data range is so powerfull!
Glad you like it!
Absolutely brilliant tip on Radio buttons
I wish I had discovered your channel a long time ago. Never fail to amaze me.
Glad to have you aboard!
Gosh.. you make it look so simple.. just simply, awesome!
Very clever. I love the way you say "developer"
each tutorial is an other level of knowledge. Thank you Leila. PS: my daughter is Leila too
Oh my! I am impressed what Excel can do! Thanks to you!
Great to hear!
Very good, you explain every point in detail.
Leila, you always impress me with the simplicity to create a dashboard. Please continue these vlogs. I am sure that you have big fans
Thank you Leila .... it's another way to present a dashboard and i like it 👍👍👍
You're welcome 😊
This is going to be a game changer. Thank you for sharing this Leila :)
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!
Outstanding video's - completely transformed the way that I work. 😁👍
Great to hear!
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.
These things you do here are great! Thanks a lot!
Awsome technique ..... I Never regret stopping by to learn
Glad you liked it, Abraham!
Amazing knowledge you have and passionate for Excel... 👍👍👍
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 ;)
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?
I wish I could not only put one "like" but 10 for this very helpful dynamic graphic trick.
Therefore the nine others "like" are here 👍👍👍👍👍👍👍👍👍
Many thanks
Much appreciated!
I always watch your videos as I like to learn from the Best
I appreciate that!
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!
Excellent! Very smart. Hats off 🙌… I really learn a lot here…
You always amazed me with innovative ideas and techniques to use formula.
Superb technique!! Thanks a lot Ms. Leila
My pleasure!
Many thanks Leila! That’s really helpful. It would also be great if the form works for the online Shared file..
Its way easier to use slicers which leads to the same effect but safes the whole work shown in this video.
Am gonna make a career out of your training, Thanks Leila. Love from Vizag,India
Wonderful!
Thank you Leila. Learning a lot from your videos.
Happy to hear that!
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
Love you always, you explain very well. Anyone can be a master. Thanks you
I appreciate that!
Great video Leila! So many useful tips covered in a short video.
Glad you liked it, Savio!
Thank you for this fantastic solution Leyla!
You're very welcome, Iván!
Wooow.. That was exactly what I was looking for!! Thanks Leila.
Glad it was helpful!
you are amazing, I learn so much from you!
Thanks so much. Awsome trick with SWITCH and clever use of Name
Always comes up with smart tips. Thanks a billion😊
My pleasure!
Wow... Amazing technique.... Thank you
My pleasure 😊
Thanks Leila! Your videos are amazing and very helpful!
Glad you think so, Adriano!
Thanks Leila. There are lots of great methods in this one. Thanks for sharing.
You’re welcome 😊
I learn so much from up you! Thank you!
Thanks for showing us creative ways to do stuff in Excel, very inspiring!
My pleasure!
Perfect! Informational stuff. Love it
Pretty nifty tutorial. New learned today = Switch. Love it!!!
Glad to hear it!
You are Amazing Leila !! Many Thanks for the hard work and valuable information 💚🙏
You're so welcome!
this lesson is very important, i learnt new things, thank you
Thank you so much for detailed explanation of uses of Radio button. Can we do it on PPT as well in live meeting while presenting PPT ?
This level of knowledge sharing is awesome and thank you
Thank you Leila! You gave me a solution to one of my problems I was facing in charts! You are awesome! 😊👍
It appears some comments here are being spammed by fishy reply! 😱or am I day dreaming!
Unfortunately, this is a common problem these days. I'm doing my best to report them but they keep coming back.
@@LeilaGharani Sorry to know that, Hope this stops. Good luck! 👍
I love the way you combine different functions. Thanks for sharing with us.
You are so welcome!
That is really clever - I'll definately be using this as inspiration. Thanks!
You are awesome, Leila! I was thrilled with the solution 😁👍
Glad you enjoyed it, Omar!
Super clear (as usual) and will make my work that much easier!
Excellent M'aam, very informative