|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-application-of-pivot-table-in-amlcft-investigations/
课程评论：没有评论
课程名称：Excel在反洗钱/打击恐怖融资客户银行对账单分析中的应用 课程概述： 本课程旨在教授学员如何有效利用Excel的功能作为反洗钱（AML）和打击恐怖融资（CFT）分析及调查的数据分析工具。Excel的透视表被一些AML/CFT专家视为最强大的功能之一，因其能够从数千个金融交易的数据集中总结、筛选和提取数据。这使得分析师和调查人员能够从客户银行对账单及其他客户财务记录中，建立证据以识别可疑的洗钱和恐怖融资活动，即使在极为复杂的情况下也能有效运用。 本课程将通过逐步的实践演示，展示如何将Excel过滤器和透视表应用于洗钱（ML）和恐怖融资（TF）红旗的客户银行对账单分析。课程中将包括Excel练习和实际案例研究的练习，配有视频解答，确保学员能深入理解和掌握相关技能。
Excel features and functions can be utilized effectively as a data analysis tool in Anti-Money Laundering (AML) , Combating Terrorist Financing (CFT) analysis and investigationPivot table is regarded by some AML/CFT experts as the most powerful feature of excel , this is because of its ability to summarize, filter and extract data sets from an array table of thousands of financial transactions , providing the analyst / investigator the necessary tool to establish evidence of illicit activities from customer bank account statements and other customer financial records even in very complex money laundering and terrorist financing activitiesThe course is a step by step practical demonstration of the application of Excel filters and Pivot tables in AML/CFT customer bank account statements analysis for Money Laundering(ML) and Terrorist Financing(TF) red flags. The course will also have excel exercises and practical case study exercises with video solutions
