Team Fitness Testing Framework in Microsoft Excel
Description
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).
What Will I Learn?
- Data management
- Data analysis
- Data visualization
- Database construction
- Microsoft Excel skills
Topics for this course
24 Lessons10h 30m
Introduction
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.
LEVEL-UP!
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.