Team Fitness Testing Framework in Microsoft Excel

Categories: Microsoft Excel
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

In this course, we will build a database and interactive team fitness testing dashboard together. Throughout the videos, we review the ins and outs of database and dashboard design. A version of Microsoft Office 2013 or newer is required to complete this course (Office 2013, Office 2016, Office 2019, Microsoft 365).

Team Fitness Testing Dashboard after completing tutorial

What Will You Learn?

  • Data management
  • Data analysis
  • Data visualization
  • Database construction
  • Microsoft Excel skills

Course Content

An overview of how the final file will work and the key features of the data set that we will be using throughout the course.

  • The Inner Workings: Part 1
  • The Inner Workings: Part 2
  • The Inner Workings: Part 3

Building a Database
We learn how to set up a fitness testing database in Microsoft Excel that allows for an interactive dashboard experience.

Dynamic Scoring Framework
We learn how to build a custom a dynamic scoring framework whereby each metric is associated with an easily digestible score; we give ourselves the ability to choose how each metric score is calculated from an array of options.

Getting Visual
We create visual elements for our interactive team fitness testing dashboard using our well-organized database structure and dynamic scoring system.

The Finale: Interactions and Design
We organize our dashboard into a nice design, facilitate the interactions, and include features such as Freeze Panes to enhance workflow.

We create more visual elements for our interactive team fitness testing dashboard, including interactive charts that are controlled by our table, and calling out the top and bottom performers for our metrics of interest.