Start with the work people perform on the manufacturing floor. A useful tracking process connects each role to its training requirements, each completion to evidence, and each open gap to an owner. A green cell without an underlying record leaves the next reviewer guessing what happened.
List requirements by role and task
List the tasks each role performs, the training needed for those tasks and who owns the requirement. Include changes of role and temporary assignments in the review. Name the applicable procedure or instruction version where the training depends on it. Do not assume every employee needs every course.
The UK Health and Safety Executive's brief guide to health and safety training recommends identifying needed skills and knowledge, comparing them with current capability and monitoring records for refresher needs. Use that as a planning method, while checking the requirements that apply where the work takes place.
Keep a dated register of training events
Use one record per person and training event. Keep earlier events when a person completes the training again, rather than replacing the previous date. The fields below are a practical register design, not a prescribed legal form or a list of features every software product provides.
| Field | What to record |
|---|---|
| Person and role | An employee identifier and the role or task relevant to this event. |
| Training and version | The course or procedure, including the version used where relevant. |
| Completion date | When the training actually happened, separate from the date the record was entered. |
| Instructor and evidence | Who delivered the training and where its supporting record can be retrieved. |
| Assessment | Any required understanding check or practical evaluation, its result and reviewer, distinct from attendance. |
| Renewal or change trigger | The applicable interval, expiry date or event that prompts a review, with its basis. |
| Follow-up | The outstanding action, responsible person and target date. |
Store evidence where authorized reviewers can retrieve it and check the reference when adding a record. Mark missing evidence as unresolved rather than treating a blank entry as completed training. Keep unrelated personal information out of the register.
Track expiry and changes separately
Separate the next training due date from certificate expiry and from a review triggered by changed work. Record the basis for each interval. A procedure revision, different equipment or a new task may call for a review before a calendar renewal date arrives; do not assign a blanket annual interval to every topic.
For a specific US example, OSHA's PPE rule, 1910.132(f)(3), calls for retraining when workplace or PPE changes make previous training obsolete, or retained knowledge or skill is inadequate. That is a trigger-based rule for its covered work, not a universal refresher schedule for every topic or country.
When an instruction changes, identify the affected roles, decide what training or assessment is needed and preserve the link to the new version. An expiry date is not a deletion instruction: handle record retention separately under the applicable requirements and your policy.
Review gaps with an owner and next action
Review upcoming renewals, missing completions and unresolved evidence on the schedule set by your procedure. Include the people responsible for the work. For each gap, name the action, owner and target date, then confirm the result in the next review. Reconcile new starters, role changes and departures so the requirements list remains useful.
For example, if a packing operator moves to a different machine, review the new task requirements before treating the old training status as sufficient. Record the resulting instruction and any required assessment against the correct person and task. This is a suggested workflow, not a fixed legal interval.
When a spreadsheet is enough
A spreadsheet can be enough when a named owner can keep the requirements and event register accurate, evidence is accessible and reviews happen reliably. Use separate sheets for role requirements, training events and the current gap view. Protect the formulas, agree who can edit and keep a controlled version of the file.
Excel supports date arithmetic: Microsoft's date calculation guidance shows how to add days to a date. Test your formulas against the interval you actually use and check blank dates and exceptions. A formula cannot choose the correct training requirement for you.
Use the free training matrix template and builder as a starting point for the overview. Keep the dated event register and evidence references alongside it. Decide whether each cell represents completion, a due date or a separate assessment, and explain that meaning to reviewers.
When software helps
Consider software when repeated updates, evidence retrieval or coordination between record owners are becoming difficult to manage reliably. Evaluate the actual workflow: can a reviewer find the underlying completion, understand its status and identify the next action? Test those steps with representative records before choosing a system. Employee count alone does not decide whether a spreadsheet is sufficient.
What TrainGrid records
TrainGrid's course matrix shows employees against courses and distinguishes Completed, Due soon, Overdue, Expired, Failed, Pending, N/A (waived) and Not assigned.
Completion records can retain a completion date, instructor and attachments.
Course settings separate Repeat every (days) from Valid for (days), so recurring assignments and certificate expiry are configured separately.
Import .xlsx or .csv training history as a matrix with one row per person or a log with one row per completion. Check matches and row errors in a preview before saving. An Administrator can undo an import for 30 days. The import does not complete existing open assignments. Before importing, tick Repeats to set Repeat every (days) for recurring courses. For expiring certificates, tick Requires certificate to set Valid for (days).
TrainGrid records training and evidence; it does not deliver or grade e-learning courses.
