|
|
Digital auditing and financial fraud detection are complex tasks, because fraudsters commit fraud by creating fictitious entities, e.g. Material/ service rate or purchase Order value or vendor payments, and then manipulate the fictitious records to their advantage. It becomes very challenging job for detecting or auditing agencies to find abnormal duplications of specific digits, digit combinations, specific numbers and round numbers or other forms manipulation in data. Excel 2013/16 provides several easy-to-use tools that can greatly enhance and expedite the fraud audit process. This course will demonstrate how to use a variety of Excel tools along with
step-by-step instructions that you can put to immediate use to help your firm spot fraud red flags. This informative, practical, on-the-job training program will combine the best aspects of two different but related topics: fraud auditing and Excel tools for data mining, statistics, analytics and more useful Excel tools.
Key Learning Objectives- Understand the scope and size of fraud
- Review proper internal control
- Review SAS No. 56 Analytics and related dashboard KPIs
- Understand Bedford�s law and limitations
- Set up a worksheet to help automate Bedford�s law analysis
- Using Excel's special tools and functions to spot fraud red flags
| |
|
|
|
 | Richard T. Balog, CPA/CFF, CIA, CGFM, DACFE
He has been a CPA since 1972. Mr. Balog is an internationally-recognized seminar leader in providing audit, accounting, finance and business management professional development for over 30 years |
| View More |
| |
|
|
