The spreadsheet with the red cells
Somewhere on the shared drive there is a training matrix. Rows of staff, columns of courses: moving and handling, fire safety, safeguarding, infection control, food hygiene, medication, first aid, and the rest. Cells are green, amber or red. The colours were right on the day someone last updated it.
Since then, three people have completed e-learning, a moving and handling trainer has been in, and two new starters have joined. The certificates are in someone's inbox. The matrix still shows red for people who are now in date, and green for one person whose certificate expired last week.
When an inspection is announced, the matrix is the first document anyone asks for, and the evening before is spent fixing it.
Why the matrix never stays current
Training comes from too many places. E-learning platforms, face-to-face trainers, in-house sessions led by the nurse, and courses staff did at a previous employer. Each produces its evidence differently: a report, a certificate, a signed register.
The matrix is a copy of all of that, maintained by hand. Copies drift. The person maintaining it is doing it on top of their real job, and the matrix does not complain when it is wrong.
Renewal periods add to it. Different courses renew on different cycles, and different roles need different courses, according to your own training policy. Working out who is due what next month is a small puzzle every month.
What an out-of-date matrix costs
| Symptom | Result |
|---|---|
| Expired training unnoticed | Staff rostered for tasks their training no longer covers |
| Completions not recorded | People booked on courses they already did |
| Evidence scattered | Hours finding certificates before an inspection |
| Bookings made late | Trainers unavailable when you finally need them |
| No forward view | No budget or plan for next quarter's renewals |
Booking a trainer takes notice. Without a view of what expires in the next two or three months, bookings are made in a hurry at a worse time.
How we keep the record live
- One training record per staff member, with each course, completion date, expiry date and the evidence attached.
- Required courses and renewal periods set per role from your training policy, so the system knows what each person should hold.
- Imports from your e-learning platform, using its API or scheduled report export, so completions appear without retyping.
- An upload route for certificates from external trainers and previous employers, with the dates read from the certificate and confirmed by a person.
- Reminders to staff and their line manager before a course lapses, at intervals you choose, and a weekly summary to the manager of what is due soon.
- A matrix view that is generated, not maintained, filterable by unit or role, and exportable to show an inspector.
Where rota data is available, we can also flag when someone is rostered to a task that needs training their record shows as expired, so the senior on shift can decide what to do.
What the manager sees now
The matrix is accurate when you open it, because it is built from the records. Staff get reminders before they lapse, and completions from e-learning appear on their own. The weekly summary shows what is due next, so training is booked with some notice.
Before an inspection, you export the matrix and the evidence is already attached to each line.
Could this be your matrix?
- The training matrix is a spreadsheet someone updates by hand
- Certificates sit in email inboxes
- You fix the matrix the night before an inspection
- People are booked on training they have already done
- You cannot easily see what expires next quarter