Thank you Mike😊, I was not aware lookup function could be more effective than xlookup in some scenario. And I appreciate you always explain what is happening in the background and not just rushing through the arguments of a function. And totally agree with the intro that AI should be used responsibly - it is not just entering accurate prompts and getting correct answer - it is getting the best answer that suits your needs.
@excelisfun Thank you Mike. I have an idea regarding a next video and I think that one could be even 2 hours long considering the number of examples that come on my mind. Advanced LAMBDA functions. To be honest with you, even an advanced Excel user such myself, would need each bit of these advanced LAMBDA functions to be explained separately. I will appreciate a lot if you create such a video. Thank you in advance.
@@B1897forzajuve I have already made that video. How have you not seen it? Anyway, that is a more advanced video for this part of the class. I will have a video in this class on that topic, but at the end. Are you subbed and have you seen my TH-cam home page intro video? Home page: th-cam.com/users/excelisfun Intro Video: th-cam.com/video/81W5EZjwTqk/w-d-xo.html MECS playlist: th-cam.com/play/PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW.html LAMBDA 2 hour video: th-cam.com/video/OxV-F0vXj8I/w-d-xo.html Any questions, just ask : )
@@excelisfun Of course I am subbed, Mike. This is the first Excel related channel that I subbed to many years ago. As a father of a small child, I might have missed it due to my limited time available for Excel nowadays :)
Thank you so much for yet another amazing video sir❤ I have a question, I intend on switching career path to data analysis after learning about excel what tool should I move on next to learn( having gone through all your previous videos) I’m a bit confused. Thanks Happy holidays sir
The old one is still the best, because the pace is perfect, the only detail that is missing is dynamic spilled array formulas, and it is a complete class. Old complete class: th-cam.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html New, not complete for a few months: th-cam.com/play/PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo.html
Thank you Mike😊, I was not aware lookup function could be more effective than xlookup in some scenario. And I appreciate you always explain what is happening in the background and not just rushing through the arguments of a function. And totally agree with the intro that AI should be used responsibly - it is not just entering accurate prompts and getting correct answer - it is getting the best answer that suits your needs.
You are welcome for the LOOKUP fun and, wow! I so agree with you about AI!
Absolutely amazing video. I actually never knew about xmatch
Mike, have a great holiday and a Happy New Year. Thanks for making the Team better with every video!
You are welcome, Teammate Chris M!!! Happy Holidays to you too : )
Wonderfull Video ... Thanks Mike
You are welcome, Hussein!!!! : )
Thanks Mike. Another great video. I wish you a happy christmas and a happy new year to you and your family.
You are welcome, Formula Guy John!!!! Happy Holidays to you and your family too : ) : )
Absolutely amazing video
Glad it is amazing for you : ) : )
You are the Best Teacher ❤
Happy christmas 🎄❤
Thank you for your kind words and Happy Holidays to you : ) : )
The lookup army led by general Mike.
Merry Christmas and happy holidays to you, your family and Excelisfun's family :)
This is definitely the best lookup video I have done, so I am glad you liked it!!!!! Happy Holidays to you : )
@excelisfun Thank you Mike. I have an idea regarding a next video and I think that one could be even 2 hours long considering the number of examples that come on my mind.
Advanced LAMBDA functions. To be honest with you, even an advanced Excel user such myself, would need each bit of these advanced LAMBDA functions to be explained separately.
I will appreciate a lot if you create such a video.
Thank you in advance.
@@B1897forzajuve I have already made that video. How have you not seen it? Anyway, that is a more advanced video for this part of the class. I will have a video in this class on that topic, but at the end. Are you subbed and have you seen my TH-cam home page intro video?
Home page: th-cam.com/users/excelisfun
Intro Video: th-cam.com/video/81W5EZjwTqk/w-d-xo.html
MECS playlist: th-cam.com/play/PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW.html
LAMBDA 2 hour video: th-cam.com/video/OxV-F0vXj8I/w-d-xo.html
Any questions, just ask : )
@@excelisfun Of course I am subbed, Mike. This is the first Excel related channel that I subbed to many years ago.
As a father of a small child, I might have missed it due to my limited time available for Excel nowadays :)
Thank you for the awesome video 😊 and Merry Christmas🎄✨️
You are welcome, Teammate Malina : ) : ) Happy Holidays to you too : )
Great lesson,Thanks
You are welcome!!!
Always Great Mike
Always fun when you are creating in Excel!!
Thank you sir for this amazing video
You are welcome for the video!!!!!!
Amazing Mike :)
Thanks, Teammate Nader!!!!
thanks for dokument and simple file
very help to learn this video
thanks youtube and excelisfun
thanks very much
You are welcome very much!!!
Thank you so much for yet another amazing video sir❤
I have a question, I intend on switching career path to data analysis after learning about excel what tool should I move on next to learn( having gone through all your previous videos) I’m a bit confused.
Thanks
Happy holidays sir
You may have to lean other languages that I do not teach like: SQL, R, Python and others. I just offer Excel and Power BI at my channel.
@ thank you so much sir, what your channel offers has been my stepping stone and I truly appreciate your support and reply sir.
@mike, do you know in any way in which one can lookup hyperlinks in another excel basis condition
I am sorry, but I do not understand your question : (
Never knew what the switch function could do
SWITCH is wonderfully versatile : ) : ) : ) : )
For complete beginner which playlist to watch old or this new ....
The old one is still the best, because the pace is perfect, the only detail that is missing is dynamic spilled array formulas, and it is a complete class.
Old complete class: th-cam.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html
New, not complete for a few months: th-cam.com/play/PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo.html
Another great video
Glad it is great for you : )