Excel AML/CFT : Financial Intelligence & Compliance

سرفصل های دوره

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

1 - Introduction

1 - Introduction

2 - Excel Function combinations essential for AMLCFT analysis

2 - IF and IFAND

2 - Workbook-Lecture-3-4-and-5-IF-Function.xlsx

3 - IFCOUNTIF

4 - IFOR

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

7 - Practice Exercise Lecture 7.html

7 - Workbook-for-lecture-6-Isnumber-etc.xlsx

8 - MAXIFS IFMAXIFS

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

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

12 - Power-Pivot-Table-work-book-for-Students.xlsx

13 - Power Pivot Data Model 1

14 - Power Pivot Data Model 2

15 - Power Pivot Data Model 3

16 - Power Pivot Data Model 4 RELATED Function

17 - Power-Pivot-Table-work-book-for-exercises.xlsx

17 - Practice Exercise Power Pivot Lectures.html

18 - Introduction to Power Query

18 - Power-Query-Data-Folder1.zip

19 - Power-Query-Data-Folder2.zip

19 - Some Basic Transformations using Power Query

20 - Adding Tables to Existing Data Model

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

23 - Practice Exercise DATA ANALYSE.html

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy