Webinar: Excel Techniques for Detecting and Preventing Fraud

WK252  |  Partner Virtual Events  |  Intermediate  |  Scheduled


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.


Number of Credits Type of Credits
2 Other


Good working knowledge of Excel


Identifying fraud risk areas in your organizationCreating fraud analysis reports unavailable in your general ledger applicationUsing Excel to find duplicate payments and other duplicated transactionsPerforming analytical review using Excel calculationsUsing Benford analysis to identify potentially fraudulent transactions


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




This webinar is provided by K2 Enterprises. After registering for the course, you will receive an email from K2 with instructions for logging in to the webinar and obtaining your eMaterials.


Member (Early Bird)
Non-Member (Early Bird)
Registration for this event has closed. If you have any question or concerns please give us a call at 615-377-3825 or send us an e-mail at registrar@tscpa.com


Lawrence McClelland, MBA, JD

Mac McClelland, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas.

Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting.

He gained his practical experience in information systems with the National Aeronautics and Space Administration, and has an established practice in business and technology consulting. Mac has taught hundreds of continuing professional education seminars to accountants and business managers in the United States, New Zealand, Australia, Japan, and Southeast Asia. His presentations are highly rated, and he has won several awards for teaching excellence.

Mac has been published in leading business and practitioner journals, including Tax Ideas, Computers in Accounting, Journal of Accounting Education, Chartered Accountants Journal of New Zealand, and the top-rated Journal of Accounting Research.

Back to Facilitators