Excel Pivot in AML/CFT Customer Bank Statement Analysis
4.4 (353 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,925 students enrolled

Excel Pivot in AML/CFT Customer Bank Statement Analysis

Quick start to Customer Bank Statement Analysis using Excel Pivot Tables
4.4 (353 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,925 students enrolled
Created by Nasiru Musa
Last updated 3/2020
English
Current price: $16.99 Original price: $24.99 Discount: 32% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 2 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Course content
Expand all 11 lectures 01:14:57
+ Customer Bank Statement Analysis
2 lectures 04:20
Customer Bank Statement
02:48
Customer Bank Statement Methodology
01:32
+ Money Laundering (ML) and Terrorism Financing (TF) Red Flags
1 lecture 04:33
Understanding ML and TF Red Flags in Customer Bank Statement Analysis
04:33
+ The Pivot Table
1 lecture 06:06

Practice exercise 1: Create Pivot table and add field values to the Pivot Table

Follow the instructions on the worksheet labelled "Instructions" to complete the exercise

Creating the Pivot Table
06:06
+ Analyzing Customer Bank Account Statements Using the Pivot Table
2 lectures 30:04

Practice exercise 2: Practice analyzing the inflow of funds from the statement of account

Follow the instructions on the instructions worksheet to complete the exercise

Analysing the Inflow of funds
19:50

Practice exercise 3: Practice analyzing the outflow of funds from the statement of account

Follow the instructions on the instructions worksheet to complete the exercise

Analysing the Outflow of funds
10:14
+ Solution Videos Case Study Exercise #1
1 lecture 09:45
Video Demo solution for exercise #1
09:45