Ā Excel VLOOKUP & XLOOKUPĀ Mini Course

Letā€™s finally make VLOOKUP and XLOOKUP make sense

This short and practical course will show you exactly when to use VLOOKUP vs XLOOKUP and how to stop breaking your formulas.

Whether you're an Excel beginner or you've just been faking it for years (we've all been there), this mini course is your fast track to getting lookups right.

No fluff, no theory dumps, just real examples, quick wins, and formulas that actually work. (and of course: lots of fun, you know my style by now!)

Buy Now $29.00

Ā This course isĀ perfect for you if

  • You donā€™t even know what VLOOKUP is, but youā€™ve heard of it.

  • You open Excel and freeze because you forgot the formula (again).

  • You waste time manually searching through rows to find matching data

  • Youā€™ve heard of XLOOKUP but still default to VLOOKUP (out of fear or habit)

  • You get the dreaded #N/A error and have no idea why

  • You're ready to finally understand when to use VLOOKUP vs XLOOKUP

  • You want quick, clear, and visual examples, not textbook definitions

Course curriculum

    1. Course Introduction - Resources & How it works

      FREE PREVIEW

    1. Basics of VLOOKUP and first use case

    2. VLOOKUP #2nd Use Case - How to merge product list and sales data

    3. VLOOKUP Example #3 - Calculate inventory sold from two listings

    4. VLOOKUP Example #4 - Find customer information using (and merging) two listings

    1. The basics of XLOOKUP

    2. Example #1 - Define brackets using XLOOKUP

    3. Example #2 - Bring multiple columns from different listings using XLOOKUP

    1. Course recap & What's next

About this course

  • $29.00
  • 9 lessons

I truly regret not having learned VLOOKUP & XLOOKUP earlier in my professional career.


Buy Now $29.00

Testimonials

This course has been followed by 1,400 students so far and here's what they say about it

Ready to become Excel Proficient with VLOOKUP and XLOOKUP?

Buy Now $29.00

What real learners are saying

From YouTube tutorials to in-depth courses, people keep coming back for one reason, the content actually helps. Here's what just a few of them had to say:

ā€œIf you think all workplace trainings are snooze-fests, think again! Forget those boring, one-sided lectures that make you fight to stay awake, David brings a whole new vibe to the table. Trainings were stimulating, engaging, and tailored to the audience, with obviously a sprinkle of humor throughout the whole thing. Thanks David!ā€

Antoni Allaire, CPA

ā€œI had the pleasure of working with David as part of an artificial intelligence training session. Passionate, dynamic, and deeply committed, he knows how to convey complex concepts with clarity and enthusiasm. His mastery of the subject is undeniable, and he manages to make learning both accessible and engaging.ā€

Audrey Lessard, Business Development

ā€œDavid is a high-quality trainer who adapted to the realities of our organization. We greatly appreciated his energy and professionalism.ā€

Cloe Trepanier, HR Manager

ā€œDavid, this is awesome! Specially the OneNote part: as you said correctly: insane! Thank you!ā€

YouTube member

ā€œšŸ˜² Not Copilot that I've been ignoring with everything in my being šŸ˜¢ I'm trying this first thing tomorrow.ā€

YouTube viewer

ā€œThank you so much for the introduction ! the contents and demonstrations are Very clear and informative. you are an excellent presenter !ā€

YouTube viewer

ā€œThe course is an excellent introduction to all things M365 Copilot. David's engaging personality is woven throughout the lessons which helps to keep you watching. The inclusion of the "Prompt School" section and some excellent one pager reference guides raises the quality of this course above many others I've taken. Thank you David!ā€

Glynn Harwood, Student (Copilot Essentials)

šŸš€ Want the same kind of Excel wins?

Buy Now $29.00

MEET YOUR TEACHER

David Fortin

I am a Microsoft MVP and Chartered Professional Accountant. Two of my key projects involved raising $30M in Series B Venture Capital and playing a key role in a companyā€™s $200M exit, all achieved using Excel, PowerPoint, and the Microsoft Office suite.

People often say, ā€œYou donā€™t look like an accountant!ā€ Maybe itā€™s my energy. As a CPA, Iā€™ve completed countless hours of training to maintain my credentials. Most of those classes were dull, and I knew I could do better. My YouTube videos caught attention, and I became a Microsoft MVP, a title awarded by Microsoft to fewer than 3,000 people worldwide.

Iā€™m also aĀ LinkedIn Learning Instructor, featured alongside some of the top-tier instructors in the world.

With AI transforming the way we work, Iā€™ve trained over 500 professionals in ChatGPT & Copilot in just the last six months. The feedback? Unanimously positive.

Welcome to my world. My courses are built to make you more productive, help you get results faster, and most importantly, help you finish with a smile and excitement.

Cheers,
Dave

šŸ“¦ Want to Go Even Further With Excel & AI?

Most students who start with this VLOOKUP and XLOOKUP Mini Course eventually want more. More skills, more tools, and more results.

Thatā€™s why I created the Excel & AI Productivity Fast-Track Bundle. It includes this course and everything else you need to work faster and smarter with Excel.

  • AI-Powered Excel Quick Wins
  • Excel Charts Masterclass ā€“ Build pro dashboards that impress your boss
  • XLOOKUP & VLOOKUP Mini-Course ā€“ Make Excel actually do what you want (this course))
  • Copilot Prompt Dictionary ā€“ Copy-paste AI prompts that actually work
  • Cheat sheets & quick-reference downloads ā€“ Keep the key tips handy so you donā€™t forget them when you actually need them (at work, on the go, or when Excel brain fog hits)

I want the bundle!

Frequently Asked Questions

This course is perfect for any office professional that wants to learn VLOOKUP and XLOOKUP functions. You'll learn how to use these functions on a daily basis with real-life use cases.

I'm David Fortin, a CPA (Chartered Professional Accountant) with over 10 years of experience in the corporate sector. I've successfully facilitated a $30M venture capital raise and played a key role in a $200M company exit, giving me deep insights into business challenges, workflows, and strategic planning. Throughout my career, I've been a proficient user of the Microsoft Office suite, particularly Microsoft Excel, leveraging these tools to enhance productivity and analysis. I've also shared my expertise with over 6000 students on Udemy, consistently receiving high praise with an average rating of 4.5 stars across more than 250 reviews.

VLOOKUP is the MOST useful Excel functions out there. Its possibilities are infinite and it is truly going to speed up your workflow.

The course has a total length of 45 minutes of video lessons. Including practical exercises it should take you maximum 90 minutes. Best practice is to block 2 x 45 minutes block in your calendar! (One for VLOOKUP and another for XLOOKUP!)

Not at all :) It is a self-paced online course, so you can follow it whenever you feel like it!

Lifetime access! This is forever yours!!!

Please email me directly at [email protected]. (There might be some bulk discounts ;))

You DON'T need Excel 365 for the VLOOKUP part of the training but you do need Excel 365 for the XLOOKUP part of the training.

If you open Excel at least twice a month you should be fine to follow the course! I teach you everything you need to know on a step-by-step manner.

Click the "Buy now" button below and you can start watching it instantly! Beware, high energy alert!!!


Cheers

-Dave

14-day Money Back Guarantee

If, within the first 14 days of your purchase, the course doesn't fulfill your needs, I'll refund you! No questions asked.


šŸ”„ Escape Spreadsheet Hell (Without Losing Your Mind)

Learn the 2 Excel functions that save HOURS. Or get the full AI + Excel productivity system.

āœ… Start Learning šŸ’¼ Get the Bundle