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

Подписаться 14 тыс.

Просмотров 10 тыс.

50% 1

Want me to coach/mentor/advise you in your project management career? This link shows you how: influentialpmo.com/1-to-1-adv...
Want to join me for group Zoom calls? Join the membership space here: / influentialpmo
#projectmanagement
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...
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.
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: geni.us/skillsmatrix
#excel #team

Опубликовано:

29 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 17

@awiensyahirah9405 2 года назад

Thank you so so much. You really changed my life! Thanks a lot for the wonderful tutorial!

@InfluentialPMO 2 года назад

You’re welcome - and thank you for taking the time to leave such kind feedback. I appreciate it.

@oscarpereira3730 2 года назад

This is just perfect, thanks a lot. If you coming to Switzerland let us know. Cheers!

@InfluentialPMO 2 года назад

Thanks Oscar - will do 👍

@TalentProQuantum Год назад

Superb ! You have helped me to know better on making the skills matrix.

@InfluentialPMO Год назад

Glad I could help 👍

@peeterpoder6984 2 года назад

Thanks for nice tutorial!

@InfluentialPMO 2 года назад

Thank you, glad it was helpful 👍

@siphesihlenicholsonkhoza9876 3 года назад

I'm thoroughly enjoying the tutorials as I prepare for the coming audits. I'm having one slight challenge though, I decided to create 1 document for the whole department and the department has different jobs (packers and operators) so I listed all the skills required. The problem is that other jobs are not assessed (not applicable) on certain skills e.g. a packer is not assessed on machine-setting so I left this blank... In the end, it reflects as though packers are performing poorly on this. Any suggestions? I'm trying to keep it as simple as possible. Thank you :)

@InfluentialPMO 3 года назад

Hi, I think I answered this one in the “sequel”: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m5_FSx2LQB8.html It looks at how to separate cohorts of different teams/roles. You can create charts that just look at the packers with charts customised to their skills. Give it a try, let me know if you have problems and if so I’m happy to have a call to talk you through it. 👍

@siphesihlenicholsonkhoza9876 3 года назад

Do you think there's a way in which I could represent the overall effectiveness of the department?

@InfluentialPMO 3 года назад

Scoring effectiveness is probably going to be reliant on key performance indicators rather than a skills matrix. If you intend show the department skills score as a single value, I think you may need to determine a target score to compare against. Eg in overall skills we are 80% towards the target score. That’s if I understood the question! 😊

@allegrazz Год назад

Thank you so much, you have really made this complex system understandable! (Though I have to follow along again each time I try a new one). One question - when I add the "Teams" column, that messes up the original INDIVIDUAL skills columns, putting them all off by one (because in between the name and the first skill, the team column now shows up as column 2, where the first skill was column 2 in the first video). All the team stats work, since we're putting in new formulas and now the first skill is column 3, but when I look at the sheet for individual stats, the first skill has become a team name and all the skill numbers are off by one column. Do I have to reformat the individual sheet if I add the team column later? (To make it start with column 3 instead of column 2, and then readjust all the lines below). Or have I left off a $ from somewhere? It's all still sequential, just off by one. Am I making any sense?

@InfluentialPMO Год назад

Hi, I think I understand what you’re experiencing-but it’s not something I’ve seen before. When you added the Teams column, did you use “Insert Column”? Usually Excel can see that has happened and adjusts the formula in impacted cells.

@allegrazz Год назад

@@InfluentialPMO Thanks for getting back to me! I did "Insert Column" - I have tried to follow your clear instructions exactly, no improvising! For all I know, I probably have an old version of excel. I'll either fiddle a little more, or maybe once I know exactly what I'm going to do I'll watch again and just make a template in advance with all the columns so I don't need to change anything. It's the team info that I need anyway. Again, thank you so much for your step-by-step instructions and your notes on possible complications and where to look to fix them. I just happened to need a group skills assessment (actually a before and after), so your video has opened up a whole new world for me!