The Workbook boss cannot do more functions. It can do order.
The whole Excel course you connected: grades, pocket money, survey, charts, data clean-up, a scenario model, a dashboard for the teacher, protection, history, a one-truth audit. The Boss calculates nothing new — it puts the pieces into a pack that a stranger understands in a minute.
Today the final hand-in and a certificate.
Workbook boss check list
| Lesson | Can you? |
|---|---|
| KPI + monthly overview | ☐ |
| IMPORTRANGE (or one workbook) | ☐ |
| History / a named version | ☐ |
| Comments resolved | ☐ |
| Formula protection | ☐ |
| Dashboard for the teacher | ☐ |
| Dashboard PDF | ☐ |
| One-truth audit | ☐ |
Final pack
-
Dashboard: KPI, chart, survey sentence. Default sheet. Hidden Poznamky.
-
Sharing: teacher view. Teammate comment. The class not edit the whole workbook.
-
PDF: dashboard
lastname-excel-finale.pdf. Optionally data sheets from Chart maker/Sorter. -
Named version:
Handover-finale-2026. -
Audit: audit table OK. Ctrl+F hardcoded numbers gone.
Certificate: finished the whole Excel academy at Workbook boss level? In Certificates print the Workbook boss diploma 🗂️ — and earlier levels too, if you caught up.
What you built
- 🏫 Grade average — table, average, chart, KPI.
- 💰 Pocket money — a week, a model, scenarios.
- 📊 Class survey — clean-up, summary, chart, sentence.
- 🏆 Mini dashboard — one screen of truth.
That is not four projects. It is one workbook, four views.
🏫 Grade average — finale
Znamky!B8 → Dashboard C3. Chart A1:B6. Protection B8.
💰 Pocket money — finale
KPI total C. Model on the sheet. Scenarios for parents, not for the class.
📊 Class survey — finale
D:E COUNTIF, sentence on the dashboard, raw data hidden.
🏆 Mini dashboard — finale
PDF on the noticeboard. A link to the teacher. One workbook, one truth, one screen.
Now you 💪
- Tick off the Workbook boss checklist.
- Send a parent the dashboard PDF + a sentence about what you learned about “one truth”.
- Pick up the certificate. You earned it.
Check: The whole Excel course — from a cell to a dashboard — done. You are a Workbook boss. 🎉
What to take from this lesson
- Boss = dashboard + sharing + audit + hand-in.
- Four projects = one workbook, four views.
- Workbook boss certificate = the finale of the Excel academy.
© 2026 Ing. Martin Polak / AlgoRhino · Content usage terms