Speaker: Evan Flores, Senior Revenue Cycle Quality & Performance Management Analyst, Northwell Health

Data is a vital source for identifying trends and gaining insight. However, inconsistent or 'dirty' data often hinders effective analysis. This webinar addresses this challenge by equipping you with powerful Excel formulas and methodologies to reduce manual work, clean your data, and accurately identify critical trends for comprehensive and reliable reporting.

What you will learn:

• XLOOKUP for Data Merging: Efficiently merge and retrieve specific data from various sources (e.g., demographics, insurance, referrals) for a holistic and accurate view.
• CONCAT for Data Standardization: Consolidate and standardize information, creating unique identifiers or uniform text for consistent analysis and reporting.
• AND/OR & IF for Complex Logic: Build sophisticated, multi-criteria conditions to segment patient populations, flag action items, or dynamically categorize data for targeted reporting.

This NAHAM webinar provides one (1) NAHAM-approved contact hour.