Spreadsheet Controls Under SOX 404 (1.5 hrs)

Current Status
Not Enrolled
Get Started
Course Description

Spreadsheet Controls Under SOX 404

Spreadsheets have become pervasive in most companies and have many uses.  Those that are used in the financial reporting process are of most concern to the assessment of the effectiveness of internal controls over financial reporting mandated by Sarbanes-Oxley. This course discusses how to evaluate spreadsheets under the rules of Section 404 and AS 2201 as well as what specific compensating spreadsheet controls are supported by Excel 2007, Excel 2010, Excel 2013 and Excel 2016.  This course has been written for Excel 2007.  Steps that differ in Excel 2010, 2013 and 2016 have been noted in gray shadow boxes for the few instances where there is a difference. There are no practice files to download with this course. All the exercises will be performed using your own Excel program.

Course Information

Price: $25

Course No. 6002
Format: Online pdf (64 pages). Printed book available.
Instructional Delivery Method: QAS Self-Study
Prerequisites: Excel 2007, Excel 2010, Excel 2013, or Excel 2016 is needed.
Advance Preparation: None
Level: Overview
CPE Credit: 1.5 hrs.
Field of Study: Computer Software & Applications – 1 hr, Auditing – .5 hr
Course expiration:  You have one year from date of purchase to complete the course.
Course Revision Date: January 2017


Upon completion of this course, you should be able to:
• Recognize fundamental aspects of Section 404 of the Sarbanes-Oxley Act and Public Accounting Oversight Board AS 2201
• Recognize the process for evaluating spreadsheets under the rules of Section 404 and AS 2201
• Identify specific compensating spreadsheet controls supported by Microsoft Excel