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.
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
