SmartTechnology solutions for business

Team Skills Matrix

Enter skill levels, compare them with a target, and export the training gaps.

People, skills, and levels

Levels run from 0 (none) to 5 (expert). Set the target level under each skill. Leave a cell on “—” if you have not assessed it.

Your result

Name a person and pick at least one level to see the matrix.

How to use it

  1. Name the skills and pick a target for each.
  2. Enter the people.
  3. Pick each person's level for each skill.
  4. Review the matrix and the biggest gaps, and download a CSV if you like.

Examples

  • A gapSara at Excel level 2, target 4 Red cell, gap 2
  • Meets the targetOmar level 5, target 3 Green cell
  • Not assessedA cell left on "—" Grey cell, left out of the average
Tool details and privacy

Add people and skills, pick each person's level and each skill's target, and get a colour-coded matrix of gaps.

Green meets the target, amber is one level short, red is two or more short, so you see where the team needs training.

Options

  • Up to 12 skills and 40 people. Levels run from 0 to 5.

Limits

  • Levels are your own assessment; the matrix does not measure skill.

Privacy

What you type stays in your browser. Nothing is uploaded or saved on the server.

Questions

What is the gap?

Target minus level, never below zero.

What does "—" mean?

You have not assessed that skill for that person.

Can I open the file in Excel?

Yes, it is a CSV file.

Are names uploaded?

No.

Related tools

All tools