Five ready-to-use Excel tools to run a mentoring or training programme, and prove to a sponsor it worked.
The problem
This pack ends with a number.
Open the workbooks, fill them in, and the dashboards do the rest. No building, no formulas to write. The five tools share one join key: a participant ID (never names), so the numbers flow from survey to tracker to ROI to the sponsor one-pager.
What's inside
Three tabs. The Dashboard computes the use-case funnel (named → committed → adopted), confidence lift, completion, and a Green/Amber/Red roll-up a sponsor reads in 30 seconds.
The two-wave instrument with auto-scoring. The headline number (cohort confidence lift) computes itself against the benchmark.
T+30 / T+60 / T+90. Adoption rate and a clearly-labelled estimated annual value, computed.
The frequency × pain grid; sweet-spot cells highlight automatically.
The sponsor presentation template: lift + adoption + quotes + the ask.
Built-in discipline
"The value figure is always labelled a self-reported estimate, never an audited saving."
That label is what protects your credibility in the room. Over-claim once and you lose the person whose budget funds the next cohort.
Run it, and prove it worked.