Team Fitness Testing Framework in Microsoft Excel


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 I Learn?

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

Topics for this course

24 Lessons10h 30m


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 13:21
The Inner Workings: Part 25:08
The Inner Workings: Part 311:10

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.

Material Includes

  • Exclusive access to tutorial videos
  • PDF with MS Excel and databasing tips and tricks
  • Completed Microsoft Excel file after each lesson
  • Instructor support through our exclusive Q&A forum


  • Internet connection
  • Microsoft Excel 2013 or later (2013, 2016, 2019, Office 365)

Target Audience

  • Strength coaches
  • Sports scientists
  • Physical therapists
  • Sport coaches
  • Collegiate students in exercise, physiology, or data science fields
  • Microsoft Excel users