With over 300 images, this course reviews and shows how twenty substantive and rigorous tests can be used to detect fraud, errors, estimates, or biases in your data. For each test, the original data is shown with the steps needed to get to the final result. The tests range from high-level data overviews to assess the reasonableness of data to highly focused tests that give small samples of highly suspicious transactions. These tests are relevant to your organization, whether small or large, for profit, nonprofit, or government-related.
Upon successful completion of this course, participants will be able to:
- Describe how Access is used in forensic analytics and discuss the basic architecture of Access and Access tables.
- Identify how to import data into Access and discuss the main types of Access queries.
- Analyze how the Access Documenter can be utilized in a forensic investigation and discuss other aspects of Access.
- Cite how Excel is used in forensic investigations, including how to import data into Excel and the pitfalls that can be encountered when using Excel.
- State how Excel can be used in Word files.
- Discuss the planning involved in the forensic presentation, including the use of PowerPoint.
- Describe the process of copying from Word, Excel, and other sources to PowerPoint.
- Analyze the three tests (data profile, data histogram, and periodic graph) that are used to form a good foundation for a data-driven forensic investigation.
- Describe how Access and Excel can be used in preparing the data profile, data histogram, and the periodic graph.
- Summarize the history of Benford's Law and how it can be used in forensic investigations.
- Analyze how data sets and data size impact Benford's Law, and define the basic digit tests.
- Compute the Z-statistic, the Chi-Square test, and the Mean Absolute Deviation test and determine their applicability in forensic investigations.
- Analyze the tests based on the logarithmic basis of Benford’s Law and the Mantissa Arc Test, and discuss how to create a perfect synthetic Benford Set.
- Discuss how the second-order and summation tests can be used in forensic analytic tests.
- Explain how the number duplication and last-two digits tests drill down into the data table to identify abnormalities.
- Define descriptive statistics and analyze how it can be used in a forensic analytic case.
- Discuss the value of the largest subsets test and the largest growth test and determine how to run the tests in Access.
- Analyze how to run the largest subsets test and the largest growth test in Excel.
- Cite how the relative size factor (RSF) findings are used to find anomalies.
- State how the RSF test can be run in Access or Excel.
- Analyze how the same-same-same test, the same-same-different test, and the subset number duplication aid are used in forensic analytics.
- Discuss how the tests can be run in Excel and Access.
- Define the concepts behind correlation.
- Explain how correlation can be used to detect fraud and irregularities.
- Discuss how to calculate correlations in Access and Excel.
- Describe time-series methods.
- Discuss the applications for time-series analysis.
- Explain how to run a time-series analysis in Excel, including the calculation of the seasonal factors.
- Explain the risk-scoring method.
- Discuss how the risk-scoring method was used in a case involving franchised restaurants.
- Discuss the audit selection method of the IRS.
- Cite how risk scoring is used to detect various frauds.
- Assess how the various techniques such as the digits of financial statement numbers and detecting biases in accounting numbers can uncover financial statement fraud.
- Analyze the case that used risk scoring to detect manipulations in monthly subsidiary reports.
- Discuss the use of purchasing cards and their potential for fraud.
- Analyze how analytics can be used on purchasing card transactions.
Choose Your Preferred Format
Get immediate access to a robust collection of learning and reference materials, allowing you to dive deep into the information you need. Our self-study materials are authored by top-quality, industry experts who focus on helping you grasp concepts quickly using real-life examples. Download your CPE to any device, and take it with you so you can learn when and wherever you want. Complete your CPE with an online exam, and enjoy instant grading with the option to print your certificate immediately upon passing.
Our self-study materials are authored by top-quality, industry experts. You’ll receive a bound notebook of all the course materials, shipped to you within one business day. In addition, you’ll also have full online access. Each self-study package includes a robust collection of learning and reference materials to help you cover the information efficiently and put it into practice immediately.
Experience high-quality instruction with our Self-Study Videos, available to you 24/7. With more than 80+ videos currently in the Western CPE Self-Study Video library, you can see and hear our expert instructors deliver the information you need in a dynamic way that allows you to immediately apply your learning. Unlike a live course or webcast, you can complete the course on your own time, playing and pausing as needed. Self-Study Videos allow you to complete your CPE requirements on your own time.
Back to top