In this webinar, we define financial fraud and then describe how to detect suspicious activities. The webinar begins with a brief review of the Excel functionality used in an investigation: formulas, functions, and graphs. We then look at how to use default Excel tools such a Filter to examine a data set for fraud. We then discuss how to use Excel to spot suspicious activities using more advanced techniques such as Benford’s Law. Finally, we discuss best practices, how to present investigation results, and applying more advanced techniques.
WHY SHOULD YOU ATTEND?
Anyone interested in expanding their knowledge of fraud investigation. For example:
• Financial professionals
• Business owners
• Investigators looking to expand their skillsets
AREA COVERED
• Fraud Detection
• What is it?
• Why Excel?
• Getting Familiar with Excel Tools
• Formulas
• Functions
• Graphs
• Fraud Detection Techniques
• Filter
• Formula and function example
• WEEKDAY
• TEXT
• VLOOKUP
• MATCH
• Advanced techniques
LEARNING OBJECTIVES
• Learn what financial fraud is
• Provide a solid understanding of Excel tools
• Learn how to use Excel tools to identify patterns and anomalies in the context of accounting principals
• Learn how to apply statistical analysis methods to fraud investigation
• Become familiar with more advanced investigative methods
• Learn about the characteristics of a good investigator
WHO WILL BENEFIT?
- Financial professionals and business owners.
Anyone interested in expanding their knowledge of fraud investigation. For example:
• Financial professionals
• Business owners
• Investigators looking to expand their skillsets
• Fraud Detection
• What is it?
• Why Excel?
• Getting Familiar with Excel Tools
• Formulas
• Functions
• Graphs
• Fraud Detection Techniques
• Filter
• Formula and function example
• WEEKDAY
• TEXT
• VLOOKUP
• MATCH
• Advanced techniques
• Learn what financial fraud is
• Provide a solid understanding of Excel tools
• Learn how to use Excel tools to identify patterns and anomalies in the context of accounting principals
• Learn how to apply statistical analysis methods to fraud investigation
• Become familiar with more advanced investigative methods
• Learn about the characteristics of a good investigator
- Financial professionals and business owners.
