Making a Skills Matrix for your Team with Excel

Get your VIP pass to all things Influential PMO! Support me on Patreon and unlock special benefits at www.patreon.com/influentialpmo.

Looking for your next - or first - project management job? Try this: https://geni.us/FindYourNextPMJob

Want me to coach/mentor/advise you in your project management career? This link shows you how: https://influentialpmo.com/1-to-1-adv...



#projectmanagement

This tutorial shows how to create a basic skills matrix for capturing and presenting your teams skills in Excel, using vlookup function and charts. This will be useful for anyone managing a team and interested in developing the skills of that team.

Timestamps:
0:00 - Intro
1:20 - Create the Data worksheet in Excel
5:00 - Create the Skill worksheet in Excel
5:56 - Make a dropdown list in Excel using Data Validation
7:28 - Transpose paste in Excel to turn horizontal data into a vertical list
8:00 - Vlookup function in Excel to find data in a table
12:25 - Creating charts in Excel that are updated by our Vlookup data - creating radar chart and column chart in Excel
15:15 - Setting Print Area in Excel to limit the outputs

The sequel to this video which shows how to create team skill views and charts can be found at:    • Excel Charts for Beginners - Create T...  

To download my copy of this template, sign up for the Influential PMO newsletter at: https://geni.us/skillsmatrix


#exceltutorial #excel