Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementTraining & LearningEmployee Training Tracker

SpreadsheetTraining & LearningFree

Employee Training Tracker

A training matrix showing who is compliant, every course record with expiry dates and renewal alerts, and hours and spend by person.

Shown with sample data

Colour

Employee Training Tracker

A training matrix showing who is compliant, every course record with expiry dates and renewal alerts, and hours and spend by person.

Overall compliance
83%
Mandatory courses in date
Expired or missing
4
Renewals in 60 days
2
All courses
Training spend this year
$1,590
Mandatory training compliance
  • Amara Okafor100%
  • Lucas Silva100%
  • Priya Shah100%
  • Sofia Rossi100%
  • Daniel Brooks66.7%
  • Mei Tanaka66.7%
  • Grace Kim66.7%
  • Omar Haddad66.7%
Training spend this year
  • Amara Okafor$90057%
  • Grace Kim$45028%
  • Omar Haddad$24015%

How to use it

  1. 1List your courses on the Courses sheet with type, provider, validity in months (0 for no expiry), hours and cost.
  2. 2Log each completion on the Records sheet: employee, course and date completed.
  3. 3Check the Matrix for gaps and the Records Status column for renewals.
  4. 4Book renewals for anything Expiring before it lapses.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Stay compliant and see your investment in people. Set up your course catalogue once with type, provider, validity, hours and cost; then log each completion and the tracker works out when it expires and flags anything expired or due for renewal in the next 60 days. A training matrix shows every employee against your mandatory courses (Valid, Expiring, Expired or Missing) with a compliance score, and a people sheet totals hours and spend.

Who it’s for

  • Mandatory safety and compliance training
  • Certification renewals (first aid, forklift, professional)
  • Training budget tracking and audits

What’s included

  • Matrix sheet: Every employee against the mandatory courses.
  • Records sheet: Every course completion with its expiry and renewal status.
  • Courses sheet: Your course catalogue with validity, hours and cost.

How to use it

  1. 1List your courses on the Courses sheet with type, provider, validity in months (0 for no expiry), hours and cost.
  2. 2Log each completion on the Records sheet: employee, course and date completed.
  3. 3Check the Matrix for gaps and the Records Status column for renewals.
  4. 4Book renewals for anything Expiring before it lapses.

Tips

  • Log a renewal as a new record rather than overwriting the old date, so you keep an audit trail.
  • Add new mandatory courses to the Courses sheet and a column to the Matrix.

Questions

When is a course flagged Expiring?

When it expires within the next 60 days.

How is the compliance score worked out?

The share of mandatory courses that are Valid or Expiring (still in date) for that person.

Related searchestraining trackertraining matrixcompliance trainingcertificationscertification expirylearning and development

Details

Format
Spreadsheet
Category
Training & Learning
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetTraining & LearningFree

Employee Training Tracker

A training matrix showing who is compliant, every course record with expiry dates and renewal alerts, and hours and spend by person.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Training & Learning
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More training & learning templates

View all
Skills Matrix & Training Needs Analysis2 sheets

Skills assessed

9

Priority training needs

3

Competent ratings

44%

ABCD
1EmployeeTeamSkillCurrent level 0-4
2RaviAssemblyLine changeover4
3RaviAssemblyTorque calibration1
4MinaAssemblyLine changeover2
5MinaAssemblyTorque calibration3
Skills
SpreadsheetTraining & Learning

Skills Matrix & Training Needs Analysis

Rate each person on the skills the team needs and see gaps, single points of failure and who to train.

10 min setupPreview

Training Evaluation Form

Ask learners what they thought, what they learned and what they will do differently back at work.

Course title *

Date *

Trainer

Submit evaluation
FormTraining & Learning

Training Evaluation Form

Ask learners what they thought, what they learned and what they will do differently back at work.

10 min setupPreview
Annual Training Plan and Budget4 sheets

Annual budget

$95,000

Planned cost

$83,320

Unallocated budget

$11,680

Planned cost by quarter
$20k
$14k
$42k
$7,980
Q1Q2Q3Q4
SpreadsheetTraining & Learning

Annual Training Plan and Budget

Plan every training programme by quarter with participants, cost and hours, and track actual spend against the budget.

25 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ