Login

If you are a CPA Alberta member, or have a CPA Alberta account, please login with your account information.

If you are a non-member and do not already have an account, please create an account.

Forgot your account number or password?

Need help registering for a seminar? See our How to Register instructions.

  1.  
  2.  

Centennial 2010
  • Location:
 

DETECTING AND PREVENTING SPREADSHEET ERRORS


Level: Intermediate
Competency: Information Technology
Seminar Code: 01644
Format: Webinar 2 Hours
CPD Hours: 2
Availability: This seminar occurs in the past. To view other offerings of this seminar, go to "Additional Offerings"


Register before Jan 29, 2019 and pay the early fee!
Date: Tuesday, Feb 05, 2019
Time: 8:00 AM-10:00 AM
Location:

,
Meeting Room:
Fee Options: Tickets Required: N/A
(Passport Tickets can only by used 14 days prior to seminar start date)
Fee Required: $79.00 - Early Member
$79.00 - Early Non-Member
$79.00 - Regular Member
$79.00 - Regular Non-Member
Seminar 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.

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
Seminar Outline:
  • 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
Pre-requisite:
Who Will Benefit: Accountants and finance professionals who want to reduce errors in the spreadsheets used by their organization
Seminar Leader(s): MCCLELLAND, Mac
Special Notes:
Additional Offerings:
Can't make it to this session? See the other offerings of this seminar.

Terms and Conditions