Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementTraining & LearningSkills Matrix & Training Needs Analysis

SpreadsheetTraining & LearningFree

Skills Matrix & Training Needs Analysis

Rate each person on the skills the team needs and see gaps, single points of failure and who to train.

Shown with sample data

Colour

Skills Matrix & Training Needs Analysis

Rate each person on the skills the team needs and see gaps, single points of failure and who to train.

Skills assessed
9
Priority training needs
3
Competent ratings
44%
Total gap points
8
Entries by team
  • Assembly4
  • Quality3
  • Maintenance2
Share of entries by team
  • Assembly444%
  • Quality333%
  • Maintenance222%

How to use it

  1. 1List the skills the team needs.
  2. 2Rate each person: 0 none, 2 can do with help, 4 can teach.
  3. 3Set the level required for the role.
  4. 4Train where the gap is largest and cover is thinnest.

In this workbook

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

About this template

Know what your team can do and where you are exposed. Rate each person from 0 to 4 on each skill against the level the role requires; the sheet works out the gap, flags training needs and shows which skills depend on only one competent person.

Who it’s for

  • Planning training budgets
  • Cross-training to cover absence
  • ISO and audit evidence of competence

What’s included

  • Skills sheet: One row per person per skill.
  • Summary by Team sheet: The number of entries for each team, calculated from the Skills sheet.

How to use it

  1. 1List the skills the team needs.
  2. 2Rate each person: 0 none, 2 can do with help, 4 can teach.
  3. 3Set the level required for the role.
  4. 4Train where the gap is largest and cover is thinnest.
Related searchesskills matrixtraining needs analysiscompetency matrixskills gapcross training

Details

Format
Spreadsheet
Category
Training & Learning
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetTraining & LearningFree

Skills Matrix & Training Needs Analysis

Rate each person on the skills the team needs and see gaps, single points of failure and who to train.

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
Training & Learning
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More training & learning templates

View all
Employee Training Tracker3 sheets

Overall compliance

83%

Expired or missing

4

Renewals in 60 days

2

ABCD
1EmployeeCourseCompletedCertificate no.
2Amara OkaforData protection essentialsMar 2
3Amara OkaforFire safety awarenessJan 20
4Amara OkaforHealth and safety inductionApr 2
5Amara OkaforLeading teamsMay 14BS-2291
Records
SpreadsheetTraining & Learning

Employee Training Tracker

A training matrix showing who is compliant, every course record with expiry dates and renewal alerts, and hours and spend by person.

10 min setupPreview

Training Evaluation Form

Ask learners what they thought, what they learned and what they will do differently back at work.

Course title *

Date *

Trainer

Submit evaluation
FormTraining & Learning

Training Evaluation Form

Ask learners what they thought, what they learned and what they will do differently back at work.

10 min setupPreview
Annual Training Plan and Budget4 sheets

Annual budget

$95,000

Planned cost

$83,320

Unallocated budget

$11,680

Planned cost by quarter
$20k
$14k
$42k
$7,980
Q1Q2Q3Q4
SpreadsheetTraining & Learning

Annual Training Plan and Budget

Plan every training programme by quarter with participants, cost and hours, and track actual spend against the budget.

25 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