A Simple Training Needs Analysis Template In Excel

Training Needs Analysis TemplateThere are many ways to conduct a training needs analysis activity and I’ve been involved in some of the most complex around with multi-dimensional competencies and different levels at each!

The process can be as complex or as easy as you need it to be and it needs to be right for the stage that your company is at.

Below is an easy to use, beginners training needs analysis template in excel.

It’s great if you’re new to this or need somewhere to start.

It comes with instructions too. So I recommend that you download the excel file and either work through each of the steps below or download the instructions too and work from that (they contain the same information)

Download The Instructions

Training Needs Analysis Template
Download The Spreadsheet

If you’ve got any questions about the template please feel free to email at sean@skillshub.com and I’ll be happy to help you.

Training Needs Analysis Instructions:

Step 1

Download the training needs analysis template.

Step 2

List the skills or competencies down the left hand side of the spreadsheet that are associated with the role.

If you can do so, create section headings and group the skills.

Step 3

List the people across the top of the spreadsheet that you want to complete the training needs analysis for.

Step 4

Decide on a scale. Some companies use a 0 to 10 scale. With 10 being most proficient and 0 the least. Others use a 0 to 5 scale. Make it consistent with whatever you use at your company for ratings/scores.

Step 5

At the moment the spreadsheet will not show which are the most important skills for the role or those that should have priority. If applicable we recommend that you highlight these in a different colour so they stand out.

Step 6

There are a couple of ways to complete the spreadsheet. Firstly, you could just ask the member of staff to give themselves a self-assessment score and use that. Other options include asking the line manager to complete the scores or they could complete the scores together.

Use what works best for your organisation.

Step 7

The lowest scores given in the shaded areas will be the top priority areas for you to focus on first.


I hope that helps you!


Sean photo

Sean McPheat | Linkedin



LD footer
I give you permission to email me the above report, a weekly L&D tip and occasional exciting offers about Skillshub. I understand I can opt out at any time. *

See Privacy Policy


You might also be interested in…

work from home. people making video conference with colleague via laptop computer during home quarantine to avoid spreading illness transmission of COVID-19 Coronavirus outbreak. Social distancing

Virtual Working – How To Stay Productive

You’re working from home… What time do you start? When do you take your first break? Do you logon before ...
Read More
Learning sign with road background

Does Your Learning Platform Support Personal Learning Journeys?

Most online learning platforms act like a content library. With this, a whole host of elearning content and digital assets ...
Read More
Learning Management System (lms)

A Learning Platform Is Not Just For Christmas

Don’t be misled by the title of this blog! I mean it. So many organisations purchase a learning platform and ...
Read More
Learning Vector Horizontal Banner. Education Concept Illustratio

What Are KOLB’s Learning Styles And What Do They Mean?

Why is it important to understand learning styles? What do learning styles mean? And how can they influence the way ...
Read More
Student Elearning Wearing Headphones Watching Online Tutorials I

What Is A Flipped Classroom?

Think about traditional learning for a moment… You normally attend a course or a learning event and then the trainer/teacher ...
Read More
Augmented reality map

What Is Augmented Reality & How It Will Impact The L&D World

Augmented Reality is the idea of taking the real world around you and enhancing it to make it better. What if ...
Read More

Get In Touch

Speak to an expert

02476 998 101

Prefer to keep it digital? Please complete our quick form below or email us at info@skillshub.com and we'll get back to you within 1 working hour



Phone Number