Excel Application of Pivot Table in AMLCFT Investigations

[mitsumi]

Excel: Application of Pivot Table in AML/CFT Investigations
.MP4 | Video: 1280x720, 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 link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction