February 15, 2023


Webinar


2 Total CPE Credits

product-artwork-1225971

Excel - Building Powerful Lookup & Reference Formulas

Learning Objectives

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

Major Topics

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

CPE Credits Available

2
Total CPE
2
Other

Things to Know About This Course

Course Level

  • Intermediate

Prerequisites

None

Advanced Preparation

None

Intended Audience

All Excel users who want to become Excel Formula Experts

Provider

CPA Crossings

Register For This Event

  • ASCPA Member

    $ 79 79
    Join
  • ASCPA Non-Member

    $ 129 129
    Your Price

Please login to register.