Microsoft Excel Guru : Master VLOOKUP and XLOOKUP functions

Description

In this course, you will learn:

• Demonstrate proficiency with Excel's lookup capabilities, notably VLOOKUP and XLOOKUP.
• Describe the significance of properly locking cells to improve the convenience and efficiency of formula dragging in Excel.
• Use VLOOKUP to combine several datasets, including payroll data, salary lists, and inventory lists.
• Evaluate and categorize items by assigning specific values using bracket grouping rules.
• Explore seven diverse cases where the use of XLOOKUP or VLOOKUP functions can greatly boost productivity, perhaps saving hundreds of hours.
• Use the skills gained in the course to plan and implement a complete data analysis project utilizing multiple Excel functionalities.
• Exploring the subtleties of when and how to use the VLOOKUP and XLOOKUP functions for best efficiency
• Use the XLOOKUP function to bring many columns at once.

Syllabus:

1. VLOOKUP Function

• The Basics of VLOOKUP and how to merge Payroll data with employee list
• VLOOKUP Example #2 - How to merge Product List and Sales Data
• VLOOKUP Example #3 - Calculate Inventory Quantity Sold from two listings
• VLOOKUP Example #4 - Find Customer information using VLOOKUP and two listings

 

2. XLOOKUP Function

• The Basics of XLOOKUP
• XLOOKUP Example #1 - Set grades (letters) to school notes (Brackets merging)
• XLOOKUP Example #2 - Bring multiple columns from a different listing

Show more