Searching and combining data in Excel is one of the most important features for power users. In this training, you will learn the basic functions for this.
In the training, you will learn how to use VLOOKUP and VLOOKUP functions, learn how to retrieve data from another table using table values, and to combine data from multiple data sources into a single table.
The training is useful for users who want to learn how to use VLOOKUP or HLOOKUP functions in different scenarios. We hope that participants are already familiar with basic calculation formulas and the use of $ signs in formulas. If you’re not familiar with these, we recommend going through the Excel Basics courses first.
The training is suitable for users of Excel 2010 or later.
- Function arguments
- Combining and comparing datasets
- Search for specific data
- Most common problems
- How to use the HLOOKUP function
Excel, Functions, Searching, Lookup, Combine, Merge