K2’s Testing and Auditing Excel Workbooks

Salepage : K2’s Testing and Auditing Excel Workbooks
Archive : K2’s Testing and Auditing Excel Workbooks Digital Download
Delivery : Digital Download Immediately

Excel mistakes continue to be a problem for businesses of all kinds, with estimates putting the error rate at about 90%. As spreadsheets grow increasingly ubiquitous, testing and auditing Excel workbooks is more important than ever to limit the impact of these mistakes on nearly every Excel user and those who rely on Excel-based data and analytics. Fortunately, this does not have to be the case because there are numerous options available to prevent, identify, and correct spreadsheet errors before they negatively impact reports and decision-making processes, and in this session you will learn procedures for testing and auditing Excel workbooks.

This workshop will teach you how to use best practices to limit the number of errors in workbooks that you and others on your team develop and modify. Moreover, you will learn how to use Excel add-ins to dynamically scan and audit your spreadsheets to uncover potentially devastating problems while there is still time to repair them. You don’t want to miss out on this chance to discover how technologies like PerfectXL, ClusterSeven, and ActiveData may assist you and your team in identifying and correcting potentially devastating spreadsheet problems.

Fundamental Course Information

Objectives of Learning

List the most typical causes of spreadsheet mistakes and their associated consequences.
Determine the best strategies for reducing the amount of mistakes in Excel spreadsheets.
Use Excel add-ins to dynamically detect spreadsheet mistakes.

Major Topics

Causes of spreadsheet mistakes
Examples of spreadsheet blunders in the real world
Best spreadsheet design practices Tools for recognizing and managing risk problems in Excel spreadsheets

Tommy Stephens graduated from Auburn University in 1985 with a Bachelor of Science in Business Administration (major in Accounting). He received his Master of Science degree (Major in Finance) from Georgia State University in Atlanta in 1992. Tommy now has the designations of Certified Public Accountant, Certified Information Technology Professional, and Chartered Global Management Accountant.

Tommy has earned great expertise in a number of areas over his professional career, including:

Working as an auditor and technology consultant for an Atlanta-based public accounting firm; Managing a Cost Accounting team and leading an Internal Audit staff for a Fortune 500 corporation;
Working as the Chief Financial Officer for a multinational engineering firm; and founding and operating his public accounting firm, which offers accounting, tax, and consulting services to individuals and a range of small and developing enterprises.

Tommy started writing and presenting continuing professional education courses to accounting and finance professionals in 1995. He joined K2 Enterprises as an associate in 2003 and became a partner in 2007. He has taught on topics such as internal controls for small firms, technological strategies, computer hardware and software applications, tax strategies and compliance, and financial accounting standards and applications throughout the world. Tommy has delivered over 2,700 instructional programs to over 70,000 attendees across the United States and Canada over the last twenty-five years.

Tommy currently resides in Woodstock, Georgia, where he maintains a busy personal life with his wife. Snow skiing, fishing, jogging, and other outdoor sports are among his interests. Tommy is a member of the American Institute of Certified Public Accountants as well as the Georgia Society of Certified Public Accountants. He is also a former member of the Institute of Internal Auditors.

More from Categories : Business & Sales