-
Excel workbook preview
Learning, Training and Development
Training Needs Analysis Workbook
3 downloads per free account, no card needed.
Who this is for
An L&D lead who must turn managers' training wish lists into a ranked, costed list for the budget meeting next week.
What is inside
- 11 worked sample needs plus 20 blank rows, with Source, level, score and status dropdowns
- Live formulas: gap, priority score (gap x impact x urgency), priority band and total cost
- Legal items banded Mandatory and funded first; non-training causes excluded from the ranking
- Summary sheet with cumulative cost by band that turns green or red against the budget you enter
- Scoring Guide sheet with 5 impact and urgency levels and the band cut-offs
- Overdue target dates turn red until the need is delivered or closed
How to use it: Delete the sample rows, enter one row per need, score impact and urgency with the guide, then enter your budget on the Summary sheet.
Files & formats
- XLSXtraining-needs-analysis-workbook.xlsx15 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves. These templates are original working documents built on the public law or guidance named here. They are not legal advice and are not endorsed by the government body or publisher.



