Excel Data Analytics In Aml Financial Intelligence Analysis

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
Apply Pivot Tables and Pivot Charts in AML/CFT Data Analysis
Requirements
Excel 2007 or higher installed on your computer
You dont need to have any prior knowledge of excel
Description
I created this course as a quick start in using Excel for AML/CFT analysis and investigation for those analysts or investigators that are looking for an alternative tool that is more affordable and has a much simpler learning curve than the conventional vendor specific analytical tools used in AML/CFT analysis and investigations. The course is also designed to accommodate anyone who is interested in having an insight into AML/CFT financial intelligence analysis using excel data analytics or anyone who wants to have a quick start in learning how to apply excel data analytics in AML/CFT financial intelligence analysis.

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

Lecture 8 Pivot Chart 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

Lecture 21 About Exercise #2: Strategic AML Descriptive Charts

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

without You and Your Support We Can’t Continue
Thanks for Buying Premium From My Links for Support
Click >>here & Visit My Blog Daily for More Udemy Tutorial. If You Need Update or Links Dead Don't Wait Just Pm Me or Leave Comment at This Post