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

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.