Excel - Building Powerful Lookup & Reference Formulas Webinar

Feb 26
10:00 - 12:00 p.m.

Online

2-Other
CPE Credits

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

Registration

PICPA Member: $79
Nonmember: $104

More Information

Course No. OX123W-022618

Level: Intermediate

Prerequisites: None

Speaker(s)

Bryan Smith

DataSmith Pro LLC