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
    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
  • National Registry of CPE Sponsors for the QAS self-study delivery method
    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.

Sign Up For Our All-Access Pass:

Unlimited Access

12+ unique premium webinars each month and 560+ hours of on-demand self-study courses.

Save Time

CPE should be about learning, not wasting time searching all over for the right training.

Save Money

Complete your CPE requirements at one affordable price.

On-the-Go Learning

Learn at your own pace from your computer, tablet, or mobile device.