28 easy lessons will help you master VLOOKUP and its new version, XLOOKUP. These are the most important functions in Excel, boosting your productivity and your resume. Learn them now!
If you work in finance, audit, accounting, or tax, mastering Excel functions like VLOOKUP and XLOOKUP is essential. This course teaches you how to use VLOOKUP to compare spreadsheets, find missing data, and connect multiple sources into one report—all of which can save you time and make you stand out in your team. You’ll start with simple examples and progress to advanced techniques explained in plain language.
The course also introduces XLOOKUP—the powerful modern alternative to VLOOKUP available in Microsoft 365—with 14 dedicated lessons. Practice files are included so you can follow along with the tutor. Plus, enjoy 3 bonus lessons on Pivot Tables, In-Cell Dropdowns, and Password Protection to further boost your Excel skills.
Future skills trainer and innovator. He works with global clients like Roche, Johnson&Johnson and DHL. He spent 5 years at PwC’s Lean management practice and 3 years as a CEO of an investor-backed startup.He focuses on Excel, Design Thinking, Lean Six Sigma and Digital Skills. He is also a blogger and a podcast host. He has 20+ years of Excel experience and 10+ years training experience. Lean Six Sigma Black Belt Certified (2016) He loves hiking the mountains, climbing the rocks and reading the books.
