Excel Pivot in AML/CFT Customer Bank Statement Analysis (Udemy.com)

Quick start to Customer Bank Statement Analysis using Excel Pivot Tables

( 87 Reviews )

Created by: Nasiru Musa

Produced in 2021

What you will 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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 88 / 100

Course 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 investigationPivot 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 activitiesThe 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 OfficersLaw enforcement AML/CFT investigators and AnalystsAML/CFT consultantsAML/CFT enthusiast

Time: 1 hour on-demand videoh

Instructor Details

Nasiru Musa

4.4 Rating
87 Reviews

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.

Excel Skills for Business: Essentials (2017)
5.0 (432 Reviews)

- Provider: Coursera
- Time: 4h

Free

Excel Skills for Business: Intermediate I
4.9 (463 Reviews)

- Provider: Coursera
- Time: 22h

Free

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365)

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

Visually Stunning Microsoft Excel Dynamic Dashboard Course

Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

Excel with Top Microsoft Excel Hacks (2016)
4.9 (95 Reviews)

- Provider: Udemy
- Time: 2h

$11.99

Microsoft Excel Complete Excel Guide (Excel 2007 2021)

Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)

- Provider: Udemy
- Time: 21h

$11.99

All excel courses

Reviews

4.4

87 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Imran Ladhani on 9/11/2020

Excellent coach.. great exercise activity. very clear delivery.

By Swarnalakshmi R on 6/6/2020

Learnt the basic stuff .Good.

By Peter Malliaras on 5/3/2020

Very clear and concise.

By Mohammad Mubarah on 2/27/2020

Simply this course is not to improve your analysis skills to analyze (AML) but it is for learning you how to use pivot tables, Big Upset and time waste.

By Wajahat Ullah Qureshi on 2/18/2020

A very interesting and useful course.

By Kalpesh Chauhan on 10/1/2019

learning on the detail Filter as per Date, text and more Grouping manner. Very useful for Analysis and come out for the Judgement or decision Making

By Nadia Delgado on 8/17/2019

Could of showed alittle more explains

By Rachel Rogers on 7/5/2019

Yes, it's perfect. The teacher is wonderful, explains the topic in a way that is concise and clear to understand. I already feel more comfortable about this topic. He's a great teacher!

By Shomail Rashad on 6/24/2019

TOO FAST, ANNOYING, CLUTTER, AND NOTHING INTERESTED

By Aderoju Adekoya on 6/1/2019

Very easy to understand.

By Mukaya TSHITAMBA on 5/23/2019

I learned excel year ago but I never think that it can be applied in AML...a good section...thx
January 17th, 2019
hi, Mr Nasiru;
I like the course and would ask you to see if you can recommend some books.
yours Sincerely,
Tshitamb

By Anant Saxena on 5/17/2019