
K2's Excel Techniques for Detecting and Preventing Fraud - On Demand (2 hours)
Course Description
Fraud is alive and well! From large, multi-national companies to small, family-held businesses, fraud continues to plague American businesses. The latest surveys suggest that fraud consumes approximately 5% of all revenues generated in the US economy. This webinar provides a practical approach for uncovering fraud using easy to implement procedures in Excel.
Major Topics
- Identifying fraud risk areas in your organization
- Creating fraud analysis reports unavailable in your general ledger application
- Using Excel to find duplicate payments and other duplicated transactions
- Performing analytical review using Excel calculations
- Using Benford analysis to identify potentially fraudulent transactions
Learning Objectives
Upon completing this course, you should be able to:
- Identify two statistical techniques available in the Analysis ToolPak for assessing the reasonableness of accounting data
- Describe how to automate the process of extracting and analyzing data using Open Database Connectivity (ODBC)
- Use simple Excel queries to uncover billing schemes
- Identify duplicate payments using conditional formatting and filtering in an Excel Table
- Recognize when to use Excel Tables and PivotTables for creating reports and analysis for fraud detection
- Explain the Benford distribution and how it is used as a fraud detection tool
Who Should Attend: Accounting and financial professionals looking for practical approaches and techniques for minimizing their exposure to fraud
Course Level: Intermediate
CPE Credits: 2 Hours Computer Software and Applications
Prerequisites: Good working knowledge of Excel
Advance Preparation: None
Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.