Excel Techniques for Detecting and Preventing Fraud

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.

Highlights

Objectives

Upon completing this course, participants 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

Designed For

Accounting and financial professionals looking for practical approaches and techniques for minimizing their exposure to fraud