4

So one of the questions that comes up when I am helping customers with this is how do you calculate what percentage of your staff are compliant.

In this scenario, I have set up 16 employees who each have to do a Health and Safety and Induction course. Some of them have done it and some have not. So what percentage of my staff have their courses completed?

Here is the file I start with.

Here is the video that shows you how to do it.

 

You can view the completed file here..

 

As always, comments and suggestions welcome.

 

4 Responses to “Training records management – summarizing percentage compliance”

  1. Lia m says:

    How would you summarize compliance by date completed. For example, a trainee has 30 days from hire to complete training of 20 different SOPs. I have each SOP completion date under the column of the employee. How do we calculate which employees are within their 30 day target due date and which are out of compliance? Is there maybe a formula that can automatically count the number of documents read after the target date?

  2. Lia M says:

    How would you summarize compliance by date completed. For example, a trainee has 30 days from hire to complete training of 20 different SOPs. I have each SOP completion date under the column of the employee. How do we calculate which employees are within their 30 day target due date and which are out of compliance? Is there maybe a formula that can automatically count the number of documents read after the target date?

Leave a Reply