Excel Smart School Dashboard Template

A ready-to-use Excel dashboard that brings attendance, educational-stage numbers and school events into one clear view. Pick a school year and month from two dropdowns and every card, chart and list updates from a single, editable data table — no macros, no add-ins.
 
Best for
School administrators and heads of year who report attendance and headcounts each month
Teachers or coordinators who track events and want one shared overview per school year
Anyone who already keeps school data in Excel and wants a presentable dashboard on top of it
 
What you get
Dashboard page: four KPI cards (Schools, Teachers, Students, Parents), a Calendar Attendance card with year strip and month grid, an Educational Stage chart, the month's Activities & Events, and Top-3 attendance cards
Teachers page: teacher, subject, current topic and comment, read from a table
Events page: six upcoming events with date, stage and description
Data sheet with four Excel Tables (attendance records 2019–2026, yearly KPIs, teachers, events) — replace the sample rows and everything recalculates
Calc sheet with every formula visible and documented; blue dropdown cells are the only inputs
Cover image (PNG and editable SVG) in the same visual style
 
Why it helps
One place to answer "how did attendance look in April, and who were the top students?" without rebuilding charts each month
Consistent, presentation-ready layout for staff meetings and parent evenings
Transparent formulas rather than hidden logic, so figures can be checked and audited
Easy to hand over: new users only change the dropdowns or add rows to the tables