Fraud Audit Techniques Using Excel (FAMC)

Pre-requistes:

Knowledge Level:

Major Topics:

• Getting Started with Auto
• Filter
• Searching for P.O. Boxes
• Text Filters
• Checking EIN Numbers
• Missing EIN or Telephone Number
• Reviewing Items Below a Review Threshold
• Comparing Lists Using Arrays
• Text functions 
• Benford's Law

Learning Objectives:

• Identify the uses of auto filter in fraud auditing
• Recognize when auto filter and conditional formatting may be utilized to highlight exceptions
• Associate VLOOKUP and IFERROR functions with a need to compare lists
• Associate array formulas and certain text functions with a need to compare lists
• Identify and eliminate duplicate items
• Identify gaps in a sequence using Excel
• Recognize the uses of Benford’s Law

Designed For: