Training Needs Analysis

Skills Matrix – a Training Needs Analysis Tool

Skills Matrix

Here is a great tool to identify training requirements within a business or department. It’s in Excel which is fine for projects or small to medium sized businesses (for large business you are probably better looking at a Learning Managment System). Essentially it’s a template to help you with  training needs analysis.

Here’s the link

Skills Matrix Template

It currently contains three main areas (held in 3 worksheets):
  • Roles Matrix – Defines what level of competence people are required to reach (by role) in order to carry out their job effectively.
  • Skills Matrix – Defines the current level of competence of an individual.
  • Gap Analysis – Looks at where people should be for their role against where they are now and works out the difference i.e. ‘Required Competence Level for Role – Current Level of Competence’.
This can also be used to:
  • Work out skill gaps for people wishing to move into another role. You can do this by just changing the role in the Skills Matrix worksheet. When you go into the Gap Analysis it will automatically show you the gaps for the individuals new role
  • To monitor & control training effectiveness. You could keep historical versions of this Spreadsheet to compare before and after training.
  • To work out the weakest/strongest of competences with teams/dept/business.

If you have any questions about how to use this or any comments about how it could be improved please let me know.

Here’s the link again – enjoy!!

Skills Matrix Template

PS – Don’t forget to subscribe so you don’t miss out on any further posts. Until next time …


2 Responses to “Skills Matrix – a Training Needs Analysis Tool”

  1. Hi, I’ve found the skills matrix template very useful. I have a question on the Role Matrix worksheet – there’re some numbers on the row 2nd that are used in the formula on the Gap Analysis worksheet. Would you be able to confirm what these numbers are?

    Many thanks in advance!

    Posted by Wiktoria Gwiazda | February 16, 2017, 10:40 am
    • Hi Victoria, sorry for the late reply. Good to hear you found the matrix useful. The numbers in the 2nd row are used in the Vlookup formula to populate the Column Index number so it can pull back the correct information from the correct column. Hope that makes sense. If you need to add any further columns to the Role Matrix then just add some more incremental numbers to row 2.


      Posted by Admin | February 26, 2017, 11:19 am

Leave a Comment

Your email address will not be published. Required fields are marked *

Reading Material

The best (training related) book I have ever read is Accelerated Learning for the 21st Century by Colin Rose. Here is a link:

Want to know more about how people learn and how to build rapport with your delegates then try this: