Errors and fraudulent transactions can be remarkably difficult to spot. In the Forensic Analytics course, we provide a number of tools for teasing out these problem transactions from the masses of data in which they are normally hidden. Techniques covered include Benford's Law, outlier analysis, round numbers analysis, growth spurt analysis, policy threshold analysis, and time-series analysis. The auditing CPE course also gives extensive coverage to the process of importing data into Excel, so that these analyses can be conducted.
Learning Objectives
Upon successful completion of this course, participants will be able to:
Specify how data can be imported into Excel and scrubbed for analysis purposes.
Specify how Benford's Law can be used to identify suspect transactions.
Identify the uses to which data analysis techniques can be put for forensic analysis.
Major Topics
Forensic Analytics
Forensic Analytics Steps
Excel Data Importing and Scrubbing
Excel Forensic Analysis Techniques
Supplier-Specific Analytics
