December 1, 2025


Webcast Replay


2 CPE

Excel for Accounting Professionals Session 6: List Comparisons and Indenting

December 1, 2025
Webcast Replay
2 CPE

Excel for Accounting Professionals Session 6: List Comparisons and Indenting

Learning Objectives

  • Apply Excel’s LOOKUP function to perform list comparisons.
  • Use the ISERROR function to detect errors.
  • Use the COUNTIFS function to perform multicolumn list comparisons.
  • Determine appropriate application of indentation for efficiency gains.
  • Compare traditional LOOKUP functions to multiple condition summing function.

Major Topics

  • List Comparisons
  • The ISERROR Function
  • Multicolumn Lists with COUNTIFS
  • Indentation
  • Perform Lookups with SUMIFS

CPE Credits Available

2 CPE
2
Specialized Knowledge

Things to Know About This Course

Course Level

  • Intermediate

Professional Area of Focus

  • Technology

Prerequisites

Working knowledge of Excel

Advanced Preparation

None

Intended Audience

Accounting and finance professionals who'd like to improve their mastery of Microsoft Excel

Provider

AICPA

Register For This Event

  • MACPA Member

    $ 125 125
    Join
  • MACPA Non-Member

    $ 149 149
    Your Price

Please login to register.