On-Demand
Excel Power User Module 4: Handling Errors and Comparing Lists
CPE: 2
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
Product Code
1000003312
Credit Type
CPE: 2CPE-Technical: 2Format
Online Self-Study
Intended Audience
Accounting professionals that use Excel for Windows.
NASBA Field of Study
Computer Software & Applications
Level of Difficulty
Overview
Prerequisites
Excel Power User Modules 3 or knowledge of the topics covered.
Advance Preparation
None.
Learning Objectives
Major Subjects
- Trap errors with IFERROR
- The IF function
- List comparisons
- The ISERROR function
- Multicolumn list comparisons with COUNTIFS
- Indentation
- Perform lookups with SUMIFS