Name: Using Excel Vlookup, Hlookup, Xlookup, Match, and Index
Price: 83 CAD
Rating: 4.5 (183 reviews)

by learnformula

shopping_cart Sign in

Homepage LearnFormula Podcasts Latest Intelligence LearnFormula Business Terms of use Contact us Privacy policy Report Abuse Help Center

by learnformula

shopping_cart Sign in

Homepage LearnFormula Podcasts Latest Intelligence LearnFormula Business Terms of use Contact us Privacy policy Report Abuse Help Center

Office Productivitychevron_rightMS Excel

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 hour

starstar

star_halfstar

4.5(183 ratings)

Created By Tom Fragale

~~CA$182~~

-54%

CA$83

auto_storiesINSTRUCTOR(S)

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

CPA Prince Edward Island

CPA Saskatchewan

CPA Newfoundland & Labrador

CPA Quebec Order

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 May 9, 2021

Latest Intelligence Requirements