Рет қаралды 122,579
✅Follow along and download the Excel for Business Analysts files for this tutorial here ⏩
www.simonsezit.com/excel-biz-...
In this hour-long Lookups tutorial, we teach you how to use the essential lookup functions that Microsoft Excel has to offer.
We start with a VLOOKUP tutorial, followed by an HLOOKUP tutorial. After that, we move on to using INDEX and MATCH to create a lookup, and finally, we look at the awesome XLOOKUP as a replacement for all the other lookups! This Excel tutorial is a must-watch tutorial if you're using lookups in Excel.
📝Video Markers:
0:00:19 - Vlookup Exact Match
0:11:11 - Vlookup Approximate Match
0:17:39 - Vlookup with Expanding Data
0:27:39 - Using Hlookup
0:39:58 - Combining Vlookup and Match
0:52:21 - Using Index, Match and Xlookup
✅Check out the rest of the videos in this playlist ⏩ • Data Analysis using Mi...
✅Follow along and download the Excel for Business Analysts files for this tutorial here ⏩
www.simonsezit.com/excel-biz-...
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
Check out our Excel 2021 tutorials for beginners playlist here
✅ • Excel 2021/365 Trainin...
Check out our FREE 300+ hour training course playlist here ➡️
🔥 • Simon Sez IT Long Trai...
💻Watch more popular tutorials from Simon Sez IT:
✅Microsoft Office 2021 and Office 365 Training Tutorials playlist
👉 • Microsoft Office 2021 ...
✅Microsoft Office 2019 Training Tutorials for Beginners playlist
👉 • Microsoft Office 2019 ...
✅ PivotTable training here 👉 • Pivot Tables - All you...
💬Stay in touch!
✅SimonSezIT.com: 👉www.SimonSezIT.com/
✅StreamSkill.com: 👉StreamSkill.com/
✅KZfaq Channel: 👉 / simonsezittraining
✅LinkedIn: 👉 / simon-sez-it
🔔Subscribe to our channel:
kzfaq.info...
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)