Excel Data Analytics In Aml Financial Intelligence Analysis2

Mastering Excel Functions and Advanced Tools for AML/CFT Financial Intelligence Analysis

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:

Requirements

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

Description

"This course is a follow up to my best selling course on "Excel Data Analytics for AML/CFT Financial Intelligence Analysis"This course offers much more in leveraging Excel for AML/CFT (Anti-Money Laundering/Combating the Financing of Terrorism) analysis and investigation. Withe 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 analyst to go beyond just the basic excel features and functions of this powerful analysis tool.The primary goal of this course is to introduce more features and functions to update the skills of the analysts in Excel data analytics to meet up with current demands of the AML/CFT and financial intelligence analyst and investigator . 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 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. Additionally, the course covers a basic introduction to integration of AI-driven macros and VBA coding for automating repetitive tasks and enhancing analytical workflows.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Excel Function combinations essential for AML/CFT analysis

Lecture 2 IF() and IF(AND())

Lecture 3 IF(COUNTIF()

Lecture 4 IF(OR())

Lecture 5 Practice Exercise Lecture 3,4 and 5

Lecture 6 MATCH(), IF(ISNUMBER(MATCH()))

Lecture 7 Practice Exercise Lecture 7

Lecture 8 MAXIFS(), IF(MAXIFS())

Lecture 9 Practice Exercise 9

Lecture 10 XLOOKUP, (COUNTIF())

Lecture 11 Practice Exercise Lecture 11

Section 3: Introduction to Power Query, Power Pivot and Excel Data Models

Lecture 12 Introduction to Power Pivot

Lecture 13 Power Pivot Data Model 1

Lecture 14 Power Pivot Data Model 2

Lecture 15 Power Pivot Data Model 3

Lecture 16 Power Pivot Data Model 4- RELATED() Function

Lecture 17 Practice Exercise Power Pivot Lectures

Lecture 18 Introduction to Power Query

Lecture 19 Some Basic Transformations using Power Query

Lecture 20 Adding Tables to Existing Data Model

Lecture 21 Practice Exercise Power Query Lectures

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

Lecture 22 DATA ANALYSE in Excel

Lecture 23 Practice Exercise DATA ANALYSE

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