Making a Skills Matrix for your Team with Excel

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: https://youtu.be/m5_FSx2LQB8 To download my copy of this template, sign up for the Influential PMO newsletter at: https://influentialpmo.kit.com/skillsmatrix 💡 Need expert guidance? 🔹 Looking for your first or next project management job? → Check out my course: https://geni.us/FindYourNextPMJob 🔹 For project professionals → If you're looking for career advice, mentorship, or support in managing your projects, book a 1:1 coaching session with me: https://calendly.com/influentialpmo/advice-call 🔹 For organisations → If your company needs PMO or project assurance services, book a call to discuss how I can help: https://calendly.com/influentialpmo/influential-pmo-b2b-query #projectmanagement #pmo #exceltutorial #excel #projectmanagement