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. As spreadsheets become ever-more common, the effects of these errors will continue to impact 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 adversely affecting reports and decision-making processes.

In this session, you will learn how to apply best practices to reduce the error rate in Excel workbooks you and others on your team create and edit. Equally important, you will learn how to take advantage of add-ins for Excel to programmatically scan and audit your spreadsheets to identify potentially costly errors while there is still time to correct them. Finally, you do not want to miss this opportunity to learn how tools such as PerfectXL, ClusterSeven, and ActiveData can help you and your team identify and correct potentially disastrous spreadsheet errors.

Learning Objectives

Upon completing this course, 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
  • Cite examples of Excel Add-ins to identify spreadsheet errors programmatically

Course Specifics

Course ID
WC1222283695
Revision Date
April 25, 2022
Prerequisites

Fundamental understanding of Microsoft Office Excel 2013 and newer

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 G. (Tommy) 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 internal controls for …

K2 Enterprises (Thomas G. (Tommy) Stephens, Jr., CPA, CITP, CGMA) Read More »

Testing and Auditing Excel Workbooks

CPE CREDITS
4 Credits: Computer Software & Applications

$196.00


Webcasts are available for viewing Monday - Saturday, 8am - 8pm ET and Sunday 12pm - 4pm ET.

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. As spreadsheets become ever-more common, the effects of these errors will continue to impact 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 adversely affecting reports and decision-making processes.

In this session, you will learn how to apply best practices to reduce the error rate in Excel workbooks you and others on your team create and edit. Equally important, you will learn how to take advantage of add-ins for Excel to programmatically scan and audit your spreadsheets to identify potentially costly errors while there is still time to correct them. Finally, you do not want to miss this opportunity to learn how tools such as PerfectXL, ClusterSeven, and ActiveData can help you and your team identify and correct potentially disastrous spreadsheet errors.

Learning Objectives

Upon completing this course, 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
  • Cite examples of Excel Add-ins to identify spreadsheet errors programmatically

Course Specifics

Course ID
WC1222283695
Revision Date
April 25, 2022
Prerequisites

Fundamental understanding of Microsoft Office Excel 2013 and newer

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 G. (Tommy) 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 internal controls for …

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 and Sunday 12pm - 4pm ET.

$196.00