-
Excel workbook preview
Learning, Training and Development
Skills Matrix Template
3 downloads per free account, no card needed.
Who this is for
A line manager asked by HR for the team's skills gaps before the training needs analysis, or by an auditor who wants to see cover for key tasks.
What is inside
- 10 sample team members by 8 skills, 4 of them O*NET skill names credited under CC BY 4.0
- Required level row; cells below it turn red and at or above it turn green
- Live gaps, skills at required level and coverage % per person (amber below 75%)
- Team Summary sheet flags any skill with fewer than 2 people at level 3 or 4 as At risk
- Levels sheet defining the 0 to 4 scale in plain words
- 20 blank rows, 0 to 4 dropdowns, frozen header and filter
How to use it: Replace the 8 skill names and the required levels in row 4 with your team's, then enter each person's level after a short conversation with them.
Files & formats
- XLSXskills-matrix-template.xlsx12 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves. These templates are original working documents built on the public law or guidance named here. They are not legal advice and are not endorsed by the government body or publisher.



