Excel Charts for Beginners - Create Team Skill Charts In Excel to Enable Skill Gap Analysis скачать в хорошем качестве

Excel Charts for Beginners - Create Team Skill Charts In Excel to Enable Skill Gap Analysis

A video showing how to create useful charts to see team skills (and skill gaps) in Excel. This builds on the Excel tutorial for creating a skills matrix in the previous video, which can be found here:    • Making a Skills Matrix for your Team with ...   This demonstrates the use of the vlookup function, the iferror function and the creation of Excel charts. All of this will be useful to managers that are interested in assessing the skills levels and skills gaps within their teams - either for the entire team or cohorts. 💡 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/a... 🔹 For organisations → If your company needs PMO or project assurance services, book a call to discuss how I can help: https://calendly.com/influentialpmo/i... #projectmanagement #pmo Timestamps: 0:00 - Intro 1:30 - Add team or cohort category by adding a column in Excel 3:01 - Create the Team worksheet in Excel 5:09 - Using the IfError function and Vlookup function in Excel 12:00 - Using the Average function in Excel 13:14 - Creating charts in Excel that are updated by our Vlookup data and team average scores - creating a radar chart in Excel 15:35 - Formatting charts in Excel 18:50 - Creating charts in Excel that are updated by our Vlookup data and team average scores - creating a column chart in Excel 24:11 - The benefit of simplicity 26:35 - Fixing common errors and problems To download my copy of this template, sign up for the Influential PMO newsletter at: https://geni.us/skillsmatrix #excel #team