Spot Your Team's Skills Gap
A skills gap stays invisible until your best person quits. Here's how to run a skills audit and map your team's capability before it costs you.
A curated set of 25 spreadsheets for the people who run people. Map your team's capability on a skills matrix, find what's missing with a gap analysis, and settle who owns what with a RACI matrix — your team's capability and risk on one grid, not buried in someone's head.
Most teams carry their capability in their heads — who can cover what, who's the only one who knows the process, where the next gap will open when someone leaves. A skills matrix puts that on a single grid you can actually act on: spot key-person risk, plan training, and make the case for a hire with evidence instead of a hunch. For task-by-task coverage on a line or shift, an ILUO matrix records who is signed off to run each task alone — and flags the ones only one person can.
Pair it with a gap analysis to see the distance between where the team is and where it needs to be, and a RACI matrix to make responsibilities unambiguous across a project or a reorg. To map the seats you can't afford to lose, a succession plan scores each critical role's bus factor and flags your single points of failure. When people do leave, an exit-interview & turnover-analytics workbook turns each departure into a trend — your turnover rate by team and manager, the regrettable split, the reasons people go, and the cost of turnover; capture one exit free with the exit-interview form, or see how it compares to HR analytics software. And when it comes to pay, set salary bands and check compa-ratio and pay equity in a workbook you own, instead of a per-seat compensation platform. And to keep the day-to-day covered, a PTO & absence tracker logs who's off and flags when a shift runs short — see what PTO accrual means, or how a tracker compares to HR leave software.
When it's time to hire, interview on evidence rather than a gut feeling: a structured interview asks every candidate the same questions and scores them like-for-like, and an interview scorecard & question bank ranks your slate and recommends a hire — see how it compares to ATS software. Once you've made the hire, give them a strong start: a 30-60-90 plan maps a new starter's first three months into goals, owners, and check-ins — the onboarding end of the funnel that begins with a job applicant tracker.
And to point the whole team at the same quarter, set OKRs — objectives and key results scored each cycle — in an OKR & Goal-Setting Workbook that rolls every team up to one company view, instead of a per-seat goal-tracking app. Then keep the thread with each person in a one-on-one: a 1:1 Meeting & Goal-Tracking Workbook logs every meeting, carries action items forward, and tracks whether goals are on pace — instead of a per-seat performance-management platform.
Recommended templates
25 templates
Skills matrices, gap analysis, a RACI matrix, and PTO & coverage tracking — in Excel and Google Sheets.
A 9-tab skills matrix for Excel & Google Sheets: score your team 0-5, find the skills gaps, and flag single points of failure before someone resigns.
A competency matrix and framework builder for Excel & Google Sheets — define role targets, score your team 1–5, and see every competency gap.
A structured interview scorecard for Excel & Google Sheets — score every candidate on the same competencies, auto-rank your slate, plus 100+ questions.
A 9-box talent grid for Excel & Google Sheets — score performance and potential, auto-place each person, and see succession risk on one grid.
A stay-interview & retention-risk tracker for Excel & Google Sheets — score flight risk and impact, auto-rank who to keep, and track the action for each.
An exit-interview and turnover-analytics workbook for Excel & Google Sheets — log departures and see turnover rate, regrettable split, reasons, and cost.
A weighted performance review template for Excel & Google Sheets — score your team on shared criteria and calibrate the rating distribution.
An OKR workbook for Excel & Google Sheets — set objectives and key results, score progress 0.0–1.0 each cycle, and roll every team up to one company view.
A 1:1 meeting & goal-tracking workbook for Excel & Google Sheets — log every one-on-one, carry action items forward, and track goal pace across your team.
A 30-60-90 onboarding plan for Excel & Google Sheets — plan and track every new hire's first 90 days with goals, check-ins, and a progress dashboard.
Staff up for a peak without over- or under-hiring: a workbook that sizes seasonal headcount from your forecast, times the hiring ramp, and costs the season.
A mentorship program tracker for Excel & Google Sheets — pair mentors and mentees, set goals, log sessions, and see outcomes on one program dashboard.
A succession-planning & key-person-risk workbook for Excel & Google Sheets — score criticality and coverage to map your single points of failure.
A pay-band & pay-equity workbook for Excel & Google Sheets — set salary bands, compute compa-ratio and range penetration, and screen pay equity.
An ILUO skills matrix for Excel & Google Sheets — track each operator's level on every task, see coverage at a glance, and flag key-person risk.
A training-needs analysis workbook for Excel & Google Sheets — rate skills 0–4, rank the gaps by priority, and turn them into a costed training plan.
A safety-training & toolbox-talk tracker for Excel & Google Sheets — automatic refresher expiry, color-coded status, and audit-ready compliance dashboard.
An apprenticeship & OJT training-hours logbook for Excel & Google Sheets: log hours by competency, capture sign-offs, and track completion readiness.
A cross-training and coverage planner for Excel & Google Sheets — set a coverage target per task, see the gaps, and get the pairings to close them.
A PTO and absence tracker for Excel & Google Sheets — log leave once, see each person's balance, and a team calendar that flags coverage clashes.
A shift schedule and labor-cost workbook for Excel & Google Sheets: staff the week, price the hours, and check labor cost against your sales target.
Most strategy decks describe goals. They skip the gap. This excel gap analysis template forces the conversation: current state, future state, gap, and the actions to close it.
Your last strategy review listed goals. Did it tell you what to fix first? This google sheets gap analysis template ranks every gap by priority and status with live charts.
A RACI chart isn't paperwork. It's how you spot the person you're about to burn out. Excel RACI matrix template with a live workload view per resource.
Is anyone on your team quietly drowning under the work? This google sheets raci matrix template doubles as a raci chart template with a live workload view.
Where we fit
Most tools force a choice between a blank spreadsheet you build from scratch and a monthly app that's overkill. Ardent Workshop is the rung in between — structure you own.
Free, but you build and maintain every formula, tab and layout yourself.
Owned, structured, connected workbooks — a one-time price, yours to keep.
Powerful, but overkill, rented and locked-in — built for someone bigger than you.
Reading list
Manager-facing playbooks for mapping your team's capability and spotting the gaps before they become emergencies.
A skills gap stays invisible until your best person quits. Here's how to run a skills audit and map your team's capability before it costs you.
How small shops set fair pay for a first employee: read the market, build a simple pay range, and budget the real cost beyond the hourly wage.
A three-person shop needs a handbook—not a corporate binder. Here's what actually goes in one, and how to write it in an afternoon.
The annual performance review is quietly dying — and small teams have the least reason to keep it. Here's what's replacing it in 2026, and how to run it.
Why small-team managers in 2026 ask employees 'why do you stay?' before they quit — how stay interviews work and why they beat exit interviews.
The 9-box grid maps your team by performance and potential on one page. Here's how a talent review actually works—and how to run one.
You hired help — now what? A first-time boss's guide to running a simple, useful one-on-one with your first employee, without the awkwardness.
Your most reliable employee is often your team's biggest single point of failure. Here's how to find your bus factor and lower it before someone leaves.
Build a vacation coverage plan for your small team in one afternoon: sort the work into three buckets, name backups, and stop dreading time-off requests.
How to hire seasonal staff before your fall rush: size peak-week headcount, work the hiring ramp backward from opening day, and budget the real cost.
Skills-based hiring is 2026's loudest trend — but most companies only announce it. Here's how managers actually hire for skills, not degrees.
Hiring your first helper after years working solo? How to onboard them well—the first week, the slow start, and a system to train without losing your rush.