0      0

AICPA ENGAGE 2019

PST1918 - Excel for Fraud


Jun 11, 2019 3:45pm ‐ Jun 11, 2019 5:00pm


Standard: $49.00

Description

In this session, participants 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 CPAs 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.

Learning Objectives:

  1. Provide guidance for testing data for authenticity and reasonableness.
  2. Provide a guideline for using Excel to test data for the potential of Fraud using Benford's Law.
  3. Provide guidance for preparing a general ledger report for pivoting in Excel.
  4. Provide guidance in producing random numbers to be used in selecting data for statistical analysis and other data procedures.

Speaker(s):

Tags: PST

You must be logged in and own this session in order to post comments.

Yolanda Veliz
6/11/19 6:52 pm

How do I access the excel template being used in the session