Training Calendar Template: Free Excel Format With Example

Train teams faster and more effectively with AI

Start Free

A training calendar brings your planned training sessions into one place. It shows when they happen, who needs to attend, where they run and who is responsible. Use it to plan a whole year, coordinate several teams or keep track of the next few months.

I'm the COO at Coursebox, where we make employee training software, and I manage most of our Perth team.

The free Excel template below turns one session list into a month calendar and a year overview. Its completed example follows an illustrative community health provider across three Queensland sites. On 3 August, an induction day and a CPR refresher need the same room, and induction has 18 bookings for 16 seats. We’ll use those problems to show how to build a calendar you can actually deliver.

Training calendar template

Get the blank Excel workbook, a completed example with 24 sessions and five sample planning outlines, and a printable four-page PDF. No sign-up required. The example is illustrative.

Blank template (Excel)XLSX · 85 KBCompleted example (Excel)XLSX · 93 KBCompleted example (PDF)PDF · 127 KB

No email required

Open the calendar preview at full size

What is a training calendar used for?

A training calendar helps you bring individual programmes together. An induction day might work for the new starters, while taking the only available room away from a refresher for existing staff. Seeing both in the same calendar lets you resolve that conflict before asking people to attend.

Start with a reason for each programme: a task people need to learn, a required refresher or a change coming to the business. Your training plan explains that purpose and the intended result. The calendar gives the work dates and resources. You may need to adjust the programme as you find out what staff and trainers can fit in.

Training calendar, schedule, plan or agenda?

The terms overlap in practice. In this guide, we use them to describe the following jobs:

In the example, the calendar has five separate induction dates from July to November. A new starter’s personal schedule then includes their induction date, supervised work and later check-ins. These are different views of the same training.

The induction day itself runs from a training agenda.

What goes into a training calendar

Use one row for each dated session. If you run the same workshop for three shifts, give each delivery its own row so you can check the trainer, room and attendance limit separately.

Use Type to label different kinds of training, such as onboarding or compliance. The Year view groups by Programme and counts sessions rather than hours. Estimate the length of each session separately before booking staff time.

Types of training calendars

• Annual calendar: plan a defined year alongside your staffing and budget decisions. The example uses July 2026 to June 2027, but you can choose another starting month.
• Rolling calendar: keep a fixed period ahead, such as the next 12 months. As one month finishes, plan the next month at the end. Update the dates and rows yourself in this workbook.
• Monthly view: use a closer view of the session list to coordinate the coming weeks. It should reflect the same dates as the annual plan.
• Intake calendar: plan around people’s start dates. A shared induction goes on the calendar, while each new starter also needs dates for practice and check-ins.
• Renewal calendar: work back from each person’s next required refresher date. Confirm the interval that applies to their role and training before entering it.
• Public training calendar: advertise dates that customers can book. This template is intended for internal staff planning.

View the types of training calendars infographic at full size

How do I create a training calendar?

The example follows a fictional community health provider with about 250 staff in Logan, Ipswich and Toowoomba. Its workbook contains 24 selected sessions across five programmes from July 2026 to June 2027. It illustrates planning decisions, rather than a complete training allocation for all 250 employees.

Step 1: Put the fixed dates in first

Start with deadlines and the people they affect. Check required refresher dates, new starter dates, planned leave and business changes such as a system launch. For compliance training, use the applicable requirement to work backwards to a suitable session date. In this example, the organisation uses a 12-month CPR refresher interval and initially proposes three August sessions, one per site.

The Renewals tab adds the interval you enter to each person’s recorded completion date. It compares the result with the review date at the top. The completed example uses 19 October 2026; change that date when reviewing it. The blank workbook uses today’s date. Labels such as Expired describe the interval entered in the sheet, rather than independently verifying a qualification’s validity.

Step 2: Add the intakes

Group new starters into shared induction dates where that suits the job. The example has five intakes, each on the first Monday of the month from July to November. Check whether anyone joining between those dates needs essential instruction before their first shift.

Step 3: Add what the needs analysis found

Next, add training that addresses a specific work need. A training needs analysis can help establish what people need to do differently and whether training will help. Once you have agreed on the programme, allow time for instruction, practice and follow-up in the calendar.

The example has two development priorities. Staff at all three sites need to learn a new rostering app before it launches on 4 September. Newly appointed team leaders also have a six-month programme from January to June. The app sessions have a fixed deadline; the leadership sessions can be arranged around the cohort’s availability.

Step 4: Give every session an owner, a room and a seat limit

Confirm who will run each session and how many people can attend. Use the actual room or delivery limit, then ask managers whether enough staff can be released at once. A room with 20 seats is no help if the team can only spare six people from a shift. When another trainer takes over, a facilitator’s guide can explain the session, while a training checklist covers preparations.

Step 5: Read the Check column

The Check column compares sessions on the same date for overlapping room and trainer bookings. It also flags bookings above the seat limit, a missing trainer or owner, and a session dated after its deadline. Use consistent room and trainer names: the sheet matches the text you enter. For self-paced sessions, enter Online as the location. A blank start or end time is treated as the start or end of the day.

Problems left visible in the completed example

Example: Illustrative Queensland community health provider, July 2026 to June 2027.

1. 11. Room booked twice: Two sessions in the same room at overlapping times on the same day. Online sessions never clash on room.
2. 22. Trainer booked twice: The same owner on two sessions that overlap. A session with no times counts as all day.
3. 33. Seats left: Seats minus bookings. A negative number means more people booked than the room holds.

Get this template

Open the session checks at full size

The completed workbook deliberately leaves these problems visible. Here is how you could resolve them before confirming the dates:

A 09:00 to 10:00 session and a 10:00 to 11:00 session do not trigger an overlap warning. Allow time for room setup, breaks and travel yourself. The workbook compares one Trainer or owner field, so it cannot check a separate coordinator or several trainers. Keep those arrangements in your booking records.

Step 6: Look at the month and the year

In Calendar, enter the first day of the month you want to see. Each day shows up to two session names, with a count such as “+1 more” when there are others. Go back to Sessions for the complete list and times. Cancelled sessions are excluded from the month grid and year totals.

The Year view counts sessions by programme and month. In this example, August contains seven of the 24 sessions and December has none. Investigate that concentration with managers: one short online module and one full-day workshop each count as one session, so the totals alone cannot tell you how much staff time a month needs.

Check which dates can move before spreading the work out. The infection control module is due by 31 August, so moving it to an empty December would miss its deadline. Look for another August date or move a flexible session. Compare the plan with staff availability and your training budget separately; this workbook does not calculate costs or staff hours.

Step 7: Publish it, then review it every month

Ask managers to check coverage before you confirm the calendar. Once dates are agreed, send invitations through your normal calendar or learning platform. Name someone responsible for keeping the shared plan current, and review it monthly as well as whenever a booking changes.

For repeating sessions, Next run due adds the repeat interval to the planned session date. Treat it as a provisional booking date for next year. It neither creates a new row nor proves that an individual completed the course. Update personal renewal records from actual completion evidence.

Training schedule samples for other situations

In the 180 days to 19 October 2026, at least 100 people asked our AI course builder, in their first request, for workplace training planned across several sessions or a stretch of time, from 30-day onboarding paths to annual compliance refreshers. The samples follow the patterns that came up most.

The five sample tabs in the example workbook suggest ways to arrange training. Their short tables are planning outlines, so do not paste them directly over the wider Sessions table. Turn relative timings such as Day 30 into actual dates, then enter each delivery in the matching Sessions fields.

Onboarding: a 30, 60 and 90 day path

Use a sequence that helps a new starter move from initial instruction to supervised work and then independent performance. These dates are a starting point; a role with safety requirements may need a practical check much earlier than day 60.

Compliance renewals

Use a renewal plan when people need repeat training at defined intervals. The intervals in the downloadable sample are illustrative inputs. Confirm the current requirement for your workplace, role and qualification before using them.

Check the earliest individual due date before choosing the group session. Leave time for people on leave, people on other shifts and anyone who needs another attempt. The sample allows six weeks before the earliest due date; choose a lead time that fits your actual booking arrangements.

A six-month programme for new managers

Space the sessions so new managers can try a task between meetings. After a session on feedback, for example, ask each manager to prepare and hold a feedback conversation before the next meeting.

At the following session, discuss what happened and give managers a chance to practise again. Check that each topic arrives before managers need it. A team leader handling rosters immediately may need that topic before month four.

The same session for every shift

If the site runs around the clock, one daytime workshop will leave some staff without a practical way to attend. Repeat the session for each shift, and include any supervised assessment in the plan.

Agree the timing with shift managers so staff can attend during paid working time and the site keeps enough cover. Check overnight bookings manually against both dates. The workbook warns when an end time is at or before the start time, but does not calculate conflicts across midnight.

A new system, trained in waves

Plan backwards from the launch date. Train a small group first so they can help colleagues, then give each team time to practise before the system becomes part of everyday work.

Champions are staff trained first so colleagues have someone nearby to ask for help. Book the follow-up while arranging the launch sessions, then use questions and mistakes from the first weeks to decide what it should cover.

What to send once the calendar is set

Managers need to know which dates affect their team and what you need them to check. Send a link to the master calendar, with a short note such as this:

Subject: Please check the training calendar for [YEAR]

Hi everyone,

The training calendar for [YEAR] is ready for your review. Please use the master copy at [LINK].

By [DATE], please check:
1. Your team can attend the proposed dates and you have enough staff cover.
2. Anyone on leave has a suitable alternative before their deadline.
3. People due for a refresher have a booking that meets their individual requirements.

Please reply with any conflicts or missing sessions so we can agree on a workable arrangement before confirming bookings.

Thanks,

Each month after that, check the calendar in this order:

1. Mark sessions that ran as Done. Record individual attendance and completion in your learning platform or a separate register.
2. Review missed or moved sessions against their deadlines, then check the new room, trainer and staff arrangements.
3. Add new intakes and update personal renewal records from confirmed completion dates.
4. Review the next three months with managers for leave, busy periods and coverage gaps.

A calendar shows what you planned and which sessions ran. Use attendance and completion records alongside it to review training measures. After each programme, check whether people can apply what they learned, then use the findings to plan the next session.

When a spreadsheet calendar is not enough

• For the day itself, run each session from a training agenda.
• When chasing enrolments takes longer than planning, use an LMS that assigns and tracks each course and keep the calendar for the dates.
• For shared editing, agree where the master file lives, who can change dates and how managers hear about changes. Avoid circulating several editable email attachments.

Version 1.1 (19 October 2026) was checked in Microsoft Excel on Windows. The workbook has space for 300 sessions, 12 programme names in Year view and 20 person-course renewal records. It does not send invitations or reminders. Google Sheets, LibreOffice and Excel for Mac have not been tested.

Planning your training year

Use the blank workbook for your own dates and keep the completed example beside it while you plan. Once the dates and delivery arrangements are agreed, Coursebox’s employee training software can help you create the self-paced courses that sit alongside your live sessions.