LF logo
by learnformula
search
Log in
search
Courses/Office Productivity/MS Excel

Excel VLOOKUP & XLOOKUP Mini Course

Master Excel to analyze, clean, and merge data effortlessly!

Created byDavid Fortin
4.8
(70 reviews)
BeginnerUpdated Sep 15, 2025
Excel VLOOKUP & XLOOKUP Mini Course

What You'll Learn

check_circleDemonstrate the ability to utilize Excel's lookup functions, specifically VLOOKUP and XLOOKUP.
check_circleIllustrate the importance of properly locking cells to enhance the ease and efficiency of formula dragging in Excel
check_circleApply the knowledge of VLOOKUP to merge different datasets, such as payroll data, salary lists, and inventory lists
check_circleUse XLOOKUP function to bring multiple columns at once from a sheet to another

About This Course

Learn Excel Functions to better analyze your data, clean it, and merge lists. In this quick course, you will learn everything you need to know about the VLOOKUP and XLOOKUP functions.

This course is designed for beginners and professionals alike, focusing on practical applications of these powerful tools. You'll explore how to use VLOOKUP and XLOOKUP to efficiently find, compare, and retrieve data across spreadsheets. By the end of the course, you'll be equipped with the skills to streamline your workflow and make smarter data-driven decisions.

Your Instructor

David Fortin
David Fortin

Chartered Professional Accountant & Microsoft MVP

menu_book3 courses
star529 reviews

David Fortin is a Chartered Professional Accountant (CPA) and a 2024 Microsoft MVP. He runs Piggy Bank Accountant, a YouTube channel where he shares practical insights on Excel and Microsoft Copilot. With a background in Financial Planning & Analysis (FP&A) for a SaaS startup, David was instrumental in raising $30 million in venture capital funding and played a key role in the company’s successful exit, valued at hundreds of millions. Known for his dynamic and energetic personality, David is all about helping people, which he does through his online courses on Excel and Copilot. What sets David apart is his ability to make learning fun and engaging, bringing a unique energy to his videos that resonates with his audience.

Credit Information

Is this course eligible for my CPD requirements as a Canadian CPA?

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.

What Students Are Saying

4.8
Student's Choice
70 reviews

Frequently Asked Questions

We are a registered provider with 327+ associations and regulatory bodies worldwide. We operate across 29 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.