Certified Forensic Accounting and Audit Analyst
10–12 weeks (Flexible Delivery: Weekday evenings or Weekend sessions)
Target Audience:
- Professional Accountants and Auditors
- Internal Control & Compliance Officers
- Corporate and Public Sector Finance Professionals
- Fraud Investigators and Risk Analysts
- Graduate Students in Accounting, Finance, or Forensic Studies
Curriculum Structure
Module 1: Introduction to Forensic Accounting & Fraud Examination with Investigative Techniques Using Tech Tools
- Definition, scope, and evolution of forensic accounting
- Key roles and responsibilities of a forensic accountant
- Common occupational fraud schemes: asset misappropriation, corruption, and financial statement fraud
- Introduction to the Fraud Triangle (Cressey) and fraud red flags
- Overview of regulatory/legal frameworks (UK, US, Nigeria, Canada, global best practices)
Tools: None (Theory-focused)
Deliverable: Case Study Analysis & Reflection Write-up
Module 2: Core Accounting & Audit Concepts for Forensics
- Overview of GAAP and IFRS principles relevant to forensic reviews
- Audit trails, internal controls, and control environment assessment
- Analyzing financial statements for inconsistencies and red flags
- Risk-based auditing and evidence-gathering strategies
- Documenting findings for legal admissibility
Tools: Microsoft Excel (ratio and trend analysis templates)
Deliverable: Fraud Risk Review of Financial Statements
Module 3: Data Analytics for Forensic Accounting
- Importance of analytics in fraud detection
- Data types: structured/unstructured, internal/external
- Fraud analytics lifecycle: identification to resolution
- Descriptive and diagnostic analytics techniques
- Detecting outliers, trends, and anomalies
Tools: Â Excel, Power BI
Deliverable:Â Audit Analytics Dashboard
Module 4: SQL for Forensic Investigations
- Introduction to relational databases for financial systems
- Key SQL operations: SELECT, WHERE, JOIN, GROUP BY, HAVING
- Querying ledgers and subledgers for fraud detection
- Identifying duplicate transactions, vendor irregularities, and payment anomalies
- Identifying duplicate transactions, vendor irregularities, and payment anomalies
Tools: PostgreSQL / MySQL / MS SQL Server
Deliverable: SQL Query Pack Investigating Simulated Fraud Cases
Module 5: Advanced Excel for Fraud Detection & Reporting
- Advanced Excel functions: INDEX, MATCH, VLOOKUP, IFERROR
- Conditional formatting to flag suspicious transactions
- Scenario analysis, forecasting, and fraud simulations
- Building automated dashboards for audit reporting
Tools: Â Excel (latest version)
Deliverable: Dynamic Forensic Workbook
Module 6: Power BI for Interactive Forensic Dashboards
- Power Query for data cleansing and preparation
- DAX for custom calculations and fraud indicators
- Designing dashboards for real-time fraud tracking
- Visual storytelling with risk maps and drill-down analytics
Tools: Power BI Desktop
Deliverable: Interactive Power BI Fraud Dashboard
Module 7: Jira for Case Management & Audit Trail Documentation
- Setting up forensic investigation workflows in Jira
- Task assignment, milestone tracking, and evidence logs
- Real-time collaboration and case tracking
- Integrating documentation into formal reporting
Tools: Jira (Cloud version)
Deliverable: Jira-Based Fraud Case Tracker
Module 8: Ethics, Report Writing & Expert Testimony
- Ethical standards: ACFE, ICAN, ACCA, AICPA, CIMA, ICAEW guidelines
- Writing forensic audit reports: structure, findings, recommendations
- Presenting findings in legal and professional settings
- Managing confidentiality, whistleblower protection, and conflict of interest
Tools:  Word, Forensic Report Templates, Legal Checklists

Deliverable: Â Final Forensic Report & Expert Testimony Roleplay
Capstone Project: End-to-End Fraud Investigation Simulation
Participants will conduct a full forensic investigation using a real-world case simulation involving:
- SQL-based transactional data extraction
- Excel and Power BI analytics and dashboards
- Case documentation and task tracking in Jira
- Final report presentation with evidence-based conclusions
Assessment & Certification
- Weekly assignments and knowledge checks
- Peer-reviewed case submissions
- Final Capstone Presentation
- Certification of Completion (DigitCyber Infotech Academy & Partnered Institute)
Additional Features
- Optional Python Integration: Use of Pandas, NumPy, Seaborn, and Scikit- learn for advanced fraud analytics
- Guest Lectures: Sessions with forensic accountants, legal professionals, or certified fraud examiners (ACFE, ICAEW Faculty)
- Compliance Alignment: Aligned with ACFE Fraud Examination Manual, IFAC Forensic Guidelines, and ICAEW Forensic Faculty standards