Tool · Excel template
Annual training calendar template (Excel)
An annual training calendar turns the gaps in your competence matrix into a plan: which course, for which group, in which month, delivered how, and by whom. This Excel template marks planned and completed training by month and builds the summary management review needs. No sign-in and no e-mail address needed.
What is inside
- How to use: a one-page guide
- Calendar: one row per course and group, with the delivery, the owner, a planned or done mark for each month, and the status
- Summary: planned and done training per month and for the year, with the share completed, ready for management review
Excel workbook · no sign-in, no e-mail · prepared by the Sterling expert panel
What is an annual training calendar?
It is the plan that schedules the training your organisation needs over the year. Where the competence matrix shows who needs what, the calendar shows when it will happen, how and who is responsible. Together they give an auditor, a client or a manager the full picture: the need, the plan and the evidence that the plan was carried out.
How do you build the plan?
Start from the gaps in the competence matrix: people marked as due, refreshers coming up, new starters and roles that change. Group the training by course and audience, choose the delivery for each (online and self-paced, classroom, live online or on the job), name an owner, and mark the month. Spread the load: induction and awareness training early, internal auditor training ahead of the internal audit programme, and refreshers ahead of the certification or surveillance audit.
When the training is done, change the planned mark to done and update the competence matrix, so the evidence and the plan stay in step.
What should the plan include?
A sound plan covers induction for new staff, awareness of each management system for everyone in scope, role training for process owners, risk owners and the people who run the system, internal auditor training ahead of the audit programme, refreshers when a standard or a process changes, and any training a regulation or a client contract requires. A new edition of a standard, such as ISO 9001:2026 or ISO 14001:2026, belongs in the plan as a dated item with its own owner.
Who should own the training calendar?
Usually the person who leads the management system, with each row owned by the manager of the group being trained. Top management approves it, typically at management review, because the plan commits people's time, and because the standards expect top management to make sure the resources the system needs are available.
How do you keep the plan on track during the year?
Review the calendar every month alongside the status column. Anything planned but not done moves to a later month with a reason, rather than disappearing, so the summary stays a fair picture. Look out for the common causes of slippage: training planned in the busiest season, a single owner for too many rows, and classroom sessions that depend on everyone being in one place. Moving awareness and refresher training to online, self-paced courses usually removes the last of these.
How does it help at management review and audit?
Management review asks whether resources, including competent people, are adequate, and whether planned actions were completed. The summary sheet answers that in one table: training planned and done by month and for the year. At the certification audit, the calendar shows that training is planned rather than reactive, and the matrix shows the result for each person.
How does Sterling Academy fit in?
Online, self-paced courses are the easiest rows of the calendar to deliver on time, because people take them around their shifts and sites. Sterling Academy courses are built by industry experts in the same content and format as Sterling's classroom training, end with a final exam and a verifiable certificate, and give the client administrator one view of everyone's progress. Use the training finder to choose the courses for each group.
Frequently asked questions
Questions about the template
Do I need to sign in or give an e-mail address to download it?
No. The download starts straight away from this page.
Does the calendar work with the competence matrix template?
Yes. They are designed to be used together: the matrix shows who needs which training, the calendar shows when it happens, and both use the same course names.
Does online, self-paced training belong in the calendar?
Yes. Plan it like any other training, with a month, a group and an owner, so that the summary shows it and the competence matrix is updated when each person completes the course and its final exam.
Can I plan classroom and online training in the same calendar?
Yes. Each row has a delivery field: online and self-paced, classroom, live online or on the job.
How far ahead should I plan?
Plan the full year, and review it at each management review and whenever roles, processes or standards change.
Which Excel versions does it work with?
It is a standard .xlsx file with simple formulas, drop-down lists and colour rules, and opens in current Excel, Excel online and other programs that read .xlsx.