Excel Power User Module 4: Handling Errors and Comparing Lists
Available Until
Self-study
2.00 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. 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.
Notice
This is a self-study/on demand course offered by a 3rd party vendor and will NOT be accessible in the My Upcoming CPE section of the ISCPA website. Course access information will be emailed directly to you by CalCPA. The course expires one year from the purchase date. Format = Online Self-Study.
Non-Member Price $89.00
Member Price $69.00