Who can do what, as live data instead of a laminated spreadsheet

Skills, training and competency: three words people muddle

These three terms get tangled because people search for them interchangeably, and most vendors sell them as synonyms. A firm looking for a competency matrix and a firm looking for a training matrix are usually describing the same underlying need from slightly different angles. The muddle is understandable, but it matters, because each word actually answers a distinct question about your people. Here is how the three lines separate once you draw them cleanly.

These are not three separate documents. They are one grid viewed through three lenses: capability, training records, and sign-off. When someone asks for a training matrix or a competency matrix, they usually mean this same artefact seen from the training-records angle or the assessment angle. Picture the anatomy and it becomes concrete: rows are people, columns are skills and certifications, and each cell holds a level or a status plus an expiry date. It sits neatly alongside your standard operating procedures: the SOP says how a task is done, and the skills matrix says who is qualified to do it.

The spreadsheet that quietly runs your business

Every workshop, care home, food factory and engineering firm already runs one of these, whether they call it that or not. Somewhere sits a grid that decides who is qualified for a task, whose certificate is about to lapse, and who is allowed to sign a job off. It usually lives in a single Excel file, one person keeps it up, and it is accurate for roughly one day: the day of the audit. By the morning after, someone has renewed a ticket, someone new has started, and the sheet has already drifted from what is actually true on the floor.

In a regulated trade that drift carries weight. ISO 9001 clause 7.2 asks you to evidence competence, not just assert it. The Care Quality Commission expects care providers to show their staff are trained and competent for the work they do. Food manufacturers work to HACCP and BRCGS. The trades run on live tickets: Gas Safe, NICEIC, the 18th Edition, CSCS. The training records sitting behind all of these are precisely what an inspector or an auditor asks to see first. In that context the matrix stops being admin. It is the thing that says whether a given piece of work can legally go ahead.

Here is what a stale training matrix looks like from the inside.

None of this means anyone is careless. It is what happens when a live operational question keeps being answered by a static file.

From a document to live data

The expiry that goes unseen is not a spreadsheet problem, it is a wiring problem. A cell holding a renewal date does nothing on its own: it waits for a person to look at it, and the previous section showed how rarely that person looks in time. The value of a skills matrix is not the grid you can see, it is what the grid sets in motion once every qualification and expiry date becomes live data the rest of your systems can read. A spreadsheet records that a certificate lapses next month. A live record acts on it.

When your training records and certification dates sit in one connected place rather than a static file, three things start to run on their own.

There is a quieter payoff too. When the skills matrix is the live record your rota and dispatch actually run on, the audit report generates itself from the same data. No scramble, no last-minute rebuild, because the working version and the audit version are the same version.

Choosing a rating scale

A rating scale earns its place only when a level means the same thing to everyone who reads the grid. If one manager treats a 3 as safe to work alone and another treats it as still learning, the skills matrix stops being data and becomes opinion. Pick one scale, write down what each level means, and hold every assessor to that definition rather than leaving cells open to interpretation.

• RAG: red, amber and green for at-risk or not-yet-trained, developing or under supervision, and fully competent. Quick to read at a glance.
• 0 to 4 numeric: from no exposure (0) through to expert or able to train others (4). Good when you want finer gradations.
• ILUO: in-training, under supervision, independent, can-train others. Popular on the shop floor because each letter maps to what a person may actually do unsupervised.

The worked example in the next section uses RAG colour alongside a short status or level, so you can see both the glance value and the precise standing at once.

A filled-in skills matrix: a worked example

Most guides hand you a blank grid and wish you luck. Most skills matrix templates ship empty; this skills matrix example is filled in, so you can see what a live matrix looks like when it carries real dates and real gaps. The team below runs a small electrical and M&E firm. It is an illustrative pattern rather than a real company, but the shape will be familiar to anyone who signs off electrical work.

Reading the colours: green means current or independent, amber means due soon or still under supervision, red means expired or in training, and a blank cell means the person does not hold that skill or ticket.

Now read the story the grid tells at a glance. Marcus's 18th Edition expired last month (the red cell), exactly the kind of lapse that should have booked its own retraining. First Aid at Work sits with Priya alone, so the whole team depends on one person being in for any job that needs a first aider: a single point of failure you can see running down the column. Chloe's EICR cell is blank because she is not signed off yet. One glance down the columns shows you your risks.

Building your first skills matrix

You can start today, in a spreadsheet you already own. The method matters far more than the tool, and a single tab is plenty to begin with. Get the shape right on one page and you can always move it somewhere smarter later.

A starter skills matrix template is just a single spreadsheet tab, and the rows keep filling as people join and get signed off. New starters first land on the matrix during the onboarding that fills it in the first place, so the two records grow together rather than drifting apart.

Reading it for gaps and single points of failure

Most people read a matrix across the rows, checking how skilled one person is. The risk lives in the columns. Read a skills matrix vertically and a column with a single green cell means only one person can do that work: in the electrical contractor example, First Aid at Work sits with Priya alone. A holiday or a resignation, and that column goes dark.

These are the warning signs to look for when you scan downward:

The next two are quieter, but they catch people out just as badly.

A handover is often where a hidden skills gap first surfaces, so read the columns before one forces the issue. The thinnest columns tell you exactly who to cross-train next.

Keeping it current, and when a spreadsheet stops coping

A matrix nobody owns is a matrix that rots. Give it one named owner and a light cadence: a ten-minute review each month, with dates updated as certificates renew rather than saved up for a big annual scramble. Handled that way, your training records stay current in the background, and audit evidence is something you already have rather than something you build under pressure.

The dividing line is simple: a spreadsheet records an expiry, a live system acts on it. Most teams are perfectly fine on a sheet until the day an expiry needs to gate real work, and that is the point where a built system earns its keep. When you reach it, that is what we build.

Turn the matrix into something that acts

A skills matrix earns its place when you treat skills, training and competency as three separate things it tracks, not one blurred column. Its worth is never the document itself: it is what the data sets in motion once a rating drops or a certificate nears its expiry. Start with a spreadsheet and a clear legend, then move to a live system at the point an expiry needs to act rather than sit on a page.