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.
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