Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesCareers & Job SearchJob Search & InterviewsCareer Skills Gap Analysis

SpreadsheetJob Search & InterviewsFree

Career Skills Gap Analysis

Rate your current skills against your target role, see the gaps by priority and cost out a dated learning plan.

Shown with sample data

Colour

Career Skills Gap Analysis

Rate your current skills against your target role, see the gaps by priority and cost out a dated learning plan.

Role readiness
63%
Share of required skill levels you already meet
High-priority gaps
2
Learning cost still to spend
$1,437
Hours still to invest
167
Weeks to close all gaps
28
At your weekly learning hours
Budget left after plan
$63
Skill gap by skill
  • Product discovery and customer interviews2
  • A/B testing and experiment design2
  • Stakeholder management and influencing2
  • Product management certification2
  • Roadmapping and prioritisation (RICE, opportunity sizing)1
  • Product analytics tools (event-based)1
  • Writing PRDs and user stories1
  • Technical fluency (APIs, system design basics)1
Hours needed by skill area
  • Technical45
  • Domain knowledge42
  • Certification40
  • Leadership16
  • Communication16
  • Tools & software8

How to use it

  1. 1Pull 8 to 15 skills from three or four real job postings for your target role; skills that appear in most postings are the ones that matter.
  2. 2Set the required level from 1 (aware) to 5 (expert) and rate your current level honestly, ideally with a manager or mentor.
  3. 3Mark each skill Critical, Important or Nice to have; Priority calculates from importance and the size of the gap.
  4. 4Write one concrete learning action per gap (a stretch project beats a course), with cost, hours and a target date.
  5. 5Set your weekly learning hours and budget on the Settings sheet and review progress monthly.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Find out exactly what stands between you and your next role. List the skills the target role needs with the level required, rate yourself honestly and say how critical each one is; the sheet calculates every gap, sets a priority, and totals the cost, hours and weeks of learning needed to close them, with a roll-up by skill area and a readiness score you can watch rise.

Who it’s for

  • Planning a move into a new field or function
  • Preparing a promotion case with your manager
  • Choosing which courses or certifications are worth paying for

What’s included

  • Skills sheet: Each skill the target role needs, your gap and the plan to close it.
  • By skill area sheet: Total gap and Hours needed and Cost and the number of entries for each skill area.
  • Settings sheet: Your target role, time and budget.

How to use it

  1. 1Pull 8 to 15 skills from three or four real job postings for your target role; skills that appear in most postings are the ones that matter.
  2. 2Set the required level from 1 (aware) to 5 (expert) and rate your current level honestly, ideally with a manager or mentor.
  3. 3Mark each skill Critical, Important or Nice to have; Priority calculates from importance and the size of the gap.
  4. 4Write one concrete learning action per gap (a stretch project beats a course), with cost, hours and a target date.
  5. 5Set your weekly learning hours and budget on the Settings sheet and review progress monthly.

Tips

  • Use the 70-20-10 rule: most learning comes from doing (stretch assignments), some from people (mentoring, shadowing) and only a little from courses.
  • Close the High-priority gaps first. Two critical skills at the right level will get you further than ten nice-to-haves.
  • Show evidence for each closed gap (a project, a portfolio piece, a certificate) so you can prove it in interviews.

Questions

What is a skills gap analysis?

A comparison of the skills a role requires with the skills you have now. The difference (the gap) tells you what to learn, and ranking gaps by importance tells you what to learn first.

How do I rate my own skill level objectively?

Use a simple scale with descriptions: 1 aware, 2 can do with help, 3 can do independently, 4 can teach others, 5 recognised expert. Ask a manager, mentor or peer to rate you as well and use the lower score if you disagree.

How long does it take to close a skills gap?

It depends on the size of the gap and the hours you can commit. This sheet divides the hours still needed by your weekly learning time to estimate the weeks. Most career moves need three to twelve months of steady effort.

Related searchesskills gap analysiscareer skills gap analysis templatepersonal development planskills assessmentcareer change planlearning plan template

Details

Format
Spreadsheet
Category
Job Search & Interviews
Sheets
3
Setup
25 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetJob Search & InterviewsFree

Career Skills Gap Analysis

Rate your current skills against your target role, see the gaps by priority and cost out a dated learning plan.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Job Search & Interviews
Sheets
3
Setup
25 min
Level
Intermediate
Price
Free

Your copy is private to you.

More job search & interviews templates

View all
Job Offer Comparison3 sheets

Best ongoing total comp

$145,140

Highest-paying option

Offer C: Meridian Bank, Senior Data Analyst

Uplift vs current job

$38,280

ABC
1FactorWeightWhat a 5 looks like
2Role and growth25%Scope you want, a clear path to the next level within two years, visible work
3Manager and team20%A manager who develops people, a team you would learn from, low turnover
4Flexibility and commute15%Hybrid or remote options that suit you, a commute under 30 minutes, reasonable hours
5Job security15%Profitable or well-funded employer, stable demand for the role, no recent layoffs
Weights
SpreadsheetJob Search & Interviews

Job Offer Comparison

Compare your current job and up to three offers on true total compensation and weighted fit, not just base salary.

20 min setupPreview
Work Achievements Log (Brag Document)2 sheets

Wins logged

10

Total annual impact

$295,200

Ready for review

8

ABCD
1DateAchievementCategoryMetric
2Jan 22Automated the weekly sales forecast in the BI tool, replacing a manual spreadsheet processCost & efficiencyHours per week
3Feb 27Redesigned customer onboarding emails and in-app checklist with the product teamCustomer impact30-day churn %
4Mar 18Mentored two junior analysts through their first dashboards; both now own regional reportingLeadership & mentoringAnalysts mentored
5Apr 30Earned a cloud data engineering certification in my own timeLearning & certificationCertifications
Wins
SpreadsheetJob Search & Interviews

Work Achievements Log (Brag Document)

Capture every win with before-and-after metrics and dollar impact, ready for performance reviews, raises and your resume.

15 min setupPreview

Interview Preparation Worksheet

RoleSenior Operations Analyst
CompanyBrightline Health
Interview date and timeTuesday 1 December 2026, 10

1. The role in one sentence

Write what they are really hiring for. If you cannot say it in one sentence, read the posting again.

They need someone to turn messy operational data into decisions that cut patient wait times and staffing costs across 12 clinics.

2. Company research

TopicWhat I foundHow I will use it
Mission and strategyExpanding from 12 to 20 cliLink my scaling experience
Recent newsNew scheduling system launcAsk how adoption is going;
DocumentJob Search & Interviews

Interview Preparation Worksheet (STAR Method)

Research the company, map your evidence to every requirement and build a bank of STAR stories before you walk in.

45 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ