(https://i106.fastpic.ru/big/2019/0907/3e/d59c10f2fe9c75376ffa843c9778313e.jpg)
Excel: Application of Pivot Table in AML/CFT Investigations
.MP4 | Video: 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | 296 MB
Duration: 1 hours | Genre: eLearning | Language: English
Analysing Bank Account Statements
What you'll learn
Apply Pivot table filter options in AML/CFT bank statement analysis
Requirements
Basic Excel features
Description
Excel features and functions can be utilized effectively as a data analysis tool in Anti-Money Laundering (AML) , Combating Terrorist Financing (CFT) analysis and investigation
Pivot 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 bank account statements even in very complex money laundering and terrorist financing cases
The course is a step by step practical demonstration of the application of Pivot tables in analyzing bank account statements in AML/CFT investigation. The course will also have excel exercises and a practical case study exercise with both video and excel spread sheet solutions
The course is the first in a series of courses that i will be publishing on AML/CFT analysis and investigation
Who this course is for:
AML/CFT Financial Institution complaince Officers/Managers and Auditors
Law enforcement AML/CFT investigators and Analysts
AML/CFT consultants
Chartered Accountants (External Auditors)
(https://i106.fastpic.ru/big/2019/0907/d0/7832100e964c34c47806b9b3317242d0.jpg)
Download link:
Só visivel para registados e com resposta ao tópico.Only visible to registered and with a reply to the topic.Links are Interchangeable - No Password - Single Extraction