What are four controls that could be implemented into an excel sheet to prevent, detect, control etc. Explain briefly why the controls you have mentioned would be beneficial.

This is the first of four sessions on Using Excel to Detect Fraud. In keeping with our goal of not taking you away from your work all day, we have found the two hour sessions work better in the attendee’s schedule. Additionally, the concepts are presented from standpoint of fraud detection and prevention first, and the Excel tools to accomplish this second. As a result it is considered a Fraud topic qualifying for Fraud CPE as well as Technical CPE.

Excel’s robust list of features have most all the tools needed for preventing or detecting fraud. The real issue is which ones to use and when and which ones give the best results.  This session will layout different fraud scenarios and Excel approach and features to tackle the issue. Certain features will be presented as generic Excel topic and then how to use them in the fraud challenge.  Its one thing to find fraud or other anomalies but providing a winning forensic accounting / expert witness report is another. Exercises will show techniques from the spreadsheet analysis to the final report. Addition technical techniques will be presented to accomplish Zero Time Reporting; once the data is entered, imported or otherwise updated, the report is done.