Overview

1.0 Credits
IN-PERSON

If online registration has closed, please contact Sherrie Hodges at shodges@mstiller.com.

*Students: please RSVP to Sherrie Hodges at shodges@mstiller.com and bring $10 cash or check to pay at the door.

Speaker: Carlton Collins, CPA
Topic: Using Benford’s Law to Detect Fraud

J. Carlton Collins, CPA – There are many ways to use Excel to help detect and prevent fraud, and in this session you will learn about some of those methods including the clever application of Benford’s Law, as presented by J. Carlton Collins in the prestigious Journal of Accountancy last April. This article can be viewed at this web address: https://www.journalofaccountancy.com/issues/2017/apr/excel-and-benfords-law-to-detect-fraud.html.

 As time permits, Mr. Collins will also cover other fraud techniques using Excel including - working with random numbers, consolidating data, using regression to test the validity of data, profit margin monitoring, cleaning data so it can be properly analyzed, data analysis tools, using Sparklines to evaluate data trends, conditional formatting methods, ratio reporting and more. Don’t miss this unique opportunity to learn more about Excel from this unique and interesting perspective.  

 

Add to Cart