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.
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.
