Skills gap assessment toolkit

Know exactly where your team's skill gaps are, and what to do about them.

A ready-to-use toolkit for managers, HR, and L&D teams in any industry. Define the skills that matter, collect honest ratings, and get a prioritized action plan, with the spreadsheet doing the math.

Works in any industry Excel & Google Sheets Instant download
Spider chart comparing a team's average skill levels with target levels across ten skills
The Skill Radar: your team vs. target, filterable by skill category
The problem

Most teams don't know where their skill gaps are until something breaks.

1

Someone leaves, and you find out they were the only one who knew how to do something critical.

2

Training budget goes to whatever course is popular, not what your team actually needs.

3

You're asked to justify headcount or development spend, and all you have is a gut feeling.

4

New tools, regulations, or customer demands arrive, and you're not sure who's ready.

Skills gap assessments fix this. But most are either expensive consulting projects or generic quizzes that don't fit your team.

The solution

A proven method, packaged so you can run it yourself.

I built this method running skills assessments with my own team. It's the same process: define what the team needs, rate where people are today, calibrate honestly, and turn the gaps into a plan people actually follow.

[One sentence about a real result, e.g. "The first time we ran it, we found two critical processes depended on one person, and fixed both within a quarter."]

Now it's a complete toolkit, with every guide, form, and spreadsheet you need to run it in 2–4 weeks.

How it works

Four steps from guesswork to a plan.

Define

Choose 8–15 skills your team needs over the next 12–18 months, from a library of 20 ready-made skills plus your own.

Assess

Team members rate themselves, and managers rate independently, on a clear 0–4 scale with real examples.

Calibrate

Short conversations turn two opinions into one honest rating. The workbook flags where to focus.

Act

The workbook ranks your gaps by priority. The playbook helps you build, borrow, buy, or bridge each one.

See the results

Your team's gaps, at a glance.

Enter the ratings. The workbook does the rest.

Dashboard with readiness score, single points of failure, and top five priority gaps
Priority Dashboard: readiness score, single points of failure, and your top 5 gaps, ranked.

Shown with sample data from a fictional 10-person team. The sample workbook is included, so you can explore it before you start.

What's inside

Everything you need, nothing you don't.

πŸ“˜

Facilitator Guide

The step-by-step method, with an announcement email, calibration agenda, and common pitfalls.

🧭

Competency Framework

A 5-level proficiency scale, 20 ready-made skills, and a builder for role-specific skills, with examples from 9 industries.

πŸ“

Assessment Forms

Self-assessment, manager rating, evidence guide, and calibration worksheet. Ready for Google or Microsoft Forms.

πŸ“Š

Skills Matrix Workbook

Enter ratings and get gaps, coverage risks, a ranked priority list, a spider chart, and a heatmap.

πŸ“ˆ

Sample Workbook

A completed example, so you can see what finished results look like before you begin.

πŸ“„

Gap Report Template

A ready-to-fill report for leadership, plus private one-page summaries for each team member.

🎯

Action Playbook

Build, Borrow, Buy, or Bridge: development activities for every level, a 90-day plan, and individual plans.

πŸ“₯

Google & Microsoft formats

Google Sheets, Docs, and Forms copies, plus Excel and Word files and PDF guides.

πŸ”„

Built to repeat

Re-run it in 6–12 months with the same skills and scale, and show leadership the progress.

Who it's for

Built for any team, in any industry.

  • Managers and team leads who want a clear picture of their team's skills
  • HR and L&D professionals who need a repeatable assessment process
  • Leaders who need to justify training or hiring decisions with data
  • Teams preparing for growth, new technology, or a reorganization

Works for teams in…

HealthcareManufacturingTechnology SalesFinanceRetail & hospitality EducationNonprofitProfessional services

You choose the skills that matter to your team, so it fits wherever skills matter.

Built from real experience

Not theory. A method that's been run for real.

[Your Name], founder of AppyPaths

[2–3 sentences in your own words: how long you've managed teams, why you started doing skills assessments, and one concrete result.]

Every part of this toolkit comes from running it: the forms people actually fill in, the calibration questions that settle disagreements, and the action plans that actually get done.

Pricing

Choose your toolkit.

Founding buyer offer: 40% off for the first 25 buyers. In exchange, I'll ask for 10 minutes of feedback after you run your first assessment.

Essentials
For trying the method with one team.
$47$79
Founding price
  • Facilitator Guide
  • Competency Framework
  • Assessment Forms
  • Skills Matrix Workbook
Get Essentials
Team License
For HR teams and multi-team organizations.
$359$599
Founding price
  • Everything in Complete
  • Use across multiple teams
  • 60-minute Quick Start Call
Get Team License
Instant downloadExcel & Google Sheets versionsLifetime access to updates
Need a hand?

Want expert support?

Run it yourself with the toolkit, or bring me in for the hardest parts: building your skills framework, running calibration, or writing the report. Toolkit buyers get [X%] off any consulting service.

FAQ

Questions, answered.

Does this work for my industry?

Yes. You choose the skills that matter for your team. The framework includes 20 universal skills, a template for writing your own role-specific skills, and worked examples from 9 industries.

Do I need Excel?

No. The workbook works in Microsoft Excel and Google Sheets. All guides come as PDFs and editable Word or Google Docs files.

How big a team does it work for?

Teams of 3–50. The workbook handles up to 20 skills and 25 people per file. For larger groups, use one file per team.

How long does an assessment take?

2–4 weeks from start to finish, or about 8–12 hours of your time for a team of 10. Each team member spends about 20 minutes on their self-assessment, plus a 30-minute conversation.

Will my team think this is a performance review?

Not if you follow the guide. It includes an announcement email and ground rules that make clear this is about development, which is what gets you honest answers.

Is my team's data private?

Yes. Everything runs in your own spreadsheet and forms. Nothing is sent to me or any third party.

Can I use this with my own clients?

The standard licenses cover use within your own organization. If you're a consultant or coach and want to use it with clients, email me about a Consultant License.

Your team's skill gaps already exist.
Now you can see them.

Get the toolkit and run your first assessment in 2–4 weeks.