I've been viewing many YT tutorials to improve my Excel skills, especially formula creation and this is one of the very best. It's clear, concse, well presented and most importantly explains why these formulas could be helpful. Well done !
@SimonSezIT2 жыл бұрын
Thanks for taking the time to write some kind comments and feedback :-)
@liezlsabandal14212 жыл бұрын
I agree!
@kipronoelijahkoech4630 Жыл бұрын
Thanks, Simon. You make very interesting videos. Just to throw in an addition on how to randomly choose. Another option is to use INDEX and RANDBETWEEN. The first cell will be "=INDEX($D$4:$D$7, RANDBETWEEN(1,4))" The advantage with this is that, it accepts the range as the choices unlike CHOOSE function.
@sivareddy3745 Жыл бұрын
Hi Adeb Ashby, Thanks to you. you teach Advanced Excel very good.
@arunkhanal72082 жыл бұрын
In the second sheet (Logical Functions) the result in column D (IFS, AND) are mutually exclusive but not collectively exhaustive. The sixty-four thousand dollar question is: "What will be the outcome if the sales be $30,000?" You have to rectify the rule for "Review" as Sales
@Monica-yp6yc3 жыл бұрын
great examples - thank you for video + providing the sample sheet!
@SimonSezIT3 жыл бұрын
You're welcome Monica, Delighted that you've enjoyed the video!
@rebeccakimpland83863 жыл бұрын
Awesome overview - just my pace, very helpful - I could use some more complicated ones also - thank you
@SimonSezIT3 жыл бұрын
Glad it was helpful!
@beebless23583 жыл бұрын
Oh wow. Thank you. Cirrently taking this class and this popped up.
@SimonSezIT3 жыл бұрын
Glad it was helpful!
@realHAUTEcre3 жыл бұрын
GREAT overview!
@SimonSezIT3 жыл бұрын
Thanks!
@EcommerceOfGeorgia Жыл бұрын
amazing!
@SimonSezIT Жыл бұрын
Thanks for you kind comments! 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u 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!
@danielacheampong7519 Жыл бұрын
You are great
@NewsGrid21122 жыл бұрын
So impressing video. Thank you very much!
@SimonSezIT2 жыл бұрын
That is great to hear, Yared!
@darrylmorgan3 жыл бұрын
Well Done Really Enjoyable Tutorial...Thank You Deb :)
@SimonSezIT3 жыл бұрын
You’re welcome 😊
@simuislam57522 жыл бұрын
Thank you so much
@SimonSezIT2 жыл бұрын
You're welcome 😊 Thanks for watching!
@jackwilliams77162 жыл бұрын
Wow Excel really is easy with you ;)
@SimonSezIT2 жыл бұрын
Glad you think so!
@michaelfgondwe2 жыл бұрын
Wonderful
@SimonSezIT2 жыл бұрын
Thank you! Cheers!
@FastandCurious-c6sАй бұрын
Hi, I'm a carpenter and i would like to use excel for estimation and quotation that updates when I imput data
@SimonSezITАй бұрын
Excel can be a fantastic tool for that! 😃 You can set up formulas to update your estimations and quotations automatically based on your inputs. You can try our free KZbin courses here: kzbin.info/www/bejne/rpKroWWJopWtnNU
@ampcoreelectricalfittingco11882 жыл бұрын
Its not working once the file is closed and open again please help.
@lawrencekazibwe97512 жыл бұрын
Hearing loud and clear
@TanvirMostofa Жыл бұрын
Dear sir, I am facing some problems with the index match function (Vba macro Excel) But i can not explain.I want to share an excel file to describe . I need help. Please help me . If you want to help me, please send your mail address to share the file.