Excel for Accounting Professionals Session 6: List Comparisons and Indenting

Prerequisites

Working knowledge of Excel

Designed For

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

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.