COURSE
Using Excel Vlookup, Hlookup, Xlookup, Match, and Index
How to use Excel Vlookup, Hlookup, Xlookup, Match, Index. and Xmatch to look up data
schedule 1 hour4.6(85 ratings)
starstar
starstar
starstar
starstar
star_halfstar
CA$59
![Course image](/_next/image?url=https%3A%2F%2Fdbtkvjd5m619u.cloudfront.net%2Faccounts%2F275%2Fimages%2Fcourses%2F3077%2F41f1b383d2c7b11fd8186345a91b30ec.jpeg&w=640&q=75)
auto_storiesINSTRUCTOR(S)
![](/_next/image?url=https%3A%2F%2Fdbtkvjd5m619u.cloudfront.net%2Faccounts%2F275%2Fusers%2F9198%2Fd51f255d2ff0c02ebf47efd645af1335.jpeg&w=96&q=75)
Tom Fragale
Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall
About this course
CPA Alberta
CPA British Columbia
CPA Manitoba
CPA New Brunswick
CPA Nova Scotia
CPA Ontario
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:
schedule1 hours on-demand video
signal_cellular_altIntermediate level
task_altNo preparation required
calendar_todayPublished At Nov 12, 2020
workspace_premiumCertificate of completion
errorNo prerequisites
lock1 year access
calendar_todayUpdated At Jul 27, 2024
HomepageBecome an InstructorLatest IntelligenceLearnFormula BusinessTerms of useContact usPrivacy policyReport AbuseHelp Center
Copyright @ 2024 CPDFormula LearnFormula | Professional Development Course Marketplace