Employee Skills Matrix

A free Excel skills matrix that shows, on one sheet, which workers hold which skills, tickets and licences, when each one expires and where training is needed. Expired dates turn red, dates due in the next 30 days turn yellow, and each row counts that worker’s gaps, so you can plan training and check that only licensed workers do high risk work.

Use it with our Employee Training Register, Consultation, Communication & Training Policy.

What is included in our employee skills matrix?

• A Start Here sheet: type your business details once and they appear on every sheet and every printed page
• One row for each worker with their position or role
• First aid, CPR, white card, working at heights and confined space, with expiry dates
• High risk work licences for forklift, boom-type elevating work platform and dogging, with expiry dates
• Driver licence class and expiry, plus two more skills you can rename to suit your business
• For each skill choose Yes, Training needed or Not required; each row counts the training needed and expired items
• Expired dates in red and dates due in the next 30 days in yellow
• A plain-English summary of the Queensland training, high risk work licence and white card rules

Legislation and codes of practice referenced

• Work Health and Safety Act 2011 (Qld): s 19(3)(f) (information, training, instruction and supervision)
• Work Health and Safety Regulation 2011 (Qld): s 39 (training), ss 81 and 85 and sch 3 (high risk work licences), s 317 (general construction induction training)

What you get

• An editable Microsoft Excel workbook with no macros
• Drop-down lists, frozen headings, automatic counts and colour highlighting
• Room for 100 workers, with more rows when you need them
• Print-ready pages: the header and each worker’s name and role repeat on every printed page
• Drop-down options you can change on the Lists sheet to suit your business

Review it and adjust it to suit your business, your sites and the way your team works, and talk it through with your workers.