Advanced Excel for healthcare data
Format
Face to face or Virtual
Number of participants
Duration
Full day
Course overview
Transform raw data into actionable insights. Covers Pivot Tables, VLOOKUP/XLOOKUP, and dashboard creation specifically designed for NHS data sets and performance tracking.
Format
Full day, virtual or face-to-face.
Learning outcomes
- Construct Pivot Tables to summarize large NHS data sets instantly
- Use XLOOKUP and VLOOKUP to reconcile disparate patient or staff lists
- Build a dynamic performance dashboard with visual charts and ‘slicers’
- Utilise data validation and conditional formatting to ensure data integrity.
Who should attend
Performance managers, analysts, finance staff.
Cost per session
Pre-training requirement
Intermediate knowledge of Excel formulas.
