Call Now: 0800 130 3225

How to identify your training needs with a simple spreadsheet

Posted on Jan 04, 2018


This handy Traning Needs Analysis template for Excel helps you get a better insight into the training and skills levels with your organisation

A Training Needs Analysis has a variety of uses from supporting gap analysis between required and actual knowledge levels and also tracking competency levels. When used as a visual management tool, the matrix can identify, at a glance, individual skill levels and weaknesses within the department.

We have compiled a simple template for construction employers to create their own training matrix. The document itself will need to be tailored slightly to suit your company.

Download our template HERE.

Creating a Training Needs Analysis

Here’s our guide to producing a training needs analysis template using Excel.

This Training Matrix covers three key areas within training:-

Health & Safety Training

Management Training

General Training

User’s Guide

To identify the training needs of your employees:

Mark the box with a red bold ‘X’

When training has been completed we would recommend you change this to a green tick ‘✓‘

Insert the date training was completed (to identify refresher training)

Construction Skills People are dedicated to delivering training solutions to meet your every need. We have training centres available nationwide and where it’s convenient we can also deliver courses on-site. For more information about any of our courses or to discuss your specific training needs, please call us on 0800 130 3225.