Employee Training Tracker Spreadsheet
Budget: ₹750 – ₹1,250 INR
I need a detailed spreadsheet to track employee training. The spreadsheet should handle the following:
- Training Completion Status
- As detailed in the email I will send
- Automatic date renewal and frequency
Ideal Skills:
- Proficiency in spreadsheet software (Excel, Google Sheets)
- Experience in creating automated tracking systems
- Attention to detail and accuracy
am also interested in a quote please for our training matrix for employees. What we do with this is we add in the training, there is a rag rating and a frequency set at the top which I needs changing to that it goes red when its expired, orange within 3 months and green until that point regardless of the frequency set, leave the frequency as this is an important part, we also want an option of NFA and N/A for people who don’t need to do the training again.
Additions to the document please would be a percentage at the top of each training course, so unless it says NFA we can see how many people are outstanding, and also with this a dashboard TAB which reports all of what happening on the TAB’s for example, it shows the percentages of each tab and course for each service, it shows how many squares are incomplete for each service.
I have provided a blank copy of what we currently use which needs amending, we use multiple versions of this so it would need to be able to be duplicated, some services are one 1 tab and not multiple so they would need to have a dashboard for that.
So, in theory it might be 2 versions required, 1 version with only 1 tab as 1 service, and one with multiple tabs, I have given a black version of the template we have been using, attached to see the amends needed to the existing document and can I have a price please, as I would like this completed as soon as possible.
On the names, we link there name to their personal file so we can store the training certificates.
- Training Completion Status
- As detailed in the email I will send
- Automatic date renewal and frequency
Ideal Skills:
- Proficiency in spreadsheet software (Excel, Google Sheets)
- Experience in creating automated tracking systems
- Attention to detail and accuracy
am also interested in a quote please for our training matrix for employees. What we do with this is we add in the training, there is a rag rating and a frequency set at the top which I needs changing to that it goes red when its expired, orange within 3 months and green until that point regardless of the frequency set, leave the frequency as this is an important part, we also want an option of NFA and N/A for people who don’t need to do the training again.
Additions to the document please would be a percentage at the top of each training course, so unless it says NFA we can see how many people are outstanding, and also with this a dashboard TAB which reports all of what happening on the TAB’s for example, it shows the percentages of each tab and course for each service, it shows how many squares are incomplete for each service.
I have provided a blank copy of what we currently use which needs amending, we use multiple versions of this so it would need to be able to be duplicated, some services are one 1 tab and not multiple so they would need to have a dashboard for that.
So, in theory it might be 2 versions required, 1 version with only 1 tab as 1 service, and one with multiple tabs, I have given a black version of the template we have been using, attached to see the amends needed to the existing document and can I have a price please, as I would like this completed as soon as possible.
On the names, we link there name to their personal file so we can store the training certificates.