Worksheet

Training matrix template

A simple worksheet for mapping job roles to required training and status. It is an overview, not proof of training.

Use this matrix when you need a clear starting structure for role-based training oversight. Completing a cell is not the controlled training record — keep the individual evidence (person, item, revision, date) in your LMS, paper pack, or eQMS and point the matrix at it.

Free · Excel workbook · unlocks in seconds
See training module
Training matrix template — the Excel workbook you download, showing its columns and structure

What the template includes

The worksheet tracks role, user, required training, recurrence, owner, due date, and completion evidence so teams can see both assignment logic and status at a glance.

The workbook pairs an Instructions tab with a roles × training-items matrix sheet, a six-code status legend (Required / Assigned / Completed / Competency verified / Overdue / N/A as cell dropdowns), and sample rows showing how document revisions tie to re-training.

  • Role, user, and required training
  • Recurrence frequency and owner
  • Due date and completion evidence
  • Six-code status legend as cell dropdowns
  • Sample rows linking document revisions to re-training

When it works best

This template is useful when a team is cleaning up role definitions, harmonizing training assignments, or moving from ad hoc spreadsheets into a more governed training model.

When to move beyond the worksheet

Once assignments, acknowledgements, overdue follow-up, and evidence retrieval become operational pain points, most teams benefit from a governed training workflow instead of a stand-alone matrix.

Frequently asked questions

What is a training matrix?

A grid mapping who must be trained on what: training items (SOPs, curricula) down the rows, roles across the columns, and a status code in each cell — required, assigned, completed, competency-verified, overdue or N/A. It is the document an inspector asks for when testing whether people are trained on the current revision.

Should training be tracked per document revision?

Yes — training against revision B does not cover revision D. The template carries a revision column per training item precisely so retraining needs become visible the moment a document revs.

What is the difference between 'completed' and 'competency verified'?

Completion records that the person attended or read; competency verification records that they can actually perform the task, established by assessment, observation or questioning. Regulators increasingly ask for the second — the template's CV code keeps the distinction visible.

See role-based training run inside a governed LMS

Complere's Training & Competency module turns this matrix into live assignments, acknowledgements, overdue follow-up, and competency evidence — tied to document revisions and ready for inspection.