Spreadsheets for Health Records Data

Clean admission and discharge data, build summary tables, and calculate bed occupancy and average length of stay.

Beginner
About 10 hours of study
8 CEU hours
Certificate on completion

Taught by Ngozi Eze

No reviews yet. The stars shown in the catalogue are sample data until real reviews arrive.

What is inside

3 modules, 8 lessons, 2h 35m of material.

Module 1 Getting data in order 3 lessons · 55 min

Cleaning an export before you trust a single total.
- What a messy export looks like Preview Video 12 min
- Dates, blanks and duplicate patients Video 18 min
- Clean this admissions sheet Exercise 25 min
Module 2 Summarising 2 lessons · 35 min

Pivot tables, counts and rates.
- Pivot tables without fear Video 20 min
- Counts, rates and why the difference matters Video 15 min
Module 3 The indicators you report 3 lessons · 1h 5m

Bed occupancy, length of stay, turnover.
- Average length of stay, step by step Video 16 min
- Bed occupancy rate Video 14 min
- Build a monthly summary sheet Exercise 35 min

The lesson times add up to 2h 35m of material, while the course is listed as about 10 hours. The larger figure includes the exercises, reading and practice you do yourself, which is where most of the learning happens.

Learner reviews

No reviews yet.

Reviews here are written by people enrolled in this course. None are supplied as sample content.