Training Roadmap Template: Free Excel, With an Example
Get a free training roadmap Excel template and worked example. Link goals to programmes, check timing and resources, and plan reviews.
A training roadmap links learning programmes to business goals and shows their sequence, audiences, owners, costs and measures over a chosen period.
- Investigate the work behind each goal before choosing training. Record a baseline and a target so you can review progress later.
- Check prerequisite order using actual dates where needed. A quarter-level timeline cannot resolve the order of two activities within the same quarter.
- Learner hours, external spending and initiative counts help compare plans, but team availability, delivery effort and payment timing still need review.
- Plan a review after an early phase, using work evidence and learner feedback to decide what to change.
Scale training programs and cut development time using AI
A training roadmap connects the work people need to learn with the organisation’s goals. It shows which programmes you will run, why they are needed and how they fit together over time. Add audiences, owners, costs and measures so the plan can be reviewed before people commit their time.
The free Excel template below plans four quarters of training. It totals learner hours and planned external spending, draws a timeline and flags missing information, ordering questions and limits you set.
There is a fictional worked example for an 80-person professional services firm, plus three separate programme samples. Use the guide to make the planning decisions, then record them in the workbook.
I'm the CEO of Coursebox, and I've spent over a decade selling and supporting learning platforms for corporate teams and registered training organisations. Coursebox makes training management software to build courses, assign learners and review completion.
The firm’s first draft has eight initiatives linked to four business goals. One workshop series overlaps the coaching course it depends on, five initiatives run in quarter 3 against a review threshold of four, and planned spending is AUD 3,000 above budget. The example shows how to investigate those warnings before agreeing the plan.
The download includes that first draft so you can inspect the warnings and try the changes described below.
Download the blank four-quarter roadmap or the fictional firm example with its timeline, budget and review warnings. The example file also includes three separate programme samples and a guide to related planning documents.
Open the quarterly workbook preview at full size
What a training roadmap is
A training roadmap sets out the direction and sequence of learning over a chosen period. Here, it is an annual plan for an organisation or department. A roadmap can also cover a shorter programme or several years; choose a time horizon that matches the decision you need to make.
What goes in one
| Part | What it answers | From the firm's roadmap |
|---|---|---|
| Business goals | What the organisation needs to change | Cut rework on client reports from 18% to 10% |
| Initiatives | The training that serves each goal | Report writing and review course, for 40 consultants |
| Timing | Which quarters each initiative runs in | Quarter 2 |
| Size | People, hours and cost | 40 people, 6 hours each, 6,000 |
| Dependencies | What has to finish first | The needs analysis in quarter 1 |
| Owner and measure | Who is accountable, and how you'll know it worked | L&D lead; the rework rate |
The goals explain why each initiative is proposed. The measures give you something to review later: did the work improve, and what evidence suggests the training contributed? A change in a business result alone does not show that training caused it.
Roadmap, plan, calendar or path?
These documents answer related questions. Their names and time spans overlap between organisations, so agree what information your team needs rather than treating the labels as fixed rules.
| Document | Covers | Time span | Answers |
|---|---|---|---|
| Training roadmap | The organisation or a department | Chosen horizon, such as a year | Which initiatives, in what order, for which goals |
| Training plan | A team or one programme | Weeks to a year | Who takes which training, by when |
| Training calendar | Everyone attending sessions | Weeks to months | Dated sessions, rooms and trainers |
| Learning path | A role or one learner | Days to months | The order of courses one person works through |
| Curriculum map | A programme or qualification | The whole programme | Which course covers which outcome |
Once the roadmap is agreed, the sessions go into a training calendar. An academy on the roadmap becomes a learning path for each person who takes it.
Learning and development, or training?
Training often focuses on tasks people need to perform in their current roles. Development can prepare them for wider responsibilities or future roles. A roadmap can include both, as well as practice, coaching and access to useful guidance.
In the firm’s example, the privacy refresher addresses current requirements. The coaching programme helps team leaders develop how they support their teams. Neither label determines the format: both need a clear purpose and a suitable way to check progress.
Who reads it
| Reader | What they look for |
|---|---|
| Leadership | Which business goals the training serves, and what it costs |
| Managers | When their people are away, and what they'll come back able to do |
| L&D and HR | The order of work, owners, budget and what to measure |
Write the summary for leadership, and keep the detail in the workbook.
How to build a training roadmap
The steps follow a fictional professional services firm with 80 staff. It is planning calendar year 2027: Q1 is January to March, Q2 April to June, Q3 July to September and Q4 October to December. Its assumed external-spending budget is AUD 35,000, excluding staff salaries, and its learning allowance is 40 hours per person.
Step 1: Agree the business goals
Ask leadership what needs to change, then record a measure, its current value (the baseline), a target and an owner. The CIPD learning needs analysis guidance connects learning needs with business strategy. The workbook has room for five goals; that is a file limit, not a recommendation to choose five.
The firm’s assumed goals are to improve client retention from 72% to 80%, reduce report rework from 18% to 10%, shorten the time to a new starter’s first billable project from eight weeks to five, and complete its required privacy and anti-money-laundering training. These are example targets to replace with your own approved requirements.
Open the business goal and training diagram at full size
Step 2: Find the needs behind each goal
Find out what is preventing the desired result. Report rework could reflect a skill gap, unclear review criteria or a difficult process. In this example, the needs analysis happens in Q1 before the report-writing course, new-starter academy and coaching programme. Required refresher training proceeds separately.
Use a training needs analysis questionnaire to gather the needs, and a skills gap analysis to rank them.
Step 3: List the initiatives and link each to a goal
An initiative is one planned piece of work, such as a course, workshop series, academy or review. Give it a stable number and link it to the goal it supports. Use “All” for shared groundwork, and explain the purpose of a general resource library before including it.
If a goal has no linked initiative, the workbook flags it for discussion. That does not mean a course must be added: the goal may need a process change, recruitment or another response. Record that decision alongside the roadmap.
Step 4: Size each initiative
Estimate participants, hours per participant and external cost for each initiative. Learner hours means participants multiplied by hours each: 40 consultants taking a six-hour course creates 240 learner hours. It does not include the facilitator’s preparation, administration or cover needed while people attend.
The eight initiatives total 1,824 learner hours, an organisation-wide average of 22.8 hours across 80 staff. That is below the assumed 40-hour allowance, but some people attend several initiatives while others attend fewer. Check each audience’s workload, managers’ release time and facilitator availability before agreeing the schedule.
Step 5: Place them in quarters, in order
Place each initiative in its start and end quarter, then enter the number of any prerequisite: work that must finish first. The client-conversation workshops depend on the coaching course. Both are planned in Q3, so the file asks you to check the actual dates. A quarter-level view cannot tell whether coaching finishes early enough within that quarter.
Workshops and coaching overlap in Q3
Example: Fictional 80-person firm, calendar year 2027, before the proposed changes.
- 1. Prerequisite: The workshops refer to initiative 6, the coaching programme.
- 2. Q3 overlap: Both activities appear in Q3. Check dates or move the workshops to Q4.
Open this workbook preview at full size
Lloyds Metals: delivering procedures in stages
In the Lloyds Metals case study, the production team describes splitting a procedure into smaller training packages delivered at different times. Its new operators also need college learning and supervised experience on site.
This illustrates the sequencing question a roadmap should make visible: what do people need to learn first, and what experience must follow? A row marked complete is only one part of that review; it does not establish readiness for independent work.
Step 6: Check the load and the budget
The workbook counts active initiatives in each quarter and compares them with your chosen review threshold. It also spreads each initiative’s learner hours and external cost evenly over its active quarters. Use that allocation to compare the draft, then check real attendance and payment dates separately.
Quarterly hours and external spending
Example: Fictional 80-person firm, calendar year 2027, before the proposed changes.
- 1. Quarter 3: Five initiatives exceed the chosen review threshold of four. Check audiences and facilitators before deciding what to move.
- 2. Allocation assumption: Hours and cost are spread evenly across each initiative’s active quarters; actual payment dates can differ.
- 3. Budget: Total external spending is AUD 38,000 against an AUD 35,000 budget.
Open this workbook preview at full size
In the example, moving the client workshops to Q4 puts them after Q3 coaching. It also brings Q3 down from five active initiatives to four. This meets the chosen review threshold; managers still need to confirm that the people and facilitators are available.
The second assumed change is to replace the AUD 3,000 tools-library licence with suitable free resources. That brings planned external spending from AUD 38,000 to AUD 35,000. Check the replacement’s suitability, permissions and preparation time before accepting the saving. The workbook then reports “Checks clear: review plan”, leaving approval to the people responsible.
Two large programmes for the same team can be harder to deliver than five small programmes for separate teams. Check participant overlap, release time, preparation and facilitation. Move work, add support or redesign activities where needed; an initiative count alone cannot establish capacity.
Step 7: Plan a review after the first phase
Put a review on the roadmap itself, with an owner and evidence to examine. The firm’s review follows the report-writing course. Check work samples and rework rates as well as attendance and learner feedback, then decide whether to continue, change or postpone later work.
In one programme we supported, learners said the first two courses in a 14-course programme contained too much text. The remaining courses were revised with more interaction. Planning a review after an early phase leaves time to act on that kind of feedback before the whole programme has been delivered.
Once the roadmap is agreed, use Coursebox to build and assign courses. Course prerequisites can support a required order. Keep the roadmap’s dates, budgets and review decisions alongside the delivery records. Track release dates and reminders in your team’s scheduling process.
Training roadmap examples for other programmes
These requests describe plans people wanted to build. They do not show whether the programmes were delivered or achieved their goals.
These three fictional samples illustrate different programme lengths and audiences. Each is a separate tab in the example workbook, not a component of the professional services firm’s annual plan. Timings and checks are assumptions to adapt.
A sales onboarding academy
This separate example gives new sales representatives six stages over 12 weeks, totalling 40 planned hours each. Before the final team-lead review, define what a satisfactory conversation or demonstration must include.
| Stage | When | Audience | Hours each | Measure |
|---|---|---|---|---|
| 1 Product and market | Week 1 | New reps | 6 | Quiz pass |
| 2 Our sales process | Week 2 | New reps | 4 | Process walkthrough |
| 3 Discovery calls | Weeks 3 to 4 | New reps | 8 | Recorded role play |
| 4 Demos and objections | Weeks 5 to 6 | New reps | 8 | Observed demo |
| 5 Live calls with a buddy | Weeks 7 to 10 | New reps | 12 | Buddy feedback |
| 6 Sign-off | Week 12 | New reps | 2 | Team-lead sign-off |
Give people opportunities to practise before they handle live customer work. The Secure Meters case study shows a curriculum that starts with fundamentals before progressing to product knowledge. In the sales sample, use the role plays and observed demonstrations to decide what further support is needed.
A four-week hospitality programme
This sample spreads four planned hours across short lessons and supported practice. Complete relevant food-safety and allergen instruction before staff undertake those duties; the week numbers do not override that requirement.
| Stage | When | Audience | Hours each | Measure |
|---|---|---|---|---|
| Food safety and allergen procedures | Before relevant duties | All new staff | 1 | Approved knowledge and practical checks |
| Week 2 Service standards | Week 2 | Front of house | 1 | Manager check on shift |
| Allergen questions: supervised practice | After initial instruction, before independent duties | All staff | 1 | Observed use of approved information and referral |
| Week 4 Complaints and recovery | Week 4 | Front of house | 1 | Observed role play |
Check whether the planned hours are enough for the tasks and the people involved. Add supervised practice and any required assessment; a short quiz alone cannot establish safe practical performance.
A three-course compliance path
This separate fictional path shows three pieces of learning across three quarters. Required instruction must happen before the relevant work or regulatory deadline, even when that means changing the sample’s order or timing.
| Stage | When | Audience | Hours each | Measure |
|---|---|---|---|---|
| 1 Current rules | Q1 | All staff | 2 | Assessment pass |
| 2 The firm's obligations | Q2 | All staff | 2 | Attestation |
| 3 Upcoming changes | Q3 | Managers | 1 | Briefing attended |
The course order helps learners encounter the rules before completing an acknowledgement. Define what the attestation records and keep the evidence your organisation requires. Attendance or a signature alone does not demonstrate compliance or capability.
Presenting the roadmap for sign-off
Give leadership a concise decision summary, with access to the underlying workbook and assumptions. Include:
- The goals, each with its measure, baseline and target.
- The initiatives by quarter, with the "Must" items marked.
- The total cost and hours, against the budget and the allowance.
- What you're not doing, and why, such as the "Could" items that didn't fit.
- When you'll review it, and what would make you change it.
At each review, compare the work with its baseline and record what changed. Consider other changes, such as a new system or staffing, before attributing the result to training. Use that evidence to update the remaining roadmap.
Common training roadmap mistakes
| Mistake | What happens | What to do |
|---|---|---|
| Starting from a list of courses | It is hard to explain why the courses were chosen | Start from business goals with measures |
| More work than people can support | The same learners or facilitators are needed in several places | Check audience overlap and delivery effort, not just the number of goals |
| Initiatives out of order | Advanced training runs before the basics | Enter prerequisite IDs and check actual dates for same-quarter work |
| One overloaded quarter | People are away from work too often | Review learner/facilitator capacity, then change the sequence or resources |
| Never revisiting it | Changes in needs and availability can be missed | Put a review on the roadmap itself |
| Planning without managers | Managers can't release people when needed | Show managers the quarters before sign-off |
When a roadmap isn't the right tool
- For one person's growth, write a development plan rather than a roadmap.
- To map outcomes across courses in a qualification, use a curriculum map.
- To plan one course in detail, start with a course outline.
- To set and defend the budget, see this guide to a training budget.
The downloads are version 1.1, reviewed on 21 October 2026. The Excel files support five goals and 20 initiatives over four quarters and were tested in Excel for Windows. Other spreadsheet platforms are untested; the PDF is a static worked example.
Building your training roadmap
Start from a few business goals with measures, and let a needs analysis tell you which ones need training. Link every initiative to a goal and give it an owner, then size it and put it in order. Check the load and the budget, and plan a review after the first phase.
To build and assign the training once the roadmap is agreed, start with Coursebox's training management software.
Frequently Asked Questions
A plan connecting learning programmes to business goals over a chosen period. It shows what will run, why, in what order, for whom and with what resources. This template uses an annual four-quarter view; roadmaps can use other time horizons.
Here, the roadmap explains the direction, priorities and sequence across several initiatives. A detailed training plan adds delivery and participation arrangements for a team or programme. Organisations use the names differently, so agree the required detail.
Goals with baselines and targets; initiatives linked to those goals; audiences, owners, timing, prerequisites, hours, cost and measures; and planned review points. Record the assumptions behind the estimates.
Agree the goals, investigate learning needs, choose suitable initiatives and estimate their resources. Sequence the work, check audience and facilitator capacity, then agree how progress will be reviewed.
Choose the horizon that fits the work and how far ahead you can make useful decisions. This workbook covers four quarters. Give near-term activities more detail, and revisit later activities as needs, resources and results become clearer.
Travis Clapp
Travis Clapp is the original founder and CEO of Coursebox. As an experienced instructional designer, he has lived through the process of building high quality courses. These experiences brought about his idea to upload all your documents and ideas into a virtual box that could convert those magically into a course. Prior to Coursebox, he successfully founded and built a social based LMS. Travis has 15+ years of experience designing courses and EdTech platforms from university MOOCs to enterprise LMS. Travis has built training for reputable companies like Johnson & Johnson, Electrolux, Michael Hill and SA Health. One of his courses reached 20,000+ learners which was a flagship edX course. He is based in the Adelaide, South Australia office and passionately works on customer support, sales and bringing the original product vision to life every day.
