K2's Detecting and Preventing Spreadsheet Errors - On Demand (2 hours)

$79.00

Course Description

Spreadsheet error rates are at alarmingly high levels and have remained stuck there for years. In fact, many professionals who study this topic estimate that approximately 90% of spreadsheets contain errors. One organization - the European Spreadsheet Interest Group - identifies the top three reasons for spreadsheet errors as: 1) human error, 2) fraud, and 3) overconfidence. Regardless of the cause of spreadsheet errors, in an era in which business professionals rely increasingly on spreadsheets, the current error rate is not acceptable. In this session, you will learn techniques to help prevent and detect spreadsheet errors so that you will have confidence in the spreadsheets used by your organization.

Major Topics

Designing and building spreadsheet models using best practice techniques
Utilizing six specific techniques to reduce spreadsheet errors
Documenting workbooks using the Inquire add-in
Customizing and using error checking in Excel

Learning Objectives

Upon completing this course, you should be able to:

List the five principles of good spreadsheet design
Reduce the number of formulas used in analysis
Identify at-risk formulas in spreadsheets
Utilize Inquire feature to manage the process of documenting and auditing spreadsheets
List various add-ins for Excel that can help improve accuracy

Who Should Attend: Accountants and finance professionals who want to reduce errors in the spreadsheets used by their organization

Course Level: Intermediate

CPE Credits: 2 Hours Computer Software and Applications

Prerequisites: Good working knowledge of Excel

Advance Preparation: None

Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.