Online Seminar

Excel: Mastering Exact, Tier, and Error-Trapped Lookups using Vlookup, Index, Match, and Logical functions

Jun 24, 2022

Online

DATE

JUN 24

2022

TIME

12:00 PM - 2:00 PM

WHO CAN ATTEND

All

PD HOURS

2 Hours

ETHICS HOURS

0 Hours

STATUS

Registration closed on

Jun 21, 2022

EVENT 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.

PRICING

$81.50 Personal Passport

$95.00 Organization Passport

$120.00 Member

$120.00 Student

$147.00 Public

Status: Registration closed on Jun 21, 2022

LOCATION

Online

SPEAKER(S) BIO

Paul Mascarenhas, BSc. MBA., President of Avancer Learning Inc., specializes in hands-on workshops in IT skills and Communications. A specialist in Communications and Strategic Planning, Paul has facilitated numerous workshops for renowned corporations, in Canada and Internationally. At Avancer Learning Inc, Paul conducts his much sought-after brand of creative computing workshops for leading Canadian Corporations, Government Departments, & Professional Bodies.

SPECIAL INSTRUCTIONS

  • 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.
  • PLEASE read the FAQs and test your computer system at this link BEFORE registering.

    Registration, cancellation, withdrawal and all other CPA Ontario PD Seminar policies can be found here.