Skills Gap Analysis: A Step-by-Step Framework (Free Template)

Last updated: July 2026.

Every HR and L&D leader has said some version of this sentence: "We know we have skills gaps, we just don't know exactly where." It's the most expensive kind of not knowing, because it means training budget gets spent on whoever asks loudest, not on the gaps that actually move the business.

A skills gap analysis fixes that. It's not a mysterious consulting deliverable. It's a repeatable method: define what good looks like, measure where people actually are, calculate the distance, and spend your training budget on the distance that matters most.

This guide gives you the full method, a copy-and-use template, and an honest answer for what to do once you've found the gaps (because finding them is the easy part).

Key takeaways

• A skills gap analysis compares required skill levels against current skill levels and turns the difference into a prioritized list, not a vague impression.
• The core tool is a skills matrix: people or roles as rows, skills as columns, a proficiency score in every cell.
• Prioritize gaps by gap size multiplied by business criticality, not by whoever complains loudest.
• Self-reported skill levels are a starting point, not a finish line. Pair them with an actual assessment where you can.
• Closing a gap works best in small, spaced, targeted doses in the flow of work, not a single course dump.
• Kirkpatrick's four levels give you a way to prove the gap actually closed, not just that a course got completed.

What is a skills gap analysis?

A skills gap analysis is the process of measuring the difference between the skills a role requires and the skills the person in that role currently has, then using that difference to decide where to spend training time and budget.

It answers three questions at once: what do we need, what do we have, and what's the fastest, cheapest way to close the distance between them. Done well, it replaces guesswork with a ranked list. Done badly, it's a spreadsheet nobody opens after the kickoff meeting.

The output isn't just a report. It's a decision tool: which skill do we train first, who needs it most, and how will we know it worked.

Skills gap analysis vs training needs analysis

A skills gap analysis measures the size of the gap. A training needs analysis asks whether training is even the right fix for that gap.

They overlap but they're not the same exercise. A skills gap analysis can tell you that half your managers score a 1 out of 4 on "giving direct feedback." A training needs analysis goes one step further and asks why: is it a skills problem (they don't know how), a motivation problem (they know how but avoid it), or a process problem (there's no structured 1:1 cadence to practice it in). Sometimes the fix isn't a course at all, it's a template, a checklist, or a changed process. Run the skills gap analysis first. It's the input the training needs analysis reasons from.

The 6-step skills gap analysis framework

Here's the method, start to finish. Each step builds on the last, and you can run the whole thing with a spreadsheet if you have to (the template below gives you exactly that).

1. Define the target skills. For each role or team, list the 4 to 8 skills that actually determine performance. Resist the urge to list twenty. A long list dilutes focus and nobody finishes rating it.
2. Set the required level for each skill. Not every skill needs to be a 4 out of 4 for every person. A junior analyst might need a 2 on "financial modeling" while a finance manager needs a 4. Required level is role-specific, not universal.
3. Measure current levels. This is where most skills gap analyses go wrong. Self-ratings alone are unreliable (everyone thinks they're a 3). Combine self-assessment with a manager rating, a real skills assessment, or observed work output wherever you can.
4. Calculate the gap. Gap equals required level minus current level. A person who needs to be a 4 and measures at a 2 has a gap of 2. Someone who needs a 3 and measures at a 3 has no gap, even if their raw score is lower than the first person's.
5. Prioritize the gaps. Not all gaps deserve the same urgency. Score priority as gap size multiplied by business criticality (how much this skill affects revenue, risk, or delivery right now). A gap of 3 in a skill nobody uses this quarter is lower priority than a gap of 1 in a skill blocking a live project.
6. Build the action plan. For each prioritized gap, assign an owner, a method (a course, a stretch assignment, coaching, a mentor), and a review date. A gap without an owner and a date is just a finding, not a plan.

The free template

Copy the three tables below into a spreadsheet and you have a working skills gap analysis, no software required.

1. Skills matrix

Rows are people or roles. Columns are the skills that matter for this team. Each cell is a proficiency score.

Proficiency scale (0 to 4):

• 0, Not yet started. No practical exposure to this skill.
• 1, Aware. Understands the basics but hasn't applied it independently.
• 2, Developing. Can apply the skill with guidance or in familiar situations.
• 3, Proficient. Applies the skill independently and reliably.
• 4, Expert. Applies the skill in complex situations and can coach others in it.

2. Gap score method

For each cell, subtract current level from required level. A negative or zero result means no gap.

Gap = Required level minus Current level

Priority score = Gap size multiplied by business criticality (rate criticality 1 to 3, where 3 is highest impact this quarter)

Example: Marcus needs a 4 in negotiation for an upcoming vendor renewal (criticality 3) and currently scores a 1. Gap is 3. Priority score is 3 times 3, which is 9. That outranks a gap of 3 in a skill with criticality 1 (priority score 3).

3. Action plan

Adjust the skills, scale, and criticality weighting to match your team. The structure is what matters: define, measure, calculate, prioritize, assign, review.

How to close the gaps without buying another course library

The honest answer is that most skills gaps don't close because someone finished a course. They close because someone practiced the skill in small, repeated doses close to the moment they actually needed it.

A single eight-hour negotiation course, taken once, mostly fades within weeks. A ten-minute exercise on negotiation, delivered the day before an actual negotiation, spaced again a week later, sticks because it's tied to real use. The research on spaced repetition and forgetting curves backs this up consistently: distributed practice beats massed practice for retention.

This is also why buying a bigger course catalog rarely fixes a real skills gap. The gap in the example above isn't "Marcus hasn't taken a negotiation course." It's "Marcus needs to get better at negotiation before a specific vendor renewal in three weeks." That calls for short, targeted, spaced practice aimed at the exact skill and the exact deadline, not a 40-hour catalog he'll never finish.

How to prove you closed the gaps

You'll know a training investment worked if you can show it moved behavior and results, not just that people showed up.

Donald Kirkpatrick's Four Levels of Training Evaluation give you a way to check this honestly:

• Level 1, Reaction. Did people find the training relevant and worth their time?
• Level 2, Learning. Did their knowledge or skill actually increase? This is where your gap score from the template comes back in: measure current level again after the intervention.
• Level 3, Behavior. Are they applying the skill differently on the job, not just in a quiz?
• Level 4, Results. Did the business outcome move? Fewer escalations, faster deal cycles, better retention, whatever the skill was meant to affect.

Most L&D reporting stops at Level 1 (satisfaction surveys) because it's the easiest to collect. The skills gap analysis you just ran gives you a clean Level 2 baseline for free: re-run the same matrix in three months and compare the scores.

How Omie automates this

Omie is built to run this exact framework without the spreadsheet maintenance.

A Learning Scan baselines each person's actual current level on the skills that matter, rather than relying only on a self-rating. Bayesian Knowledge Tracing models mastery over time as people complete real work, so the "current level" column updates itself instead of going stale the week after you filled it in. A skills matrix view rolls individual scores up to team and org level, so managers and HR see the gap picture live instead of rebuilding it every quarter.

Once gaps are visible, the recommender assigns targeted nuggets (short, focused lessons, ten minutes or less) aimed at the specific skill and specific gap size, delivered in the flow of work rather than as a separate course to schedule. Managers track progress through a dashboard that shows movement on the actual gaps, not just completion counts.

Omie's Business plan is $15 per seat per month and includes the manager dashboard with a Kirkpatrick Level 1 through Level 4 rollup, plus SSO. It's a web app and a mobile app on the same account, so the data stays current whether someone's at a desk or between meetings.

If you want to see your team's actual current levels rather than guessing, run a Learning Scan to baseline where people stand today. If you're comparing options for the whole team, see how team plans roll this up.

For more on the tools that make this repeatable: how a skills matrix works as the living version of the template above, why some skills matrices break down, how to tie skills work to OKRs so gaps map to business goals, how L&D teams prove ROI with Kirkpatrick, the formulas for calculating learning program ROI, and how AI is changing corporate L&D more broadly. If AI skills are your biggest gap this year, building a workforce AI-skills program applies this same method to AI, and learning in the flow of work explains how to deliver the fixes without pulling people off the job. If you're deciding what platform to run any of this on, see the case for Omie or compare pricing.

FAQ

What is a skills gap analysis?

A skills gap analysis is the process of comparing the skills your team currently has against the skills your team needs, then quantifying the difference so you know exactly where to invest training time and budget. It turns a vague feeling of "we're not ready" into a ranked list of specific gaps.

How do you conduct a skills gap analysis?

Define the target skills for each role, set the required proficiency level for each skill, measure everyone's current level with a real assessment (not a guess), calculate the gap between required and current, prioritize gaps by size and business impact, then build an action plan that assigns who closes which gap and how.

What is the difference between a skills gap analysis and a training needs analysis?

A skills gap analysis measures the distance between required and current proficiency for specific skills, usually role by role or team by team. A training needs analysis is broader: it looks at gaps plus root causes (is this a skills problem, a motivation problem, or a process problem) before recommending training as one possible fix among several.

How often should you run a skills gap analysis?

Run a full skills gap analysis once or twice a year, aligned to planning cycles, and refresh individual skill data continuously if you can. A static matrix from eighteen months ago is closer to fiction than fact. Continuous, low-effort measurement (like a short recurring scan) beats a once-a-year spreadsheet sprint.

Get your personalised lesson today — free for 14 days.