Practical Templates · Planning · Free Excel (.xlsx)

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
Annual Training Plan Workbook template preview — Needs survey responses — yellow rows are sample entriesEnlarge ⤢

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

  1. 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.
  2. 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.
  3. Enter instructor fees excluding VAT, and leave the materials and venue columns blank for online courses.
  4. 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)

RankCompetencyImportanceCurrent levelNeed score
1stUsing generative AI at work4.42.39.24
2ndCoaching and feedback (managers)4.52.97.20
3rdData analysis and Excel4.12.85.33
4thWriting documents and reports4.33.15.16
5thPerformance management and goal setting (managers)4.23.05.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 coursesTotal participants (cumulative)Training hours per employeeTotal budget (excl. VAT)Training cost per employee
10 courses519 participants11.0 hoursKRW 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

Stuck while filling out the template? → 1:1 inquiry on instructors and curriculum · See training costs first (quote calculator)

Frequently asked questions

How is the needs index calculated?

Needs index = (average importance − average current level) × average importance (the Borich needs index). The more important a competency is and the weaker current performance is, the higher the value. The workbook calculates it from the responses and ranks the results automatically.

How is training cost per employee calculated?

Total budget is the sum of instructor fees, materials, and venue costs for each course, plus other expenses and a contingency, divided by the number of employees. Enter only the number of employees and the contingency rate; everything else is calculated automatically.

Are the templates free?

Yes, they are free. Just leave your company name, name, and email to download the template you choose right away. We also email you the same file.

Can I adapt a template to our company format?

Yes, you can swap in your company logo and approval box and use it as an in-house template. We only ask that you do not sell it elsewhere or redistribute it as is.

More practical templates

We offer every template for running a training program, from planning through reporting, completely free. Browse the full practical template library →

Document Library — Practical Documents for Training Managers and Corporate InstructorsDocuments such as an AI training adoption plan, a statutory mandatory training calendar, a training budget table, and a sample instructor proposal are also available the same way, with filled-in examples.View Documents ›

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