Excel Vlookup, Xlookup, and Match & Index functions

What you'll learn
Learn how to use the Vlookup and Xlookup functions
Understand the use of Match and Index
Learn the new Xlookup function
Understand how to link one sheet to another sheet with formulas
Requirements
Understanding of Basic Excel worksheets and formulas
Description
In Microsoft Excel, sometimes there is a need to look up information from a table or from a different sheet, or to link the sheets together.
Excel has built-in functions called vlookup, hlookup, xlookup, and match and index and other functions to facilitate this process.
However, many people get very confused when using the vlookup and hlookup formulas. This course will really break it down so that anybody can understand and use these functions, and become more productive in Excel.
This course will show you how to do that with the following functions/formulas
- Vlookup - includes several examples and different variations of the vlookup function
- Hlookup - similar to the vlookup, but used when the data table is horizonal instead of vertical
- Xlookup - this is a new function which is simpler to use than the vlookup or hlookup.
- Match - usually used with the index function, so it is also called match/index
- Index - usually used with the match function
- Xmatch - anew function which simplifies the match / index
- Linking sheets with formulas
- Data Consolidation - adding sheets together that are similar
Learn how to use these functions in Excel from Tom Fragale, a Microsoft Certified Trainer with over 22 years of training experience, and a total of over 38 years of professional experience in the IT field
Who this course is for
Anyone who wants to increase their use and productivity in Excel
Screenshots