Excel Data Analytics In Aml Financial Intelligence Analysis2

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
Homepage