All Articles
Guide 7 min read

Free Training Matrix Template (Excel) and How to Keep It Up to Date

A training matrix is a grid of people against required courses that shows who is trained, who is due and who has lapsed. Download a free Excel template with care and construction examples, and learn how to build one and keep it current.

A training matrix is a grid of your people against the training they must complete, showing when each person last completed each course and when it runs out. Green cells are in date, amber cells are due soon and red cells have lapsed, so you can see in seconds who needs a refresher. You can download a free Excel version below. Type in the dates and it colours itself.

This guide covers what a training matrix is for, what to put in it, how to build one in five steps, how it differs from a skills matrix, typical refresher intervals, and how to keep it up to date once the first version is done.

Key Takeaways

  • What is a training matrix and what is it for?
  • What should a training matrix include?
  • How do you create a training matrix?
  • Download the free training matrix template
01

What is a training matrix and what is it for?

A training matrix (also called a training needs matrix or staff training matrix) records which training each person must have and whether they have it. Most organisations use it for three things:

  • Proving compliance. When an inspector, auditor, client or insurer asks whether your staff are trained, the matrix is the answer.
  • Planning refreshers. Training that expires (first aid, fire safety, safeguarding) has to be booked before it lapses, not after.
  • Spotting gaps. New starters, people who changed role and anyone who missed a session show up as empty or red cells.
02

What should a training matrix include?

Keep it to the columns you will actually use:

ColumnWhat goes in it
NameOne row per person.
RoleWhat they do. Most training needs follow the role.
Team or siteSo you can filter and give each manager their own view.
Start dateNew starters usually have a deadline for their first training.
One column per courseThe date the person last completed it, or N/A if it does not apply to them.
Renewal intervalOne row above the courses: how many months each course lasts before it must be renewed. 0 means once only.

Store the completion date rather than the expiry date. The expiry can be worked out from the interval, and if the interval changes you only update it once.

03

How do you create a training matrix?

  • 1. List your roles. Group people by what they do: for example carer, senior carer, cook and manager.
  • 2. Decide what each role needs. For each role, list the required courses. Start with what the law, your regulator or your clients require, then add your own policies.
  • 3. Set a renewal interval for each course. In months, or "once" for something like an induction.
  • 4. Fill in the dates. Enter the date each person last completed each course, from certificates or training records. Mark courses that do not apply as N/A, so a blank cell always means "not done".
  • 5. Colour it and review it. Use conditional formatting so expired and due-soon cells stand out, and look at it on a fixed day every month.
04

Download the free training matrix template

The template follows the five steps above. It has four tabs:

  • How to use: short instructions.
  • Matrix: a blank matrix for up to 50 people and 12 courses. Course names go in row 5 and renewal intervals in row 6.
  • Example – care: a filled-in care home matrix.
  • Example – construction: a filled-in construction site matrix.

Each cell turns green when the training is in date, amber when it expires within the warning period (30 days by default, which you can change), red when it has expired, and pink when it has not been done. Two rows under the table show the percentage in date for each course and how many people are expired or due soon.

Download the template. The Excel file has a blank matrix for up to 50 people and 12 courses, plus filled-in care and construction examples. Type a completion date and the cell turns green, amber or red on its own. There are no macros.

05

What is the difference between a skills matrix and a training matrix?

Training matrixSkills matrix
Question it answersHas this person done the training they need, and is it still in date?How good is this person at each skill?
What goes in the cellsCompletion dates (and so expiry dates)A rating, such as 1 to 4 or novice to expert
Who uses itCompliance, HR, health and safety, qualityManagers planning work and development
How it changesGoes out of date on its own as training expiresChanges when someone is reassessed

If you are asked for evidence that staff are trained, you need the training matrix. If you are deciding who can cover a shift or who to develop next, you need the skills matrix.

06

How often should refresher training be done?

There is no single answer. A few intervals come from official guidance, and most come from your sector, your insurer or your own risk assessment. These are typical starting points, not legal requirements:

CourseTypical renewalNote
Emergency first aid at work / first aid at workEvery 3 yearsHSE guidance: certificates last three years, with an annual refresher recommended.
Asbestos awarenessCommonly every yearHSE expects refresher training as needed; many employers do it every year.
Fire safety awarenessEvery yearCommon practice; your fire risk assessment decides.
SafeguardingEvery 1 to 3 yearsDepends on the role and your sector’s guidance.
Manual handling / moving and handlingEvery 1 to 3 yearsCare settings often do it every year.
Data protection (UK GDPR)Every yearCommon practice for staff who handle personal data.
Food hygieneEvery 3 yearsCommon practice; check with your local authority.
InductionOnceDone when someone starts.

Check each interval against your own policy, your regulator and the course provider, and write the interval you settle on into the matrix, so the next person does not have to guess.

07

How do you keep a training matrix up to date?

  • Give it one owner. A matrix that everyone can edit is one nobody trusts.
  • Update it the same day. When someone completes training, enter the date straight away, while the certificate is in front of you.
  • Review it monthly. Book everyone in the amber cells before they turn red.
  • Keep the evidence. A date in a cell is only as good as the certificate or record behind it. File them where you can find them.
  • Add new starters on day one. Their empty cells are your induction plan.
  • Revisit the course list once a year. Roles and rules change. Remove training nobody needs and add what is missing.
08

When does a spreadsheet stop working?

A spreadsheet is fine for a small team. It starts to struggle when:

  • you have more people or sites than one person can keep track of;
  • renewals come round every few weeks rather than a few times a year;
  • people have to be chased, and the chasing is done by hand;
  • managers need to see their own team without seeing everyone else;
  • the dates have to be copied in from another system, such as an LMS.

At that point the matrix is better kept by the system where the training happens, so it updates itself.

09

How does Continuum Learn keep the matrix for you?

In Continuum Learn, a training requirement says "these learners must complete this course, and complete it again every so often". The details below come from our recurring training help guide; see also compliance training with a live training matrix.

  • It repeats on your schedule. Either a number of months from each person’s completion, or a fixed date every year (useful for membership years and annual deadlines).
  • It does the chasing. Learners are enrolled and emailed before and after the due date, at 08:00 in your time zone. If line managers are switched on, managers can be told when someone is overdue.
  • It reopens the course for renewal. Earlier progress is archived, not deleted, and the learner takes the course again, including any quiz or sign-off.
  • It issues a certificate each time. Each completed cycle gets its own numbered certificate with the expiry date on it.
  • It shows the matrix. Manage > Compliance shows tiles for compliant, due soon, overdue and expired, a table of learners with their dates, filters, and a CSV export.
  • It records training done elsewhere. An admin can record a completion with a date and a note, so outside courses still count.

Conclusion

A training matrix is simple: people down the side, courses across the top, and a date in every cell that matters. The hard part is keeping it current. Start with the template, give it one owner and review it every month. When the chasing takes longer than the training, see how Continuum Learn keeps the matrix up to date for you.

Frequently asked questions

What is a training matrix and what is its purpose?

A training matrix is a grid with people down one side and required training across the top. Each cell shows when that person last completed that training, so you can see at a glance who is trained, who is due for a refresher and who has lapsed. Its purpose is to prove that everyone has the training their role needs, and to spot gaps before an audit or an incident does.

How do I create a training matrix?

List the roles you have, decide which courses each role must complete and how often they must be renewed, then make a grid with people as rows and courses as columns. Fill in each person’s last completion date, mark courses that do not apply as N/A, and use colour to show what is in date, due soon and expired. Our free Excel template does the colouring for you.

What is the difference between a skills matrix and a training matrix?

A training matrix records whether someone has completed required training and whether it is still in date. A skills matrix rates how competent someone is at each skill. Many organisations keep both: the training matrix for compliance, the skills matrix for planning work and development.

How often should refresher training be done?

It depends on the course and your sector. Some intervals come from guidance, such as first aid certificates lasting three years. Others, such as fire safety, asbestos awareness or data protection every year, are common practice. Set an interval for each course in your matrix and check it against your own policy, your regulator and the course provider.

Can I keep a training matrix in Excel?

Yes. A spreadsheet works well for a small team with a handful of courses, as long as one person owns it and it is updated as soon as someone completes training. It gets harder once you have many people, several sites or frequent renewals, because nobody is reminded when training is due and the dates must be typed in by hand.

Found this useful? Share it with your network

LinkedIn

Ready to transform your training?

See how Continuum Learn helps organisations deliver impactful learning experiences at scale.

Book a Demo Explore Features