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.

[fvplayer src=”https://s3-eu-west-1.amazonaws.com/the-excel-expert/Training_records_compliance.mp4″]

 

You can view the completed file here..

 

As always, comments and suggestions welcome.