Template · Training
Training matrix template
In short
A training matrix template is a grid that lists employees down one side and required training across the top, showing for each person whether each course is complete, due, overdue or not required. It tells you at a glance who is qualified to do what and which training is expiring, and doubles as a training record for audits.
Training Matrix template
Training Matrix
Set up the course list and role requirements once, then update the employee section every time training is completed. Use the status codes below in every cell. Record completion dates, not just ticks, so expiry dates can be calculated.
Matrix details
- Location / site
- Department / team
- Matrix owner
- Last updated
- Next review date
Status codes
C = Complete and current (enter completion date) D = Due within the next [30] days O = Overdue or expired S = Scheduled (enter session date) IP = In progress NR = Not required for this role W = Waived or equivalent qualification accepted (attach evidence)
Course catalog (one line per required training)
- Course 1: name, code, owner, delivery method
- Course 1: required for roles
- Course 1: refresher interval
- One time onlyEvery 12 monthsEvery 24 monthsEvery 36 monthsOn change of process or system
- Course 1: due within (days of hire or role change)
- Course 2: name, code, owner, delivery method
- Course 2: required for roles
- Course 2: refresher interval
- One time onlyEvery 12 monthsEvery 24 monthsEvery 36 monthsOn change of process or system
- Course 2: due within (days of hire or role change)
- Course 3: name, code, owner, delivery method
- Course 3: required for roles
- Course 3: refresher interval
- One time onlyEvery 12 monthsEvery 24 monthsEvery 36 monthsOn change of process or system
- Course 3: due within (days of hire or role change)
- Additional courses (same details)
Employee 1
- Name, employee ID and role
- Hire or role start date
- Course 1: status code and completion / due date
- Course 2: status code and completion / due date
- Course 3: status code and completion / due date
- Additional courses: status and dates
Employee 2
- Name, employee ID and role
- Hire or role start date
- Course 1: status code and completion / due date
- Course 2: status code and completion / due date
- Course 3: status code and completion / due date
- Additional courses: status and dates
Employee 3 (copy this block for each additional employee)
- Name, employee ID and role
- Hire or role start date
- Course 1: status code and completion / due date
- Course 2: status code and completion / due date
- Course 3: status code and completion / due date
- Additional courses: status and dates
Compliance summary
- Total required training assignments
- Number complete and current
- Compliance rate (complete / required x 100)
- Number overdue
- Employees working in a task without the required training (must be zero; list and action)
- Actions and owners for overdue training
Review sign-off
- Reviewed by (manager)
- Reviewed by (training / HR)
- Date
How to use this template
- List every required training once in the course catalog, with the roles that need it, the deadline after hire and the refresher interval.
- Add every employee with their role and start date, then mark NR for courses their role does not require.
- Enter completion dates rather than ticks, and calculate the next due date from the refresher interval.
- Mark anything due in the next 30 days as D so supervisors can schedule it before it lapses.
- Update the matrix the same week training happens, using the signed attendance sheet or system completion record as evidence.
- Review the compliance summary monthly and act on overdue items, starting with anyone doing a task they are not yet qualified for.
What a training matrix shows
A training matrix answers two questions quickly: is everyone trained for the work they are doing, and what is about to expire? Rows are people, columns are courses, and each cell holds a status and a date. A filled-in matrix lets a site manager see in a minute that three night-shift pickers have forklift evaluations due next month, or that a new team lead has not done harassment prevention training.
It is not the same as a skills matrix. A skills matrix rates how well someone can do something (for example, 1 to 4 on handling escalations). A training matrix records whether required training was completed and when. Many teams keep both, and the training matrix is the one auditors ask for.
Worked example: a distribution center
A 180-person distribution center has five required trainings: site safety orientation (once, before first shift), powered industrial truck training and evaluation (every 3 years, for 60 equipment operators), hazard communication (on hire and when new chemical hazards are introduced), harassment prevention (every 2 years in the state where it operates) and the warehouse management system basics (once, within 14 days).
That gives 180 + 60 + 180 + 180 + 180 = 780 required assignments. At the monthly review, 741 are complete and current, so the compliance rate is 741 / 780 = 95 percent. Of the 39 gaps, 22 are new hires still inside their 14-day window, which is fine, 12 are refreshers due in the next 30 days, and 5 are overdue forklift evaluations. Those five operators come off powered equipment until they are evaluated. That last step is the point of the matrix: under OSHA's powered industrial truck standard (29 CFR 1910.178), operators must be trained and evaluated before operating, with a performance evaluation at least once every three years.
Setting up the matrix
Build the course list from three sources: legal and regulatory requirements for your industry and states, customer or contract requirements (common in staffing and BPO work), and internal standards from your training plan for each role. Then map courses to roles, not to individual people, so new hires inherit the right requirements automatically.
A few design choices that save trouble later:
- Use dates in every cell. A tick tells you nothing about expiry.
- Keep status codes few and consistent across sites.
- Separate "required by law" from "required by us" in the catalog, so you know which gaps carry legal risk.
- Keep evidence (sign-in sheets, certificates, system records) somewhere linked from the matrix. A training attendance sheet is enough for classroom sessions.
Using it in high-volume and multi-site operations
A spreadsheet matrix works well up to a few hundred people at one site. Beyond that, or across several sites, it breaks down: tabs multiply, versions drift and nobody trusts the numbers. At that point a learning management system or HR system that assigns training by role and reports compliance automatically is worth the cost.
Until then, a few habits help. Update the matrix weekly, not quarterly. Give each site a single owner. Report one number per site (compliance rate and overdue count) to operations leaders each month. For contact centers and staffing firms with monthly new-hire classes, add the class start date to each row so you can see whether a whole cohort missed a module.
Record-keeping notes
Retention rules vary by subject. OSHA standards that require training generally expect you to be able to show it was done, and some require written certification (the forklift standard requires certifying that each operator was trained and evaluated, with name, dates and evaluator). Several states that require harassment prevention training, such as California, specify how long records must be kept. Many employers keep training records for the length of employment plus at least 3 years. Check the rules for your industry and states and set your retention period to the longest that applies.
Common mistakes
- Tracking completion but not expiry, so certifications lapse without anyone noticing.
- Listing training per person rather than per role, so new hires miss courses.
- Counting someone as trained because they were scheduled.
- Letting people work on equipment or in regulated tasks while training is overdue.
- Several versions of the matrix in email attachments, none of them current.
Frequently asked questions
What is a training matrix?
It is a grid of employees and required trainings that shows, for each person, which courses are complete, due, overdue or not required, with dates. It helps managers see who is qualified for each task and plan refresher training before it expires.
How do I make a training tracker in Excel?
Put employees in rows and courses in columns. Add a row at the top for each course's refresher interval. In each cell enter the completion date, then use a formula to add the interval and conditional formatting to color cells green, amber when due within 30 days, and red when overdue.
What should an employee training record include?
The employee's name and ID, course name and version, completion date, trainer or provider, assessment result if any, expiry or next due date, and where the evidence (signed sheet, certificate or system record) is stored.
What is the difference between a training matrix and a training log template?
A training log lists sessions as they happen: date, course, trainer and attendees. A training matrix is organized by employee and course and shows current status. The log is the evidence; the matrix is the summary you manage from.
How often should a training matrix be updated?
Update it as training is completed, ideally the same week, and review it monthly. Sites with regulated equipment or high new-hire volume often review weekly so nobody works an untrained task.