|
Participants are invited to download the workbooks before class, and bring their laptops if they would like to work on the examples during class.
All spreadsheets used in class are available for download at clickconsulting.com.
Objectives
· Explore Excel features relevant to auditing and fraud examination
· Examine the Excel tools that facilitate accurate financial reports
· Learn how to more fully use Excel to add efficiency to the engagement
Major Topics
· Reports: Quickbooks exports, electronic reporting, IF function for error checking, SUBTOTAL() function for balance sheets, XBRL
· Workpapers: trace dependents, show formulas, conditional format, search for plug numbers, data validation
· Auditing: SAS56, sampling techniques, analysis tool pack
· Analysis: Pivot Tables, auto filter, advanced filtering, duplicate records, VLOOKUP()
· Fraud: Benford's law
|
