Excel Power User Module 4: Handling Errors and Comparing Lists (2 hours) [NT] – On-Demand Webcast
Available Until
On-Demand
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. 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
Prerequisites
Excel Power User Modules 3 or knowledge of the topics covered
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
“Adding to Calendar” does not register you for this event. Please either register online by clicking “Add to Cart” or contacting OSCPA at 503-641-7200 / 800-255-1470, ext. 3. Thank you!
Non-Member Price $89.00
Member Price $69.00