
Combine if function with Countif in Excel to flag customers with more than five transactions as high risk, apply conditional formatting, and summarize results with a pivot table for AML/CFT.
Create a PowerPivot data model by linking the transaction table to the customer and country risk tables using customer ID and country, establishing relationships and a pivot table for analysis.
Data drives decisions in today’s financial, risk, and intelligence sectors—but raw data is only as powerful as your ability to analyze and apply it. Applied Excel for AML & Financial Intelligence is a hands-on course designed for professionals across finance, risk management, compliance, and intelligence who want to turn data into actionable insights.
In this course, you will learn how to clean, transform, and analyze complex datasets using Excel’s most powerful tools, including Power Query, PivotTables, advanced formulas, and AI-assisted features. You will apply these tools to a variety of real-world scenarios—from AML monitoring and risk assessment to financial intelligence analysis and operational decision-making—so that the skills you gain can be applied across multiple industries.
Through practical exercises and step-by-step examples, you’ll gain confidence in uncovering patterns, identifying trends, and producing insightful reports that support strategic decisions. You’ll also explore how AI features in Excel can automate repetitive tasks, highlight anomalies, and accelerate your workflow, giving you a competitive edge in data-driven roles.
By the end of this course, you’ll be able to turn raw data into intelligence, support risk and compliance initiatives, and make informed decisions with confidence. Whether you work in financial intelligence analysis, compliance, risk, intelligence, or any similar data-driven role, this course equips you with practical Excel skills that can be applied immediately to solve real-world problems.