Рет қаралды 2,387
Unlock the power of Excel's lookup functions with our comprehensive tutorial! Master VLOOKUP for exact and approximate matches and explore horizontal lookups with HLOOKUP. Dive deeper into flexible lookups using INDEX and MATCH and discover modern alternatives like XLOOKUP and XMATCH. Learn to easily handle duplicates and leverage advanced techniques with the CHOOSE and SWITCH functions. Elevate your spreadsheet skills and streamline your data retrieval processes. Subscribe for more Excel tips, and don't miss out on mastering lookup functions with our in-depth course.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! Timestamps:
00:00:00 - Simon Sez IT Intro
00:00:09 - VLOOKUP: Exact and Approx Match
00:08:46 - Horizontal Lookups: HLOOKUP
00:15:14 - Flexible Lookups: INDEX and MATCH
00:22:58 - Modern Lookups: XLOOKUP and XMATCH
00:30:42 - Lookups with Duplicates
00:37:41 - Lookups with the CHOOSE Function
00:42:00 - The SWITCH Function
00:46:32 - Exercise 04
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzbin.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)