Advanced Excel Formulas (IF, IFS, INDEX, MATCH, SUMPRODUCT, XLOOKUP, OFFSET, CHOOSE)

[@philiplbrown]

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 !

[@SimonSezIT]

Thanks for taking the time to write some kind comments and feedback :-)

[@liezlsabandal1421]

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.

[@arunkhanal7208]

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-yp6yc]

great examples - thank you for video + providing the sample sheet!

[@SimonSezIT]

You're welcome Monica, Delighted that you've enjoyed the video!

[@rebeccakimpland8386]

Awesome overview - just my pace, very helpful - I could use some more complicated ones also - thank you

[@SimonSezIT]

Glad it was helpful!

[@beebless2358]

Oh wow. Thank you. Cirrently taking this class and this popped up.

[@SimonSezIT]

Glad it was helpful!

[@realHAUTEcre]

GREAT overview!

[@SimonSezIT]

Thanks!

[@NewsGrid2112]

So impressing video. Thank you very much!

[@SimonSezIT]

That is great to hear, Yared!

[@darrylmorgan]

Well Done Really Enjoyable Tutorial...Thank You Deb :)

[@SimonSezIT]

You’re welcome 😊

[@danielacheampong7519]

You are great

[@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!

[@simuislam5752]

Thank you so much

[@SimonSezIT]

You're welcome 😊 Thanks for watching!

[@jackwilliams7716]

Wow Excel really is easy with you ;)

[@SimonSezIT]

Glad you think so!

[@ampcoreelectricalfittingco1188]

Its not working once the file is closed and open again please help.

[@michaelfgondwe]

Wonderful

[@SimonSezIT]

Thank you! Cheers!

[@lawrencekazibwe9751]

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.