Skills Matrix Template: Free Excel Download and Example
Free Excel skills matrix with a completed example, three sample settings and a PDF. Compare skill ratings, staffing targets and record dates.
A skills matrix lists people against tasks and rates how well each person can perform them. It helps you identify skills gaps and dependence on one person.
- Define the evidence for each rating. Completing a course or holding a licence does not, on its own, demonstrate that someone can do a task.
- Set a required level and a whole-team headcount for each skill. Check shifts, absences and simultaneous work separately before assigning cover.
- Where a task requires a current licence, certificate or competency check, keep the dates and supporting record. An expired check needs renewal or reassessment before it counts.
- Investigate each gap before choosing training, supervised practice, reassessment, a roster change or recruitment.
Five reflection questions to help you choose what to review. This score does not verify competence, staffing coverage or compliance.
Go from storyboard to an interactive course in minutes
A skills matrix shows the tasks a team needs to do and how well each person can do them. Read across to see one person’s skills, or down a column to find who can take on a task. The free Excel template below also compares those people with your staffing targets and checks the dates on required licences, certificates and competency checks.
I'm the COO of Coursebox, and I run our team in Perth. We make HR training software that teams use to build training and track who has completed it.
The completed example follows a fictional home care team of ten. Only Grace meets the team’s dementia-care standard. Medication assistance has a different problem: some workers have the required rating, but their supporting checks are overdue or missing. Those gaps need different responses.
Download the blank workbook for your team, or open the completed example to see the ratings, evidence records and staffing check together. Both files are free, with no email required.
Download the blank matrix to map your own team. The example file has the home care team's completed matrix, cover check and ticket log, plus samples for plant operators, a field service team and a therapy practice, one per tab.
Open the staffing-check preview at full size
What a skills matrix shows
A skills matrix helps you work out who has the skills for a task and where the team needs support. It starts with the work itself: what someone must be able to do, how you will judge that, and how many people need that skill.
Open the skills matrix diagram at full size
Keep task standards alongside the grid. The rating is a summary; the supporting evidence explains what was checked and when.
The building blocks
| Part | What it is | Example from the home care team |
|---|---|---|
| Skills | Tasks the team must be able to do, written so you could watch someone do them | Hoist transfer, medication assistance |
| People | Everyone who might be rostered on that work | Ten support workers on day, evening and weekend shifts |
| Level | How well each person does each task, on a short scale | Mei is a 2 in dementia care: she does it with someone checking |
| Level needed | The task standard someone must demonstrate before they count towards the target | 3 for every skill in this team |
| People needed | How many must be at that level for the work to keep running | 5 across the team for medication assistance; each shift still needs a separate roster check |
| Evidence | What the rating is based on, including any ticket and its expiry date | An annual medication competency check, observed by an assessor |
The rating scale
There is no single rating scale that every team must use. This template uses four levels of developing skill, plus zero for someone who has not been trained. Agree what each level looks like for your tasks before you rate anyone.
| Level | Name | What you would see | Evidence before you rate it |
|---|---|---|---|
| 0 | Not trained | Has never done the task and hasn't been shown | Nothing needed |
| 1 | Learning | Has done the course, but needs step-by-step help | Course or induction completed |
| 2 | With support | Does the task with someone checking, or does part of it | Seen doing it under supervision |
| 3 | On their own | Does the whole task to standard, including the usual problems | Observed meeting the approved standard without prompting, under safe assessment arrangements; any required current licence checked separately |
| 4 | Can train others | Does it well enough to show someone else and check their work | Demonstrated the task and supported another learner effectively; formal trainer or assessor authorisation checked separately |
Each level has a test you can check. "Advanced" or "expert" invites people to rate their confidence instead.
Skills matrix, competency matrix and training matrix
These names often overlap. A competency matrix can also rate people, and a skills matrix can include broader competencies. The comparison below is a useful way to organise the information, rather than a universal naming rule.
| Name | Rows and columns | Answers |
|---|---|---|
| Skills matrix | People by tasks, rated by level | Who can do this task, and how well? |
| Competency matrix | Roles by competencies, with the level each role needs | What should someone in this role be able to do? |
| Training matrix | People by required courses or tickets, with dates | Who has done the training, and when is it due again? |
This template combines skill ratings with a record of required licences, certificates and checks. A current certificate supports the record, but does not replace evidence that someone can do the task. To define what each role needs first, start with competency mapping.
Skills people want to develop
Ask people which skills they want to develop as well as checking what they can already do. That conversation can help you choose practice opportunities. Interest does not replace evidence, and a reluctant learner may need time, resources or a clearer reason for learning.
| Level | Wants to learn it | Doesn't want to |
|---|---|---|
| Below the required level | Discuss suitable practice, support and assessment | Ask what is getting in the way; check whether the skill is required |
| At the required level | Discuss a development or mentoring opportunity | Agree role expectations and workload before adding responsibilities |
Use the free-text “Wants to learn” column to record those interests. It does not score motivation or automatically match learners with trainers.
When a skills matrix is the wrong tool
- You need to know why a gap exists: a matrix shows the gap, not the cause. Run a training needs analysis before you book training.
- You’re mapping skills across several departments: this workbook has space for 20 people and 12 skills. Larger shared records need consistent role definitions and ownership. See skill mapping.
- You're planning one person's growth: use a development plan, which turns their gaps into goals and dates.
How to build a skills matrix
The steps below use the fictional home care team from the completed workbook. Its ratings, staffing targets and annual-check policies are illustrative. The example uses 20 October 2026 as its check date.
Step 1: List the tasks, not the traits
Write each skill as a task you could watch someone do. "Hoist transfer" works. "Good with clients" doesn't, because two people would rate it differently.
The home care team has eight: personal care, hoist transfer, medication assistance, dementia care, infection control, first aid, driving clients, and the care notes app.
Start with the tasks that matter to the team’s work and group them clearly. If a skill is too broad to rate consistently, split it: “care notes” might mean recording a visit, documenting a change in condition and escalating a concern. Keep the detail in your task standards so the grid stays usable.
Step 2: Set the level and number of people for each skill
For each task, set the standard a person must demonstrate. In this example, level 3 means doing the task to the approved standard without prompting. Then set a whole-team staffing target from the workload, shifts and likely absences. Check the roster separately: five trained people on the team may still leave a particular shift short.
The example sets a target of 5 people for medication assistance, 10 for infection control and 3 for dementia care. These are planning assumptions for this fictional team, not recommended staffing ratios. Everyone needs infection-control skills because everyone works with clients.
Some templates total each column against a target, such as 25. Thirteen people all at level 2 score 26 and pass, yet nobody can do the task alone. Count the people at the level needed instead, which is what the template does.
Step 3: Rate each person, with evidence
Ask people to describe their experience and suggest an initial rating. Then compare it with recent task evidence: observation notes, work samples and any required assessment. Agree who can assess the task and what a successful demonstration involves. Record the evidence so another reviewer can understand the rating.
If a self-rating and a supervisor’s view differ, investigate the difference. They may be thinking of different equipment, conditions or versions of a procedure. A certificate can establish that training was completed; it does not settle whether someone can perform the task.
For example, if a worker needs prompting on a required step, discuss the missing step and the practice they need. Assess it again under safe conditions before recording that they can do the task without help.
Use N/A only when a task is outside the person’s role. Aisha’s example role excludes driving clients. If she will need to drive but has not been trained, record 0 instead; leave an unassessed rating blank until you have evidence.
Step 4: Add tickets and expiry dates
In the workbook, “ticket” means a required licence, certificate or competency check. Mark the tasks that need one, then enter each record’s issue or assessment date and expiry. If a record has no expiry, confirm this explicitly and explain why. A blank expiry date by itself does not count as current.
Expiry tracking also appears in requests to our support team. The figure below concerns certificate validity, rather than requests for a skills matrix.
Some requirements are legal; others come from an organisation’s procedures. Under US federal OSHA rules for powered industrial trucks, each operator’s performance must be evaluated at least every three years. Unsafe operation, an accident or near miss, and certain changes in trucks or working conditions can require earlier refresher training and evaluation. The home care example’s annual checks are fictional policy assumptions.
Renewal cycles vary. In the 180 days to 19 October 2026, at least 7 people asked our AI course builder for a refresher tied to a ticket or a fixed cycle. They ranged from a hydraulic maintenance certificate valid for two years to an annual code of conduct course.
The home care team's completed matrix
Example: Ten support workers across eight skills, with tickets checked on 20 October 2026.
- 1. Evidence to investigate: Mei and Ben have medication-assistance ratings of 3 but lack usable current checks. Hana’s hoist check has expired. Ratings alone do not establish cover.
- 2. People at the level now: only 4 count for medication assistance, against the 5 needed.
- 3. Dementia care: Only Grace meets the dementia-care target level. The Cover tab shows a shortfall of two against the target of three.
Open this workbook preview at full size
Step 5: Read the cover check
The Cover tab compares current whole-team counts with the targets you entered. It also lists people one level below the target, possible trainers at level 4 and evidence records expiring soon. Check the individual evidence and availability before assigning work. A level 4 rating does not confer formal assessor authority.
What the cover check says about the home care team
Example: The same team, read skill by skill.
- 1. Dementia care: Ravi and Mei are at level 2 and have recorded an interest in dementia care. Discuss suitable supervised practice with Grace, then arrange assessment.
- 2. Medication assistance: Mei needs a new competency check. If she meets the standard and the record is current, the count rises from 4 to the target of 5.
- 3. Tickets expiring soon: Ravi’s first aid record and Daniel’s infection control record expire within 60 days. These are example renewal dates.
Open this workbook preview at full size
Use the staffing check to decide what to investigate first:
- No cover, or one person only. Check which work depends on that person and what happens during an absence. In the example, only Grace currently meets the dementia-care standard.
- Missing or expired checks. Mei needs reassessment for medication assistance; Ben has no supporting record. Find out what each requires before assuming a renewal will close the gap.
- Records expiring soon. Arrange Ravi’s first aid renewal and Daniel’s infection-control refresher in time for the work they are expected to do.
- Other shortfalls. Discuss practice opportunities with people near the required level, taking account of their role, interest and available supervision.
Step 6: Act on each gap, and set a review date
Choose an action that addresses the cause of the gap and meets the task’s requirements:
- Arrange renewal or reassessment when a required record has lapsed. Count the person again only after they meet the requirements and you have current evidence.
- Arrange supervised practice with a suitable, authorised trainer. Ravi and Mei could practise dementia-care tasks with Grace, then be assessed against the agreed standard.
- Train when nobody is close, or the task has changed.
- Change the roster when the skill exists but sits on the wrong shift.
- Hire when the team is too small to cover the task at all.
Update the matrix when someone joins, leaves, changes role or demonstrates a new level. Set a regular review date suited to your work; a quarterly review is a starting point, with earlier checks when evidence or staffing changes. Moving the check date tests record validity at a future date, not future availability or competence.
Set the check date to the first day of the new roster. In the example, moving it to 31 December 2026 shows infection control falling one person short when Daniel's refresher lapses.
Skills matrix examples for other teams
The following fictional samples suggest tasks you might include. Move each task into a separate Matrix column, then enter your required level and a numeric whole-team headcount. Replace “every operator” or “2 per shift” with a number based on your actual team, and check each shift separately.
Each sample is a tab in the example file.
Plant operators
This sample groups plant work by procedure and equipment. Its targets are examples; approved site procedures determine who may operate equipment, isolate plant or issue permits.
| Skill | Level needed | People needed | Ticket needed | Why |
|---|---|---|---|---|
| Isolation and tagging | 3 | Every operator | Yes | Follow the approved isolation procedure and authorisation requirements |
| Permit to work | 3 | 2 per shift | No | Someone on every shift must be able to issue and close a permit |
| Pre-start checks | 3 | Every operator | No | Rated on what you see at the machine, not on the course |
| Front-end loader | 3 | 2 per shift | Yes | Two per shift covers a break or a sick day |
| Forklift | 3 | 3 | Yes | In the US, each operator's driving is evaluated at least every three years |
| Crusher start-up and shutdown | 3 | 2 per shift | No | One trained person per shift stops the plant when they're away |
| Emergency stop and evacuation | 3 | Every operator | No | Practised in a drill, not only read |
| Training new operators | 4 | 1 per shift | No | A level 4 rating alone does not authorise assessment or sign-off |
Lloyds Metals: training for specific equipment
Lloyds Metals is building safety training with Coursebox for a new iron ore operation expected to need around 350 people in crushing and screening. The training covered specific departments, areas and equipment, in English, Hindi and Marathi. This illustrates why a plant matrix needs task-specific columns. The published case does not establish that Lloyds Metals used this matrix or show staffing coverage.
A field service team
Service technicians, where know-how on older equipment sits with a few long-serving people.
| Skill | Level needed | People needed | Ticket needed | Why |
|---|---|---|---|---|
| Install the standard unit | 3 | All technicians | No | The everyday job. Everyone should be at 3 |
| Fault-find older models | 3 | 3 | No | Usually held by one or two people. Pair them with someone at 2 |
| Commission a new site | 3 | 2 | No | Rare but high stakes. Two people means one can check the other |
| Electrical work | 3 | 4 | Yes | Only counts while the licence is current |
| Working at height | 3 | 4 | Yes | Record the ticket and its renewal date |
| Customer handover | 3 | All technicians | No | Explains the system and what to do if it fails |
| Training new technicians | 4 | 2 | No | So a new starter isn't waiting on one expert's calendar |
Secure Meters: making specialist knowledge reusable
Secure Meters needed to make specialist knowledge available without repeatedly taking engineers away from their work to teach new joiners. Its Coursebox case describes turning that knowledge into reusable training. A matrix can help identify a similar dependency in your own team, but the case does not report matrix ratings or a change in the number of trainers.
A therapy or counselling practice
This fictional practice illustrates clinical and administrative tasks. Its annual refresher cycles are example policies, not a statement of legal or professional requirements. Check the qualifications and authorisations each role needs.
| Skill | Level needed | People needed | Ticket needed | Why |
|---|---|---|---|---|
| Intake assessment | 3 | 4 | No | Enough people to book new clients every weekday |
| Risk assessment and safety planning | 3 | All clinicians | Yes | Annual refresher. A lapsed one doesn't count |
| Behaviour support plans | 3 | 3 | No | Written and reviewed by someone at 3 or above |
| De-escalation | 3 | All staff | Yes | Annual practical refresher, including reception |
| Mandatory reporting | 3 | All staff | Yes | Annual. Rate on knowing what to report and to whom |
| Privacy and client records | 3 | All staff | Yes | Annual. Rate on what you see in the notes |
| Telehealth sessions | 3 | 4 | No | Running a session, plus what to do when the call drops |
| Supervising students | 4 | 2 | No | Check professional qualifications and supervisor authorisation separately |
In conversations with Coursebox, a counselling training provider described tracking modules in separate spreadsheets, while an aged-care provider wanted to find staff with current records for a particular standard. A skills matrix can bring ratings and record dates together; the underlying evidence still needs to be available for review.
What to hand over after a review
A matrix is only useful if the gaps turn into actions with owners. After each review, send your manager or HR a short summary:
- The skills at risk: no cover or one person, and what happens if that person is away.
- Tickets lapsed or due: names, skills and dates, with renewals booked.
- The action for each gap: renew, pair, train, change the roster or hire, with an owner and a date.
- What isn't a training problem: gaps caused by the roster, headcount or equipment, which training won't fix.
For the home care team, the immediate plan is to arrange dementia-care practice and assessment, investigate two expired checks and one missing record, and book two upcoming renewals. The assessment results will determine whether further training is needed.
When a spreadsheet is no longer enough
- To turn the gaps into priorities and budgets, use the skills gap analysis template.
- To close a one-person skill, plan cross-training between shifts.
- For licensed tasks in Australian workplaces, read about verification of competency.
- Before an audit, check the records behind the matrix with a training audit.
Coursebox issues a certificate automatically when someone completes a course. Its reports export who completed what, and when, as a CSV you can copy into the ticket log. It doesn't put an expiry date on certificates or send renewal reminders, so keep expiry dates in the matrix.
The download is version 1.1 (20 October 2026), checked in Excel for Windows. It supports 20 people, 12 skills and 100 evidence records; added rows or columns need extended formulas and validation. Google Sheets, LibreOffice and Excel for Mac have not been tested.
Keeping your skills matrix current
A useful matrix connects the work, the required standard and the evidence behind each rating. Keep the skill ratings and record dates current, then use the gaps to plan specific action. Check the roster before treating a whole-team total as available cover.
Review it every three months and before every roster change. To build the training that closes your gaps and keep a record of who completed it, start with Coursebox's HR training software.
Frequently Asked Questions
List the tasks across the top and people down the side. Define a rating scale, record task evidence and set the required level and whole-team headcount. Keep required licence, certificate or assessment dates alongside the ratings. The template calculates counts; check the evidence and roster before assigning work.
This template uses 0 for not trained, 1 for learning, 2 for working with support, 3 for meeting the standard without prompting and 4 for being able to train others. Agree evidence for each level. Other matrices use different scales, and level 4 does not authorise formal assessment.
The terms overlap. A skills matrix commonly rates people against tasks, while a competency matrix may define what each role requires or assess people against broader competencies. Define what your own matrix records before using it.
Include the person, required training, completion or assessment date, expiry or review date and a reference to the evidence. Where there is no expiry, record that explicitly. Course completion alone does not establish competence for a task.
Update it when people, roles, task standards or evidence change. Set a regular review suited to your work; quarterly is a starting point. Check it before roster changes, and arrange renewals before required records expire.
Alex Hey
Alex Hey is a technical marketer with 10 years of hands-on growth and digital marketing experience. He cofounded Coursebox together with Travis Clapp who he met online when looking for a cofounder to build a globally impactful software product. He works in the Perth, Western Australia office as the COO. He built the world's first automated funnel for patient recruitment before building Coursebox. After launching Coursebox in mid 2023, he drove +400k organic sign ups for Coursebox. Alex leads the marketing and digital growth of Coursebox and works with the product development team bringing a passion for data-driven product decision and exceptional user experience. Alex is determined to build the world's easiest way to build the perfect course.
