Capstone Projects
Four end-to-end projects that combine everything in the course. Pick one, ship it, show it.
Capstone 5 lessons ~~6 hours
You've learned the moves. Now build the dance. Each capstone is a real-world project you can finish in 2-6 hours, share with colleagues, and put on your portfolio.
💡 You don't have to do all four
Pick the one closest to your job. Do that one well. Come back for the others when you need them.
Lessons in this module
- Capstone 1 — Monthly close pack (Finance) · 90 min
End-to-end: load, reconcile, variance, AR aging, FX P&L, single Excel output, scheduled. - Capstone 2 — Self-refreshing dashboard (Analyst) · 90 min
A daily-refresh dashboard from a database export, with anomaly detection. - Capstone 3 — Headcount + payroll prep + tracker (HR) · 90 min
Three monthly HR jobs in one weekly script. - Capstone 4 — Pipeline + campaign report (Sales/Marketing) · 90 min
A weekly Monday email that combines pipeline, marketing spend, and ROAS. - Where to go from here · 8 min
Books, sites, communities, and the next skills worth learning.