Sold Out: Detecting Fraud with Data Analytics Workshop
CPE Credit: 24
Minneapolis, MN | July 22-24, 2019
Course Level: Overview
Prerequisite: Working knowledge of basic functions in one or more of the following software programs: Microsoft Excel, ACL, IDEA, Tableau
The Detecting Fraud with Data Analytics Workshop will teach you how to plan, design and apply numerous data analytics tests in order to detect various fraud schemes. You will also discover how to examine and interpret the results of those tests to identify the red flags of fraud.
The first day of the course will provide a solid foundation on which to build your data analytics initiatives, from understanding the types of tests that can be used to tying your tests to the fraud risk assessment, properly preparing and normalizing your data for testing, and effectively communicating the results of your analysis. On days two and three, you will link your new knowledge of analytical tests, data sources, and fraud schemes while applying data analysis techniques to real data sets and scenarios.
Bring your own laptop and the software you are most comfortable with,* and practice using data analytics to uncover the red flags of fraud. You will work through cases covering a variety of fraud schemes, including purchasing fraud, corruption, payroll manipulation and financial statement fraud.
* Practical exercises can be conducted in Microsoft Excel, ACL, IDEA or Tableau. In order to participate in this workshop, attendees will need to bring one or more of these software programs fully installed and ready to use on their own laptop. Technical support for installing and running these programs will NOT be provided.
Recommended Knowledge and Advanced Preparation
During the workshop, we will be using several functions that are common in performing data analytics to detect fraud. To get the most out of the practical exercises, we recommend some proficiency in the following functions: LEFT, MID, RIGHT, MOD, FIND, VLOOKUP or INDEX, SUMIF, SUMIFS, COUNTIF, COUNTIFS, COUNTA, and AVERAGE. Other useful (though not required) knowledge includes absolute cell references, referencing cells on another tab, text-to-columns, remove duplicates feature, and Analysis ToolPak.
If you are not familiar with these functions or would like a refresher, here is a link to a short video that provides illustrations on how each of them works. You may also use this spreadsheet to follow along with the video and try out the functions yourself.
In addition, you might find the Excel cheat sheets and resources at the following links helpful. Feel free to bookmark, download or print these and bring them with you to the workshop as a quick reference.
Excel Cheat Sheet 1
Excel Cheat Sheet 2
Field of Study: Auditing
Advanced Prep: None
Delivery Method: Group-Live
Hotel & Venue Information
1001 Marquette Avenue
Minneapolis, MN 55403
Hotel Phone: (888) 933-5363
Room Rate: $226 single/double
Hotel Cut-Off: June 21, 2019
*Payment must be received by June 21, 2019 to receive the early registration discount.
ACFE seminars are unmatched in scope and effectiveness and backed by our unconditional satisfaction guarantee. If you attend an ACFE event and are not completely satisfied, please contact an ACFE Member Services Representative at MemberServices@ACFE.com
or call (800)245-3321 / +1 (512)478-9000.