By the CIToolkit content team   |   2 minutes read

Skills Matrix Template

The main idea behind the Skills Matrix is to evaluate the available skills of a team. It allows to understand the skills that the team is missing which are required for the job or project at hand. Start by listing the team members in the left hand column and the relevant skills that are required or desired in the top row. Then fill the matrix with the skill ratings of each team member. Finally, look at the bottom of the table to see what are the training needs to improve the skill levels.

This template is a Microsoft Excel document that you can use and modify to best suits your needs. It can easily be modified to include additional sections if needed. For example, you may want to add more rows to include more team members, or add more columns to include more skills. You can also use whatever scoring method that suits your need.

If you face difficulties customizing this template or you lack time to do so, we will be happy to perform the customization for you. Let us know what you need and we will do our best to serve you. Please help us to make this template better by providing us with your comments or suggestions.

Related Templates



  5 comments on “Skills Matrix Template

  1. Daoud Post author

    In the Threshold, you should enter a score (for example 7). Any individual score above the threshold indicates a need for training for that specific individual, and this will be highlighted in yellow. This means that the company has to provide a training for those highlighted in yellow. The other scores highlighted in white indicates that the skills of the employees are sufficient. In general, wherever the number is yellow, this is an indication of a need for training.

  2. Daoud Post author

    Training Required is the sum of the zeros and ones (the sum of the cannot perform and the perform with help). At those two levels training should be prioritized.

  3. Daoud Post author

    Individual Score is a way to evaluate the skills set of each individual. The higher the score, the more skilled is this person for those selected skills.

  4. Daoud Post author

    The Threshold has to do only with the overall skills scores (horizontal). If the “score per skill” is low, its rank would be high, which means that you should focus on those “above or equal the Threshold” to improve the skills significantly.

  5. Daoud Post author

    The Threshold is an optional parameter that you set yourself to know what are the skills that you need to train your employees in. It looks at the scores of the skills which are 0’s and 1’s to highlight those to be yellow, which means that those are the skills that you need to improve. I have chosen 5 in the example to say that if 5 of the employees are non skilled in that skill (0’s and 1’s), so we should conduct a training for that skill.

Comments are closed.