How to build a staff training matrix (with a free interactive builder)

A training matrix is a simple grid: people (or roles) down one side, required training across the top, and a status in every square. Done well, it answers the question every manager dreads in an audit - "show me that everyone is trained" - in seconds rather than an afternoon.

This guide walks through building one from scratch, the mistakes that make most matrices go stale, and how to keep it accurate without becoming a full-time spreadsheet keeper. Try the interactive builder further down the page as you read.

What a training matrix is for

A training matrix does three jobs:

1. Shows compliance at a glance. Who is in date, who is expiring and who is missing a required course.
2. Drives action. The gaps tell you what to book next, and for whom.
3. Provides evidence. When a client, insurer or regulator asks, you can show the record rather than describe it.

It is not the same as a skills matrix, which rates capability rather than completion. Many teams need both - see our guide to training matrix vs skills matrix.

Step 1: start with roles, not people

The most common mistake is listing every person and then deciding, one by one, what they need. Instead, define your roles first and attach required training to each role. A new starter then inherits the right courses the moment you assign their role.

For a small support team that might look like:

Step 2: decide what each status means

Agree four statuses and stick to them:

• In date - completed, with evidence, and not yet near expiry.
• Expiring - still valid but due within the next 60 days.
• Missing - required but never completed, or already expired.
• Not applicable - not required for this role.

Not applicable matters more than it looks. Without it, people get chased for courses they never needed and your compliance percentage is meaningless.

Step 3: record dates, not ticks

A tick tells you someone did something once. A completion date plus a refresher interval tells you when it runs out. Record both. Our statutory vs mandatory training guide includes a planner for typical UK refresher intervals.

Step 4: link the evidence

Every in-date square should point to a certificate, attendance record or course completion. If you cannot find the evidence, the square is not really green.

Step 5: review it on a rhythm

A matrix decays the moment someone joins, leaves or passes a course. Put a 15-minute review in the diary every month, and look at three things only: what is missing, what expires in the next 60 days and which course has the biggest gap.

Why spreadsheet matrices go stale

Spreadsheets are a fine place to start, but they fail in predictable ways:

• Nobody updates them when a course is completed elsewhere.
• Expiry needs someone to look. There is no reminder, so renewals slip.
• Evidence lives somewhere else, so the grid and the certificates drift apart.
• Versions multiply as managers save their own copies.

If any of those sound familiar, run the training records audit to find your biggest gap.

Keeping it up to date automatically

In Passport for Teams, the training matrix fills itself: required training is set per role, completed courses and verified certificates update the grid, expiry dates turn amber on their own and staff are reminded before anything lapses. Self-reported training only counts once a manager has verified it.

Try it

Use the builder below to sketch your own team. Tap any square to change its status, add your own people and courses and watch the compliance score and biggest gap update.