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.
10 activities • 31 videos • duration: 2h 7m

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.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.
Very helpful tips and tricks, especially on how to make text formatting to be recognized into numbers.. this has caused me many issues in the past working with data
it was quite good, and learned some new tricks and shortcuts, I'm already using XLOOKUP. One thing was I did find it a bit repetitive in some places. Overall really good.
The concepts are presented clearly with common pitfalls and useful tricks. The pace is really good for learning. The xlookup presentation is virtually the same as the vlookup presentation, but a good repeat of the the concepts. This is a useful course.
Perfect and detailed