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.
Format: Online pdf (64 pages).
Prerequisites: Excel 2007, Excel 2010, Excel 2013, or Excel 2016 is needed.
Course expiration: You have one year from date of purchase to complete the course.