How to Create an Excel Dashboard for Schools with changing students images dynamically

Here’s an interesting video on creating a dashboard in Excel.

Chapters:

  • 0:00, Dashboard Features & contents Overview
  • 1:25, workbook contents
  • 1:50, 1st Dashboard background
  • 2:27, 2nd Dashboard background
  • 3:43, Left side buttons
  • 5:47, Values & charts background
  • 7:05, Main title and KPIs
  • 10:06, Side menu background image
  • 11:21, Students per educational stage column chart
  • 16:12, Activities and Events
  • 17:48, Events report
  • 18,44, Re-locate side buttons & Hyperlinks
  • 20:15, Teacher Dashboard
  • 20:26, Design teacher photos
  • 21:53, Timeline slicer
  • 22:42, Days slicer
  • 23:15, Changing images & values dynamically
  • 35:30, Protect the dashboard

Frank

#DataScientist, #DataEngineer, Blogger, Vlogger, Podcaster at http://DataDriven.tv . Back @Microsoft to help customers leverage #AI Opinions mine. #武當派 fan. I blog to help you become a better data scientist/ML engineer Opinions are mine. All mine.