I am so happy to help you have more fun with Excel!! But the drag part for you also means everyone loves you and you get a promotion first and you will get laid off last : )
I love that!!! I remember watching the VERY first Excel Video Guy: Bill "Mr Excel" Jelen two decades ago on iTunes. I would do the same fun thing: Coffee and an Excel video to start each day!
I already know these functions. Learnt many in your earlier courses. I'm running this video to increase your view count. I've seen your RUclips shorts pop-up too.
Hi, a little question: at 26:21 why did you apply ISNUMBER on C7:C12 and not on D7:D12? A few seconds earlier you said that the C cells are zeros and the D cells are the text-type ones. Thank you!
The D cells do have text, but for the TRUE and FALSE values generated by ISNUMBER, the FALSE values block out the text values from the D cells and the TRUE values pick out the cells with numbers : )
SEQUENCE is a great idea. The reason I used an array constant is because the top three scores never change in the boomerang MTA event, so by hard coding I avoid a call to the SEQUENCE function and things evaluate a bit faster : )
It is explained in the first class of this Excel Basics class. But, it is simple: any time you want to enter the things (number, text, formula into the cell and keep the cell selected, you use Ctrl + Enter. For example if you immediately format the cell or copy the cell, it is faster than using Enter and then click back up one cell.
I already know these functions. Learnt many in your earlier courses. I'm running this video to increase your view count. I've seen your RUclips shorts pop-up too.
You are the best. Thanks to you I learned power bi 5 years ago and now it is my profession. I love you
I am so glad that I can help!!!!
As other people here, one of your "students" and fan! And Excel teacher 😀. Thank you for all the commitment and work - it will always be appreciated.
You are welcome for the fun with Excel!!!
=IF(OR(you like to have fun, you like Excel), watch excelisfun , watch excelisfun) 😉
IF(Person=WantUpperEndAndOuterMarginsOfArrayFormulas,BefriendExcelLambda,BefriendExcelLambda)
: ) : ) : ) : )
Thank you! Thanks to you I am the Excel Expert at my company! That’s a compliment for you but a bit of a drag for me!! 😂
I am so happy to help you have more fun with Excel!! But the drag part for you also means everyone loves you and you get a promotion first and you will get laid off last : )
You are amazing sir❤ thank you so much for your continuous contribution
Merry Christmas 🎉
You are welcome, next video should be out tomorrow : ) Merry X-mas to you too!!
You’re amazing. I’ve learned so much thanks to you, even though I don’t know you personally, I consider you my best teacher. Thank you so much!
You are welcome!!! I am here at RUclips for you and I am a teacher for you : ) : )
Excellent Mike! Another video to help make newer users better. Go Team!!!
Exactly!!!! Thanks, Chris M : ) : )
Thank you Mike for the great video. I enjoyed following along while having a coffee 1st thing in the morning.
I love that!!! I remember watching the VERY first Excel Video Guy: Bill "Mr Excel" Jelen two decades ago on iTunes. I would do the same fun thing: Coffee and an Excel video to start each day!
How can I have forgotten this great page while being subscribed. Notifications are now set to All. Thanks you for the video.
You are welcome for the video and file : )
Awesome ❤😊
Thanks Teammate Malina : ) : ) : )
Thank you for sharing your Excel knowledge and useful tricks. It's awesome, Mike :)
You are welcome, Teammate!!!!
Absolutely amazing video
I already know these functions. I'm running it to increase your view count. I've seen your RUclips shorts pop-up too.
Thank you, Teammate!!!!
Thank you Mike. Very useful. 😃
Glad it helps!!! What was it in this video that was cool or most helpful ?
@excelisfun The IF functions.
@@markpodesta4605 Cool!
I already know these functions. Learnt many in your earlier courses. I'm running this video to increase your view count. I've seen your RUclips shorts pop-up too.
There are some cool new IF tricks in this one too : )
@excelisfun OK I'll watch the video more carefully this week-end.
@@FutureCommentary1 You might know them all, but you never know. Thank you very much for your support!!!
Hi, a little question: at 26:21 why did you apply ISNUMBER on C7:C12 and not on D7:D12?
A few seconds earlier you said that the C cells are zeros and the D cells are the text-type ones.
Thank you!
The D cells do have text, but for the TRUE and FALSE values generated by ISNUMBER, the FALSE values block out the text values from the D cells and the TRUE values pick out the cells with numbers : )
@@excelisfun Got it, thank you!
Amazing as usual
Best❤
Glad it is amazing for you : ) : )
@@tilaksingh Glad you like it!!!!
I learnt more from you following you tutorials in five years than ever .. Always topics usefull for Daily working routine... thanks ❣️
Great video ❤. Using the NOT logical function is a great trick . In large function in K argument we can use the sequence function as well .
SEQUENCE is a great idea. The reason I used an array constant is because the top three scores never change in the boomerang MTA event, so by hard coding I avoid a call to the SEQUENCE function and things evaluate a bit faster : )
@excelisfun Ok Great🙌❤️
14:53 =AND( ). Amazing.
Yep. When you know all the details, real Excel Magic can happen.
Why you do Ctrl +Enter .?
It is explained in the first class of this Excel Basics class. But, it is simple: any time you want to enter the things (number, text, formula into the cell and keep the cell selected, you use Ctrl + Enter. For example if you immediately format the cell or copy the cell, it is faster than using Enter and then click back up one cell.
Hello i hope you are good, can you share more questation of IFS funcation, if this possible for you.
Yes pls revert of my question.
I already know these functions. Learnt many in your earlier courses. I'm running this video to increase your view count. I've seen your RUclips shorts pop-up too.
Go Team!!!!