Name Screening Basics: Normalising Names, Exact Matches and Partial Hits
This lesson is part of the course
In this lesson
You clean customer names with UPPER, TRIM and SUBSTITUTE, test them for exact matches against a fictional watchlist, count partial key-term hits with SEARCH and ISNUMBER, and count the names an analyst must review.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Customer Risk Rating: Weighted Factors with XLOOKUP and SUMPRODUCT Locked
- Risk Tiers, Due-Diligence Levels & Periodic Review Dates Locked
- Large Cash Rule: Single-Transaction Flags and Daily Aggregation per Customer Locked
- Structuring: Deposits Just Below the Threshold in a Rolling 7-Day Window Locked
- Name Screening Basics: Normalising Names, Exact Matches and Partial Hits Locked
- Alert Disposition Metrics: False Positives, Escalations & Report Conversion Locked
- Rule Tuning: Alerts vs True Hits at Different Thresholds Locked
- Case Backlog: Ageing, SLA Breaches and Required Analysts Locked