Description
Know exactly who can do what in your team and see your skills gaps instantly, with a sleek, modern dark dashboard.
What it does
- Rate up to 20 team members across 20 skills, tasks or processes
- Simple 0–4 colour-coded scale (X = exempt, 1 = not yet capable, 2 = in training, 3 = capable, 4 = expert)
- Set a current AND target level for every person and skill
- Capability percentages, gaps and team scores calculate automatically
- Individual current vs target chart, KPI tiles, capability gauge and donut chart
Perfect for
Team leaders, training managers, HR, manufacturing, engineering, healthcare, client services, and anyone keeping training records for ISO 9001 or other audits.
How it works
- Add your team names, job roles and skills.
- Type ratings in the white cells.
- Everything else updates instantly. Formulas are protected, so nothing can break.
File details
- 1 Excel workbook (.xlsx)
- Works in Microsoft Excel 2016 / 365 (desktop recommended)
- Instant digital download – nothing is shipped
Please note
- Sample names are for illustration only.
- Due to the nature of digital products, refunds are not offered. If you have any issues, contact me and I’ll gladly help.
- For use within one organisation. Reselling or sharing the file is not permitted.
Prefer a lighter look? This template is also available in a Light Edition in the shop.
Thank you for choosing Macro-Tools – Smart Templates. Better Workflows.












Reviews
There are no reviews yet.