Date(s):

01/20/2020

Registration Open:

12:00 AM - 9:00 AM

Time:

9:00 AM - 11: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

Discounts available:

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

Prerequisites

None