In this tutorial, we have curated the top 10 Excel formulas that every beginner should know. Whether you are just starting out or looking to refresh your skills, this step-by-step Microsoft Excel training covers all the essentials.

Discover the power of VLOOKUP, MATCH, XLOOKUP, COUNTIF, IF statements, and more. With easy-to-follow explanations and practical examples, you'll be mastering Excel in no time!

Use the timestamps provided to navigate seamlessly through each topic. Skip ahead if you are already familiar with certain topics.

00:00:00 - VLOOKUP
00:10:12 - MATCH Function
00:12:59 - XLOOKUP and XMATCH Functions
00:23:09 - Count Cells with Text COUNTIF
00:25:32 - IF, Nested IF, IFS
00:31:03 - Conditional IF Functions
00:38:12 - Nested IF
00:44:52 - IFS Function
00:53:35 - Conditional IF Functions
01:00:11 - COUNTBLANK Function
01:04:57 - LET Function
01:20:09 - Date and Time Functions
01:28:52 - Randomized List and RAND Function

Get unlimited training with Simon Sez IT’s 200+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z

Excel 2021 Tutorials for Intermediate Users here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3

Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thumbs up ;-)