Webcast: K2's Excel Techniques for Detecting and Preventing Fraud (XKEDF117)
Register Tell a Friend About This EventTell a Friend
 

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.

 Export to Your Calendar 7/14/2017
When: 07/14/2017
9:00 AM until 11:00 AM
Where: Webcast
K2
United States
Presenter: Mac McClelland


Online registration is available until: 7/12/2017
« Go to Upcoming Event List  

Acronym XKEDF117
CPE 2 hours
Vendor K2 Enterprises
Category
Management
Level Intermediate
Prerequisite Good working knowledge of Excel
Adv Prep None
Yellow Book? No
Designed for Accounting and financial professionals looking for practical approaches and techniques for minimizing their exposure to fraud
Registration
Member $79
CPA Non-Member $104

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

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.

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

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