Annual Training Plan Excel Workbook — With Sample Entries
An Excel workbook where pasting in needs survey responses produces a ranking of demand by competency, and entering your course plan automatically calculates the budget, total trainee headcount, and cost per person. The last sheet gathers the figures you can copy straight into the annual training plan summary.
- FormatExcel (.xlsx) — just swap in your company logo and approval boxes
- What’s includedA blank template + a fully filled-in example for a fictional company
- How to get itLeave your company name, name and email for instant download + a copy by email
- CostFree
Enlarge ⤢Needs survey responses — yellow rows are sample entries
Fields in this template
- Enter survey responses (up to 300 people) → needs scores and rankings by competency are calculated automatically
- Monthly course plan — choose the delivery format; subtotals per course, participants, and hours are automatic
- Budget summary — contingency, total budget, and training cost per employee
- The five figures and top 3 needs to carry over to the 'Summary' of the annual training plan
- Sample entries — 20 responses and a 12-month plan filled in
Tips for completing it
- Download the survey responses from your survey tool and paste them into Sheet ① as they are. Just rename the competencies in your company’s own terms.
- First check that the green rows (top 3) on Sheet ② made it into ③ Course Plan. If they didn’t, the case for your plan is weaker.
- Enter instructor fees excluding VAT, and leave the materials and venue columns blank for online courses.
- The five figures in ④ Summary follow the same order as the summary line at the top of the annual training plan. Just copy them over.
Filled-in example — table view
A partial excerpt from an example filled in for a fictional company, Hanbit Precision Co., Ltd. (auto parts manufacturing · 280 employees). The file contains the blank template first, followed by this full example. Amounts and figures in the example are illustrative assumptions.
② Needs Ranking (Sample Entries — Top 5)
| Rank | Competency | Importance | Current level | Need score |
|---|---|---|---|---|
| 1st | Using generative AI at work | 4.4 | 2.3 | 9.24 |
| 2nd | Coaching and feedback (managers) | 4.5 | 2.9 | 7.20 |
| 3rd | Data analysis and Excel | 4.1 | 2.8 | 5.33 |
| 4th | Writing documents and reports | 4.3 | 3.1 | 5.16 |
| 5th | Performance management and goal setting (managers) | 4.2 | 3.0 | 5.04 |
Paste in the responses and Excel formulas do the calculating. 20 sample responses — all 10 competencies and the chart are in the file.
④ Summary — Figures to Carry Over to the Annual Training Plan
| Training courses | Total participants (cumulative) | Training hours per employee | Total budget (excl. VAT) | Training cost per employee |
|---|---|---|---|---|
| 10 courses | 519 participants | 11.0 hours | KRW 50,800,000 (≈ US$38,000) | KRW 181,000 (≈ US$135) |
Calculated automatically from the 12-month schedule and amounts you enter in ③ Course plan.
Get the Annual Training Plan Workbook
Download other templates too
You can download the Annual Training Plan Workbook right away. We will also email you a copy of the same file as a single zip. Company name, name, and email are all required; we do not collect phone numbers.
Selected templates: 1
You have already submitted a request from this browser — you can download right away without re-entering your details.
Stuck while filling out the template? → 1:1 inquiry on instructors and curriculum · See training costs first (quote calculator)
Works well with — Annual Training Plan · Training Needs Survey. You can download it right away in this browser without entering your details again.
Frequently asked questions
How is the needs index calculated?
How is training cost per employee calculated?
Are the templates free?
Can I adapt a template to our company format?
More practical templates
We offer every template for running a training program, from planning through reporting, completely free. Browse the full practical template library →
Stuck filling out a template?
If you need an instructor or curriculum while preparing training with this template, let us know. We will send you the instructor name, curriculum, and cost breakdown within 24 hours.
※ The statutory mandatory training cycles and tax rates shown are general guidelines for convenience in filling out the template. They may vary by your company’s industry and size, so please also check the underlying laws and your company’s tax policy.
Get This Template Free