I recently completed an Excel report that analyzes GCSE exam results and turns complex data into a clear visual story. In this video, I walk through how I cleaned the raw data, created automatic calculations, and designed interactive charts that help schools quickly identify performance trends by teacher, student group, gender, etc.

This project shows how data visualization can transform plain spreadsheets into a tool for smarter decisions — saving educators time while highlighting what really matters: student progress.

➡️ Tools used: Microsoft Excel (Pivot Tables, Formulas, Conditional Formatting, Dynamic Charts, VBA) ➡️ Deliverables: Fully automated report + video guide for easy use

🎥 Check out the video to see the full workflow in action!