✅ Download the free course files to follow along ➡www.simonsezit.com/excel-dashboards-instructor-files/ 🔥Check out our FREE 300+ hour training course playlist here 👉kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀Level up your Excel skill set with this free playlist 👉kzbin.info/aero/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
@ishaq792 жыл бұрын
This is amazing and decent teaching, without unwanted background music and graphics. Thank you very much!
@SimonSezIT2 жыл бұрын
We are happy that you liked it.
@n1ckyr9305 ай бұрын
In what scenario would you use choose over xlookup .. I'm struggling to see the benefits of choose given you can't just use ranges so think I must be missing something?
@crisantoeva76732 жыл бұрын
Thanks for this valuable lecture. I love your voice. It is so amiable.
@SimonSezIT2 жыл бұрын
Wow, thank you!
@gregorytaylor27493 жыл бұрын
Very educational tutorial!
@SimonSezIT3 жыл бұрын
I’m very pleased to hear that you’ve enjoyed the tutorial!
@ennykraft2 жыл бұрын
The disadvantage of CHOOSE is that you have to hardcode the number of options in the function which usually is bad practice. I only use it whenever I know there will never be more options and I don't want an unsightly lookup table in my file, like for example when calculating the end of the quarter for any given date.
@subhashini4242 Жыл бұрын
excellent
@SimonSezIT Жыл бұрын
Thank you so much for your kind words! I'm glad you liked the video. 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!
@FRANKWHITE19963 жыл бұрын
Great video thank you
@SimonSezIT3 жыл бұрын
Delighted you enjoyed it!
@OliveVlog Жыл бұрын
I run into a 254 value limit is there a way to add more values to exceed 254 value limit?
@haroune711 Жыл бұрын
well done
@karimredouane21503 жыл бұрын
THANKS
@SimonSezIT3 жыл бұрын
You’re welcome Karim
@SalukaAlwis8 ай бұрын
My excel haven't xlookup how to get that & filter function
@ahmedabdelsattar37502 жыл бұрын
Perfect
@prashia3 жыл бұрын
How to use Choose function if the list is long...50. hard to key in individual value in the formula.
@_sonicfive8 ай бұрын
Don't. Instead you could use FILTER()
@ArifKhan-qw5es2 жыл бұрын
Why are you locking the cell? What may happen if I do not lock?
@ajayvishvanathan1991 Жыл бұрын
if you dont lock, and you drag the formula to update, it'll also move the referenced cell in the same direction, it'll not pick up from that cell, it'll pick up values from the one below/beside it depending on which direction you drag the formula. Lock will ensure your input is constant.
@alikarimi19872 жыл бұрын
the link you provided does not work
@saitunzaw60423 жыл бұрын
How to do charts first for the last lesson?
@saitunzaw60423 жыл бұрын
get it
@AV-cj6li2 жыл бұрын
Great video for the function CHOOSE. Still not clear with XLOOKUP if you have multiple students with the same score...
@ennykraft2 жыл бұрын
In that case you want to use FILTER and MTRANS ( so that they are displayed next to each other). MTRANS(FILTER($A$2:$A$28,$B$2:$B$28=H4))