Skip to main content
Fraud Investigation using Excel - CLS-00010761
0%
Previous
Course data
General
Announcements
Day 1 - Sunday
Lesson Plan
Pre-Assessment Test
Session 1 - Introduction to Fraud
Session 2 - Using Excel to detect Fraud
Session 3 - Excel Functions
Workbook 1 - Functions (Student copy)
Day 2 - Monday
Session 4 - Consolidating Data
Workbook 3 - Consolidation Similar Data
Workbook 4 - Consolidation Dissimilar
Workbook 5 - Consolidation
Day 3 - Tuesday
Session 5 - Sparkline and Conditional Formatting
Workbook 7 - Conditional formatting - Sparkline's
Workbook 8 - Conditional formatting - general slide example
Workbook 5 - Conditional formatting
Session 6 - Benford's Law
Workbook 6 - Benford's Law
Workbook 9 - Overall revision
Day 4 - Wednesday
Exercise 1- Above Average payments to a Vendor
Exercise 2- Employee to Vendor Address Match
Exercise 3- Duplicate Payments
Exercise 4- Missing unusual customer information
Exercise 5- Uncollected Account Receivables
Exercise 6- Excessive Credit Memos
Exercise 7- Common Names and Addresses for Refunds
Exercise 8- Deposit in Transit - Bank Reconciliation
Exercise 9- Nonstandard Journal Entries
Post-Assessment Test
Final Assessment
Next
Side panel
Categories
Home
Log in
Username
Username
Password
Password
Forgot your password?
Log in
Or login using your account
Categories
Collapse
Expand
Home
Standard Offerings
Summary
Course info
Fraud Investigation using Excel - CLS-00010761
Teacher:
Mahmood Abdulla Kadhem Ahmed
Skill Level
:
Beginner