Forum Discussion

MattRipia's avatar
MattRipia
Copper Contributor
Jul 22, 2020

Manage staff training/upskilling in a variety of roles/courses using excel

Hi there,   As the title mentions, im trying to create a sheet that helps manage the training/upskilling of staff who belong to different teams and thus have a different set of courses or training ...
excel
MattRipia's avatar
MattRipia
Copper Contributor
Jul 23, 2020

NikolinoDE 

 

Thanks - I did find an english version of this before I posted. It is missing alot of functionality for having an employee in a certain role, and then that role having a pre-defined set of courses they need to complete.

 

Thanks for your help though.

IngeborgHawighorst 

I will look into VBA as a solution, I havent used this before so i'm unsure if it would work. I'd assume that I have a list of people with their roles, a list of courses that belong to a role, and then the script that ties those together and produces a dynamic combination. When I change a person, role, or course it would then update the main page for me. Is that assumption correct?

IngeborgHawighorst's avatar
IngeborgHawighorst
MVP
Jul 23, 2020

MattRipia Your requirement is very specific, so it will be hard to find a template that does exactly what your company process is.

 

If you have no experience coding in VBA, this will be a big challenge. You may want to start with some smaller tasks to learn how to use VBA. The good news is that there is plenty of free learning out there, if you are willing to search and put in the time to learn.