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”: kzitem.info/news/bejne/zmuVrIeua36CdW0 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. 👍
@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!
@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! 😊
@laivybrown8312
2 жыл бұрын
For some reason it is populating in all but one column and is entirely blank. Any ideas?
@InfluentialPMO
2 жыл бұрын
Do the populated columns all match up to what you’d expect based on the data, or are they seem to be in the wrong columns?
Пікірлер: 17