J. Carlton Collins, CPA


    Credit Info
  • NASBA Field of Study

  • Format

    On demand

  • Level

  • CPE Credit


  • Course acronym

  • Prerequisites

  • Course duration

    1 Hour and 15 minutes

Excel for Fraud

Category: Tags: , ,
In this video, you will learn several ways to use Excel to help detect and prevent fraud, including working with random numbers, applying Benford’s Law, and cleaning general ledger data so it can be pivoted and analyzed in detail. The goal is to provide accounting and finance professionals with guidance for testing data for authenticity and reasonableness. Don’t miss this unique opportunity to learn more about Excel from this unique and interesting perspective.
Hurry up, special offer for a limited time only.
Topics discussed

Learning objectives

Recall guidance for testing data for authenticity and reasonableness
Identify a guideline for using Excel to test data for the potential of Fraud using Benford’s Law
Identify guidance for preparing a general ledger report for pivoting in Excel
Recall guidance in producing random numbers to be used in selecting data for statistical analysis and other data procedures

Who will it benefit?