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 👍🏽 ;-)