Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Topics Include:
- Revisiting the concepts of Range Names and their use in formula building.
- Understanding Lookups and limitations of VLOOKUP.
- Introducing the INDEX function.
- Exploring the use of the INDEX function with the MATCH function for creating Lookups that are not constrained to the left column in a dataset.
- Understanding the more advanced aspects of the INDEX function’s ability to return references.
- Understanding the “Approximate Match” method of lookups and their use in Tier-based calculations.
- Understanding Error Trapping for handling #NA errors.
- Exploring various kinds of Error Trapping formulas including newer functions available in versions 2013 and later.
Who Will Benefit
Those wishing to increase their proficiency in Microsoft Office with the convenience of taking courses at their own location.
Prerequisite(s)
- Essential requirements are a Computer with broadband internet access, audio headset or speakers, and working copy of Microsoft Office 2007 or later. Microsoft Office Starter Edition will not be adequate..
- Version 2013/2016 will be used in the demonstration of techniques of this workshop.
How to Access the Course
PLEASE read the FAQs and test your computer system at this link BEFORE registering.
This course is a live webinar. You must attend the live course to receive verifiable CPD hours. We recommend you join five minutes prior to the scheduled starting time.
Electronic material can be accessed one week prior to the course and should be downloaded in advance.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Paul Mascarenhas, BSc. MBA., President of Avancer Learning Inc., is a specialist in Strategic Analysis, and Communications. Paul has conducted his much sought after brand of hands-on IT Skills workshops, to globally renowned names as the Canadian Forces, Canadian Tire, Carlson Wagonlit, SKF Bearings (I) Ltd, CGI Inc, Scotiabank, Colgate Palmolive GSSO, Tetra Pak (I), ICICI Prudential, to name a few.