Excel Error Trapping and List Comparisons (Currently Unavailable)
Author: Jeff Lenning
| CPE Credit: |
2 hours for CPAs |
In this session, we'll discuss error trapping functions and discover how they can be used to substitute a desired value for an error to clean up our reports.
Additionally, we'll discuss how to perform list comparisons. A list comparison is performed when you have two different lists or tables, and, you'd like to know which items on one list appear on the other. For example, to find out which checks on a check register list appear on the bank download. We will compare lists using a single lookup column as well as multiple lookup columns. Note: this course is designed for Microsoft Excel for Windows, and selected items may not be available in Excel for Mac.
Publication Date: June 2014
Designed For
Accounting professionals looking to learn more about Microsoft Excel for Windows.
Topics Covered
- Trap Errors with IFERROR
- The IF Function
- List Comparisons
- The ISERROR Function
- Multicolumn List Comparisons with COUNTIFS
Learning Objectives
- Recall the arguments of the IF and IFERROR functions
- Identify which function can be used to perform list comparisons
- Recognize which function can be used to perform multicolumn list comparisons
Level
Intermediate
Instructional Method
Self-Study
NASBA Field of Study
Computer Software & Applications (2 hours)
Program Prerequisites
be familiar with basic excel functions including named references, tables, data validation, conditional formatting, SUBTOTAL, skinny row, cell styles, nested functions, conditional summing, and remove duplicates, VLOOKUP, MATCH, INDEX.
Advance Preparation
None
