Webinar

K2's Detecting and Preventing Spreadsheet Errors

  • Friday, December 22, 2017

    1:00pm – 3:00pm
  • 2
    CREDITS
    Computer Software and Applications

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

Highlights

  • 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
  • Additional Information

    Designed For

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

    Vendor

    K2 Enterprises

    Advanced Preparation

    None

    Prerequisite

    Good working knowledge of Excel

    Field of Study

    Computer Software and Applications

    Course Number

    1780419

    Level of Knowledge

    Intermediate

    Add to Cart

    View All Courses