Master AML/CFT Compliance: Excel & AI for Financial Intelligence
Focused View
1:19:56
1 - Introduction.mp4
03:27
2 - IF and IFAND.mp4
06:05
2 - Workbook-Lecture-3-4-and-5-IF-Function.xlsx
3 - IFCOUNTIF.mp4
06:46
4 - IFOR.mp4
05:11
4 - Workbook-Lecture-6-IF-and-OR-Functions.xlsx
5 - Practice Exercise Lecture 34 and 5.html
5 - Workbook-Lecture-3-4-and-5-IF-Function-for-Exercises.xlsx
6 - MATCH IFISNUMBERMATCH.mp4
06:59
7 - Practice Exercise Lecture 7.html
7 - Workbook-for-lecture-6-Isnumber-etc.xlsx
8 - MAXIFS IFMAXIFS.mp4
08:25
8 - Workbook-Lecture-7-MAXIFS.xlsx
9 - Practice Exercise 9.html
9 - Workbook-Lecture-7-MAXIFS.xlsx
10 - Workbook-Lecture-8-XLOOKUP-and-COUNTIF.xlsx
10 - XLOOKUP COUNTIF.mp4
08:25
11 - Practice Exercise Lecture 11.html
11 - Workbook-Lecture-8-XLOOKUP-and-COUNTIF.xlsx
12 - Introduction to Power Pivot.mp4
02:34
12 - Power-Pivot-Table-work-book-for-Students.xlsx
13 - Power Pivot Data Model 1.mp4
02:48
14 - Power Pivot Data Model 2.mp4
02:44
15 - Power Pivot Data Model 3.mp4
02:52
16 - Power Pivot Data Model 4 RELATED Function.mp4
04:50
17 - Power-Pivot-Table-work-book-for-exercises.xlsx
17 - Practice Exercise Power Pivot Lectures.html
18 - Introduction to Power Query.mp4
05:20
18 - Power-Query-Data-Folder1.zip
19 - Power-Query-Data-Folder2.zip
19 - Some Basic Transformations using Power Query.mp4
03:43
20 - Adding Tables to Existing Data Model.mp4
03:36
21 - Power-Query-Data-Folder1-Month-1.zip
21 - Power-Query-Data-Folder2-Month-2.zip
21 - Practice Exercise Power Query Lectures.html
22 - DATA ANALYSE in Excel.mp4
06:11
23 - Practice Exercise DATA ANALYSE.html
More details
Course Overview
Master advanced Excel functions, Power Tools, and AI-assisted analytics to detect financial crimes and ensure compliance. This professional training transforms you into an AML/CFT expert through hands-on financial intelligence techniques.
What You'll Learn
- Advanced Excel functions (IF, XLOOKUP, COUNTIF) for AML/CFT analysis
- Power Query and Power Pivot for financial data modeling
- AI-assisted analytics using Excel 365's Data Analyze feature
Who This Is For
- AML/CFT professionals and compliance officers
- Financial intelligence analysts
- Aspiring AML investigators
Key Benefits
- Automate suspicious activity detection with Excel macros/VBA
- Transform raw data into compliance-ready reports
- Master cutting-edge AI tools for financial crime analysis
Curriculum Highlights
- Essential Excel functions for AML/CFT
- Power Query & Pivot data modeling
- AI-powered financial analysis techniques
Focused display
Category
- language english
- Training sessions 16
- duration 1:19:56
- Release Date 2025/05/10
