Excel Power User Module 4: Handling Errors and Comparing Lists

Overview

This course is for audit professionals with audit experience with HUD (Housing and Urban Development) assisted projects such as Multifamily Housing projects. The course will include a discussion of the most commonly encountered HUD programs with audit requirements, the audit standards that apply to such audits, a review of the various compliance requirements that are common to HUD programs. We will identify common substantive and control testing audit procedures that apply to audits of multifamily housing projects, and the audit reporting requirements under both the HUD Audit Guide and the Uniform Guidance.

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.

Preparation

None.

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.