School Management Dashboard in Excel: Exams, Enrolment and Events

A school management dashboard in Excel puts students, faculty, exam results, transport and enrolment trends on one screen. This one was designed for school principals, academic managers and education analysts who need a clear picture of each stage of the school without digging through separate spreadsheets. The video below builds it step by step, from the exam result chart to event photos that change on their own.

If you would rather start from the finished file than build it from scratch, the School Management Dashboard Excel template is ready to use with your own data. Either way, the tutorial is worth watching, because the techniques carry over to any dashboard you build later.

What the school management dashboard in Excel tracks

The dashboard combines headline numbers with a few focused charts, so a school leader can read the situation in seconds and then look at the detail.

• Total students and total faculty members
• Student attendance and retention rate
• Faculty attendance and retention rate
• Enrolment breakdown by gender
• Bus transportation management

On the visual side you get:

• An examination result bar chart
• A doughnut chart for course percentages
• A student enrolment line chart with a forecast
• A column chart for monthly learning hours
• An event frame whose images update automatically

The layout is repeated for separate stage dashboards (Primary, Secondary and Advanced), so each part of the school gets its own page with the same structure.

How the education dashboard is built in Excel

Everything in the video uses standard Excel: shapes and icons from Excel's own library, charts, a PivotTable, a slicer and a couple of formulas. Here is the build order.

1. Exam results with two layered charts

The exam result graph is actually two charts stacked together. The first uses a rounded rectangle pasted into the bars for smooth edges, with a light gray series behind it to show the remaining percentage. The second chart adds a circular shape on top of each bar, with white data labels and a soft circular shadow.

The result numbers are then shown in text boxes linked to the database, so they refresh when the data changes.

2. Donut chart for performance

A donut chart shows how the course percentages compare. Keeping the ring thin and the colors consistent with the rest of the page makes it easy to read at a glance.

3. Enrolment chart with actual vs. forecast

The enrolment table is modified to hold two columns, Actual and Forecast. A combo chart then mixes a line and an area chart. The forecast line and the actual line are formatted differently, a circular marker highlights the current year, and extra points are hidden so the chart stays clean.

4. Study hours columns

The monthly learning hours use columns with rounded edges. Light gridlines stay, but the axis labels are hidden, which gives a lighter, more modern look.

5. Event photos that change automatically

This is the most interesting part of the tutorial. The steps are:

1. Insert a PivotTable and a slicer for the event number.
2. Place the event images on a separate sheet and give each one a name.
3. Use VLOOKUP to match the selected event number with its image name.
4. Define a name with the INDIRECT function so it points to the right image dynamically.
5. Link an image object to that named range.

Pick a different event in the slicer and the picture in the frame changes with it, no VBA required. If named ranges are new to you, our guide on using INDIRECT with named ranges in Excel explains the idea in more detail, and the post on using VLOOKUP like a pro covers the lookup step.

6. Stage pages and navigation

Finally the sheet is duplicated for each stage and navigation buttons are added so users can jump between the Primary, Secondary and Advanced dashboards.

Who this school dashboard is for

• School principals who want a one-page overview for meetings.
• Academic managers following attendance, retention and exam performance by stage.
• Education analysts who need to present enrolment trends with a simple forecast.
• Operations staff responsible for bus transportation.

Tips to adapt the student tracking dashboard to your school

• Keep one clean data table per topic (students, faculty, exams, events) and build every chart from it rather than typing numbers into the dashboard.
• Name your images carefully. The dynamic picture only works if the image names on the images sheet match the values your VLOOKUP returns exactly.
• Update the forecast column each year and move the current-year marker, so the chart always shows where you are today.
• Reuse the stage layout. If your school has different stages, duplicate a finished page and relink the values instead of rebuilding.
• Stick to a small palette. The video starts by showing the color codes and fonts used, and a consistent palette is what makes the stage pages feel like one system.

Want to practice the photo technique on real data? You can download the school dashboard dynamic photos dataset and follow along. For more files, browse our free Excel practice datasets, and see other school and student tools in the education dashboard templates collection.

Frequently asked questions

How do I make a school management dashboard in Excel?

Start with clean data tables for students, faculty, exams and events, then build charts and PivotTables from them on a separate dashboard sheet. Link text boxes to the data and add slicers or navigation buttons so users can move between views.

Can Excel show a different picture based on a slicer?

Yes. A slicer filters a PivotTable, VLOOKUP turns the result into an image name, a defined name using INDIRECT points to that image, and a linked picture displays it. It is all formulas, with no macros.

How is the enrolment forecast shown?

The source table has separate Actual and Forecast columns, and a combo chart draws them as different lines on top of an area chart, with a marker on the current year.

Does the school dashboard need VBA?

No. The tutorial uses shapes, charts, a PivotTable, a slicer, VLOOKUP and INDIRECT, all of which are standard Excel features.

Get the school dashboard template

Skip the build and start tracking students, faculty, exams and events today with the ready-made School Management Dashboard in Excel. Looking for something for another department? Browse all our Excel dashboard templates and pick the one that fits your data.