← Back to all articles HR

Skills Matrix Template: Rating Scales, Coverage and Gaps

A grid of employee names against skills with cells shaded from empty to full circles

A skills matrix is a grid of people against the skills a team needs, with each cell rated on a simple scale. It answers three questions that otherwise rely on a manager's memory: who can do this task today, how many people can do it (and is that enough to cover vacations and turnover), and where should training go next. Manufacturing and quality teams have used skills matrices for decades, partly because ISO 9001 requires evidence of competence; they are now common in IT, support, healthcare and finance teams as skills change faster. The World Economic Forum's 2025 Future of Jobs report expects 39% of workers' core skills to change by 2030.

This page has a coverage calculator, the standard rating scales including the ILUO method from lean manufacturing, a template layout, how to run the gap analysis that turns the matrix into a training plan, the compliance uses, and the mistakes that make matrices go stale. For planning at workforce scale, see the workforce planning template.

Coverage calculator

Coverage counts people rated 3 (independent) or 4 (can train others) for each skill. A common target is at least two per skill per shift, so one absence does not stop the work. Trainers are people at level 4. The calculator runs in your browser.

Rating scales

0 to 4 scaleILUO (lean manufacturing)MeaningCan work alone?
0(blank)No knowledge or not trainedNo
1IIn training; knows the steps, needs full supervisionNo
2LCan perform to standard with supervision or checksWith checks
3UFully independent; meets quality and speed standardsYes
4OExpert; can train and assess others, can improve the processYes, and trains others

The ILUO method, widely used in Toyota-influenced plants, draws each letter as strokes added to a square as the person progresses, so the chart is readable at a glance from across the floor. Whatever scale you use, write a one-line behavioral definition for each level for each skill ("Level 3: completes a cycle count with variance under 1% without help"), or ratings will drift with each manager.

Template layout

NameRoleSkill ASkill BSkill CCertification D (expiry)Skills at 3+Development targetLast reviewed
[Name]Warehouse Associate342Forklift (June 2027)2Skill C to level 3 by March[Date]
[Name]Warehouse Associate420Hazmat (expired)1Renew hazmat; Skill B to 3[Date]
Coverage (people at 3+)2101 current
Target2222

Include certifications with expiry dates in the same grid, since an expired certification is a coverage gap. A spreadsheet is enough for teams under about 50; above that, the learning management or HR system should hold the data.

How to build one in five steps

  1. List the skills from the work, not from job descriptions: the tasks and tools the team actually uses, grouped into 10 to 30 skills. Too many and nobody maintains it.
  2. Define the levels for each skill in observable terms.
  3. Rate: self-assessment first, then manager validation, and for critical or safety skills a practical check by a level-4 assessor. Self-ratings alone run high.
  4. Set coverage targets per skill: usually two people at level 3 or above per shift, more for safety-critical skills, and at least one level-4 trainer.
  5. Review quarterly and after any training, hire, departure or process change.

From matrix to training plan

Compliance: ISO 9001 and training records

ISO 9001:2015 clause 7.2 requires organizations to determine the competence needed for people whose work affects quality, ensure they are competent on the basis of education, training or experience, take action to close gaps and evaluate whether it worked, and retain documented information as evidence of competence. A maintained skills matrix with dated ratings and training records is the usual evidence auditors ask for; ISO 10015:2019 gives guidelines on competence management and people development. Regulated industries (aviation, healthcare, pharmaceuticals, food) use training matrices that map required training to each role, with expiry tracking; OSHA standards that require trained and authorized operators, such as powered industrial trucks (29 CFR 1910.178), require certification records that fit the same grid.

Why skills matrices matter now

See employee training statistics and AI training for employees for the detail.

Common mistakes

Key takeaways

Frequently asked questions

What is a skills matrix?

A grid listing team members against the skills or tasks the team needs, with each cell showing the person's proficiency on a defined scale. It shows at a glance who can do what, which skills have too few qualified people, and where training should be focused. It is also called a competency matrix or training matrix.

How do you create a skills matrix?

List the 10 to 30 skills the work actually requires, define proficiency levels for each in observable terms, rate each person (self-assessment, manager validation and a practical check for critical skills), set a coverage target for each skill, and review the matrix quarterly or whenever someone joins, leaves or completes training.

What rating scale should a skills matrix use?

A four or five-level scale works best, such as 0 (none), 1 (learning), 2 (can do with supervision), 3 (independent) and 4 (can train others). Lean manufacturing uses ILUO for the same four stages. The definitions matter more than the numbers: write what each level looks like for each skill.

What is the ILUO skills matrix?

A lean manufacturing method in which each operator's skill in each process is shown by a letter built up stroke by stroke: I (in training), L (can perform to standard with checks), U (fully independent) and O (can train others and improve the process). It makes progress visible on a shop-floor board.

How many people should be trained on each skill?

A common rule is at least two people at the independent level per skill per shift, so one absence or departure does not stop the work, plus at least one person able to train others. Safety-critical skills and high-volume tasks usually need more.

Is a skills matrix required for ISO 9001?

ISO 9001 does not require a matrix by name, but clause 7.2 requires organizations to determine needed competence, ensure people are competent, act on gaps and retain documented evidence of competence. A dated skills matrix with training records is the most common way to provide that evidence.

What is the difference between a skills matrix and a training matrix?

A skills matrix records how proficient each person is in each skill. A training matrix records which training each role requires and whether each person has completed it and when it expires. Many teams combine them, but completing training is not the same as being competent.

How often should a skills matrix be updated?

At least quarterly, and whenever someone is hired, leaves, changes role or completes training or certification. Ratings older than a year should be revalidated, and certification expiry dates should trigger renewal before they lapse.

← Back to all articles