Webcast: K2's Detecting and Preventing Spreadsheet Errors (XKDPS17)
Register Tell a Friend About This EventTell a Friend
 

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 spreadshee

 Export to Your Calendar 9/6/2017
When: 09/06/2017
9:00 AM until 11:00 AM
Where: Webcast
K2 Enterprises
United States
Presenter: Mac McClelland


Online registration is available until: 9/4/2017
« Go to Upcoming Event List  

Acronym XKDPS17
CPE 2 hours
Vendor K2 Enterprises
Category
Management
Level Intermediate
Prerequisite Good working knowledge of Excel
Adv Prep None
Yellow Book? No
Designed for Accountants and finance professionals who want to reduce errors in the spreadsheets used by their organization
Registration
Member $79
CPA Non-Member $104

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

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.

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

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