Excel Data Analytics In Aml Financial Intelligence Analysis

Excel Data Analytics In Aml Financial Intelligence Analysis
Last updated 5/2019
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz

Applying Excel Data Analytics in Anti-Money Laundering/Combating Financing of Terrorism Analysis & Investigations

What you’ll learn
Apply essential Excel features and functions in your data analysis
Requirements
Excel 2007 or higher installed on your computer
You dont need to have any prior knowledge of excel
Description
Overview

Section 1: Introduction

Lecture 1 Introduction of the Course

Lecture 2 Introduction to Excel Features and Functions for AML/CFT analysis

Section 2: Excel Features Essential in AML/CFT Analysis and Investigation

Lecture 3 Import Feature

Lecture 4 Protect Feature

Lecture 5 Sort Feature

Lecture 6 Filter Feature

Lecture 7 Pivot Table Feature

Section 3: Excel Functions Essential in AML/CFT Analysis and Investigation

Lecture 9 Sum Function

Lecture 10 Subtotal Function

Lecture 11 Count Function

Lecture 12 Nth and Largest value Function

Lecture 13 Vlookup Function

Section 4: Course conclusion

Lecture 14 What did you learn ?

Section 5: Practice case study exercises

Lecture 15 About the Case Study Exercises

Section 6: Hypothetical Case Study Exercise #1- ML/TF Investigation (Operational/Tactical)

Lecture 16 About Exercise #1: ML/TF Investigation of an International Crime Syndicate

Lecture 17 Exercise #1-1(Excerpts of statement of funds receipts by MR N)

Lecture 18 Exercise #1-2 (Custom Declaration Analysis)

Section 7: Solution Videos Case Study Exercise #1

Lecture 19 Exercise #1-1

Lecture 20 Exercise #1-2

Section 8: Hypothetical Case Study Exercise #2- Strategic AML Descriptive Products

AML/CFT professionals,Analysts curious about using excel data analytics in financial intelligence analysis,Persons interested in exploring a career as an AML/CFT analyst or investigator,Persons who are interested in exploring new applications of excel data analytics