Create INTERACTIVE Excel Dashboards With Option Buttons | How to use Radio Buttons

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/radio-buttons-file

[@kristoferbrown8007]

I had no idea that you can use the # to automatically grab the data range, despite the size. Game changer.

[@EliotPowell]

My team thinks I know Excel stuff. Really, I just subscribe to Leila 'cause she knows stuff!

[@austinc124]

Same here. My team: "how do you (insert impossible function here) in excel? Me: (Sends link to Leila's video).

[@EliotPowell]

@@austinc124 Exactly

[@iantau3455]

Thats me too😊

[@sammixie3753]

Same here, LOL.

[@saromijuwon7151]

Same here lol

[@ali8bilal]

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.

[@faucillon]

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

[@LeilaGharani]

That's great to hear. Glad to have you aboard, Thierry!

[@kyleutuber]

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!

[@mariyammalshetty9110]

Kojpko

[@vasistreddy968]

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!

[@muhdfadillah2343]

Brilliant Microsoft programmer who created this Excell so functionable.we just have to learn how to make use that.

[@PeymanSayyadi]

Every time I watch your videos, I feel like an Excel newbie. Thanks for these great lessons.

[@LeilaGharani]

You're very welcome!

[@ArticulateDesignASMR]

I have watched so many of your videos for work 🙈 Thank you very much :D

[@LeilaGharani]

Glad you like them!

[@MasterofPlay7]

did you get caught by boss?

[@zioeddie65]

Not only you really know what you are talking about, but the way you explain is awesome! My sincere congratulations...

[@scottnero]

Your english is wonderful and well pronounced, it makes listening to your lessons wonderful. Great job!

[@soumadip.m]

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!

[@skthalange]

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

[@Elthorr149]

Can't thank you enough, the company I'm working in doesn't have Power BI, I needed this so much.

[@LeilaGharani]

Glad I could help!

[@METN]

Coool!!! The wonderwoman in Action!! Grettings Leila

[@rkalwaysravi]

Yet another great tutorial 👍🏻

[@paintandgame]

Funny you mention wonderwoman cos i thought Gal Gadot do look almost as beautiful as Leila

[@davidferrick]

During my very brief lunch breaks I simply sit on KZbin 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. :)

[@LeilaGharani]

Thank you for spending your lunch with me :)

[@stoffel1330]

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

[@mirkowilhelm4792]

simply perfect - your teaching skills are great - thank you

[@Dubai711]

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!

[@mashokhan8811]

REALLY FALL in love with this amazing technique and you are already in my heart

[@deepakkashyaprajput8515]

This is some alien level stuff!

[@tifouraamina1761]

Absolutely 😂🛸🛸🛸🛸

[@abshirelmi3107]

Abshir elmi is my name guys.

[@lifesymphony2024]

Exactly!

[@binhthai078]

You never stop surprising us with those MS Office tips, I've never find it boring

[@excel_along_the_way]

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.

[@sameermathur9927]

Absolutely brilliant tip on Radio buttons

[@TylerStanczak]

This is going to be a game changer. Thank you for sharing this Leila :)

[@mohamadmneimneh4036]

Thank you... I have been learning a lot from you! You're excel knowhow is mind-blowing!

[@PiotrMys]

Wow.. this is badass.. I thought I was good and efficient with Excel but this is so so so elegant!!!

[@alisonzhang6162]

I have been looking for those option buttons forever, thank you so much!

[@LeilaGharani]

Our pleasure!

[@MyrayEsterCatibayan]

Gosh.. you make it look so simple.. just simply, awesome!

[@shashankshekhar4441]

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.

[@claudemouaya5639]

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 🇨🇬

[@LeilaGharani]

My pleasure, Claude!

[@fuzzylon]

Thank you for this! There are lots of things here I didn't know before and I will find really useful.

[@rina2012ful]

Oh my! I am impressed what Excel can do! Thanks to you!

[@LeilaGharani]

Great to hear!

[@BM-zd3vs]

Just subscribed! Respect to all excel gurus 🙏

[@ltcmdc1782]

OMG! I learn so much from you every video I watch. You are always clear and make things easy to understand!

[@idaeinjaw2139]

wow learnt so many things in just a short 13 minute video! radio buttons chart fiter formula dynamic named ranges dynamic chart titles

[@LeilaGharani]

Glad you enjoyed it!

[@Meanna12]

Leila, you always impress me with the simplicity to create a dashboard. Please continue these vlogs. I am sure that you have big fans

[@naboulsikhalid7763]

each tutorial is an other level of knowledge. Thank you Leila. PS: my daughter is Leila too

[@q46ward]

Out of her many great videos, this is certainly one of the best. Maybe using the SWITCH function can ease my spreadsheet management.

[@LeilaGharani]

Glad you like it, Terrence!

[@amateurtorque6709]

Very clever. I love the way you say "developer"

[@damlayldz1907]

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

[@khalidarab2829]

اي شو هاد .. المرأة الخارقة ؟ ابداع ما بعده إبداع .. تسلم ايديك يا ليلى

[@mateuszlika2652]

These things you do here are great! Thanks a lot!

[@City89Hunter]

I thought I am good at this stuff, but you probably beat me easily! Thanks for the video!

[@joeschmoe2659]

I learn so much from up you! Thank you!

[@aperkinsvt]

Great video! Good reminder about using the SWITCH function. Also, clever use of named ranges for chart data ranges. Thank you!

[@LeilaGharani]

Glad you liked it, Andy!

[@thailynguyen]

Thanks so much. Awsome trick with SWITCH and clever use of Name

[@smsunder]

This is awesome! I learn so many new functions watching your channel!!!

[@LeilaGharani]

Great to hear, Steve!

[@smsunder]

@@LeilaGharani Wow...thanks for your reply. I'm humbled as you a KZbin star!!!

[@KasSyl1234]

Perfect! Informational stuff. Love it

[@abijahmaniaco]

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

[@abrahamadinoyi]

Awsome technique ..... I Never regret stopping by to learn

[@LeilaGharani]

Glad you liked it, Abraham!

[@ym10up]

This is so satisfying!!!

[@ricardoromo96]

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

[@v.vivekthamilarasan990]

Wow... Amazing technique.... Thank you

[@LeilaGharani]

My pleasure 😊

[@danielcatron8489]

¡Gracias!

[@LeilaGharani]

Thank you so much Daniel!

[@CG-yy2fc]

Thanks!

[@CG-yy2fc]

I REALLY appreciate your content Lelia!! You save me so much time 🙏💞

[@LeilaGharani]

Thank you so much! Really glad to hear the videos are helpful.

[@waresfaisal9305]

Superb technique!! Thanks a lot Ms. Leila

[@LeilaGharani]

My pleasure!

[@Landerozaki]

Wooow.. That was exactly what I was looking for!! Thanks Leila.

[@LeilaGharani]

Glad it was helpful!

[@kuldeep.3012]

You are wonderful mam....Your teaching style is stunning....thanks my dear teacher

[@shajupauljohn3244]

Very good, you explain every point in detail.

[@marckirsch]

Amazing Vido. I thought I have seen a lot on Excel, but this one it outstanding. Right pace, very well presented. Awesome!

[@LeilaGharani]

Glad you liked it, Marc!

[@beytlowg9994]

I wish I had discovered your channel a long time ago. Never fail to amaze me.

[@LeilaGharani]

Glad to have you aboard!

[@bawwapark]

Wonderful Trick Leila, Grate !!!

[@nevermind4780]

You always amazed me with innovative ideas and techniques to use formula.

[@nmastercz]

so many quick little things I never knew where a thing. never would've thought that you could have a dynamic title

[@LeilaGharani]

Glad you found something new, Niels.

[@CJ-gn8ud]

Thank you Leila! This is so helpful, don't need to manually select the chart data range is so powerfull!

[@LeilaGharani]

Glad you like it!

[@josecarlosconejo5724]

Excellent! Very smart. Hats off 🙌… I really learn a lot here…

[@adrianodossantosfernandes1236]

Thanks Leila! Your videos are amazing and very helpful!

[@LeilaGharani]

Glad you think so, Adriano!

[@robjchristopher]

That is really clever - I'll definately be using this as inspiration. Thanks!

[@dpu_paul]

Always comes up with smart tips. Thanks a billion😊

[@LeilaGharani]

My pleasure!

[@2000sunsunny]

Thank you Leila. Learning a lot from your videos.

[@LeilaGharani]

Happy to hear that!

[@savioseona]

Great video Leila! So many useful tips covered in a short video.

[@LeilaGharani]

Glad you liked it, Savio!

[@colormile-vid8888]

Pretty nifty tutorial. New learned today = Switch. Love it!!!

[@LeilaGharani]

Glad to hear it!

[@IvanCortinas_ES]

Thank you for this fantastic solution Leyla!

[@LeilaGharani]

You're very welcome, Iván!

[@gianluigiredolfini6154]

Leila you are an excel angel…

[@fireman87]

you are amazing, I learn so much from you!

[@amaroel]

Thank you Leila .... it's another way to present a dashboard and i like it 👍👍👍

[@LeilaGharani]

You're welcome 😊

[@eloufie]

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. 👏🏻

[@theedspage]

Wow! Your videos are wonderful, thank you!

[@hiteshbhatia787]

Amazing knowledge you have and passionate for Excel... 👍👍👍

[@Tdx-nk3os]

Thanks for showing us creative ways to do stuff in Excel, very inspiring!

[@LeilaGharani]

My pleasure!

[@ezequielbosch1321]

Super clear (as usual) and will make my work that much easier!

[@nairobi203]

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

[@TongkiNgaceng]

thank you very much for the switch function ,..

[@davidk919]

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

[@venusaxieinfinitytv907]

I am out of words. simple amazing. kudos

[@navinraj0107]

This level of knowledge sharing is awesome and thank you

[@samuellazarus1107]

Wow... that's awesome... you make it look so simple.

[@vs_gaming3013]

That was brilliant. Thanks!

[@nadermounir8228]

Great tutorial Leila. Amazing ! 👏

[@CanTukel-db1qp]

mind blowing! Thank you!

[@keyur145]

I always watch your videos as I like to learn from the Best

[@LeilaGharani]

I appreciate that!

[@artyafridi]

MASTER OF EXCEL YOU ARE TOO GENIOUS

[@sarahredmond5366]

Brilliant - thanks so much!

[@somairsarem5652]

honestly, that's fantastic !

[@nyashadzashemandizera4475]

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

[@ashleymoore1845]

What a fantastic video! Thanks Leila.

[@LeilaGharani]

Thank you! 😃

[@shakeeljaved3181]

Many thanks... Love your videos..

[@ikartiko]

Very interesting..thank you for clear explanation Leila....