Excel Vlookup, Xlookup, and Match & Index functions
Learn how to use Vlookup, Xlookup, Match, Index, and other functions in Microsoft Excel to efficiently look up information and link sheets together. Increase your productivity in Excel with this comprehensive course by Tom Fragale, a Microsoft Certified Trainer with over 22 years of training experience. Perfect for anyone looking to enhance their Excel skills and become more proficient in data analysis and manipulation.
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
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
User Reviews
Be the first to review “Excel Vlookup, Xlookup, and Match & Index functions”
You must be logged in to post a review.
There are no reviews yet.