
Webcast



Intermediate



CPE Credits
4 Credits: Computer Software & Applications
Course Description
Excel errors continue to plague organizations of all sizes – estimates peg the error rate at approximately 90%. As spreadsheets become ever-more common, testing and auditing Excel workbooks becomes more necessary than ever to mitigate the effects these errors could have on virtually every Excel user and those who rely on Excel-based data and analyses. Fortunately, that need not be the case because many options exist to prevent, identify, and correct spreadsheet errors before they adversely affect reports and decision-making processes and in this session you will learn procedures for testing and auditing Excel workbooks.
In this session you will learn how to apply best practices to reduce the error rate in workbooks that you and others on your team create and edit. Equally important, you will learn how to take advantage of add-ins for Excel that can programmatically scan and audit your spreadsheets to identify potentially disastrous errors while there is still time to correct them. You do not want to miss this opportunity to learn how tools such as PerfectXL, ClusterSeven, and ActiveData can help you and your team to identify and correct potentially disastrous spreadsheet errors.
Major Topics Covered
- Causes of spreadsheet errors
- Real-world examples of spreadsheet errors
- Best practices for spreadsheet design
- Tools to assist in identifying and addressing risk factors in Excel spreadsheets
Learning Objectives
Upon completing this session, you should be able to:
- List common causes of spreadsheet errors and the potential impact of these errors
- Identify best practices to reduce the number of errors in Excel workbooks
- Implement various Excel add-ins to programmatically identify spreadsheet errors
Course Specifics
Course ID WC12206860 |
Revision Date March 23, 2020 |
Advanced Preparation None |
Compliance information
Course Instructor



Thomas (Tommy) G. Stephens, Jr., CPA, CITP, CGMA, received a Bachelor of Science in Business Administration (Major in Accounting) from Auburn University in 1985. In 1994, Mr. Stephens opened his public accounting practice in the metropolitan Atlanta area. In his practice, Mr. Stephens provided accounting, tax, and consulting services to individuals and a wide variety of small and emerging businesses. He developed a successful consulting practice providing installation and support services of small business accounting software. Additionally, he has authored and presented continuing professional education courses to accounting and finance professionals. Mr. Stephens has lectured nationally on subjects such as …
K2 Enterprises (Thomas G. (Tommy) Stephens, Jr., CPA, CITP, CGMA) Read More »
Testing And Auditing Excel Workbooks



CPE CREDITS
4 Credits: Computer Software & Applications
$245.00
Webcasts are available for viewing Monday – Saturday, 8am – 8pm ET.



Webcast



Intermediate



CPE Credits
4 Credits: Computer Software & Applications
Course Description
Excel errors continue to plague organizations of all sizes – estimates peg the error rate at approximately 90%. As spreadsheets become ever-more common, testing and auditing Excel workbooks becomes more necessary than ever to mitigate the effects these errors could have on virtually every Excel user and those who rely on Excel-based data and analyses. Fortunately, that need not be the case because many options exist to prevent, identify, and correct spreadsheet errors before they adversely affect reports and decision-making processes and in this session you will learn procedures for testing and auditing Excel workbooks.
In this session you will learn how to apply best practices to reduce the error rate in workbooks that you and others on your team create and edit. Equally important, you will learn how to take advantage of add-ins for Excel that can programmatically scan and audit your spreadsheets to identify potentially disastrous errors while there is still time to correct them. You do not want to miss this opportunity to learn how tools such as PerfectXL, ClusterSeven, and ActiveData can help you and your team to identify and correct potentially disastrous spreadsheet errors.
Major Topics Covered
- Causes of spreadsheet errors
- Real-world examples of spreadsheet errors
- Best practices for spreadsheet design
- Tools to assist in identifying and addressing risk factors in Excel spreadsheets
Learning Objectives
Upon completing this session, you should be able to:
- List common causes of spreadsheet errors and the potential impact of these errors
- Identify best practices to reduce the number of errors in Excel workbooks
- Implement various Excel add-ins to programmatically identify spreadsheet errors
Course Specifics
Course ID WC12206860 |
Revision Date March 23, 2020 |
Advanced Preparation None |
Compliance information
Course Instructor



Thomas (Tommy) G. Stephens, Jr., CPA, CITP, CGMA, received a Bachelor of Science in Business Administration (Major in Accounting) from Auburn University in 1985. In 1994, Mr. Stephens opened his public accounting practice in the metropolitan Atlanta area. In his practice, Mr. Stephens provided accounting, tax, and consulting services to individuals and a wide variety of small and emerging businesses. He developed a successful consulting practice providing installation and support services of small business accounting software. Additionally, he has authored and presented continuing professional education courses to accounting and finance professionals. Mr. Stephens has lectured nationally on subjects such as …
K2 Enterprises (Thomas G. (Tommy) Stephens, Jr., CPA, CITP, CGMA) Read More »
Testing And Auditing Excel Workbooks



CPE CREDITS
4 Credits: Computer Software & Applications
Webcasts are available for viewing Monday – Saturday, 8am – 8pm ET.
Excel errors continue to plague organizations of all sizes – estimates peg the error rate at approximately 90%. As spreadsheets become ever-more common, testing and auditing Excel workbooks becomes more necessary than ever to mitigate the effects these errors could have on virtually every Excel user and those who rely on Excel-based data and analyses. Fortunately, that need not be the case because many options exist to prevent, identify, and correct spreadsheet errors before they adversely affect reports and decision-making processes and in this session you will learn procedures for testing and auditing Excel workbooks.
In this session you will learn how to apply best practices to reduce the error rate in workbooks that you and others on your team create and edit. Equally important, you will learn how to take advantage of add-ins for Excel that can programmatically scan and audit your spreadsheets to identify potentially disastrous errors while there is still time to correct them. You do not want to miss this opportunity to learn how tools such as PerfectXL, ClusterSeven, and ActiveData can help you and your team to identify and correct potentially disastrous spreadsheet errors.
Major Topics Covered
- Causes of spreadsheet errors
- Real-world examples of spreadsheet errors
- Best practices for spreadsheet design
- Tools to assist in identifying and addressing risk factors in Excel spreadsheets
$245.00