Training Matrix: How to Build One, With a Free Template and Example
What a training matrix is, what goes in it and how to build one in six steps, with a worked example, HSE and OSHA refresher intervals and a free template.
On this page
- Key takeaways
- 1What a training matrix is
- 2Training matrix vs skills matrix
- 3What to put in a training matrix
- 4Which training the law requires, and how often
- 5How to build a training matrix in six steps
- 6Training matrix example
- 7Training matrix template
- 8Keeping it current
- 9Building a training matrix for a client
- 10Frequently asked questions
A training matrix is a grid of people against the training their roles require, showing for each person and course whether the training is done, when it runs out and what is due next. It shows who is trained to do what, who is about to fall out of date, and who has not been trained at all. Most are kept in a spreadsheet. The work is in deciding what each role needs and how often, and in keeping the dates current. A free template with the formulas filled in is further down.
Key takeaways
- A training matrix has two parts: what each role requires, with how often it must be refreshed, and what each person has done, with the dates. Keep them as two tables and the matrix stays easy to update.
- The law sets triggers more often than intervals. UK health and safety law requires training on recruitment and when risks change, “repeated periodically where appropriate”, which leaves the interval to the employer. Some rules are specific: UK first aid certificates last three years, and OSHA requires bloodborne pathogens training at least annually.
- Record where each requirement comes from, whether a law, a regulator, a client contract or your own policy. It tells you what you can change and what you cannot.
- Status needs four values: valid, due soon, expired and missing. “Missing” catches the new starter who never did the course, which a list of expiry dates hides.
- A matrix is only useful when it drives bookings. Look 60 to 90 days ahead, group people due for the same course, and book them together.
What a training matrix is
A training matrix lists people, or roles, down one side and training across the top. Each cell shows that person’s status for that course: a date, a status, or a dash where the course is not required for the role.
It usually holds two kinds of information, and keeping them apart makes it easier to maintain:
- The requirements. For each role, the training it needs, where the requirement comes from and how often it must be repeated. A forklift operator needs forklift training; an office worker does not.
- The records. For each person, the date they completed each course, who delivered it, the certificate reference and the date it runs out.
The grid is what you get when you put the two together. Most matrices are built in a spreadsheet, and many organizations move to training records software once the number of people or sites makes the spreadsheet hard to keep current.
Training matrix vs skills matrix
The two are often confused, and many templates mix them.
| Training matrix | Skills matrix | |
|---|---|---|
| What it records | Courses and certificates: completed or not, and when they expire | How good each person is at each skill, often on a scale such as 0 to 4 |
| Main question | Is everyone trained and in date? | Who can do which task, and how well? |
| Evidence | Dates, certificates, attendance records | Observation, assessment, manager judgment |
| Typical use | Compliance, audits, booking refreshers | Planning rotas, cover, development and succession |
They meet where a training course leads to a competence that has to be checked. A training needs analysis usually starts from a skills view (what people cannot yet do) and ends in a training matrix (what they will be trained in, and when).
What to put in a training matrix
Two tables hold everything. The requirements are set once for each role; the records hold one row for each person and course.
| Column | Table | What it holds |
|---|---|---|
| Role | Requirements | People grouped by what they do, not by name, so a new starter inherits the right list |
| Training | Requirements | The course or qualification, named the way the certificate names it |
| Required by | Requirements | The law, regulator, client contract or internal policy behind it |
| Refresh interval | Requirements | In months, or “once” for training with no expiry |
| Completed | Records | The date of the course or assessment |
| Expires | Records | The completion date plus the refresh interval, or the date on the certificate |
| Status | Records | Valid, due soon, expired or missing |
| Evidence | Records | The certificate reference and who delivered the training |
| Next date booked | Records | The column most matrices leave out, and the one that turns the matrix into a plan |
Which training the law requires, and how often
Most training rules say when training must happen and leave the interval to the employer. A matrix needs both, so where the rule is silent on the interval, set one and write down why.
In the UK, the Health and Safety at Work etc. Act 1974 requires employers to provide “such information, instruction, training and supervision as is necessary” for health and safety, so far as is reasonably practicable (section 2(2)(c)). The Management of Health and Safety at Work Regulations 1999 add when: on recruitment, and on exposure to new or increased risks, such as a transfer, a change of responsibilities, new equipment or a new system of work. The training must “be repeated periodically where appropriate” and take place during working hours (regulation 13). Fire safety training follows the same pattern under the Regulatory Reform (Fire Safety) Order 2005: when people are “first employed”, when risks change, and “repeated periodically where appropriate” (article 21).
In Australia, the model Work Health and Safety Regulations require training that is “suitable and adequate” for the nature of the work, its risks and the control measures in place (regulation 39).
In the US, OSHA’s standards contain specific training requirements, which OSHA collects in its publication Training Requirements in OSHA Standards. Some set an interval in the rule itself.
The intervals below come from the source named in each row. Everything else in a matrix is an interval the employer, the client or a sector body chooses.
| Training | Interval | Source |
|---|---|---|
| First Aid at Work and Emergency First Aid at Work (UK) | Certificate lasts three years; requalify before it expires | HSE |
| First aid annual refresher (UK) | Half a day each year, “strongly” recommended but not mandatory | HSE |
| First aid certification (US, American Red Cross) | Two years | American Red Cross |
| Bloodborne pathogens (US) | At initial assignment, then at least annually | OSHA 29 CFR 1910.1030 |
| Respiratory protection (US) | Retraining annually, and when things change | OSHA 29 CFR 1910.134 |
| Forklift operators (US) | Performance evaluation at least once every three years, plus refresher training after an accident, near miss or unsafe operation | OSHA 29 CFR 1910.178 |
| Health and safety and fire safety (UK) | On recruitment, when risks change, and “periodically where appropriate” | Management of Health and Safety at Work Regulations 1999; Fire Safety Order 2005 |
HSE is direct about expired first aid certificates: once a certificate has expired, the first aider “is no longer considered to be competent to act as a workplace first aider”. That is the cell in a matrix that matters most to get right.
Some rules also set what the record must contain. OSHA’s bloodborne pathogens standard requires training records with the dates of the sessions, a summary of their content, the names and qualifications of the trainers and the names and job titles of everyone who attended, kept for three years. A matrix that holds the certificate reference and the provider, with the provider holding the register, covers most of that.
How to build a training matrix in six steps
- 1List the roles
Group people by what they do. Note the site, shift and manager for each person, since those decide how training can be scheduled.
- 2Set the requirements
For each role, list the training, where each requirement comes from and how often it must be refreshed. Check the rules that apply in each country you operate in.
- 3Collect the records
For each person and course: the completion date, the provider and the certificate reference. Ask the provider for copies where certificates are missing.
- 4Work out the status
Expiry is the completion date plus the interval. Mark each cell valid, due soon, expired or missing, with due soon meaning inside your booking lead time.
- 5Plan the bookings
Look 60 to 90 days ahead. Group people due for the same course, so one date or one in-house session covers them, and record the booked date in the matrix.
- 6Keep it current
Update it after every course, when someone joins or changes role, and when a rule changes. Review all of it at least monthly.
Set the requirements once for each role
A matrix built person by person drifts: two people in the same job end up with different lists, and a new starter’s row is copied from whoever sat nearest. Set the list once for each role and let each person take the list of their role. Where someone holds two roles, such as a team leader who is also a first aider, give them both lists.
Write down where each requirement comes from
The “required by” column is the one most templates leave out. A requirement set by law cannot be dropped to save money, one set by a client contract applies only to people who work on that contract, and one set by your own policy can be changed by whoever owns the policy. When an auditor or a client asks why a course is on the list, this column answers.
Choose your “due soon” window
Due soon should match how far ahead you need to book. Public courses for common topics such as first aid run often, but a group booking, an in-house session or a course that needs a specialist trainer can need two or three months’ notice. A 60-day window works for most compliance training. Requalification courses also need the person to attend before the certificate expires, so the window has to leave room for the course date itself.
Training matrix example
A warehouse and distribution business has five people in three roles. Its requirements table looks like this.
| Role | Training | Required by | Refresh every |
|---|---|---|---|
| Everyone | Health and safety induction | MHSWR regulation 13 (on recruitment) | Once |
| Everyone | Manual handling | Company policy, from the risk assessment | 3 years |
| Everyone | Fire safety awareness | Fire Safety Order article 21; yearly by company policy | 1 year |
| Forklift operator | Counterbalance forklift | Company policy | 3 years |
| Team leader | First Aid at Work | First aid needs assessment; certificate validity from HSE | 3 years |
| Team leader | First aid annual refresher | HSE recommendation | 1 year |
| Team leader | Fire marshal | Fire risk assessment; yearly by company policy | 1 year |
On November 13, 2026, the matrix looks like this:
| Person | Induction | Manual handling (3 yrs) | Fire safety (1 yr) | Forklift (3 yrs) | First Aid at Work (3 yrs) | First aid refresher (1 yr) | Fire marshal (1 yr) |
|---|---|---|---|---|---|---|---|
| Anna Warehouse operative | Done Mar 2025 | Due soon 4 Dec 2026 | Due soon 20 Nov 2026 | – | – | – | – |
| Ben Forklift operator | Done Jun 2024 | Valid 11 Jun 2027 | Valid 9 Feb 2027 | Expired 16 Oct 2026 | – | – | – |
| Chloe Forklift operator, started Oct 2026 | Done Oct 2026 | Valid 6 Oct 2029 | Missing Not done | Valid 12 Oct 2029 | – | – | – |
| Dev Team leader | Done Jan 2022 | Valid 13 Jan 2028 | Due soon 12 Jan 2027 | – | Valid 22 Jan 2027 | Expired 20 Jan 2026 | Due soon 8 Dec 2026 |
| Erin Warehouse operative | Done Aug 2026 | Valid 4 Aug 2029 | Valid 4 Aug 2027 | – | – | – | – |
- Valid, or done with no expiry
- Due soon
- Expired
- Missing
- Not required for the role
Reading across the grid gives the plan for the next two months:
- Fire safety awareness: Anna is due on November 20 and Dev on January 12, and Chloe has not had it at all, although she started in October and the Fire Safety Order requires training when people are first employed. One session for the three of them settles it.
- Ben’s forklift refresher ran out on October 16 under the company’s own three-year rule. Under that rule he should not drive until he has been refreshed, so it is the most urgent booking on the sheet.
- Dev’s annual first aid refresher is ten months overdue, and his First Aid at Work certificate expires on January 22. A requalification course before that date brings both up to date. If it slips, the site loses its only qualified first aider.
- Anna’s manual handling and Dev’s fire marshal training fall due in December and can go on the same booking order.
Five people need five courses in the next two months. A business with 50 people and the same mix produces enough for several in-house sessions a year, which is where the matrix starts to save money as well as time.
Training matrix template
The template is a spreadsheet with the formulas, colors and example already in place: make a copy in Google Sheets or download it as an Excel file. It has a Requirements tab for each role’s training, a Records tab with one row per person and course, a Matrix tab that draws the grid with a compliance percentage for each course, and a Settings tab for your “due soon” window.
To build it yourself instead, the two tables below match the two kinds of information above. Copy each one into a spreadsheet, replace the example rows with your own, and add the formulas below.
Requirements by role
| Role | Training | Required by | Refresh every (months) | Notes |
|---|---|---|---|---|
| Everyone | Health and safety induction | Law: on recruitment | 0 | 0 means once, with no expiry |
| Everyone | Fire safety awareness | Law, with the interval set by policy | 12 | |
| Team leader | First Aid at Work | First aid needs assessment | 36 | Requalify before expiry |
| [Role] | [Training] | [Law, regulator, client or policy] | [Months] |
Training record
| Person | Training | Completed | Months | Expires | Status | Evidence | Next booked |
|---|---|---|---|---|---|---|---|
| Anna | Fire safety awareness | 2025-11-20 | 12 | ||||
| Ben | Counterbalance forklift | 2023-10-16 | 36 | ||||
| Chloe | Fire safety awareness | 12 | |||||
| [Name] | [Training] | [Date] | [Months] |
The Expires and Status columns fill themselves with two formulas, which work the same in Excel and Google Sheets. With the training record starting in column A and the first data row in row 2, put these in E2 and F2 and copy them down:
E2 (Expires): =IF(OR(C2="",D2=0),"",EDATE(C2,D2))
F2 (Status): =IF(C2="","Missing",IF(E2="","Done",IF(E2<TODAY(),"Expired",IF(E2<=TODAY()+60,"Due soon","Valid"))))
Change 60 to your booking lead time. Conditional formatting on the Status column (green for Valid and Done, amber for Due soon, red for Expired and Missing) gives the colored grid. A pivot table with Person as rows, Training as columns and Expires as values (summarized by Max) turns the record into the matrix view in the example.
To report compliance for one course, put the course name in J2 and this formula next to it, formatted as a percentage:
=(COUNTIFS(B:B,J2,F:F,"Valid")+COUNTIFS(B:B,J2,F:F,"Due soon")+COUNTIFS(B:B,J2,F:F,"Done"))/COUNTIF(B:B,J2)
It counts everyone still in date, including those due soon, against everyone who needs the course, so the record needs a row for every person and required course, including the ones not yet done. In the example above, fire safety awareness is at 80%: four of the five people are in date and one has not been trained.
Keeping it current
A matrix goes out of date without anyone noticing. The usual causes, and the fix for each:
- New starters join without a row, so they are never expired and never show up. Add each new person on their first day, with every training on their role’s list marked missing.
- Someone moves to a role with more requirements, such as driving a forklift or becoming a first aider, and the new courses never appear. UK law treats a change of responsibilities as a trigger for training, so change the role in the matrix on the day it changes.
- A course happens but the certificate never reaches the file, and the cell stays empty. Ask the provider for certificates as part of the booking, and record the reference when it comes.
- Without a “next date booked” column, the same person is booked twice or not at all.
- Each site or manager keeps its own sheet. Merge them, or at least use the same roles, course names and intervals in each, so the totals add up.
Building a training matrix for a client
For a training provider, a client’s training matrix is the plan for the work you will do for them. Clients with compliance training to manage often keep the matrix badly or not at all, and a provider who offers to build and keep it current becomes the supplier who already knows what is due.
Start from the needs analysis. The roles, the requirements and the intervals come out of the training needs analysis: what each role must be able to do, which standard applies, and how often it has to be refreshed. Agree the requirements table with the client before you fill in a single date.
Ask for what they already hold. A staff list by role and the certificates they have on file. Gaps in the certificates are the first bookings, and “missing” cells for new starters usually outnumber the expired ones.
Turn the due dates into dates on your schedule. Group the people due for the same course in the same quarter and offer a private date or a block of places. For a client with several sites, group by site. Selling training to L&D buyers covers when a private date costs the client less than public places.
Send the matrix back after every course. Attendance, results and new certificate dates, with the next expiry dates highlighted. The client’s L&D or health and safety lead needs it for their own reporting, and it puts the next booking in front of them. Training certificates and CPD covers what each certificate should show and how to keep expiry dates and renewals in order.
Frequently asked questions
What is a training matrix? A training matrix is a grid of people, or roles, against the training they need, showing for each person and course whether the training is done, when it expires and what is due next. Employers use it to keep compliance training in date and to plan bookings.
What should a training matrix include? For each role: the required training, where the requirement comes from and how often it must be refreshed. For each person: the date they completed each course, the expiry date, the status (valid, due soon, expired or missing), the certificate reference and the next date booked.
What is the difference between a training matrix and a skills matrix? A training matrix records courses and certificates, with completion and expiry dates. A skills matrix records how good each person is at each skill, often on a scale. Use a skills matrix to plan who can do what, and a training matrix to keep required training in date.
Is a training matrix a legal requirement? No law in the UK or the US requires a document called a training matrix. The law requires the training, and some rules require records: OSHA’s bloodborne pathogens standard, for example, requires training records kept for three years. A matrix is the simplest way to show that the training happened and is in date.
How often should a training matrix be updated? After every course, whenever someone joins, leaves or changes role, and when a rule or policy changes. Review all of it at least monthly, looking ahead by your booking lead time, usually 60 to 90 days.
How do I make a training matrix in Excel? Keep one table of requirements by role and one table of training records, with one row per person and course. Calculate the expiry date with EDATE (completion date plus the refresh interval in months), work out the status with an IF formula against TODAY(), and use a pivot table to show people against courses as a grid. The free template above does all of this, for Excel or Google Sheets.
How often does first aid training need to be refreshed? In the UK, a First Aid at Work or Emergency First Aid at Work certificate lasts three years, and HSE strongly recommends a half-day refresher each year. In the US, American Red Cross first aid certification lasts two years. Requalify before the certificate expires, since an expired certificate no longer counts.
Who is responsible for the training matrix? Usually the person who answers for compliance: the health and safety lead, the HR or L&D manager, or the operations manager in a small business. In some cases the employer’s training provider keeps the matrix up to date as part of a contract, with the employer still responsible for the training happening.
Sources
Checked on November 13, 2026.
Show all 10 sources
- Health and Safety at Work etc. Act 1974, section 2
- Management of Health and Safety at Work Regulations 1999, regulation 13
- Regulatory Reform (Fire Safety) Order 2005, article 21
- HSE, First aid training and qualifications
- NT WorkSafe, Information, training and instruction (model WHS Regulations, regulation 39)
- OSHA, Training Requirements in OSHA Standards (OSHA 2254)
- OSHA, 29 CFR 1910.1030, Bloodborne pathogens
- OSHA, 29 CFR 1910.134, Respiratory protection
- OSHA, 29 CFR 1910.178, Powered industrial trucks
- American Red Cross, First Aid classes