Excel: Application of Pivot Table in AML/CFT Investigations
4.5 (31 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,220 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel: Application of Pivot Table in AML/CFT Investigations to your Wishlist.

Add to Wishlist

Excel: Application of Pivot Table in AML/CFT Investigations

Analysing Bank Account Statements
4.5 (31 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,220 students enrolled
Created by Nasiru Musa
Last updated 6/2017
English
Price: Free
Includes:
  • 1 hour on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Apply Pivot table filter options in AML/CFT bank statement analysis
View Curriculum
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 is the target audience?
  • AML/CFT Financial Institution complaince Officers/Managers and Auditors
  • Law enforcement AML/CFT investigators and Analysts
  • AML/CFT consultants
  • Chartered Accountants (External Auditors)
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Application of Pivot Tables AML/CFT Investigation and Analysis
5 Lectures 54:52
Introduction Application of Pivot Tables AML/CFT Investigation and Analysis
03:24

Lecture 1: Quiz 1
5 questions

Practice exercise 1: Create Pivot table and add field values to the Pivot Table

Follow the instructions on the worksheet labelled "Instructions" to complete the exercise

Creating the Pivot Table for Bank Account Statement Analysis
06:06

Practice exercise 2: Practice analyzing the inflow of funds from the statement of account

Follow the instructions on the instructions worksheet to complete the exercise

Analysing the Inflow of funds
19:50

Practice exercise 3: Practice analyzing the outflow of funds from the statement of account

Follow the instructions on the instructions worksheet to complete the exercise

Analysing the Outflow of funds
10:14

Lecture 5: Bonus Lecture (No Audio)- Introduction to Pivot Charts
15:18
About the Instructor
Nasiru Musa
4.5 Average rating
30 Reviews
1,220 Students
1 Course
Financial Intelligence Analyst

Nasiru Musa has a BSc In Accounting from ABU Zaria (Nigeria) , MSc Information systems from the university of Liverpool and a Post graduate certificate in corruption studies from the Hong Kong University, he is also a certified anti money laundering specialist (CAMS) ,he has several years of experience in Auditing, Financial Investigation, Information systems and Law enforcement intelligence analysis. 

He has worked for over 8 years in the Nigerian Financial Intelligence Unit , where he has lead several teams in cases bordering on Corruption, Human trafficking , illicit drug financial investigations , Money laundering and Terrorist financing. He is currently a trainer with the training academy of the prestigious economic and financial crimes commission (EFCC) in Nigeria. Feel free to contact him on LinkedIn for more information on any of his current or upcoming courses.