Back to Search

K2's Testing and Auditing Excel Workbooks Webinar


April 8
12:00 - 3:30 p.m.

CPE Credits



PICPA Member: $150 | Nonmember: $201

 More Information

Course No.
Fundamental understanding of Microsoft Office Excel 2010 and newer.


List Common Causes of Spreadsheet Errors and the Potential Impact of these ErrorsIdentify Best Practices to Reduce the Number of Errors in Excel WorkbookImplement Various Excel Add-ins to Programmatically Identify Spreadsheet Errors


Excel errors continue to plague organizations of all sizes—estimates peg the error rate at approximately 90%. As spreadsheets become ubiquitous, testing and auditing Excel workbooks becomes critical. Fortunately, many options exist to prevent, identify and correct spreadsheet errors. Learn procedures to test and audit Excel workbooks.Equally important, explore Excel Add-Ins that programmatically scan and audit your spreadsheets to identify potentially disastrous errors. Tools including PerfectXL, ClusterSeven and ActiveData, that identify and correct potentially disastrous spreadsheet errors.


Thomas G. Stephens, Jr., CPA.CITP

    • Bachelor of Science in Business Administration, Major in Accounting,Auburn University
    • Master of Science, Major in Finance (emphasis in Corporate Finance), Georgia State University
    • Twenty-five Years of Public Accounting Experience, Five Years of Corporate Internal Auditing Experience, Four Years of Corporate and Cost Accounting Experience
    • Nineteen Years of Experience as a Continuing Professional Education Discussion Leader
    • Member of the American Institute of Certified Public Accountants and the Georgia Society of Certified Public Accountants; Past Member of the Institute of Internal Auditors
    • To Date, Has Presented Over 1,800 Continuing Education Sessions to Over 55,000 Participants

You May Also Like

K2's Data Analysis with Power Pivot Webinar
April 14 | Webinar
Differentiate between ordinary PivotTables and those created with Power PivotIdentify the advantages of working with Power PivotList the steps for building a PivotTable using Power PivotDefine Data Models, Data Analysis ...
K2's Mastering the Excel Data Model Webinar
April 14 | Webinar
Describe the Excel Data Model List the advantages of using the Data Model as a PivotTable data source Create PivotTables from data stored in multiple related Tables Describe the process ...
K2's Intro to Excel Macros Webinar
April 15 | Webinar
Create a macro in Excel using the Macro Recorder tool.Manage the fundamental elements of macros in Excel, including accessing macro functionality, naming macros, shortcut keys, storing and deleting macros, absolute ...