# Safety Training Matrix Worksheet

> Source: https://netray.co/tools/safety-training-matrix-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable training record that shows who is trained on what, when it was last done and how many days remain before renewal.

## Category

ehs-workforce

## Industry

Manufacturing

## Audience

- Safety manager
- HR training coordinator
- Shift supervisor

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Employee

**Key:** employee

**Type:** text

#### Department

**Key:** dept

**Type:** select

**Options:**

- Machining
- Fabrication
- Assembly
- Warehouse
- Maintenance
- Quality

#### Training

**Key:** course

**Type:** select

**Options:**

- Hazard communication
- Lockout/tagout
- Powered industrial truck
- Hearing conservation
- Respiratory protection
- First aid / CPR
- Fire extinguisher
- Confined space
- Fall protection

#### Date completed

**Key:** done

**Type:** date

#### Valid for (months)

**Key:** valid_months

**Type:** number

**Format:** integer

#### Renewal due

**Key:** due

**Type:** date

#### Days left (enter)

**Key:** days_left

**Type:** number

**Format:** integer

**Help:** Enter days remaining as of today, or use the due date.

#### Months overdue (enter 0 if current)

**Key:** weight

**Type:** number

**Format:** integer

#### Trainer

**Key:** trainer

**Type:** text

**Rows:**

**Employee:** J. Lindqvist

**Dept:** Machining

**Course:** Lockout/tagout

**Done:** 2026-03-10

**Valid months:** 12

**Due:** 2027-03-10

**Days left:** 141

**Weight:** 0

**Trainer:** Internal EHS

**Employee:** T. Banerjee

**Dept:** Warehouse

**Course:** Powered industrial truck

**Done:** 2023-11-02

**Valid months:** 36

**Due:** 2026-11-02

**Days left:** 13

**Weight:** 0

**Trainer:** Forklift Training Co

**Employee:** S. Tran

**Dept:** Fabrication

**Course:** Hearing conservation

**Done:** 2025-08-15

**Valid months:** 12

**Due:** 2026-08-15

**Days left:** 0

**Weight:** 2

**Trainer:** Occupational Health Clinic

**Employee:** M. Okafor

**Dept:** Maintenance

**Course:** Confined space

**Done:** 2026-01-20

**Valid months:** 12

**Due:** 2027-01-20

**Days left:** 93

**Weight:** 0

**Trainer:** Internal EHS

**Employee:** P. Moreno

**Dept:** Assembly

**Course:** First aid / CPR

**Done:** 2025-04-05

**Valid months:** 24

**Due:** 2027-04-05

**Days left:** 168

**Weight:** 0

**Trainer:** Red Cross

**Employee:** R. Alvarez

**Dept:** Maintenance

**Course:** Fall protection

**Done:** 2025-09-30

**Valid months:** 12

**Due:** 2026-09-30

**Days left:** 0

**Weight:** 1

**Trainer:** Internal EHS

**Totals:**

#### Training records

**Key:** employee

**Agg:** count

#### Total months overdue

**Key:** weight

**Agg:** sum

**Format:** integer

#### Soonest expiry (days)

**Key:** days_left

**Agg:** min

**Format:** integer

**Summary:**

#### Average months overdue per record

**Key:** avg_overdue

**Expr:** sum_weight / count

**Format:** decimal

**Primary:** true

#### Share of records overdue (approx. by months overdue)

**Key:** overdue_share

**Expr:** min(100, sum_weight / count * 100)

**Format:** percent

**Notes:** Enter the completion date and validity, then set the due date. Intervals vary by standard and company: lockout/tagout needs periodic inspection and retraining when conditions change, forklift operators need evaluation at least every three years under 29 CFR 1910.178, and hearing conservation training is annual. Confirm each interval against your program. Export to Excel and add conditional formatting for due dates.

## Content

**Intro:** A training matrix shows at a glance who has completed which safety training and when each certification expires. Most safety managers keep it in Excel, so this worksheet gives you a clean starting layout.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per employee and training course, or one row per employee if you prefer to widen it in Excel. Enter the completion date, the validity period in months and the renewal due date. Set days left from today's date and note months overdue where a renewal has lapsed. Use the totals and summary to see how many records you hold and how much is overdue. Export to Excel monthly, sort by due date, and give supervisors a list of renewals for the next 60 days so they can plan release from production.

#### Typical required training and intervals

**Body:** Requirements depend on the work. Hazard communication training is needed at initial assignment and when new hazards appear. Lockout/tagout needs training for authorized and affected employees and retraining on changes, with periodic inspection of procedures at least annually. Powered industrial truck operators need evaluation at least every three years. Hearing conservation training is annual for exposed employees. Respiratory protection requires annual fit testing and training. Confined space and fall protection depend on your program and conditions.

**Bullets:**

- Hazard communication: at assignment and on new hazards
- Powered industrial trucks: evaluation every three years
- Hearing conservation: annually for exposed workers
- Respiratory protection: annual fit test and training

#### Common mistakes

**Body:** The usual weakness is a matrix that is accurate in January and stale by March. Assign an owner, update it when training is delivered rather than in batches, and tie it to job roles so a transfer automatically triggers new requirements. Another mistake is tracking only attendance and not competence. For operator training, record the practical evaluation. Keep certificates and sign-in sheets linked to the matrix so any row can be defended in an audit.

**Cta:** If you want training expiry to block or warn on work assignments in your ERP or MES, Netray can discuss how to connect it.

**Faq:**

#### Can I use this as proof of training for OSHA?

**Answer:** It is a tracking record. Pair it with sign-in sheets, certificates, test results and, for some standards such as forklifts, a written certification of training and evaluation. Keep those alongside the matrix.

#### How do I handle new hires?

**Answer:** Add them to the matrix on day one with required courses for their role and a target completion date before they perform that task unsupervised.

#### What if an employee is overdue?

**Answer:** Restrict them from the task that requires the training until it is renewed, unless your program allows supervised work. Record the action and the date training was completed.

#### Can I add more courses?

**Answer:** Yes. Export to Excel and add rows or extra course names. The dropdown list covers common examples, and any text can be typed in an Excel export.

## Search terms

safety training matrix excel, training matrix template, OSHA training tracker, employee safety training record, forklift certification tracker, training expiry tracker excel, EHS training matrix

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json