← Guides

November 13, 2026 · The Cademy Team

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.

certificatesoperationscourse-business

On this page
  1. Key takeaways
  2. 1What a training matrix is
  3. 2Training matrix vs skills matrix
  4. 3What to put in a training matrix
  5. 4Which training the law requires, and how often
  6. 5How to build a training matrix in six steps
  7. 6Training matrix example
  8. 7Training matrix template
  9. 8Keeping it current
  10. 9Building a training matrix for a client
  11. 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 matrixSkills matrix
What it recordsCourses and certificates: completed or not, and when they expireHow good each person is at each skill, often on a scale such as 0 to 4
Main questionIs everyone trained and in date?Who can do which task, and how well?
EvidenceDates, certificates, attendance recordsObservation, assessment, manager judgment
Typical useCompliance, audits, booking refreshersPlanning 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.

ColumnTableWhat it holds
RoleRequirementsPeople grouped by what they do, not by name, so a new starter inherits the right list
TrainingRequirementsThe course or qualification, named the way the certificate names it
Required byRequirementsThe law, regulator, client contract or internal policy behind it
Refresh intervalRequirementsIn months, or “once” for training with no expiry
CompletedRecordsThe date of the course or assessment
ExpiresRecordsThe completion date plus the refresh interval, or the date on the certificate
StatusRecordsValid, due soon, expired or missing
EvidenceRecordsThe certificate reference and who delivered the training
Next date bookedRecordsThe 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.

TrainingIntervalSource
First Aid at Work and Emergency First Aid at Work (UK)Certificate lasts three years; requalify before it expiresHSE
First aid annual refresher (UK)Half a day each year, “strongly” recommended but not mandatoryHSE
First aid certification (US, American Red Cross)Two yearsAmerican Red Cross
Bloodborne pathogens (US)At initial assignment, then at least annuallyOSHA 29 CFR 1910.1030
Respiratory protection (US)Retraining annually, and when things changeOSHA 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 operationOSHA 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

  1. 1
    List 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.

  2. 2
    Set 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.

  3. 3
    Collect 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.

  4. 4
    Work 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.

  5. 5
    Plan 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.

  6. 6
    Keep 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.

RoleTrainingRequired byRefresh every
EveryoneHealth and safety inductionMHSWR regulation 13 (on recruitment)Once
EveryoneManual handlingCompany policy, from the risk assessment3 years
EveryoneFire safety awarenessFire Safety Order article 21; yearly by company policy1 year
Forklift operatorCounterbalance forkliftCompany policy3 years
Team leaderFirst Aid at WorkFirst aid needs assessment; certificate validity from HSE3 years
Team leaderFirst aid annual refresherHSE recommendation1 year
Team leaderFire marshalFire risk assessment; yearly by company policy1 year

On November 13, 2026, the matrix looks like this:

Person InductionManual 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
A worked example with invented people. Cells show the date each piece of training runs out. Due soon means within 60 days.

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

RoleTrainingRequired byRefresh every (months)Notes
EveryoneHealth and safety inductionLaw: on recruitment00 means once, with no expiry
EveryoneFire safety awarenessLaw, with the interval set by policy12
Team leaderFirst Aid at WorkFirst aid needs assessment36Requalify before expiry
[Role][Training][Law, regulator, client or policy][Months]

Training record

PersonTrainingCompletedMonthsExpiresStatusEvidenceNext booked
AnnaFire safety awareness2025-11-2012
BenCounterbalance forklift2023-10-1636
ChloeFire safety awareness12
[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

← All guides