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
- Basic Excel features
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
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 led several teams in cases bordering on Corruption, Human trafficking, illicit drug financial investigations, Money laundering and Terrorist financing. He was also a trainer and a training administrator with the training academy of the prestigious economic and financial crimes commission (EFCC) in Nigeria. He is an Excel and Power tools specialist who has built and educated numerous financial analysts, law enforcement officials, and analysts in the use of analytical tools and techniques in money laundering, terrorist financing and financial crime investigations and intelligence analysis.
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.