Excel - Building Powerful Lookup & Reference Formulas (C46129)


Cancellation Policy

Please note that this webinar is from a third party vendor, CPA Crossings. We strongly recommend registering no later than one-hour before the webinar begins. Please contact CPA Crossings webinar hotline if you do not receive your webinar invitation via email within five minutes after registering:  877-370-2220 ext. 1. Thank you.

Date(s):

08/18/2020

Registration Open:

12:00 AM - 8:00 AM

Time:

8:00 AM - 10:00 AM

Facility:

 Online

Meeting Type:

Webinars

CPE Credit:

2.00

Field(s) Of Study:

Computer Software and Applications (2.00)

Level of Knowledge:

Intermediate

Price:

Member: $79.00
Nonmember: $99.00

Individual Discounts:

Not Available

Overview

After completing this class you will have the ability to...

  • Create complex lookup formulas
  • Use the INDIRECT function to speed worksheet creation
  • Use ERROR checking functions in calculations

Highlights

The major topics that will be covered in this class include:

  • Performing advanced searching & data retrieval with LOOKUP, INDEX & MATCH functions
  • Speeding up worksheet creation with the INDIRECT function
  • Testing conditions with the LOGICAL functions (IF, AND, OR, NOT)
  • Using ERROR checking functions

Speaker(s)

Prerequisites

None