When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Microsoft Excel Guru : Master VLOOKUP and XLOOKUP functions
How VLOOKUP and XLOOKUP will change your workflow and increase your professional skillset
This Course Includes
udemy
4.4 (110 reviews )
41 total mins 
english
Online - Self Paced
course
Udemy
About Microsoft Excel Guru : Master VLOOKUP and XLOOKUP functions
In this course, we will learn the powerful Microsoft Excel functions: VLOOKUP and XLOOKUP.
VLOOKUP is an essential function that everyone should master. It’s particularly useful for merging lists from two different systems using a unique identifier. Here are some practical examples we’ll cover:
Employee Salary Lookup: Given an employee list and payroll data, we’ll use VLOOKUP to find an employee’s salary using their unique ID.
Inventory Management: With an inventory list and sales data, we’ll determine the remaining quantity of an item when the quantity sold is only listed in one of the two lists.
Customer Information Retrieval: We’ll use VLOOKUP to find customer information, such as their name or email, based on their customer ID from sales records.
XLOOKUP, a robust function introduced in 2020, is set to eventually replace both VLOOKUP and HLOOKUP. We’ll explore its capabilities through the following examples:
XLOOKUP Basics: Learn the fundamentals of XLOOKUP and understand how it differs from VLOOKUP.
Grade Assignment: Discover how to use XLOOKUP to assign bracket values to specific values. For instance, if a grade ‘A’ corresponds to scores between 80 and 100, we’ll assign the letter ‘A’ to all scores within this range in just a few clicks.
Multi-column Merge: Learn how to merge two lists by bringing multiple columns at once from one list to another using XLOOKUP.
Throughout this course, you’ll also pick up invaluable Microsoft Excel tips, tricks, and hacks, all thought by a pro ;)
See you there!
What You Will Learn?
- 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.