K2's Testing And Auditing Excel Workbooks
4.00 Credits
Member Price $155
Non-Member Price $205
Overview
Excel errors continue to plague organizations of all sizes. As spreadsheets become more common, 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 workbooks you and others on your team create and edit. Equally important, you will learn how to use 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 PerfectXL, ClusterSeven, and ActiveData tools can help you and your team identify and correct potentially disastrous spreadsheet errors.
Highlights
- Examples of common errors found in Excel workbooks
- How to reduce Excel errors
- Add-in solutions that can minimize spreadsheet error risk
Prerequisites
Fundamental understanding of Microsoft Office Excel 2019 and newer
Designed For
Business professionals seeking to reduce errors and improve accuracy and efficiency when working with Microsoft Office Excel. Although many of the concepts in this program apply to Microsoft Office Excel for the Mac, this course focuses on techniques found in Microsoft Office Excel for Windows
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 workbooks
- Cite examples of Excel Add-ins to identify spreadsheet errors programmatically
Preparation
None
Leader(s):
Leader Bios
Stephen Yoss Jr., Stephen M. Yoss, Jr., CPA, MS is a ce, K2 Enterprises
Stephen M. Yoss, Jr., CPA, is the partner, and principal of Devmatics, LLC, a software development company that focuses on solving problems through the implementation of technology. Stephen has consulted with several companies on how to lower overhead, personnel and compliance costs by investing in technology and reengineering their business practices. He teaches his clients to embrace technology at every opportunity in order to increase efficiency and productivity.
Stephen began working with technology at age ten, and started his first IT company at age 13, designing web applications for local businesses. He has presented to thousands of practitioners nationwide on topics such as cloud computing, mobile technology, spreadsheet design and best practices, information security, identity theft prevention and many more.
Non-Member Price $205
Member Price $155