By the end of the course, participants will be able to:

• Explain fraud and forensic accounting
• Implement fraud controls to decrease the likelihood of fraud in the organization
• Utilize Microsoft Office tools to find fraudulent transactions and report on them
• Apply statistical and forensic accounting tools to analyze data
• Assist internal audit and senior management in testing data and finding anomalies
• Utilize Excel efficiently to identify suspicious information that needs further fraud investigation
• Identify fraud and anomalies using Excel

CONTENT

Fraud and forensic accounting

• • Introduction to fraud
  • Fraud triangle
  • Introduction to forensic accounting
  • Introduction to fraud examination
  • Corporate governance and ethics
  • Code of conduct

Fraud schemes and controls

• • Financial statements
  • Corruption schemes
  • Fraud Schemes in Assets
  • Fraud Schemes in Liabilities
  • Fraud Schemes by outsiders
  • Fraud Schemes in Purchasing & Sales
  • Red flags
  • Fraud detection & prevention
  • Fraud response
  • Internal controls

Forensic analysis with MS Office

• • Importing data into Excel
  • Analyzing data in Excel
  • Protecting data in Excel
  • Reporting data in Word
  • Reporting data in PowerPoint

High-level data tests

• • Data profile
  • Periodic graph
  • Histogram
  • Utilizing Excel to prepare data profile

Utilizing Benford’s law to test numbers

• • Data sets that could be used
  • Effect of data size
  • Basic digit test
  • First two-digit tests
  • Summation test
  • Number duplication test in Excel
  • Last two digits test

Identifying fraud and anomalies using Excel

• • Largest growth test
  • Largest subsets test
  • Relative size factor test
  • Same-Same-Same test
  • Same-Same-Different test

FOR WHOM

Professionals in the field of finance and accounting, controllers, accounting managers, senior and chief accountants, analysts, internal and external auditors and accountants at all levels

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.

This course is available in the following locations:

Nigeria - $5000
Rwanda - $7000
UK - $8000
USA - $8000