COURSEUS$127
Using Excel Vlookup, Hlookup, Xlookup, Match, and Index
How to use Excel Vlookup, Hlookup, Xlookup, Match, Index. and Xmatch to look up data
1 hour 4.5(183 ratings)
-54%
US$58
INSTRUCTOR(S)
Tom Fragale
Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall
About this course
In Excel, sometimes there is a need to look up information from a table or from a different sheet, or to link the sheets together. This course will show you how to do that with the following functions/formulas:
- Vlookup
- Hlookup
- Xlookup
- Match
- Index
- Xmatch
- Linking sheets with formulas
- Data Consolidation
This course includes:
1 hours on-demand video
Intermediate level
No preparation required
Published At Nov 12, 2020
Certificate of completion
No prerequisites
1 year access
Updated At May 9, 2021
