Cart 0
K2's Excel Techniques for Detecting and Preventing Fraud - On Demand (2 hours)

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.