K2's Testing and Auditing Excel Workbooks
Course Information
4
CPE Credits
4-Hour Course
Information Technology (4 Credits)
Fundamental Knowledge of Excel 2013 and Newer
Prerequisites
Intermediate
Program Level
No
Preparation
Course Information
4
CPE Credits
4-Hour Course
Information Technology
(4 Credits)
Fundamental Knowledge of Excel 2013 and Newer
Prerequisites
Intermediate
Program Level
No
Preparation
Major Topics
Small businesses have unique and specific technology needs, including those around remote access. Whether team members need remote access to desktops, data, voice services, instant messaging, or Cloud-based services, sometimes the list of available options can be overwhelming!
In this course, you will learn about practical solutions for facilitating remote access in small businesses. Among other items, included in this program is a detailed review of various solutions to provide remote access to a desktop, how to work securely from remote locations, key considerations when selecting Cloud-based solutions, and how to facilitate communication and collaboration in remote environments.
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.
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
- Implement various Excel add-ins to programmatically identify spreadsheet errors
Who is the course 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.
Instructional Delivery Method
Group-live demo and discussion using color computer projection.
More Courses
Looking for Other Excel-Focused Learning Options?
Consider the Following Seminars Available from K2 Enterprises
K2's Advanced Excel
K2's Advanced Excel
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
K2's Budgeting and Forecasting Tools and Techniques
K2's Budgeting and Forecasting Tools and Techniques
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
K2’s Excel Best Practices
K2’s Excel Best Practices
Computer Software and Applications (8 Credits)
K2's Excel Boot Camp
K2's Excel Boot Camp
Computer Software and Applications (16 Credits)
K2’s Excel Charting and Visualizations
K2’s Excel Charting and Visualizations
Computer Software and Applications (4 Credits)
K2’s Excel Essentials for Staff Accountants
K2’s Excel Essentials for Staff Accountants
Computer Software and Applications (8 Credits)
K2’s Excel PivotTables for Accountants
K2’s Excel PivotTables for Accountants
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
K2’s Excel Tips, Tricks, and Techniques for Accountants
K2’s Excel Tips, Tricks, and Techniques for Accountants
Accounting (4 Credits)
Computer Software and Applications (4 Credits)
K2’s Introduction to Excel Macros
K2’s Introduction to Excel Macros
Computer Software and Applications (4 Credits)
K2’s Mastering Advanced Excel Functions
K2’s Mastering Advanced Excel Functions
Computer Software and Applications (4 Credits)
K2’s Next Generation Excel Reporting
K2’s Next Generation Excel Reporting
Accounting (8 Credits)
K2’s Testing and Auditing Excel Workbooks
K2’s Testing and Auditing Excel Workbooks
Information Technology (4 Credits)