Training Matrix & Certification Expiry Tracker

Know who is trained, what is missing and what expires next — for every employee, by role.

• Status per person: OK · DUE · EXPIRED · MISSING
• Trainings required by role – set once
• Expiry dates calculated from validity in months
• Instant download: BLANK + EXAMPLE · Quick Start PDF
• Built by a production manager · one-time purchase, no subscription, no macros

▶ REQUIRES MICROSOFT EXCEL (DESKTOP) 2016 OR NEWER — Windows or Mac.

Not for Google Sheets, Apple Numbers or mobile apps.

The SmartFactoryTools Training Matrix & Certification Expiry Tracker is a practical Excel system for HR and training coordinators, production managers and quality / food-safety managers who must prove that every employee has the required trainings — and that none of them has expired.

Set once which role needs which training. Then simply log each completed training. The workbook calculates expiry dates, the status of every employee × training and your compliance — automatically.

No macros. No subscription. No HR software.

WHAT IT DOES

• Training catalogue with validity in months (0 = never expires) and "required for all employees"
• Requirements by role: one X per role × training — no per-person setup
• Training log with history: employee, training, date, trainer, result, certificate reference
• Expiry date calculated automatically; the newest passed record counts, older ones stay as history
• Training matrix: employees × trainings with OK · DUE · EXP · MISS for every cell
• Compliance % per employee, department, training and overall
• Leavers and long-term absence excluded automatically
• Built-in Data Check: unknown IDs, duplicates, future dates, missing roles

DASHBOARD

• KPIs: active employees, required trainings, overall compliance, missing, expired, due soon
• Fully compliant staff %, expiring in the next 30 days, trained this year
• Compliance by department and by training — lowest first
• Expired & expiring next: who, which training, days left
• Expiry windows: 0–30, 31–60, 61–90 days
• Least compliant employees
• Gaps by training category
• Required trainings expiring per month — next 12 months
• 2 charts

PRINTABLE TRAINING RECORD

Choose an employee and print a one-page training record (A4 / Letter): required trainings first, then extra trainings, with last completed date, expiry, status, trainer, certificate and sign-off lines — for the personnel file or an audit.

WHAT'S INCLUDED (ZIP)

• BLANK workbook — ready for your data
• EXAMPLE workbook — 59 fictional employees, 22 trainings, 537 training records
• Quick Start Guide (PDF, 2 pages)

Sheets: START_HERE · SETUP · TRAININGS · EMPLOYEES · REQUIREMENTS · RECORDS · MATRIX · EMPLOYEE_RECORD · DASHBOARD · FAQ · LICENSE

HOW IT WORKS

1. SETUP + TRAININGS — departments, roles, shifts and your training list with validity
2. REQUIREMENTS — X where a role needs a training
3. EMPLOYEES + RECORDS — your staff and every completed training
4. MATRIX / DASHBOARD — see the gaps and what expires next; print records

Yellow cells = your input. Light blue cells = automatic formulas (protected against accidental changes, no password).

WHO IT'S FOR

HR and training coordinators · Production and plant managers · Quality, food safety and HACCP teams · Health & safety officers · Small and medium manufacturers — food, packaging, assembly, warehousing and more.

Typical trainings: induction, GMP, food hygiene, HACCP, allergens, forklift licence, first aid, lock-out / tag-out, fire safety, chemical handling, machine operation. The example list is fully editable — you decide what is required.

TRAINING MATRIX vs SKILLS MATRIX

This tool tracks MANDATORY trainings and certificates with expiry dates (compliance). Our Manufacturing Skills Matrix tracks HOW WELL people can do tasks (skill levels, cross-training, coverage risk). They work well together.

LIMITS

• Up to 150 employees, 40 trainings, 25 roles and 3,000 training records per file
• No e-mail reminders, certificate scans, training costs or session planning
• Filters work on the protected sheets; sorting is not supported
• It does not decide which trainings are legally required in your country
• Fully editable inputs. Need it set up with your data or adapted to your plant? See the Setup & Customization section in our shop.

FAQ

Q: Does it work in Google Sheets or on an iPad?

A: No. It is built and tested for Microsoft Excel 2016 or newer on Windows or Mac desktop.

Q: Someone did a refresher. Do I overwrite the old record?

A: No — add a new row. The newest passed record counts automatically; the old one stays as history.

Q: A training never expires.

A: Enter validity 0. The status stays OK.

Q: An employee changes role.

A: Change the role. Required trainings update immediately; records are kept.

Q: Is the file locked?

A: Formulas are protected against accidental changes, without a password. Input cells are always editable.

DIGITAL DOWNLOAD

This is a digital product. No physical item will be shipped. After purchase, download the ZIP from your Etsy account on a computer, unzip it and open the workbook in Excel.

LICENSE

For use within your own company or organisation. Resale, sharing or redistribution of the template is not permitted.

© SmartFactoryTools