Excel AML/CFT : Financial Intelligence & Compliance

Focused View

Nasiru Musa

1:19:56

0 View

1 - Introduction

1 - Introduction.mp4

03:27

2 - Excel Function combinations essential for AMLCFT analysis

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

3 - Introduction to Power Query Power Pivot and Excel Data Models

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

4 - AI assisted analysis using the data Analyse Feature in Excel 365

22 - DATA ANALYSE in Excel.mp4

06:11

23 - Practice Exercise DATA ANALYSE.html

Description

Harness Excel Functions,Power Tools, Data Models and AI assisted Data analytics for AML/CFT Analysis & Compliance

What You'll Learn?

Applying the IF Function alongside essential functions effective for AML/CFT Analysis
Utilizing Power Query for Table Combination and Transformation in AML/CFT Analysis
Managing Data Models with Power Pivot
Automating Tasks with AI: Creating Macros and VBA Codes:

Who is this for?

AML/CFT professionals

Financial Intelligence Analysts

Compliance officers of financial and other financial institutions

Analysts curious about using excel data analytics in financial intelligence analysis

Persons interested in exploring a career as an AML/CFT analyst or investigator

What You Need to Know?

Having some prior knowledge of Excel will make the content easier to understand.

More details

Description
I designed this course to offer AML compliance professionals, analysts, and investigators an easier, more practical way to learn Excel skills tailored to their everyday tasks. With exercises specifically aligned to AML compliance, analysis, and investigation, this course ensures that the skills you acquire can be immediately and easily applied to your job.
Rather than navigating a comprehensive Excel course that might lack relevance to your professional activities, this course focuses on practical learning. It enhances your day-to-day tasks with tools and techniques that directly address your needs, providing quick, actionable insights that make a real difference in your work.
With Excel standing out as a cost-effective and accessible alternative to specialized vendor tools traditionally used in this domain Excel is being used for more complex data analysis in this domain , as such the need for the AML analyst and investigator to go beyond just the basic excel features and functions of this powerful analysis tool.
The primary goal of this course is to introduce in detail essential Excel features and functions to update your skills to meetÂ with the day to day demands of AML compliance and investigation . It is designed for individuals seeking a rapid yet thorough understanding of applying Excel's powerful capabilities in this specialized field. Whether you are new to AML/CFT analysis or aiming to enhance your proficiency in financial intelligence through practical Excel applications, this course equips you with the much needed essential skills.
Participants will learn to effectively utilize Excel functions such as IF, COUNTIF, MATCH and much more , alongside advanced tools like Power Query and Power Pivot in real world AML/CFT applications . Additionally, the course covers a basic introduction to integration of AI-driven Excel data analysis and AI driven macros and VBAÂ for automating repetitive tasks and enhancing analytical workflows which will be particularly useful in data cleaning, transaction monitoring and AML risk assessments and Audits
Who this course is for:
AML/CFT professionals
Financial Intelligence Analysts
Compliance officers of financial and other financial institutions
Analysts curious about using excel data analytics in financial intelligence analysis
Persons interested in exploring a career as an AML/CFT analyst or investigator

User Reviews

Rating

average 0

Total votes0

Focused display

Financial Modeling

Nasiru Musa

Instructor's Courses

Nasiru Musa has a BSc In Accounting from ABU Zaria (Nigeria) , MSc Information systems from the university of Liverpool and a Post graduate certificate in corruption studies from the Hong Kong University, he is also a certified anti money laundering specialist (CAMS), he has several years of experience in Auditing, Financial Investigation, Information systems and Law enforcement intelligence analysis. He has worked for over 8 years in the Nigerian Financial Intelligence Unit, where he has led several teams in cases bordering on Corruption, Human trafficking, illicit drug financial investigations, Money laundering and Terrorist financing. He was also a trainer and a training administrator with the training academy of the prestigious economic and financial crimes commission (EFCC) in Nigeria. He is an Excel and Power tools specialist who has built and educated numerous financial analysts, law enforcement officials, and analysts in the use of analytical tools and techniques in money laundering, terrorist financing and financial crime investigations and intelligence analysis.He was also a certified fraud examiner (CFE), certified information systems auditor (CISA), and a certified information security manager (CISM) from 2008 to 2015Feel free to contact him on LinkedIn for more information on any of his current or upcoming courses.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.