Course curriculum

  • 1

    Introduction

    • Introduction to the course

    • Introduction to Excel Features and Functions in AML/CFT

  • 2

    Excel Features Essential in AML/CFT Analysis & Investigation

    • Import Feature Video Demonstration Lecture

    • Practice Exercise- The Import Feature Exercise

    • Protect Worksheet Feature Video Demonstration Lecture

    • Practice Exercise- The Protect Worksheet Feature Exercise

    • Sort Feature Video Demonstration Lecture

    • Practice Exercise- The Sort Feature Exercise

    • Filter Feature Video Demonstration Lecture

      FREE PREVIEW

    • Practice Exercise- The Filter Feature Exercise

    • Pivot table Feature Video Demonstration Lecture

    • Practice Exercise- The Pivot Table Feature Exercise

    • Pivot Chart Feature Video Demonstration Lecture

      FREE PREVIEW

    • Practice Exercise- The Pivot Chart Feature Exercise
  • 3

    Excel Functions Essential to in AML/CFT Analysis & Investigation

    • The Count Function

    • Practice Exercise- The Count Function Exercise

    • The Subtotal Function

    • Practice Exercise- The Sub-Total Function Exercise

    • The Sum Function

    • Practice Exercise- The Sum Function Exercise

    • The Nth and Largest Value Function

    • Practice Exercise- The Large Function Exercise

    • The Vlookup Function

    • Practice Exercise- The Vlookup Function Exercise
  • 4

    Conclusion

    • What did you learn?
  • 5

    Hypothetical Case Study Exercise #1- ML/TF Investigation (Operational/Tactical)

    • About Exercise #1: ML/TF Investigation of an International Crime Syndicate

    • Exercise #1-1(Excerpts of statement of funds receipts by MR N)

    • Exercise #1-1(Excerpts of statement of funds receipts by MR N)

    • Exercise #1-2 (Custom Declaration Analysis)

    • Exercise #1-2 Excel worksheet(Custom Declaration Analysis)
  • 6

    Solution Videos Case Study Exercise #1

    • Solution to Exercise #1-1

    • Solution to Exercise #1-2
  • 7

    Hypothetical Case Study Exercise #2- Strategic AML Descriptive Products

    • About Exercise #2: Strategic AML Descriptive Charts
  • 8

    Course Update 2023 (Index/Match, Networkdays and Xlookup Functions)

    • Index/Match

    • Index/Match (Different worksheets)

    • Index/Match (Lookup Table)

    • NetworkDays

    • Xlookup

Instructor Bio

Lead Instructor

Nasiru Musa CAMS

Meet Nasiru Musa, an accomplished professional with a diverse background in the fields of Accounting, Information Systems, and Law Enforcement Intelligence Analysis. Nasiru holds a BSc in Accounting from ABU Zaria (Nigeria), an MSc in Information Systems from the esteemed University of Liverpool, and a Postgraduate Certificate in Corruption Studies from Hong Kong University. With extensive experience spanning over 8 years at the Nigerian Financial Intelligence Unit, Nasiru has honed his expertise in Auditing, Financial Investigation, and Information Systems. Throughout his career, he has successfully led teams in high-profile cases involving Corruption, Human Trafficking, Illicit Drug Financial Investigations, Money Laundering, and Terrorist Financing. Nasiru Musa's commitment to excellence is further demonstrated by his impressive list of certifications, including the prestigious Certified Anti-Money Laundering Specialist (CAMS). From 2008 to 2015, he also held esteemed designations as a Certified Fraud Examiner (CFE), Certified Information Systems Auditor (CISA), and Certified Information Security Manager (CISM). Nasiru is passionate about sharing his wealth of knowledge and practical experience with others. As an instructor, he aims to empower students with valuable insights and skills in the realms of Financial Intelligence, Anti-Money Laundering, Fraud Examination, and Information Security. Join his courses to learn from a seasoned professional who has made a significant impact in the fields of financial investigation, and intelligence analysis.