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 30, 2018 and pay the early fee!
Date: Tuesday, Feb 06, 2018
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: N/A - Early Member
N/A - 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: These webinars are delivered by K2E which is an American based company. Please note some US based content and examples will be used during this webinar. Login credentials will be emailed 2 – 5 business days before a live webinar starts. Cancellation of registrations and transfers received less than ten (10) business days, and more than five (5) business days before the Live Webinar will be subject to a $50 + GST fee which must be paid prior to the transaction being completed. Refunds will not be granted if the request is received five (5) business days or less before the Live Webinar begins.
Additional Offerings:
CityDateTimeSeminar Leader 
Feb 05, 2019 08:00 am-10:00 am MCCLELLAND, Mac
View Details
Can't make it to this session? See the other offerings of this seminar.

Terms and Conditions