Excel Power User Module 4: Handling Errors and Comparing Lists ON DEMAND
Available Until
Your Desk
2.0 Credits
Member Price $69.00
Non-Member Price $89.00
Overview
Examine functions that help us trap and handle errors and discuss efficient methods to perform list comparisons.
Highlights
Trap errors with IFERROR. The IF function. List comparisons. The ISERROR function. Multicolumn list comparisons with COUNTIFS. Indentation. Perform lookups with SUMIFS.
Prerequisites
None.
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.
Preparation
None.
Notice
None.
Non-Member Price $89.00
Member Price $69.00