May 20, 2024 - May 22, 2024
NGN 100,000.00
Details
While forensic accounting and fraud auditing and control are not new concepts, they are becoming increasingly important. We are constantly hearing about fraud cases and accounting schemes committed by corporations and individuals
in the accounting world. This course takes participants from the theory and concept of forensic accounting to its implementation and practice. It gives the necessary tools to help professionals add value to their organizations by examining fraud controls and
applying forensic accounting and analysis to their data.
Course Methodology
The course uses a blend of instructor's presentations, individual and group exercises and participants working on real life case studies and applying analytical MS Excel tools learned during the course.
Outline
Course Objectives
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
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 seeking to enhance their practical forensic
accounting skills.
Target Competencies
- Understand forensic accounting
- Apply forensic auditing
- Analyze financial data
- Detect fraud
- Prevent fraud
- Identify fraud and fraudsters
- Control fraud
- Examine data in Excel
- Utilize Excel for data analysis
National Association of State Boards of Accountancy (NASBA) : Ciel Consulting
Training and Consulting is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy
have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website
Location and Date
Ciel Consulting reserves the right to alter dates, content, venue and trainer.
Course Outline
Fraud and forensic accounting
- Introduction to fraud
- Fraud triangle
- Fraudsters’ profile
- Introduction to forensic accounting
- Introduction to fraud examination
- Corporate governance and ethics
- Code of conduct
Fraud schemes and controls
- Financial statements
- Corruption schemes
- Asset misappropriation
- Red flags
- Fraud detection
- Fraud response
- Fraud detection
- 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
- One digit a time
- Chi-Square
- Mean absolute deviation
- Logarithmic basis
- Second order test
- 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
- Subset number duplication
- Calculating correlations
- Time-Series analysis
Schedules
May 20, 2024 - May 22, 2024
| Weekdays | 10:00 AM — 04:00 PM |
Jun 17, 2024 - Jun 19, 2024
| Weekdays | 10:00 AM — 04:00 PM |
Jul 22, 2024 - Jul 24, 2024
| Weekdays | 10:00 AM — 04:00 PM |
Reviews
Be the first to write a review about this course.
Write a Review
Ciel Consulting is an ICT outsource and training Services Company with headquarters in Port Harcourt Nigeria and affiliates companies in America and Europe.
We offer world class training in Project Management, Primavera p6, Ms Project,AutoCAD (2D and 3D), Telecom, Ethical Hacking, PDMS (Plant Design Management System) as it is known in the 3D CAD industry, is a customizable, multi-user and multi-discipline, engineer controlled design software package for engineering, design and construction projects in, but not limited to, offshore and onshore.
Leading Professional Training and Consultancy firm, Authorized Training Partner of Simplilearn Int'l. Accredited Training and Examination Center
Related Courses
McTimothy Associates Consulting LLC
Ciel Consulting
Brainify Nigeria
Alpha Partners Training
