Back to Search

K2's Testing and Auditing Excel Workbooks Webinar

CPE

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

CPE Credits
4-Other

Details

 Pricing

PICPA Member: $150 | Nonmember: $201


 More Information

Course No.
4203882L
Level
Intermediate
Prerequisites
Fundamental understanding of Microsoft Office Excel 2010 and newer.
Note
None

Description

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

Highlights

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.


Speaker(s)

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 ...