Excel Student Performance Dashboard

I've used a range of techniques to build the interactive Excel student performance dashboard below, which are covered in the video and there are links to further tutorials beyond. Building dashboards for student data requires different techniques to typical Excel dashboards because there is a lot of data to fit into a relatively small space. The introduction of dynamic array formulas make building this dashboard simple, but I also cover a non-dynamic array technique for those with Excel 2019 and earlier.

Watch the Step by Step Video

Download Workbook

Techniques Used in Excel Student Performance Dashboard

I used several techniques to build this Excel student performance dashboard and below you’ll find links to the individual tutorials on those topics.

1. Excel Tables
2. INDEX and MATCH Formulas
3. Slicers
4. Excel Charts
5. Dynamic Array Formulas
6. SORTBY Function
7. SEQUENCE function
8. Conditional Formatting Data Bars & Icons
9. Custom Number Formats
10. In-cell Charts
11. ROW function
12. RANK.AVG function

Learn More

The topics above are a great start, but if you’d like to take your Excel skills further, please consider our courses below:

Excel Dashboards Course – A comprehensive course designed to give you the skills to build dashboards for any industry.

Excel Advanced Formulas - I’ve designed this course to get you quickly up to speed with the functions that are going to give you the biggest efficiency gains. Many of the functions are considered advanced, but when you’ve finished the course, you’ll know like I do, that everything is easy once you know how.

Excel Expert Course – This course includes the PivotTable Quick Start and Advanced Formulas course as well as a load more topics covering everything from beginner topics (which you can skip if you already know them) to more advanced topics.