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