A company skills matrix can become an excellent decision-making tool. It can also end up in a spreadsheet nobody opens. The difference does not lie in the number of rows, the software chosen or the precision of the colours. It lies in the starting question: does the matrix really describe what employees must achieve in their work?
General labels such as “leadership”, “AI mastery”, “customer communication” or “project management” are not enough. They say neither in which situation the skill is used, nor what result is expected, nor how a manager can observe success. A usable matrix therefore starts from activities and work situations before formalising skills, levels and training needs.
Key takeaway: a skills matrix links five elements: a work situation, an expected action, a level of autonomy, success criteria and evidence. If one of these is missing, the row remains hard to use for training, assessing or deciding.
What Should a Company Skills Matrix Be Used For?
Before creating the file, define the decision it must inform. The same organisation can use a matrix for several purposes:
- identify gaps between the skills available and the skills needed;
- prioritise the skills development plan;
- adapt a pathway to several profiles without creating a different programme for each person;
- prepare a move, a job change or a reorganisation;
- secure a critical activity that depends on a few experts;
- choose a coherent teaching method: coaching, training, mentoring, practical scenarios or digital resources;
- assess learning and transfer at work.
This purpose determines the level of detail. To build an annual plan, around twenty critical skills may be enough. To organise versatility on a production line, the matrix will have to go down to specific operations. To prepare a management pathway, it will describe situations such as conducting an interview, arbitrating a conflict or announcing a decision.
A matrix must therefore not try to represent everything. It must make a decision more reliable.
Why Start From Work Situations?
France compétences places work analysis upstream of the construction of frameworks. The logic is sequential: the activity framework describes situations and activities; the skills framework formalises what must be mobilised to carry them out; the assessment framework specifies how mastery will be verified. Reversing this order often produces abstract lists detached from the job.
A work situation provides the context that gives a skill its meaning. “Communicating clearly” does not mean the same thing when presenting an incident to a management committee, explaining a technical gesture to a newcomer or answering an unhappy customer. The verb seems close, but the interlocutors, constraints, risks and proof of success change.
The France compétences framework on learning in work situations also recommends a structured analysis of activities, based on documents, expert interviews, exchanges of practice and the identification of critical or complex situations. This approach avoids confusing the job description, which describes a scope, with real work, which contains trade-offs, surprises and sometimes implicit quality criteria.
The Eight Essential Columns of the Matrix
A simple template can fit in eight columns. Other fields can be added later, but this structure is enough to link work analysis, training and assessment.
| Column | Question to address | Example |
|---|---|---|
| — | — | — |
| 1. Population or role | Who performs the task? | Front-line manager |
| 2. Work situation | In what context is the skill used? | Giving a warning to an employee after several instances of lateness |
| 3. Expected skill | What action must be performed? | Conduct a factual warning conversation and agree a verifiable commitment |
| 4. Success criteria | What do we observe when the task is done well? | Facts separated from judgements; expectation made explicit; listening; agreement restated |
| 5. Current level | What degree of autonomy is shown today? | Level 2: performs with support |
| 6. Target level | What level is needed for the job? | Level 3: autonomous in a standard situation |
| 7. Criticality | What is the impact of insufficient mastery? | 4/5: social risk and drop in performance |
| 8. Evidence | How can progress be verified? | Simulation then observation of a real conversation with a grid |
Add, if needed, frequency of exposure, number of employees concerned, the skill owner, the date of the last assessment and the development action chosen. Avoid turning the matrix into an exhaustive HR database from the first version, however.
A Mastery Scale That Describes Autonomy
“Beginner, intermediate, expert” scales seem intuitive, but different assessors interpret them differently. A behavioural scale reduces this ambiguity.
| Level | Common descriptor | Validation question |
|---|---|---|
| — | — | — |
| 0 — Not assessed | No evidence available or no exposure to the situation. | Has the person ever had the chance to perform the task? |
| 1 — Discovery | Identifies the steps and performs part of the task with close guidance. | Do they understand what to do and why? |
| 2 — With support | Performs the routine task with a procedure, template or validation. | Can they produce an acceptable result with support? |
| 3 — Autonomous | Performs the routine task, checks their result and handles foreseeable difficulties. | Can they act without systematic supervision? |
| 4 — Adaptable | Handles complex or new situations, explains trade-offs and adjusts their method. | Can they act when the context goes beyond the usual scenario? |
| 5 — Reference person | Improves practices, supports others and contributes to standards. | Can they help the group progress without becoming the single point of dependency? |
Level 5 is not the default target. Level 3 can be perfectly suited to a routine task. The right target is the level sufficient to reach the expected quality with controlled risk.
Building the Matrix in Seven Steps
1. Define the scope and the decision
Start with a limited population, process or issue: sales team, front-line managers, rolling out a new tool, customer service or the move to generative AI. State the expected decision: select priorities for the next six months, build a pathway, reduce a dependency or prepare a move.
2. Collect data on real work
Cross-check several sources: job descriptions, procedures, objectives, incidents, deliverables, observations, interviews with managers and with job holders, and customer feedback. A needs-gathering questionnaire adds useful information on perceived difficulties, experience, autonomy, objectives and suitable forms of assessment.
Five questions to ask during the interview
- Which situations take the most time or generate the most errors?
- Which tasks can be entrusted to only one or two people?
- What does an experienced employee do differently?
- What unexpected event distinguishes routine execution from true mastery?
- What evidence would convince you that a person can act alone?
3. Select the critical situations
A critical situation is not necessarily frequent. It may be rare but have a strong impact: a security incident, a strategic negotiation, a regulatory inspection or a customer crisis. Rank situations along four dimensions: impact, frequency, variability and dependence on a few experts.
4. Turn each situation into a skill
Use a wording made of a verb, an object, a context and a standard. For example:
- Too vague: master feedback.
- Usable: conduct corrective feedback based on observable facts, check understanding and agree a monitored action.
- Too vague: use ChatGPT.
- Usable: produce a first version of a sales email with an AI tool, check the facts and remove confidential data before human validation.
5. Define criteria and evidence
Criteria describe the expected quality. Evidence shows that those criteria are met. For a conversational skill, use a simulation or an observation. For a production, compare a deliverable with a grid. For a tool skill, have a complete task performed and check the quality of the result. For a decision skill, ask the person to make their assumptions and trade-off explicit.
Self-assessment can prepare the diagnostic, but it must not be the only evidence. Cross-check it with a case, a deliverable, an observation or the view of a manager trained in the criteria.
6. Assess the current level and set the target
Assess a sample of situations first, then calibrate the assessors. Two managers must understand in the same way what distinguishes level 2 from level 3. The target depends on the job, the criticality, the margin for error and the support available. It does not always correspond to the maximum level.
7. Prioritise and have the business validate it
The simple gap between current and target level is not enough. A large gap on a secondary task may be less urgent than a small gap on a high-risk situation. Use a score as a basis for discussion:
Priority score = mastery gap × criticality × exposed population.
Frequency and the date of next exposure then help order the actions. The score does not replace judgement; it makes trade-offs explicit.
Have the matrix validated by a small group bringing together HR or L&D, managers, experienced practitioners and, where useful, employee representatives. This validation corrects wording that sounds attractive but is far from the field.
Example of a Cross-Functional Skills Matrix
| Role | Situation | Expected skill | Current / target | Criteria and evidence | Action |
|---|---|---|---|---|---|
| — | — | — | — | — | — |
| Salesperson | Price objection in a meeting | Clarify the objection, link the answer to value and confirm the next step. | 2 / 3 | Question before argument; adapted proof; agreement restated. Recorded simulation. | Workshop, pair practice and manager debrief. |
| Manager | Warning conversation | Describe the facts, listen, state the expectation and agree a commitment. | 1 / 3 | Facts without judgement; shared speaking time; deadline set. Role play then observation. | Short training, conversation template and supported practice. |
| Marketing team | AI-generated publication | Give a usable instruction, check the content and secure the data. | 2 / 4 | Sources checked; no sensitive data; tone compliant. Audit of a deliverable. | Business case, AI charter and validation checklist. |
| Project manager | Alert about a delay | Assess the impact, propose options and obtain a documented decision. | 3 / 4 | Risk quantified; options compared; decision traced. Case then real report. | Complex simulation and lessons-learned review. |
| Customer service | High-stakes complaint | Rephrase, explain the solution, announce follow-up and record the agreement. | 3 / 3 | Request understood; precise deadline; complete record. Sample of anonymised files. | Maintenance through quarterly calibration. |
The last row is a reminder that a matrix is not only used to spot deficits. It also identifies skills already at the expected level, experts who can be mobilised and practices to maintain.
From Matrix to Training Pathway
The matrix becomes useful when it changes the choice of actions. Not every gap is a training matter. A missing procedure, a badly configured tool, an incompatible workload or an unclear responsibility will not be corrected by a teaching module.
| Dominant cause of the gap | Possible response |
|---|---|
| — | — |
| Missing knowledge | Short resource, course, demonstration or method sheet. |
| Gesture or method not automated | Progressive exercises, repetition, feedback and practical scenarios. |
| Difficulty handling the unexpected | Varied scenarios, complex simulation and reflective debrief. |
| Lack of confidence despite an acquired skill | Safe practice, mentoring and gradual increase in autonomy. |
| Blocking work environment | Clarifying the process, adapting the tool, managerial or organisational arbitration. |
| Rare skill held by one expert | Pairing, mentoring, formalisation and supported practical scenarios. |
The pathway must reuse the matrix’s criteria. If the expected skill is handling a sales objection, the final assessment cannot be limited to a quiz on the stages of selling. It must include an objection, an answer, a simulated customer and a next step to obtain. That is how the matrix feeds a genuinely steered skills development plan.
Running a Two-Hour Mapping Workshop
| Duration | Step | Deliverable |
|---|---|---|
| — | — | — |
| 15 min | Clarify the scope, the stakes and the decision. | Population and objective of the matrix. |
| 25 min | Have people tell the routine, critical and new situations. | Inventory of 10 to 20 situations. |
| 25 min | Select the priority situations. | Short list ranked by impact. |
| 30 min | Formulate skills and observable criteria. | First rows of the matrix. |
| 15 min | Define target levels and evidence. | Scale and assessment methods. |
| 10 min | Assign follow-ups and validation. | Owners, deadlines and next review. |
Prepare the workshop with a few documents and two or three examples of deliverables. After the session, have the wording reviewed by people who actually do the work. This step prevents the matrix from reflecting only management’s view.
How to Keep the Matrix Up to Date
A matrix quickly becomes obsolete if nobody owns it. Assign an owner to each family of skills and set a six-monthly or annual review. Also trigger a review when a tool, a process, a regulation, a market or a responsibility changes.
Follow-up can stay light:
- date of the last validation of the skill;
- most recent evidence;
- current level and target level;
- action decided;
- owner and deadline;
- comment on how the work situation is changing.
Do not reassess the whole organisation at every cycle. Concentrate on the situations whose criticality, gap or context has changed.
Mistakes That Make a Matrix Unusable
Listing themes rather than skills
“Communication”, “Excel” or “management” are domains. A skill describes an action in a context and with a standard.
Confusing absence of evidence with absence of skill
Level 0 should mean “not assessed”, not “incapable”. A person may master a task without yet having supplied the evidence expected in the organisation.
Setting the target level at the maximum
Not everyone needs to be a reference person. This practice artificially inflates gaps and scatters the training budget.
Assessing only through self-positioning
Self-positioning tells you about perception and confidence. It must be complemented by a task, a production or an observation.
Turning every gap into training
The cause may be organisational, technical or managerial. Diagnose before prescribing.
Building a matrix that is too large
Start with the most important decisions. A short, validated, used matrix is worth more than an exhaustive framework that is abandoned.
FAQ — Company Skills Matrix
What is the difference between a matrix, a skills map and a competency framework?
The framework defines skills and their criteria. The map gives an overview of the skills needed or available. The matrix generally crosses skills with roles or people, then adds current levels, targets and gaps. In organisations, the terms are sometimes used interchangeably; what matters is to define the function of the document.
Should the matrix be built by job or by person?
Start with roles and work situations to define expectations. Then add people when the purpose requires an individual diagnostic, a pathway or a succession plan. This sequence avoids adapting criteria to each person’s profile.
How many skills should be included?
There is no universal number. For a first pilot, five to fifteen critical skills per population are often enough to make decisions. Add rows only if they provide a useful distinction.
Can an Excel matrix be used?
Yes. A spreadsheet is perfectly adequate to start, provided it allows filtering, dating and documenting evidence. Dedicated software becomes useful when populations, access rights, histories and validation workflows become complex.
Who should assess skills?
Depending on the skill: the manager, a qualified peer, a trainer, a subject-matter expert or an external assessor. Assessment is more reliable when criteria are shared, assessors are calibrated and several pieces of evidence can be cross-checked.
How do you link the matrix to the skills development plan?
Group the priority gaps by population and situation, then choose the action suited to their cause. The matrix provides the objectives, targets and assessment criteria; the plan organises the pathways, schedule, budgets and responsibilities.
Is a skills matrix enough to prove the effectiveness of training?
No. It formalises what is expected and the starting point. You then need to collect evidence after training and, if possible, in a comparable work situation. Progress and transfer must be distinguished from mere attendance.
How do you create a skills matrix?
To create a skills matrix, list the work situations, define for each skill a level of mastery and observable criteria, assess each employee’s current skill level, then identify the gaps to close. An Excel spreadsheet is enough to start; skills management software becomes useful when teams and levels multiply.
Where can you find a skills matrix template?
The eight-column table presented in this article can serve as a skills matrix template: copy it into a spreadsheet, add the scale of skill levels (0 to 5) and a dashboard to follow the gaps. The key skills of each role are deduced from work situations.
Turning Real Work Into a Development Pathway
Marmignon Brothers supports companies in analysing critical situations, formalising skills, building a readable matrix and converting priority gaps into assessable pathways. The approach can cover professional English, artificial intelligence, management, sales, digital marketing or cross-functional skills: discover our tailor-made professional training and our AI training for companies to map AI skills by job.
Request a mapping workshop to turn your work situations into a usable matrix.
Sources and References
- France compétences, Vademecum on professional certification, January 2026: analysis of work situations and the link between activity, skills and assessment frameworks (in French).
- France compétences, Framework “Supporting learning and training in work situations”: work analysis methods, positioning, learning situations and evidence (in French).
- French Ministry of Labour, The skills development plan (in French).
