My Profile
My Events
My Self-Study
My CPE Tracker
My Discounts
Member Directory
Upcoming Events
Communication Preferences
My Committees
My Transactions
My Dues
Online Store

Help

Sessions | Instructor | Event Registration |

Event Information

K2's Testing and Auditing Excel Workbooks Webcast | 4203882C
Date: August 13, 2020
Event Start time: 6:00 AM   End time: 9:30 AM
Location: Webcast

Facility: Webcast Rebroadcast

 


Member:       $149
Nonmember: $199

CPE Credits:

4.00 CPE: Continuing Professional Education Technical


 

Excel errors continue to plague organizations of all sizes—estimates peg the error rate at approximately 90%. As spreadsheets become ubiquitous, testing and auditing Excel workbooks becomes critical. Fortunately, many options exist to prevent, identify and correct spreadsheet errors. Learn procedures to test and audit Excel workbooks.

Equally important, explore Excel Add-Ins that programmatically scan and audit your spreadsheets to identify potentially disastrous errors. Tools including PerfectXL, ClusterSeven and ActiveData, that identify and correct potentially disastrous spreadsheet errors.

 

Objectives:
 
  • List Common Causes of Spreadsheet Errors and the Potential Impact of these Errors
  • Identify Best Practices to Reduce the Number of Errors in Excel Workbook
  • Implement Various Excel Add-ins to Programmatically Identify Spreadsheet Errors
 

Major Subjects:
 
  • Testing and auditing Excel workbooks
  • Common spreadsheet errors
  • Excel Add-ins to identify spreadsheet errors
 

Level of Difficulty:
Intermediate

Field of Interest:
Information Technology

Prerequisites:
 

Fundamental understanding of Microsoft Office Excel 2010 and newer.

 

Designed For:
 

CPAs, accountants and business professionals.

 

Advanced Prep:
 

None.

 

Event Notes:
Save with Discount Programs

Join or Renew Today