Self-Study Course Details
Course Description
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
- 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
Prerequisites
- Excel 2010/Excel 2013/Excel 2016 is needed.
Advanced Preparation
None
Author Details
-
Joseph Helstrom
Joe is a partner at CFO Resources, LLC, a company focused on training and courseware for CPAs and is also the owner of Mill Creek Publishing LLC, a provider of self-study courses for CPAs. Joe has over 30 years of experience as a CPA in both public accounting and industry with extensive experience in financial reporting and analysis, treasury, tax, information technology, legal and regulatory matters and strategic planning. After graduation from Butler University with a degree in Accounting, Joe got his start at Ernst & Young and, subsequent to that, has served as Chief Financial Officer, Director of Treasury and Tax, Controller and Manager of Financial Planning, Reporting and Analysis for several different companies. Joe, along with his wife Patricia McCarthy, have published articles in Missouri and Texas CPA Society publications titled “Incorporating Excel Arrays into Your Audit Plan”.
NASBA Sponsor
-
Encoursa 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 individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: NASBAregistry.org.
$27.00
CPE
-
Webinars: CPE certificates will be accessible through your dashboard 1 hour after a webinar concludes.
Self-Study: CPE certificates will be accessible through your dashboard immediately after passing the qualified assessment.
For specific instructions on accessing your CPE, please see our FAQ section on our support page.
- Multiple Attendees on Webinars: Each attendee should register separately for the webinar. If more than 1 attendee participated from the same device, please contact us after the event to let us know. For group signups for paid events, please contact us.