Brett LindenbergAn employee training tracker is a record of the training each employee needs, when they completed it, how they did, the proof, and when it expires. To track employee training, list the training each role requires and keep one row for each employee and course with those fields. Bring in completions from your LMS, sign-in sheets, and quiz or video reports, and check the tracker every week for overdue and expiring items. A spreadsheet works for a small team with a short list of required courses. Move to an LMS or an HR system when manual reminders and retyped completions start to slip. In the short demo below, pick the record that lets a supervisor assign a forklift shift.
What an employee training tracker records
Each field in a row answers a question that a manager or an auditor will ask later: who trained, on what, when, with what result, who says so, and until when.
| Field | Example | Why you need it |
|---|---|---|
| Employee ID | E-1042 | Joins records from the LMS, the HR system, and quizzes, even when names repeat or change |
| Name, team, and manager | Dana Ruiz, Warehouse, M. Chen | Lets you sort by team and send each list to the right manager |
| Training item and version | Forklift operator, sit-down truck, version 3 | Shows who took which version after the content changes |
| Requirement source | OSHA rule, client contract, or company policy | Explains why the training is required and who can grant an exception |
| Assigned date and due date | March 2, 2026; March 30, 2026 | The base for overdue items and on-time completion rates |
| Completion date | March 18, 2026 | Starts the renewal clock |
| Result | Written test 18 of 20; practical evaluation passed | Shows what the employee can do, beyond attendance |
| Trainer or evaluator | R. Okafor | Some regulations require it |
| Evidence | Link to the signed evaluation form or certificate | The first thing an auditor asks to see |
| Expiry or renewal date | March 18, 2029 | Drives reminders before the training lapses |
| Status | Current, due within 30 days, overdue, or expired | Calculated by a formula, so nobody types it by hand |
Regulated training sets some of these fields for you. Under OSHA's powered industrial truck standard, 29 CFR 1910.178, the employer must certify that each forklift operator was trained and evaluated. The certification must include the operator's name, the date of training, the date of the evaluation, and the identity of the person who did the training or evaluation. The employer must also evaluate each operator's performance at least once every three years. In the demo, record B221 fails for this reason: without an expiry date, the supervisor cannot tell whether the evaluation is still current. For more on regulated programs, see our page on safety and OSHA training.
How to track employee training in six steps
1. List the training each role requires
Start from requirements, then find the courses. For each role, list the required training, its source (a regulation, a client contract, or an internal policy), and how often it must be renewed. A training matrix shows this as a grid of roles against courses; our training matrix template has layouts you can copy. If you are not sure what a role needs, run a training needs assessment first.
2. Give every employee one ID
Use the HR employee number in every system that records training: the LMS, quiz tools, video platforms, and sign-in sheets. Names repeat and change, and email addresses change when people move teams. Without one shared ID, you will spend hours matching rows by hand.
3. Keep requirements and completions on separate tabs
Put the requirements on one tab, with one row per role and course. Put completions on a second tab, with one row per completion, and never overwrite an old row. A third tab joins the two into the current status for each employee and course. Because each completion is a new row, you keep the history an auditor asks for: the employee finished forklift training in 2023 and again in 2026, and the sheet shows both dates.
4. Bring in completions from each source
List every place where training gets recorded, and decide how each one reaches the tracker:
- LMS completion reports, exported on a schedule
- Sign-in sheets for classroom sessions, scanned and linked from the row
- External licenses and certifications, with a copy of the certificate and its expiry date
- Quiz and video reports. In Mindstamp, a completion report gives one row per learner with a score for each video, and a raw views export adds the percent each learner watched and each answer (see export training records for an audit).
Choose one person to run the import and one day of the week to do it.
5. Calculate the status of each row
Let formulas set the status from the dates, as shown in the next section. A status typed by hand goes stale as soon as a date passes.
6. Review every week and report every month
Each week, send each manager the names of their people who are overdue or due within 30 days. Each month, report the completion rate and the on-time completion rate by team and by required course, and list every expired certification by name. A percentage on its own does not tell a manager who to talk to.
Build the tracker in Google Sheets or Excel
Google Sheets and Excel both have the date and count functions you need. On the status tab, use these columns: A employee ID, B name, C team, D course, E due date, F completion date, G renewal period in months, H expiry date, and I status. Enter these formulas in row 2 and fill them down.
Expiry date (column H) adds the renewal period to the completion date, and stays blank until both exist:
=IF(OR(F2="", G2=""), "", EDATE(F2, G2))Status (column I) checks the dates in order:
=IF(F2="", IF(E2<TODAY(), "Overdue", "Assigned"), IF(H2="", "Complete", IF(H2<TODAY(), "Expired", IF(H2-TODAY()<=30, "Due within 30 days", "Current"))))Share of a team's rows with a completion date, for a summary tab:
=COUNTIFS(C:C, "Warehouse", F:F, "<>") / COUNTIFS(C:C, "Warehouse")Then make the sheet hard to break:
- Add conditional formatting that colors Overdue and Expired red and "Due within 30 days" amber.
- Use dropdown lists (data validation) for course and team names, so a typo does not split one course into two.
- Protect the formula columns and the completions tab, and keep version history on.
- Look up the renewal period from the requirements tab instead of typing it on each row.
Google documents EDATE, TODAY, IF, and COUNTIFS in its Sheets function list, and Microsoft documents EDATE for Excel with the same syntax.
How to track employee training completion rates
The completion rate is the number of required assignments completed, divided by the number of assignments due in the period, times 100. The on-time completion rate counts only the assignments completed on or before their due date.
For example, a warehouse team has 48 required assignments due this quarter. The team completes 42 of them, 39 by the due date. The completion rate is 87.5% (42 of 48), and the on-time completion rate is 81.3% (39 of 48). The six open assignments, with names, are the list the manager needs.
Three rules keep the rate honest:
- Count only assignments that are due. If you count everything assigned, new hires with courses due next month lower the rate for no reason.
- Report by team, course, and manager. A company-wide rate of 92%, for example, can hide one team at 60%.
- Pair completion with a result. Finishing a course shows that training happened, and a score or an observed task shows whether it worked. Our guides to measuring training effectiveness and training evaluation methods cover the next steps.
For video training, decide what counts as complete. A completion checkpoint that follows the playback position can be reached by dragging the seek bar to the end. In Mindstamp reports, the watched percentage counts unique seconds played, so skipping does not raise it. You can also turn off seeking and stop learners from moving past a question they have not answered, as described in how to stop learners skipping ahead.
How to track employee skills and development
A training record shows what someone attended. A skills record shows what they can do, and a development plan shows where they are heading.
For skills, build a skills matrix: list the skills each role needs, and rate each person on a fixed scale. For example, use 0 for not trained, 1 for trained, 2 for can do it with supervision, 3 for can do it alone, and 4 for can teach others. Record the date and the person who assessed each rating. The training matrix guide shows how to combine skills and required training in one grid.
For employee development tracking, give each person a few development goals with target dates, the activity that supports each goal (a course, a project, or mentoring), and the evidence of progress. Review the goals in regular one-on-ones. If a role has no career path yet, MyCulture's career tracker generator drafts milestones and competency requirements by level that you can edit (free to try, checked October 2026).
How to track employee skills digitally
Record a skill rating only with evidence attached: a manager's sign-off after observation, a scored scenario, a work sample, or a recorded demonstration. For skills that people perform, such as a sales pitch or a customer call, a video response question lets each employee record an answer inside a training video for a reviewer to score later. Keep the rating, the date, the assessor, and a link to the evidence in the same row, so that every rating can be checked.
Spreadsheet, LMS, or HR system: choosing a training tracking system
| Option | Fits when | What you get | Watch for |
|---|---|---|---|
| Spreadsheet | One person maintains it, the list of required courses is short, and completions come from a few sources | Low cost and full control of the fields | Manual imports and reminders; formulas break when many people edit |
| HR system training module | You already run an HR information system and want training next to job and employee data | One employee record, and role changes that flow through to requirements | Course delivery and reporting may be limited; test before you commit |
| Learning management system (LMS) | You deliver and assign a lot of online training | Enrollment rules, reminders, completion and score capture, and certificates | It tracks only what happens inside it unless you import outside records |
Automated employee training tracking usually covers four jobs: assigning training when someone is hired or changes role, sending reminders before due dates and expiry dates, capturing completions without retyping, and emailing reports on a schedule. List which of those jobs take the most time today, and ask each vendor to show those jobs in a demo.
These signs show that a spreadsheet is no longer enough:
- Several people edit it, and rows or formulas break.
- You retype completions from more than one system every week.
- Reminders go out only when someone remembers to send them.
- An auditor asks for history that the sheet overwrote.
Where interactive training video fits
If your training includes video, the video can give the tracker evidence beyond a "watched" flag. In Mindstamp, on supported plans:
- Questions pause the video and record each learner's answer, score, and every retry.
- A completion report exports one row per learner with a score for each video, which you can import into the completions tab.
- A SCORM 1.2 or 2004 package reports completion and a score to your LMS and passes the LMS learner ID back to Mindstamp.
- Certificates with a public verification link are available to learners who meet the watch and score rules you set.
- Completion emails tell you when an identified learner finishes, and webhooks or Zapier can send each finished view to another system, such as a spreadsheet. All of them run after the viewing session ends, so allow for a delay.
Mindstamp is not an LMS. It does not enroll learners or send assignment reminders. Use it for the training video and the evidence it produces, and keep your tracker or LMS as the system of record. The help article on tracking a training course shows how to set up learner IDs across several videos and export one report per course.
Common questions
How do you keep track of training for employees in a small business?
Use one spreadsheet with the three tabs described above, one owner, and one weekly review. Store certificates in a shared folder and link each one from its row. Most small teams can run this way until reminders or audit requests start to slip.
What is a good training tracking spreadsheet for a nonprofit job training program?
A job training program tracks participants instead of employees, and funders often ask about results after the program ends. Add columns for enrollment date, training hours attended, credential earned and its date, exit date, and employment after exit. If your program receives Workforce Innovation and Opportunity Act (WIOA) funding, match your columns to the WIOA performance indicators from the US Department of Labor. They include employment in the second and fourth quarters after exit, median earnings in the second quarter after exit, credential attainment, and measurable skill gains. To track attendance and participation week by week during the program, the weekly tracker in our guide to measuring student engagement also works for adult learners.
Who should own the training tracker?
Name one person, usually in HR, operations, or learning and development, to own the structure and the weekly import. Managers own the follow-up with their people. Employees can upload their own outside certificates, but someone should check each one before the row counts as complete.
How do I prepare training records for an audit?
Filter the tracker to the course or regulation the auditor asks about. Export the rows with the completion date, the result, the trainer or evaluator, and the evidence link, and open a sample of the links to check that they work. Because completions are never overwritten, you can also show earlier rounds of the same training.
Sources and further reading
- Mitti, by SafetyCulture, keeps a list of employee training statistics (updated September 2026). Most figures on the list are secondhand, so check each one against its original source before you reuse it.
