Construction · manufacturing · facilities

Training matrix in Excel – required courses, cards and renewal dates

On a busy site the question is not who has done a course but whose card runs out next month. The matrix sets out what each role needs, shows every person's current certificate with its expiry date and builds a renewal list with the soonest first.

  • 80 people, 20 courses and 16 roles
  • Employees, subcontract and agency operatives
  • Expired, due soon and missing flags
  • Renewal plan sorted by date
Add to basket
Training Matrix & Card Expiry – Dashboard
9sheets
20courses with expiry dates
0macros

Requirements by role

REQUIREMENTS is a role-by-course grid: R for required and O for optional. TRAINING MATRIX then compares each person with their role and fills each cell with the expiry date of the current certificate, coloured green, amber or red.

Safe Pass and other renewals

Safe Pass, manual handling, first aid, working at heights and plant tickets each have their own validity. SETTINGS lets you choose the Safe Pass renewal route and the warning window, and RENEWAL PLAN lists what has to be booked, including required courses nobody has done yet.

Subcontractors on the same page

  • Company name and contact
  • Safety statement received
  • Insurance expiry date
  • Operatives linked to the company in STAFF

Inside the workbook

Know whose card expires before they are on site

Add the training matrix to your basket and continue to payment.

Add to basket

Questions and answers

What counts as a training record?
One line per certificate or card: the course, the date completed, the expiry date and a status. A person can have many lines; the matrix shows the latest.
Can agency workers be included?
Yes. Each person is marked as employee, subcontract or agency, and subcontractors are linked to their company.
Does the matrix make us compliant?
No spreadsheet does that on its own. It shows gaps and expiry dates; training requirements still depend on your risk assessments and the regulations for your work.

What is in the file

  • START
  • SETTINGS
  • REQUIREMENTS
  • STAFF
  • TRAINING RECORDS
  • TRAINING MATRIX
  • RENEWAL PLAN
  • SUBCONTRACTORS
  • DASHBOARD
File format
.xlsx
Tabs
9
Capacity
80 people · 400 records · 20 courses · 16 roles
Requires
Excel 2016+ / Microsoft 365
Macros
None