Excel Data Analytics in AML Financial Intelligence Analysis

Name: Excel Data Analytics in AML Financial Intelligence Analysis
Rating: 4.3 (2789 reviews)

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

Created byNasiru Musa

Last updated 10/2025

English

English [Auto],

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

Course content

9 sections • 26 lectures • 2h 30m total length

Introduction of the Course2:38
This video will introduce you to the course
Introduction to Excel Features and Functions for AML/CFT analysis2:06
This video lecture will introduce you to the essential basic excel features and functions in AML/CFT financial records analysis that will be covered in this course

Import Feature3:30
In this video demonstration you will learn how to:

1) How to use the IMPORT feature to import a sample financial record
(text file ) into Excel for AML/CFT financial records analysis
Protect Feature3:47
In this video demonstration you will learn how to:
1) Add a password to protect your worksheet
2) How to un-protect your worksheet
Sort Feature4:37
In this video demonstration you will learn how to apply the:

SORT feature
Custom SORT feature

in AML/CFT financial records analysis
Filter Feature12:01
In this video demonstration lecture you will learn how to apply the:

Date filter
Text Filter
Number Filter
and Multiple filter options

in AML/CFT financial records analysis
Pivot Table Feature14:22
In this video demonstration lecture you will learn how to create the pivot table , place values in it and perform some basic AML/CFT analysis of a financial record using the pivot table filters
Pivot Chart Feature14:42
In this video demonstration lecture you will learn how to apply the pivot chart to display your AML/CFT analysis results in various chart formats

Sum Function10:03
In this video demonstration you will learn how to apply the:

SUM function
SUMIF Function
SUMIFS Function
in AML/CFT financial records analysis
Subtotal Function3:52
In this video lecture you will learn how to apply the SUB-TOTAL function in calculating summaries of an extract financial record in AML/CFT financial records analysis
Count Function17:46
In this video demonstration you will learn how to apply the:

COUNT function
COUNTIF Function
COUNTIFS Function
in AML/CFT financial records analysis
Nth and Largest value Function6:32
In this video lecture you will learn how to apply the LARGE function to an extract of a financial record in AML/CFT financial records analysis
Vlookup Function9:58
In this video lecture you will learn how to apply the VLOOKUP function in looking up values in an extract of a financial record in AML/CFT financial records analysis

About Exercise #1: ML/TF Investigation of an International Crime Syndicate0:51
Exercise #1-1(Excerpts of statement of funds receipts by MR N)0:51
In this first part of the exercise you will use Excel Data Analytics to analyze the financial transaction statement of the subject of interest , to determine leads to the Investigation, the analysis will be centered on the funds received by the subject of interest.
Exercise #1-2 (Custom Declaration Analysis)0:35
In this part of the exercise , funds collected by the subject of interest is in cash , but intelligence reveals that he is a frequent traveler to different destinations , you have been provided with excerpts of custom declaration reports of the subject of interest you are required to use your excel analytical skills to analyze custom declaration reports to see if their is a connection between the funds collected by the subject of interest and his frequent travels

Index/Match Function 13:02
Index/Match Function 28:38
Learn to use the index/match function in Excel to perform precise data analytics for AML financial intelligence analysis. Apply lookup techniques to streamline matching and retrieval of critical transaction data.
Index/Match & IFERROR Functions3:17
Master index/match and iferror techniques in Excel to power AML financial intelligence analysis and enhance data analytics workflows.
Xlookup Function3:59
NetworkDays Function2:29

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.

Who this course is for:

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

Excel Data Analytics in AML Financial Intelligence Analysis

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 5min

Excel Features Essential in AML/CFT Analysis and Investigation6 lectures • 53min

Excel Functions Essential in AML/CFT Analysis and Investigation5 lectures • 48min

Course conclusion1 lecture • 1min

Practice case study exercises1 lecture • 1min

Hypothetical Case Study Exercise #1- ML/TF Investigation (Operational/Tactical)3 lectures • 2min

Solution Videos Case Study Exercise #12 lectures • 18min

Hypothetical Case Study Exercise #2- Strategic AML Descriptive Products1 lecture • 1min

2023: Additional functions that you will find useful.5 lectures • 21min

Requirements

Description

Who this course is for: