Grab the file I used in the video from here 👉 pages.xelplus.com/radio-buttons-file
@EliotPowell
3 жыл бұрын
My team thinks I know Excel stuff. Really, I just subscribe to Leila 'cause she knows stuff!
@austinc124
3 жыл бұрын
Same here. My team: "how do you (insert impossible function here) in excel? Me: (Sends link to Leila's video).
@EliotPowell
3 жыл бұрын
@@austinc124 Exactly
@iantau3455
2 жыл бұрын
Thats me too😊
@sammixie3753
2 жыл бұрын
Same here, LOL.
@saromijuwon7151
2 жыл бұрын
Same here lol
@kristoferbrown8007
3 жыл бұрын
I had no idea that you can use the # to automatically grab the data range, despite the size. Game changer.
@ArticulateDesignASMR
3 жыл бұрын
I have watched so many of your videos for work 🙈 Thank you very much :D
@LeilaGharani
3 жыл бұрын
Glad you like them!
@MasterofPlay7
3 жыл бұрын
did you get caught by boss?
@PeymanSayyadi
3 жыл бұрын
Every time I watch your videos, I feel like an Excel newbie. Thanks for these great lessons.
@LeilaGharani
3 жыл бұрын
You're very welcome!
@kyleutuber
3 жыл бұрын
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
2 жыл бұрын
Kojpko
@METN
3 жыл бұрын
Coool!!! The wonderwoman in Action!! Grettings Leila
@rkalwaysravi
3 жыл бұрын
Yet another great tutorial 👍🏻
@paintandgame
3 жыл бұрын
Funny you mention wonderwoman cos i thought Gal Gadot do look almost as beautiful as Leila
@davidferrick
3 жыл бұрын
During my very brief lunch breaks I simply sit on KZitem 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
3 жыл бұрын
Thank you for spending your lunch with me :)
@skthalange
3 жыл бұрын
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
@TylerStanczak
3 жыл бұрын
This is going to be a game changer. Thank you for sharing this Leila :)
@vasistreddy968
3 жыл бұрын
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!
@zioeddie65
2 жыл бұрын
Not only you really know what you are talking about, but the way you explain is awesome! My sincere congratulations...
@mirkowilhelm4792
3 жыл бұрын
simply perfect - your teaching skills are great - thank you
@ali8bilal
2 жыл бұрын
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.
@excel_along_the_way
3 жыл бұрын
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.
@soumadip.m
2 жыл бұрын
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!
@deepakkashyaprajput8515
3 жыл бұрын
This is some alien level stuff!
@tifouraamina1761
3 жыл бұрын
Absolutely 😂🛸🛸🛸🛸
@abshirelmi3107
3 жыл бұрын
Abshir elmi is my name guys.
@lifesymphony2024
3 жыл бұрын
Exactly!
@waresfaisal9305
Жыл бұрын
Superb technique!! Thanks a lot Ms. Leila
@LeilaGharani
Жыл бұрын
My pleasure!
@amaroel
7 ай бұрын
Thank you Leila .... it's another way to present a dashboard and i like it 👍👍👍
@LeilaGharani
7 ай бұрын
You're welcome 😊
@muhdfadillah2343
3 жыл бұрын
Brilliant Microsoft programmer who created this Excell so functionable.we just have to learn how to make use that.
@shashankshekhar4441
3 жыл бұрын
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.
@2000sunsunny
2 жыл бұрын
Thank you Leila. Learning a lot from your videos.
@LeilaGharani
2 жыл бұрын
Happy to hear that!
@scottnero
2 жыл бұрын
Your english is wonderful and well pronounced, it makes listening to your lessons wonderful. Great job!
@Dubai711
2 жыл бұрын
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!
@bawwapark
3 жыл бұрын
Wonderful Trick Leila, Grate !!!
@Elthorr149
3 жыл бұрын
Can't thank you enough, the company I'm working in doesn't have Power BI, I needed this so much.
@LeilaGharani
3 жыл бұрын
Glad I could help!
@alnoiwangmuang8547
Ай бұрын
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
@stoffel1330
2 жыл бұрын
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!😂😁
@TongkiNgaceng
3 жыл бұрын
thank you very much for the switch function ,..
@mashokhan8811
Жыл бұрын
REALLY FALL in love with this amazing technique and you are already in my heart
@binhthai078
3 жыл бұрын
You never stop surprising us with those MS Office tips, I've never find it boring
@Meanna12
3 жыл бұрын
Leila, you always impress me with the simplicity to create a dashboard. Please continue these vlogs. I am sure that you have big fans
@venusaxieinfinitytv907
2 жыл бұрын
I am out of words. simple amazing. kudos
@v.vivekthamilarasan990
3 жыл бұрын
Wow... Amazing technique.... Thank you
@LeilaGharani
3 жыл бұрын
My pleasure 😊
@mohamadmneimneh4036
Жыл бұрын
Thank you... I have been learning a lot from you! You're excel knowhow is mind-blowing!
@CanTukel-db1qp
4 ай бұрын
mind blowing! Thank you!
@abijahmaniaco
2 жыл бұрын
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).
@fireman87
2 жыл бұрын
you are amazing, I learn so much from you!
@naboulsikhalid7763
3 жыл бұрын
each tutorial is an other level of knowledge. Thank you Leila. PS: my daughter is Leila too
@claudemouaya5639
3 жыл бұрын
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
3 жыл бұрын
My pleasure, Claude!
@ltcmdc1782
Жыл бұрын
OMG! I learn so much from you every video I watch. You are always clear and make things easy to understand!
@idaeinjaw2139
3 жыл бұрын
wow learnt so many things in just a short 13 minute video! radio buttons chart fiter formula dynamic named ranges dynamic chart titles
@LeilaGharani
3 жыл бұрын
Glad you enjoyed it!
@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. 👏🏻
@alisonzhang6162
2 жыл бұрын
I have been looking for those option buttons forever, thank you so much!
@LeilaGharani
2 жыл бұрын
Our pleasure!
@fuzzylon
10 ай бұрын
Thank you for this! There are lots of things here I didn't know before and I will find really useful.
@ricardoromo96
3 жыл бұрын
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!!
@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!
@sumukh1977
Жыл бұрын
Love you always, you explain very well. Anyone can be a master. Thanks you
@LeilaGharani
Жыл бұрын
I appreciate that!
@PiotrMys
3 жыл бұрын
Wow.. this is badass.. I thought I was good and efficient with Excel but this is so so so elegant!!!
@ym10up
2 жыл бұрын
This is so satisfying!!!
@amateurtorque6709
2 жыл бұрын
Very clever. I love the way you say "developer"
@nmastercz
3 жыл бұрын
so many quick little things I never knew where a thing. never would've thought that you could have a dynamic title
@LeilaGharani
3 жыл бұрын
Glad you found something new, Niels.
@aperkinsvt
3 жыл бұрын
Great video! Good reminder about using the SWITCH function. Also, clever use of named ranges for chart data ranges. Thank you!
@LeilaGharani
3 жыл бұрын
Glad you liked it, Andy!
@khalidarab2829
3 жыл бұрын
اي شو هاد .. المرأة الخارقة ؟ ابداع ما بعده إبداع .. تسلم ايديك يا ليلى
@vs_gaming3013
2 жыл бұрын
That was brilliant. Thanks!
@shakeeljaved3181
2 жыл бұрын
Many thanks... Love your videos..
@sarahredmond5366
2 жыл бұрын
Brilliant - thanks so much!
@chh8860
3 жыл бұрын
"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.
@wathnasay
2 жыл бұрын
Thank you so much Leila!
@12Jarved
3 жыл бұрын
Outstanding video's - completely transformed the way that I work. 😁👍
@LeilaGharani
3 жыл бұрын
Great to hear!
@smsunder
3 жыл бұрын
This is awesome! I learn so many new functions watching your channel!!!
@LeilaGharani
3 жыл бұрын
Great to hear, Steve!
@smsunder
3 жыл бұрын
@@LeilaGharani Wow...thanks for your reply. I'm humbled as you a KZitem star!!!
@danfeliciano570
2 жыл бұрын
Great video. Thank you for sharing.
@BM-zd3vs
Жыл бұрын
Just subscribed! Respect to all excel gurus 🙏
@nevermind4780
3 жыл бұрын
You always amazed me with innovative ideas and techniques to use formula.
@rina2012ful
3 жыл бұрын
Oh my! I am impressed what Excel can do! Thanks to you!
@LeilaGharani
3 жыл бұрын
Great to hear!
@josecarlosconejo5724
3 жыл бұрын
Excellent! Very smart. Hats off 🙌… I really learn a lot here…
@City89Hunter
2 жыл бұрын
I thought I am good at this stuff, but you probably beat me easily! Thanks for the video!
@joeschmoe2659
3 жыл бұрын
I learn so much from up you! Thank you!
@karennguyen7083
2 жыл бұрын
Awesome tutorial, thank a lot, Leila ^^
@LeilaGharani
2 жыл бұрын
You're welcome 😊
@luigisir6893
2 жыл бұрын
Well done... spectacular!
@MyrayEsterCatibayan
Жыл бұрын
Gosh.. you make it look so simple.. just simply, awesome!
@damlayldz1907
2 жыл бұрын
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
@dpu_paul
3 жыл бұрын
Always comes up with smart tips. Thanks a billion😊
@LeilaGharani
3 жыл бұрын
My pleasure!
@somairsarem5652
Жыл бұрын
honestly, that's fantastic !
@abrahamadinoyi
3 жыл бұрын
Awsome technique ..... I Never regret stopping by to learn
@LeilaGharani
3 жыл бұрын
Glad you liked it, Abraham!
@thailynguyen
3 жыл бұрын
Thanks so much. Awsome trick with SWITCH and clever use of Name
@shajupauljohn3244
2 жыл бұрын
Very good, you explain every point in detail.
@official_utibaba
2 жыл бұрын
Wow! Thank you for this
@kuldeep.3012
3 жыл бұрын
You are wonderful mam....Your teaching style is stunning....thanks my dear teacher
@simoiyahector-morales3781
3 жыл бұрын
Excel genius, thanks for tutorial
@LeilaGharani
3 жыл бұрын
Glad you liked it, Simoiya!
@beytlowg9994
3 жыл бұрын
I wish I had discovered your channel a long time ago. Never fail to amaze me.
@LeilaGharani
3 жыл бұрын
Glad to have you aboard!
@bijumohan2405
3 жыл бұрын
Excellent M'aam, very informative
@nyashadzashemandizera4475
3 жыл бұрын
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 ;)
@robjchristopher
3 жыл бұрын
That is really clever - I'll definately be using this as inspiration. Thanks!
@adrianodossantosfernandes1236
2 жыл бұрын
Thanks Leila! Your videos are amazing and very helpful!
@LeilaGharani
2 жыл бұрын
Glad you think so, Adriano!
@amurelashardjulies2436
Жыл бұрын
All of them are my favorite.
@ho7s4uc3
3 жыл бұрын
thanks..very useful tricks.
@CJ-gn8ud
3 жыл бұрын
Thank you Leila! This is so helpful, don't need to manually select the chart data range is so powerfull!
@LeilaGharani
3 жыл бұрын
Glad you like it!
@marckirsch
2 жыл бұрын
Amazing Vido. I thought I have seen a lot on Excel, but this one it outstanding. Right pace, very well presented. Awesome!
@LeilaGharani
2 жыл бұрын
Glad you liked it, Marc!
@manuelborgelioen
3 жыл бұрын
Thanks ! You are great !!
@Landerozaki
3 жыл бұрын
Wooow.. That was exactly what I was looking for!! Thanks Leila.
@LeilaGharani
3 жыл бұрын
Glad it was helpful!
@Tmwyl
11 ай бұрын
Love your videos!
@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
@TechWizz
2 жыл бұрын
This one needs more practice but I can't help but watch your mastery of these applications.
@williamlee8514
2 жыл бұрын
This is extremely cool!
@davidk919
2 жыл бұрын
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
@jiajiaphotography
3 жыл бұрын
Before watching this, I didn't even know this function exist... Cool! Love the switch formula as well.
@LeilaGharani
3 жыл бұрын
Great to hear!
@SothearithKONGMrMuyKhmer
Жыл бұрын
Many thanks Leila! That’s really helpful. It would also be great if the form works for the online Shared file..
@harshpatel-fn1db
3 жыл бұрын
Magical🎩✨ tricks.....
@VSLComputers
3 жыл бұрын
Wow... I thought I was an Excel jock until I saw this. Very nice presentation!
Пікірлер: 530