← All news

What Is a Training Matrix? A Practical Guide, With a Free Template

17 August 2026 · Train Aid Solutions

What Is a Training Matrix?

A training matrix is a grid. People down the side, courses across the top, and in each cell the date that person completed that course. Add the refresher interval and you can see, at a glance, who is current, who is about to lapse and who should not be doing the job at all.

That is the whole idea. The difficulty is never building one. It is keeping it true.

Download the free Excel template – 30 staff, 8 courses, automatic expiry dates and a summary dashboard. No email address required.

What goes in it

A matrix that actually gets used has five things:

Names down the left. Everyone whose training you are responsible for. Include agency and contract staff if they need training to do the work, because an auditor will not accept "they are not on our payroll" as a reason the record is missing.

Courses across the top. Only the ones you genuinely track. A matrix with forty columns, thirty of which are blank, gets abandoned within a quarter.

A completion date in each cell. The date, not a tick. A tick tells you nothing about whether it is still valid, and a matrix full of ticks is the commonest reason these things quietly stop being useful.

A refresher interval per course. Held once, in one place, so changing it updates every row at once.

A status that calculates itself. Current, due soon, overdue, not trained. If someone has to work out the status by reading two dates and doing mental arithmetic, they will stop doing it.

The distinction most matrices get wrong

Most UK training certificates do not legally expire.

First Aid at Work is valid for three years because the awarding organisation says so, not because a regulation does. Manual handling has no interval in the Manual Handling Operations Regulations 1992 at all; the three-year convention comes from insurers and auditors. Food safety Level 2 has no legal expiry, only Food Standards Agency guidance and environmental health expectation. IOSH Managing Safely does not expire, though IOSH recommends refreshing every three years.

A handful genuinely do expire: CITB SSSTS and SMSTS at five years, IPAF and PASMA cards at five, SIA licences at three. These behave like MOTs. Everything else behaves like a convention that everyone treats as a rule.

Why this matters for your matrix: if you record everything as a hard expiry, you will either panic about lapses that are not lapses, or lose credibility with staff who know the rule does not exist. The template has a "statutory expiry?" column for exactly this reason. Track the refresher interval, and be honest about what kind of deadline it is.

For a full breakdown by course, see our table of UK training certificate validity periods.

Building one, step by step

1. List the roles, not the people. Start with what each role requires. A site supervisor needs SSSTS, asbestos awareness, manual handling and first aid. A kitchen porter needs food safety and allergen awareness. Getting the role requirements right first means new starters inherit a correct row automatically.

2. Set the intervals in one place. One tab, one row per course, one interval. Never hardcode a date arithmetic into individual cells, because the day an awarding organisation changes a specification you will be editing three hundred cells instead of one.

3. Enter completion dates, not ticks. If you only have "trained, at some point", record your best evidence and flag it as unverified. An honest gap is more useful than a false green.

4. Let the status calculate. Completion date plus interval gives expiry. Expiry minus today gives days remaining. Days remaining gives status. Do not type statuses by hand.

5. Decide your warning window and stick to it. Ninety days is a good default. It is long enough to book a course that runs monthly, and short enough that people take it seriously.

6. Give it an owner and a review date. This is the step that determines whether the matrix survives. A matrix nobody owns is a matrix nobody updates, and a matrix nobody updates is worse than none because it looks like evidence while being wrong.

What the free template does

The download includes:

Courses tab with seventeen common UK courses pre-loaded, each with a refresher interval and a note on whether the expiry is statutory or conventional
Staff tab for up to thirty people
Training Matrix tab where you enter completion dates and expiry, days remaining and status calculate themselves
Dashboard tab summarising current, due soon, overdue and not trained per course
Colour coding so overdue is red, due soon is amber and current is green

Editable cells are yellow. Everything else is a formula. One example row shows the expected format.

Change the intervals to match your own requirements before you rely on it. The pre-loaded values are common industry expectations, not legal advice, and specifications change.

The maintenance problem

Here is the honest limitation, and it applies to every training matrix template on the internet including this one.

A spreadsheet is a snapshot. It tells the truth on the day someone updates it and drifts from that day onward. The maintenance is not the typing; it is that a human has to open the file, read it, notice what is going amber, and then actually do something. Every week. Forever.

That works up to roughly thirty people and ten courses. Past that, three failures show up predictably:

Nobody opens it. It is accurate in March and fiction by September. The gap is invisible until an audit or an incident.

The owner leaves. The person who maintained it takes the context with them, and their replacement finds a file they do not trust and starts again.

It has no way to act. The matrix knows Dave's asbestos awareness lapses in three weeks. It cannot tell Dave. Someone has to notice, then email him, then book it, then update the cell.

That last one is the real problem. The matrix is a record, not a mechanism.

Where the data should come from

Worth naming something that gets missed: the training provider who ran the course has better data than you do.

They hold the exact completion date, the assessment outcome, the certificate number and the expiry. You hold whatever got typed into a spreadsheet from a certificate someone emailed over. Yours is a copy, and copies drift.

If you are an employer, ask your provider whether they can send renewal reminders directly. Many can, and it moves the reminding from your to-do list to their system.

If you are a training provider reading this, that is the opportunity. Your clients are maintaining spreadsheets like this one from certificates you issued. Being the provider who tells them what is expiring, before they have to ask, is worth more than any discount, and it turns your renewal book from something you hope comes back into something that rebooks itself.

That is what Train Aid Solutions does: certificates that carry their own expiry, reminders that send themselves, and verification a client can check without ringing you. From £40 per month.

Download the training matrix template – free, no sign-up. Use it, edit it, share it.