Skills matrix template
A skills matrix is a grid of people against the tasks your team has to cover, with a rating for how well each person can do each one. This free Excel template uses a 0 to 4 scale with a key, works out each person's average, and counts the skills where someone is the only person able to do the work alone: your single points of failure.
Running a company of 30 to 200 people? Documents like this are now worth money.
Use it to plan holiday and sickness cover, choose who to cross-train, and focus development conversations. It measures ability at the work itself, not attendance on courses.
What's in the template
The workbook has a read-me, a blank matrix for 20 people and an example. The key sits at the top of the sheet:
| Rating | Means |
|---|---|
| 0 | No experience |
| 1 | Learning: can do it with supervision |
| 2 | Can do it with some help |
| 3 | Competent: does it alone, to standard |
| 4 | Expert: can train others and handle the exceptions |
Three columns are calculated: Average, Skills at 3+ (tasks the person can do alone) and Skills only they cover (tasks where nobody else is rated 3 or 4). The example, for the finance team of a fictional 70-person recruitment agency (the workbook also holds each person's role and next skill to build):
| Name | Purchase ledger | Credit control | Bank reconciliation | Payroll | VAT returns | Month-end close | Management accounts | Accounts system admin | Average | Skills at 3+ | Skills only they cover |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Rachel Byrne | 3 | 3 | 4 | 2 | 4 | 4 | 4 | 3 | 3.4 | 7 | 1 |
| Mohammed Ali | 2 | 1 | 3 | 4 | 1 | 2 | 1 | 1 | 1.9 | 2 | 1 |
| Jess Turner | 1 | 4 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 |
| Peter Ng | 4 | 2 | 3 | 1 | 1 | 2 | 1 | 0 | 1.8 | 2 | 0 |
| Amara Osei | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0.6 | 0 | 0 |
| Neil Hughes | 2 | 2 | 2 | 1 | 3 | 3 | 4 | 2 | 2.4 | 3 | 0 |
How to build a skills matrix
- List the tasks the team must be able to cover, in its own words: "run payroll", not "numeracy". Include anything that would cause trouble if nobody could do it next week.
- Agree what each rating means before anyone scores. The line between 2 and 3 matters most: a 3 does the task alone, to standard, with nobody checking.
- Rate with each person, not about them. A short conversation backed by evidence ("when did you last do a VAT return?") gives truer scores than a manager's guess.
- Read down the columns as well as across the rows. A task with only one person at 3 or above is a single point of failure, and the template counts these against that person.
- Turn each fragile skill into an action: name a learner, use the person rated 4 as the trainer, and put it in the training plan with a date.
- Re-rate every six months, and whenever someone joins, leaves or changes role.
Example: finding the single points of failure
Reading down the example's columns:
- Payroll has one person at 3 or above: Mohammed, rated 4. If he's off on payroll day, nobody can run it unsupervised. Rachel, at 2, is closest, but she already covers seven of the eight tasks, so Peter (rated 1) is the one to train, with Mohammed teaching.
- Accounts system admin depends on Rachel alone. Neil, at 2, is the nearest to taking it on.
- Bank reconciliation has three people at 3 or more, so nobody needs training there this year.
Rachel's breadth is a risk as well as a strength: her holidays need the most planning, and her role belongs in the company's succession plan.
What the average is for
The average shows breadth: how much of the team's work a person can do. It helps spot people ready for more, and newer staff whose rows should be rising, like Amara's 0.6 as an apprentice. It isn't a performance score. A specialist can be excellent at their job and still have a low average, because the matrix covers the whole team's work. Keep it out of pay decisions, and say so when you introduce the matrix, or people start inflating their ratings.
Common mistakes
- Skills so broad they mean nothing, like "IT" or "communication". Rate tasks you could watch someone do.
- Undefined levels, so one person's 3 is another's 2. Use the key and ask for an example.
- Treating it as an appraisal. If ratings feed pay, they rise and the matrix stops showing risk.
- Filling it in once. Last year's ratings hide this year's single points of failure.
- Finding gaps and doing nothing. Each fragile skill needs a named learner and a date.
Frequently asked questions
What should a skills matrix include?
The people, the tasks the team must cover, a rating for each, and a key defining every level. This template adds three calculations: each person's average, how many tasks they can do alone, and how many tasks only they can cover.
What rating scale should a skills matrix use?
Any scale works if every level is defined. A 0 to 4 scale like this one separates "can do it with help" from "can do it alone", which is the distinction that matters for cover.
What is a single point of failure in a team?
A task that only one person can do to standard. If they're ill, on holiday or resign, the work stops or goes wrong. In this template, any task where just one person is rated 3 or 4 counts as one.