[Link].
com Skill levels: 1=Novice; 2=Advan
Programming
Skill Matrix
Languages
JavaScript
Python
Java
C#
Employee Role
John Doe Azure Architect 2 3 3
Hanna Hansen Senior Developer 2 1 3
John Jones Project Manager 1
Olivia Osborn Software Tester 1 2
: 1=Novice; 2=Advanced; 3=Expert
g Software Development
Extreme Programming (XP)
Frameworks Libraries Agile Version Control Testing
Subversion (SVN)
Unit Testing
Mercurial
Angular
Kanban
Pandas
Lodash
NumPy
jQuery
Spring
Scrum
React
.NET
Git
3 2 2 2 2 3
1 2 1 2 2 1 2 1
1 1 3 2 2
1 1 2 3
Testing
Integration Testing
3
1
2
Test Automation
3
2
1
2
Jenkins
2
3
Travis CI
Integration
Continuous
CircleCI
Microservices
2
3
Patterns
MVC
1
2
Architecture
Event-Driven Architecture
1
3
AWS
1
Azure
2
3
Google Cloud Platform (GCP)
SQL
2
3
NoSQL
2
Cloud Services Databases
MongoDB
Data Management
Amazon Redshift
Data
Warehousing
ement
Data
Snowflake
Warehousing
Google BigQuery
Power BI
3
2
Tableau
Looker
Encryption
2
3
Security
Authentication
Data Analytics Practices
1
2
Authorization
1
2
OWASP ZAP
1
Tools
Burp Suite
Nessus
About
If you really want to manage skills in Excel, this template will help you get started.
Feel free to adjust it as you like.
Once you outgrow Excel go to
[Link]
for a professional solution that’s just as easy but much more powerful.
Create your custom skill matrix
To see an example of how the result will look like, check the “Skill Matrix Sample” sheet.
1.1 Create a custom skill list with generative AI
For your custom skill matrix, you need a skill list that fits your team. If you don’t have one you can
Here is the prompt we used for the example:
“I want to build a skill inventory with software development skills for an IT consulting company. Su
categories should contain at least three skills. Return it in a table that I can copy & paste to Excel.
The result is shown in “Skill List” sheet. We used gpt-4o. It should work the same with comparable
Adjust the prompt as needed for your team.
You should get an output that looks like the table on “Skill List”. The important part is that each Ca
You can also run multiple generations with adjusted prompts and add the results to the skill list in E
1.2 Fill the Skill Matrix
1. Copy & paste your skill list from ChatGPT (or whatever you use) to a new Excel sheet
2. Select the resulting table in Excel, but without the header row (start with the first cat
3. Copy (Ctrl-C) the selection.
4. Select the “Skill Matrix Template” sheet.
5. Select cell C2 (marked with x).
6. Select Paste – Paste Special … (Screenshot 1)
7. Select the option Values and check Transpose. Click OK. (scrrenshot 2)
8. Merge the cells for Categories and Sub-Categories in row 2 and 3. Select a (Sub-)Cate
9. To improve readability, adjust the background color and outer border of columns belo
10. Enter your employees starting from row 6. Row 5 is for filtering and remains empty.
Screenshots
Prompt
I want to build a skill inventory with software development skills for an IT consulting company.
Suggest a skill catalog with the following structure: Category, Sub-Category, Skill. Sub-
categories should contain at least three skills. Return it in a table that I can copy & paste to
Excel. Do not repeat category and sub-category for each row.
Result after copy & paste:
Category Sub-Category Skill
Programming Languages Java
Python
C#
JavaScript
Frameworks Spring
.NET
Angular
React
Libraries jQuery
NumPy
Pandas
Lodash
Software Development Agile Methodologies Scrum
Kanban
Extreme Programming (XP)
Version Control Git
Subversion (SVN)
Mercurial
Testing Unit Testing
Integration Testing
Test Automation
Continuous Integration Jenkins
Travis CI
CircleCI
Architecture Patterns Microservices
MVC
Event-Driven Architecture
Cloud Services AWS
Azure
Google Cloud Platform (GCP)
Data Management Databases SQL
NoSQL
MongoDB
Data Warehousing Amazon Redshift
Snowflake
Google BigQuery
Data Analytics Power BI
Tableau
Looker
Security Practices Encryption
Authentication
Authorization
Tools OWASP ZAP
Burp Suite
Nessus
onsulting company.
, Skill. Sub-
copy & paste to
[Link] Skill levels: 1=Novice; 2=Advan
x
Skill Matrix
Employee Role
: 1=Novice; 2=Advanced; 3=Expert