Uploaded January 2026 | Updated September 2026, 1 week ago
In this tutorial, explore essential Excel intermediate functions that every user should master to work smarter and faster. Learn how to use Named Ranges for cleaner formulas, apply logical functions like IF, Nested IFs, and IFERROR, and perform powerful lookups with VLOOKUP, HLOOKUP, and XLOOKUP. This session is ideal for users ready to move beyond the basics and build more dynamic, error-resistant spreadsheets.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Course Introduction
00:01:16 - Named Ranges
00:04:08 - IF Function
00:11:29 - Calculated IFs Function
00:20:35 - Nested IF Function
00:24:45 - IFERROR Function
00:26:46 - VLOOKUP Function
00:31:34 - HLOOKUP Function
00:36:09 - XLOOKUP Function
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
In this tutorial, explore essential Excel intermediate functions that every user should master to work smarter and faster. Learn how to use Named Ranges for cleaner formulas, apply logical functions like IF, Nested IFs, and IFERROR, and perform powerful lookups with VLOOKUP, HLOOKUP, and XLOOKUP. This session is ideal for users ready to move beyond the basics and build more dynamic, error-resistant spreadsheets.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Course Introduction
00:01:16 - Named Ranges
00:04:08 - IF Function
00:11:29 - Calculated IFs Function
00:20:35 - Nested IF Function
00:24:45 - IFERROR Function
00:26:46 - VLOOKUP Function
00:31:34 - HLOOKUP Function
00:36:09 - XLOOKUP Function
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
