CONTINUING EDUCATION FOR TAX & FINANCIAL PROFESSIONALS
Icon_Webcast
Webcast
Icon_Level
Intermediate
Credits
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

NASBA Provider Number: 103220

Course Instructor

Thomas G. (Tommy) Stephens, Jr. Headshot
K2 Enterprises (Thomas G. (Tommy) Stephens, Jr., CPA, CITP, CGMA)

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

Icon_Webcast
Webcast
Icon_Level
Intermediate
Credits
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

NASBA Provider Number: 103220

Course Instructor

Thomas G. (Tommy) Stephens, Jr. Headshot
K2 Enterprises (Thomas G. (Tommy) Stephens, Jr., CPA, CITP, CGMA)

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