Rank: New forum user
|
I am trying to put together a consolidated training matrix for my company displaying all the health and safety training that has been carried out i.e. manual handling, safety induction etc. i would be gratefull if somebody could provide some examples to put me in the right direction. thanking you
|
|
|
|
Rank: Forum user
|
Trev
I just use a big Excel spreadsheet, with the courses across the columns at the top (turn the titles through 45 degrees), and the employee names down the side (rows). Then I enter the date they passed each course in the cell - if you are clever you can enter these as a hyperlink to the course certificate.
I colour-code the cells - green, for 'in date', yellow, for coming up for renewal, red - for overdue (I think there is an If/true statement where you can automate this from the date, but that's beyond my ken - I just check it monthly).
You can also get it to add up each column (where there is an entry, use the COUNT formula) so you can see the running total of each course.
I'm sorry I can't attach an example - the OHAS 18001 auditor loves it though.
Best of luck
Jon
|
|
|
|
Rank: New forum user
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.