-
Demonstrate the ability to utilize Excel's lookup functions, specifically VLOOKUP and XLOOKUP.
-
Illustrate the importance of properly locking cells to enhance the ease and efficiency of formula dragging in Excel
-
Apply the knowledge of VLOOKUP to merge different datasets, such as payroll data, salary lists, and inventory lists
-
Evaluate and categorize items by assigning specific values based on bracket grouping principles
-
Explore seven distinct scenarios where the application of XLOOKUP or VLOOKUP functions can significantly increase productivity, potentially saving hundreds of h
-
Synthesize knowledge acquired in the course to design and execute a comprehensive data analysis project using various Excel functions.
-
Exploring the nuances of when and how to apply VLOOKUP and XLOOKUP functions for maximum efficiency
-
Use XLOOKUP function to bring multiple columns at once from a sheet to another
Excel VLOOKUP & XLOOKUP Mini 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 on the VLOOKUP and XLOOKUP functions.
Learning Objectives
Here is what you should expect to learn in this course
Course curriculum
-
-
Basics of VLOOKUP and first use case
-
VLOOKUP #2nd Use Case - How to merge product list and sales data
-
VLOOKUP Example #3 - Calculate inventory sold from two listings
-
VLOOKUP Example #4 - Find customer information using (and merging) two listings
-
-
-
The basics of XLOOKUP
-
Example #1 - Define brackets using XLOOKUP
-
Example #2 - Bring multiple columns from different listings using XLOOKUP
-
-
-
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.
Testimonials
This course has been followed by 1400 students so far and here's what they say about it
I HAVE RECEIVED OVER 250 REVIEWS AS A TEACHER āāāāā
Ready to become Excel Proficient with VLOOKUP and XLOOKUP?
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.
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