Excel Application Of Pivot Table In Amlcft Investigations

  1. Home
  2. Pivot-tables
  3. Excel Application Of Pivot Table In Amlcft Investigations

Tags: Pivot Tables

Quick start to Customer Bank Statement Analysis using Excel Pivot Tables

Last updated 2022-01-10 | 4.4

- 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

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

8 sections • 11 lectures

Introduction 1 lectures

Introduction Application of Pivot Tables AML/CFT Investigation and Analysis Preview 03:24

Customer Bank Statement Analysis 2 lectures

Customer Bank Statement Preview 02:48

Customer Bank Statement Methodology Preview 01:32

Money Laundering (ML) and Terrorism Financing (TF) Red Flags 1 lectures

Understanding ML and TF Red Flags in Customer Bank Statement Analysis Preview 04:33

The Pivot Table 1 lectures

Creating the Pivot Table Preview 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

Analyzing Customer Bank Account Statements Using the Pivot Table 2 lectures

Analysing the Inflow of funds Preview 19:50

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 Outflow of funds Preview 10:14

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

Using Pivot Charts in AML/CFT 2 lectures

Visualizing Your Results Using Pivot Charts Preview 14:42

About the Case study exercises that come with this course Preview 00:51

Introduction to Case Study Exercises 1 lectures

Requirements for the Exercise Preview 01:11

Solution Videos Case Study Exercise #1 1 lectures

Video Demo solution for exercise #1 Preview 09:45