Training satisfaction tally in Excel — with a filled-in example
An Excel workbook where entering each satisfaction survey as a single row automatically produces averages by area and by question, a Net Promoter Score (NPS), and charts. It also builds a separate table you can drop into your results report.
- 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 ⤢Response entry — yellow rows are the filled-in example
Fields in this template
- Response entry (100 people) — 12 questions on a 5-point scale + likelihood to recommend (0–10) + open-ended comments
- Averages by area and by question, with questions below 4.0 flagged automatically
- Automatic NPS calculation and per-question charts
- A table to paste into “3. Satisfaction Results” of the results report (with change from the previous session)
- Filled-in example — with 12 responses entered
Tips for completing it
- Question numbers match the “Training Satisfaction Survey” template. Just copy the completed survey in as is.
- Questions with an average below 4.0 are highlighted in red. Look here for what to change in the next session.
- NPS is the share of 9–10 scores minus the share of 0–6 scores. A score of +30 or higher suggests a training people would recommend to colleagues.
- Group open-ended responses by similar wording and note the count. This column, more than the numbers, is what shapes the next program.
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.
② Tally (filled-in example)
| Area | Average (out of 5) |
|---|---|
| Training content | 4.42 |
| Instructor | 4.72 |
| Operations | 4.25 |
| On-the-job application | 4.39 |
| Overall average | 4.45 |
| Likelihood to recommend (NPS) | +58 |
12 sample responses entered. Per-question averages, charts, and the table for the results report are in the file.
Get the Training Satisfaction Auto-Tally Sheet
Download other templates too
You can download the Training Satisfaction Auto-Tally Sheet right away. We also email you a copy of the same file in 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 using a template? → Instructor & curriculum 1:1 inquiry · See training costs first (quote calculator)
Templates that pair well with this one — Training Satisfaction Survey · Training Results Report. In this browser, you can download right away without re-entering your details.
Frequently asked questions
How is NPS calculated?
How many respondents can it handle?
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