Download the free course files and follow along here:
https://www.simonsezit.com/data-analysis-with-excel-functions-demo-files

Master essential data analysis skills with this focused guide on using VLOOKUP, HLOOKUP, and XLOOKUP in Excel. This course provides a deep dive into these powerful lookup functions, helping you quickly retrieve and analyze data across complex datasets. Whether you’re looking to find exact matches, handle data across rows and columns, or work with dynamic ranges, each function is covered with clear examples and practical applications.

Take your skills even further with Power Query, Excel’s tool for transforming and cleaning data. Learn how to automate repetitive tasks, filter and reshape data, and prepare your datasets for advanced reporting. Perfect for anyone looking to streamline their data workflows and gain a deeper understanding of Excel’s data management capabilities!

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 - Data Analysis with VLOOKUP, HLOOKUP and XLOOKUP
00:48:31 - Data Models, Pivot Tables and Power Query in Excel

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

Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! https://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
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

For a full training experience, check out our FREE YouTube course: https://www.youtube.com/@SimonSezIT/courses

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