Excel Power User Module 4: Handling Errors and Comparing Lists

Overview

Examine functions that help us trap and handle errors and discuss efficient methods to perform list comparisons. Continue to integrate these features as we proceed throughout the series. This is part 4 of a 10-part series Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Highlights

• Trap errors with IFERROR • The IF function • List comparisons • The ISERROR function • Multicolumn list comparisons with COUNTIFS • Indentation • Perform lookups with SUMIFS

Designed For

Accounting professionals that use Excel for Windows.

Objectives

• Identify which Excel function can be used to perform a multicolumn list comparison. • Determine which approach to indenting report labels is recommended for recurring use workbooks. • Recall which Excel function returns the count of the number of cells that meet specified conditions.