Skip to content
FitRank

Skill matrix

Employee skill matrix: format, meaning and where Excel breaks

By Yaseen Khatib, , 4 min read

Employee skill matrix: format, meaning and where Excel breaks

Search for skill matrix and you will find hundreds of Excel templates. That tells you two things: almost every team needs one, and almost every team builds it in a spreadsheet. We did too, before building FitRank.

Skill matrix meaning

A skill matrix is a grid. People go in the rows, skills go in the columns, and each cell says how good that person is at that skill. It answers one question at a glance: who here can do what, and how well?

In IT services it is used for staffing (who can take this project), for training (which skills are thin) and for appraisals (how someone has grown).

A skill matrix format that works

We made exactly this as a free employee skill matrix template in Excel. It has the rating scale, colours and gap totals built in, and it works in Google Sheets too.

Write down what each rating means

Most skill matrices fail on the scale, not the grid. If the numbers have no written meaning, every manager rates differently and the totals mean nothing. Describe each level by what the person can do without help:

Two rules keep the scale honest. A rating of 3 or 4 needs evidence: a project where the person did that level of work. And a rating should say when the skill was last used, because a strong rating from five years ago is not the same as one from last month.

Reading the gap row: a worked example

Take a made-up team of eight people and three skills a new project needs. Count only ratings of 3 or 4, because those are the people who can carry the skill alone. If Java has five strong people, Kafka has one and Kubernetes has none, the matrix is telling you three different things: Java is covered, Kafka is a key-person risk (one resignation and it is gone), and Kubernetes is a gap. The next step for each is different: nothing, cross-train a second person, and train or hire. The point of the total row is to make that visible before the project starts, not after.

Where an Excel skill matrix breaks

How FitRank approaches it

FitRank keeps the same idea, people against skills, but each skill on a profile carries a level, years of experience and when it was last used. A data-health view counts profiles with missing information and profiles due for their six-monthly review, and an employee's resume can be read into suggested skills that HR accepts or dismisses one by one. Then, instead of reading a grid, a manager opens an open task and sees the people who fit, with the reason. See people data.

If a spreadsheet works for your team today, use the template. When it stops working, that is the problem we built FitRank for.

More from the blog

Be one of the first teams to staff with FitRank

We're taking on a small number of pilot companies. Pre-register for early access, or talk to us about an annual licence.