Overview
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 2010, Excel 2013 and Excel 2016. Any features that differ between Excel 2010, 2013 and 2016 have been noted in gray shadow boxes for the few instances where there is a difference.
Learning Objectives:
The objectives of this course are:
I. Recognize fundamental aspects of Section 404 of the Sarbanes-Oxley Act and Public Accounting Oversight Board AS 2201
II. Recognize the process for evaluating spreadsheets under the rules of Section 404 and AS 2201
III. Identify specific compensating spreadsheet controls supported by Microsoft Excel
Instructional Method: Self-Study
Review Date: 01/01/2018
Required Components: Written Materials
CPE Final Exam Required Passage Grade: 70%
Please Note: This course must be completed within 1 year of
date of receipt of this course for CPE Credit.
Field of Study:
Auditing
Level of Knowledge:
Beginner
Prerequisite: None
Advanced Preparation: Excel 2010/ Excel 2013/ Excel 2016 is needed.
For more information regarding administrative policies such as refunds, cancellations
and complaints, please contact FurtherEd at 866-273-0717.
FurtherEd is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of the individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:
www.nasbaregistry.org.