Excel Pivot in AML/CFT Customer Bank Statement Analysis
What you'll learn
- Using Pivot Table Essentials in Customer Bank Statement Analysis
- What bank account statement analysis is in AML/CFT
- Money Laundering and Terrorist Financing Red Flags in bank account statement analysis
Requirements
- Basic Excel features
Description
Excel features and functions can be utilized effectively as a data analysis tool in Anti-Money Laundering (AML) , Combating Terrorist Financing (CFT) analysis and investigation
Pivot table is regarded by some AML/CFT experts as the most powerful feature of excel , this is because of its ability to summarize, filter and extract data sets from an array table of thousands of financial transactions , providing the analyst / investigator the necessary tool to establish evidence of illicit activities from customer bank account statements and other customer financial records even in very complex money laundering and terrorist financing activities
The course is a step by step practical demonstration of the application of Excel filters and Pivot tables in AML/CFT customer bank account statements analysis for Money Laundering(ML) and Terrorist Financing(TF) red flags . The course will also have excel exercises and practical case study exercises with video solutions
Who this course is for:
- AML/CFT Money Laundering Reporting Officers
- Law enforcement AML/CFT investigators and Analysts
- AML/CFT consultants
- AML/CFT enthusiast
Featured review
![Jon Lyles](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
Course content
Introduction1 lecture • 3min
- Introduction Application of Pivot Tables AML/CFT Investigation and AnalysisPreview03:24
Customer Bank Statement Analysis2 lectures • 4min
Money Laundering (ML) and Terrorism Financing (TF) Red Flags1 lecture • 5min
The Pivot Table1 lecture • 6min
Analyzing Customer Bank Account Statements Using the Pivot Table2 lectures • 30min
Using Pivot Charts in AML/CFT2 lectures • 16min
Introduction to Case Study Exercises1 lecture • 1min
Solution Videos Case Study Exercise #11 lecture • 10min
Instructor
- 4.4 Instructor Rating
- 726 Reviews
- 9,426 Students
- 4 Courses
Nasiru Musa has a BSc In Accounting from ABU Zaria (Nigeria) , MSc Information systems from the university of Liverpool and a Post graduate certificate in corruption studies from the Hong Kong University, he is also a certified anti money laundering specialist (CAMS) ,he has several years of experience in Auditing, Financial Investigation, Information systems and Law enforcement intelligence analysis.
He has worked for over 8 years in the Nigerian Financial Intelligence Unit , where he has lead several teams in cases bordering on Corruption, Human trafficking , illicit drug financial investigations , Money laundering and Terrorist financing. He is currently a trainer and a training administrator with the training academy of the prestigious economic and financial crimes commission (EFCC) in Nigeria.
He was also a certified fraud examiner (CFE), certified information systems auditor (CISA), and a certified information security manager (CISM) from 2008 to 2015
Feel free to contact him on LinkedIn for more information on any of his current or upcoming courses.