Interactive Excel Student Performance Dashboard - FREE File Download

Building Excel Dashboards from student performance data requires some different techniques to your typical dashboard, because you have a lot of data to fit into a small space. In this video I cover both the dynamic array and non-dynamic array techniques.

0:00 Introduction
0:53 Layout and Data
1:44 Slicers
4:19 SORTBY Dynamic Array Student ID Column
6:50 INDEX & MATCH Gender Column
7:50 Symbols for grades
9:58 Sparklines
12:47 Failures column & Custom Number Format
13:28 Study Time & in-cell charts
14:38 Absentee Time & Conditonal Formatting Bars
15:20 Travel Time & Conditional Formatting Icons
16:18 Family Size column
16:29 Health & Emoji Chart
17:32 Line Chart
19:59 Non-dynamic Array Dashboard Formulas

[hankgrimes]

Well, Ms. Treacy, it's official; I want to be YOU when I grow up!😆 Watching you work is, well, awe inspiring and more than a little enviable. I've been on this Excel journey for some time now, and I want to thank you for creating something that is smack in the middle of my wheelhouse. As an educator/program administrator, I'm always on the lookout for projects that are relatable to language education/learning, assessment, and analysis, and this fits the bill perfectly. THANK YOU!!

[patrick.schommer]

Incredible! I really liked that you didn't use PivotTables (not that there's anything wrong with them), but instead used emojis and wingding for give the dashboard some simple flair. Thanks also for the reminder to try and incorporate dynamic arrays into my work. It's so easy to fall back on what I know works and forget about their power.

[IvanCortinas_ES]

I love the way you create sparklines. A big round of applause.

[jimfitch]

Wow! Wow! Wow! You had me from the opening with pseudo pivot tables to generate slicers. I’ve needed that for quite some time. If that’s been demonstrated before, I missed it. I loved all the other tricks, too. I knew these tips, but never thought of using them on dashboards. Thanks for the inspiration!

[SonofthewindsInc]

Awesome Dashboard. I think Students will love this graphic feedback. 👍👍👍👍👍

[syrophenikan]

I applied some Conditional Formatting to the Health column to color the hearts Red/Yellow/Green according to value. It looks really nice; not too busy in the color department. Great video!!!

[alparkson]

Extraordinary job, Mynda. Most appreciated were the study time, travel time and health indicator icons. Absolutely brilliant!😀

[joetonka]

Brilliantly put together - Stephen Few's Student Dashboard illustrated in his information dashboard design book

[hugoguerin]

Amazing, as always - you made me progressing so much with excel & Power Query within the last months. You are brilliant. Thank you

[kama]

Absolutely brilliant, thank you Mynda 👏

[Russellsouthey]

Astonishing! Well done - so interesting to see what Excel can do. Thank you for posting these amazing videos.

[zukarimorni]

Awesome, you never fail to inspire me when viewing your sharing.❤

[ruuds]

A few techniques that were new to me. Thank you for sharing.

[chrism]

this is awesome Mynda. Almost makes we want to become a teacher :)

[YouExcelTutorials]

Great tutorial as usual...So much useful techniques packed in this video. Thanks Mynda!

[projektexcel]

Incredible! I love creating dashboards in Excel, but this is amazing!

[syrophenikan]

Also, the Study Time column can be made clearer by defining the end (i.e., MAX) of the range using a Custom Number format of ";;;@*-" (no quotes). This way, you can gauge more clearly where the vertical line is relative to the largest value. The vertical line show where you are within the entire range instead of stopping at some point. I like to use a pipe character instead of a lowercase "L" as it is a tiny bit bigger.

[Luciano_mp]

Beautiful and useful Dashboard. Very good Mynda. Thank you!

[erikguzik]

Nice SIMPLE dashboard. comment "Limited the colors so its not so noisy" -- LOL, Im guilty of that too many times. All the tips and tricks used will work for so many different things. Thats what makes these videos so awesome, you may never have this data, but when you need to show something - wait here's an idea i remember from a video. Your spark line it 3) A+'s !!!

[MuhammadAbdullah-elwz]

Simple, but fascinating, thank you mynda✌️