When Excel-Based Analytics Detect Fraud

Data analytics


When Excel-Based Analytics Detect Fraud

Speaker: Rich Lanza, CPA, CFE, CGMA

  • Format


  • Level


  • Duration

    100 min

Learn to reduce fraud using data analytic surveillance. This audio session focuses on simple techniques to minimise risk in key areas, which can be executed using Excel-based analytics.

Learning outcomes

  • Align analytic reports to help detect the three most-common frauds
  • Discuss the key data fields needed to execute top fraud-finding analytics
  • Build simple fraud scoring to aid in selecting a fraud-specific sample based on the highest mathematical likelihood
  • Learn to profile the top actors of initiating frauds within your organisation by calculating each person’s “fraud quotient” using structured and unstructured data

£35.00 (CIMA members only)


VAT calculated on checkout

Product information


The use of data analytic surveillance has been proven to reduce fraud by two-thirds while at the same time doubling the speed of detecting within an organisation. This video offers simple techniques which can be executed using Excel-based analytics in key areas to minimise risk.

From manual journal entry reviews to accounts payable and travel cost schemes, you will learn the top fraud-finding analytics and put them to immediate use with case studies and one of the management accountant’s most-trusted tools, Excel.

Topics discussed:

  • Data analytic surveillance

  • Excel-based analytics

  • Common frauds

  • Top fraud-finding analytics

  • Fraud quotient

    This is an online, audio course; it is also available as part of CGMA Essentials. You will have 12 months from date of purchase to access this course, making it easy to fit around your work and personal commitments.

Who should take this course?

  • Accounting and finance professionals interested in adding value to their organisation by understanding how to detect and prevent fraud using Excel-based analytics

Professional development

All learning resources available in the CGMA Store qualify for CPD for CIMA members.

Field of study: Specialised knowledge & applications
Prerequisites:Familiarity with Excel PivotTables and Look-ups
Programme level:Intermediate
Duration:100 min
Access:This is a digital product. You will have access to the content for a year after purchase date.

Return and refund policy

£35.00 (CIMA members only)


VAT calculated on checkout


  • Rich Lanza, CPA, CFE, CGMA


The Association is dedicated to removing barriers to the accountancy profession and ensuring that all accountancy professionals and other members of the public with an interest in the profession or joining the profession, including those with disabilities, have access to the profession and the Association's website, educational materials, products, and services. The Association is committed to making professional learning accessible to all. This commitment is maintained in accordance with applicable law. For additional information, please refer to the Association's Website Accessibility Policy. For accommodation requests, please contact adaaccessibility@aicpa-cima.com and indicate the product that you are interested in (title, etc.) and the requested accommodation(s): Audio/Visual/Other. A member of our team will be in contact with you promptly to make sure we meet your needs appropriately.