Training Matrix Template
A grid of roles against the courses each one must complete. See who is compliant, what is due and where the gaps are, by role, before an audit finds them for you.
Reviewed by Abhijit Rao, AVP & Business Head, India
- A grid of roles against the courses each one must complete
- A Complete, Due and Gap status in every cell, so coverage is visible
- Frequency, renewal and an owner set per role, so nothing lapses unseen
- Coverage read by role, so a team sitting at zero is never hidden by an average
What is inside
- A role by course grid: your roles down the side, the courses each role must complete across the top, and a status in every cell.
- A Complete, Due and Gap status so coverage is visible at a glance, with a status key that adds Overdue and Not required for the full picture.
- A frequency and a renewal per course, plus an owner per role, so training that lapses is caught and someone is accountable for closing it.
- A coverage read by role rather than a single company-wide average, so a team sitting at zero is never hidden behind a healthy-looking headline.
Who it is for
Anyone who has to plan what people learn, and answer for whether it landed.
- L&D and training teams
- People managers and team leads
- Heads of function and department
- HR business partners
- Compliance and risk teams
- Onboarding and enablement teams
- Operations and delivery leads
- COOs and HR directors
How to use this template in 4 steps
- Pick your format. Download the PDF to share, the Word file to edit, or the Excel file to work in live. All three are free.
- Make it yours. Adapt the sections, fields and wording to your team, roles and process so it fits how you actually work.
- Put it to work. Fill it in, circulate it to stakeholders for sign-off, or roll it out to your team.
- Track and improve. Review it on a set cadence and refine it as your goals, roles and priorities change.
What is inside
- A role by course grid: your roles down the side, the courses each role must complete across the top, and a status in every cell.
- A Complete, Due and Gap status so coverage is visible at a glance, with a status key that adds Overdue and Not required for the full picture.
- A frequency and a renewal per course, plus an owner per role, so training that lapses is caught and someone is accountable for closing it.
- A coverage read by role rather than a single company-wide average, so a team sitting at zero is never hidden behind a healthy-looking headline.
This is a starting structure to adapt to your own roles and obligations, not a statement of your legal training requirements. Confirm what is mandatory for each role, and how often it must be renewed, with your compliance and legal teams. It is not legal advice.
The training matrix
This is the tool itself, and the reason it exists. Roles down the side, required courses across the top, a status in every cell. It is not a skills matrix: a skills matrix would score how good each person is at a skill, from 1 to 5, while this tracks whether each role has completed the courses it must. The required level per course is Complete; anything short of that is a Due or a Gap. In Excel the coverage and the gaps calculate as you type.
| Role | People | Security | Code of conduct | Data privacy | Fire safety | Role induction | Ready |
|---|---|---|---|---|---|---|---|
| All staff | 600 | 2 | 2 | 2 | 2 | 2 | 100% |
| Office / HQ | 180 | 2 | 2 | 2 | 1 | 2 | 90% |
| Sales | 120 | 2 | 2 | 1 | 1 | 2 | 80% |
| Managers | 80 | 2 | 1 | 2 | 1 | 1 | 70% |
| Warehouse / field | 140 | 1 | 0 | 0 | 0 | 0 | 10% |
| Coverage at required | 80% | 60% | 60% | 20% | 60% | 70% |
Warehouse and field is the exposure here: fire safety, data privacy and role induction are all at Gap, despite it being the most safety-exposed group on the list. A high all-staff number hides it, which is exactly why you read coverage by role and never by a single company-wide average.
Assigning each role its required courses in an LMS auto-enrols a new hire on day one, tracks completion for you and rolls coverage up by role, so the matrix reflects who is actually compliant today instead of a spreadsheet someone has to chase.
The matrix as a list
The grid is the fast read. This list view holds the same data one line at a time, which is the form you want when you are setting frequencies, assigning owners or exporting the requirements into another system. Each line is a role, a course, whether it is required, how often it repeats and who owns it.
| Role | Course | Required | Frequency | Owner |
|---|---|---|---|---|
| All staff | Security awareness | Yes | Annual | L&D and Security |
| All staff | Code of conduct | Yes | On join + annual | HR and Compliance |
| All staff | Data privacy | Yes | Annual | Compliance |
| Warehouse / field | Fire safety | Yes | Annual | Facilities and EHS |
| Warehouse / field | Role induction | Yes | On join | Ops and L&D |
| Sales | Data privacy | Yes | Annual | Compliance |
| Managers | Role induction | Yes | On promotion | L&D |
| Office / HQ | Fire safety | No | Not required | Facilities |
How to build it
Ten checks that turn a status grid into a training matrix you can defend in an audit. Tick items as you build yours, it stays in this browser. The download has the same list with an owner column.
- Every role in scope listed down the sideStructureWhole matrix
- Mandatory courses confirmed with complianceComplianceEach course
- Required versus optional marked for each roleScopeEach cell
- A frequency set for every required courseCadenceEach course
- A renewal or expiry date set where training lapsesCadenceEach course
- An owner named for every role's trainingOwnershipEach role
- Status definitions agreed so Complete means the sameStandardWhole matrix
- Coverage read by role, never a single company-wide averageCoverageEach role
- Overdue and gap cells flagged for actionCoverageEach cell
- A refresh date set to re-check the matrix each cycleGovernanceWhole matrix
The most common failure is reading a single completion percentage for the whole company. A 94 percent average looks healthy right up to the moment you notice one role is at 20 percent. Read coverage role by role, and the thin roles stop hiding.
The status key
Every cell in the matrix carries one of these statuses. Agree what each means before you score anyone, so Complete means the same thing to the person filling it in and the auditor reading it. Not required keeps a course from dragging down a role it never applied to.
| Status | Means | Action |
|---|---|---|
| Complete | Required course done and still in date. | No action. Re-check at the next renewal date. |
| Due soon | Assigned or renewal approaching, not yet overdue. | Nudge the person to finish before the deadline passes. |
| Overdue | Required course missed its deadline or renewal. | Escalate to the role owner. This is the audit risk. |
| Not required | Course does not apply to this role. | Leave blank. Do not let it dilute the coverage read. |
How to use it
- List every role in scope
Put the roles down the side, not individuals. A handful of roles covers most of the org and keeps the matrix maintainable.
- Confirm the mandatory courses with compliance
Across the top, list the courses each role must complete. Confirm what is actually mandatory with your compliance team before you build the grid.
- Mark required versus optional per role
Not every course applies to every role. Mark each cell required or not required, so coverage is measured against the real obligation.
- Set a frequency and a renewal per course
Decide how often each course repeats and when it expires. Training that lapses needs a renewal date, or Complete today is Overdue next quarter.
- Score each cell Complete, Due or Gap
Mark where each role stands on every required course. Complete and in date, Due soon, or a Gap that needs action.
- Read coverage by role and clear the gaps
Read across each role, never a company-wide average. Fix the overdue and gap cells before the next cycle or the next audit.
Frontline teams reach 95 percent-plus completion on Disprz when courses are assigned by role and tracked automatically, which is how a training matrix like this stays green instead of going stale between audits.
Common mistakes this template prevents
- Hiding a role that is sitting at zero behind a high company-wide completion average.
- Treating training as one and done, with no renewal or expiry on courses that lapse.
- Confusing a training matrix with a skills matrix, so you track proficiency when the question is completion.
- Leaving mandatory courses unconfirmed, so the matrix faithfully tracks the wrong requirements.
- No owner per role, so overdue cells sit unactioned until an audit is the one that finds them.
Which format should you use?
| Format | Best for | What is inside | Editable | Size |
|---|---|---|---|---|
| Sharing and print | The full template, formatted to print or circulate | No | 55 KB | |
| Word | Editing the wording | Every section as editable text you can adapt | Yes | 87 KB |
| Excel | Filling it in live | The grid and fields set up as a working spreadsheet | Yes | 66 KB |
Questions people ask
What is a training matrix?
How is a training matrix different from a skills matrix?
Is this a training matrix excel template or a course?
Does the Excel version work in Google Sheets?
Do I have to fill the form three times?
More from the L&D library
A matrix shows the gaps. Keeping every role green is training people actually finish. That is the part we run.
Bring your training matrix to a 30-minute working session. We will show how Disprz assigns each role its required courses, auto-enrols new joiners, tracks completion as it moves and rolls coverage up by role, so your matrix stays current and compliance is provable in a two-minute export.