Welcome Guest! The IOSH forums are a free resource to both members and non-members. Login or register to use them

Postings made by forum users are personal opinions. IOSH is not responsible for the content or accuracy of any of the information contained in forum postings. Please carefully consider any advice you receive.

Notification

Icon
Error

Options
Go to last post Go to first unread
trevtotrev2006  
#1 Posted : 25 November 2009 10:54:43(UTC)
Rank: New forum user
trevtotrev2006

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
Jon.Dawson  
#2 Posted : 25 November 2009 12:41:29(UTC)
Rank: Forum user
Jon.Dawson

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
trevtotrev2006  
#3 Posted : 25 November 2009 12:45:09(UTC)
Rank: New forum user
trevtotrev2006

cheers for that john
Users browsing this topic
Guest
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.