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 RUclips home page intro video? Home page: ruclips.net/user/excelisfun Intro Video: ruclips.net/video/81W5EZjwTqk/видео.html MECS playlist: ruclips.net/p/PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW LAMBDA 2 hour video: ruclips.net/video/OxV-F0vXj8I/видео.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 :)
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: ruclips.net/p/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k New, not complete for a few months: ruclips.net/p/PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo
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
Absolutely amazing video. I actually never knew about xmatch
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
Glad it is amazing for you : ) : )
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 : )
You are the Best Teacher ❤
Happy christmas 🎄❤
Thank you for your kind words and Happy Holidays to you : ) : )
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!!
Amazing Mike :)
Thanks, Teammate Nader!!!!
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 : ) : )
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 RUclips home page intro video?
Home page: ruclips.net/user/excelisfun
Intro Video: ruclips.net/video/81W5EZjwTqk/видео.html
MECS playlist: ruclips.net/p/PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
LAMBDA 2 hour video: ruclips.net/video/OxV-F0vXj8I/видео.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 sir for this amazing video
You are welcome for the video!!!!!!
@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 : ) : ) : ) : )
thanks for dokument and simple file
very help to learn this video
thanks youtube and excelisfun
thanks very much
You are welcome very much!!!
Another great video
Glad it is great for you : )
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: ruclips.net/p/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
New, not complete for a few months: ruclips.net/p/PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo
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.