Excel Application of Pivot Table in AMLCFT Investigations

Excel: Application of Pivot Table in AML/CFT Investigations
.MP4 | Video: 1280×720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | 296 MB
Duration: 1 hours | Genre: eLearning | Language: English

Analysing Bank Account Statements

What you’ll learn

Apply Pivot table filter options in AML/CFT bank 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 bank account statements even in very complex money laundering and terrorist financing cases

The course is a step by step practical demonstration of the application of Pivot tables in analyzing bank account statements in AML/CFT investigation. The course will also have excel exercises and a practical case study exercise with both video and excel spread sheet solutions

The course is the first in a series of courses that i will be publishing on AML/CFT analysis and investigation

Who this course is for:

AML/CFT Financial Institution complaince Officers/Managers and Auditors
Law enforcement AML/CFT investigators and Analysts
AML/CFT consultants
Chartered Accountants (External Auditors)

DOWNLOAD
(Buy premium account for maximum speed and resuming ability)