Team Fitness Testing Framework in Microsoft Excel

Categories: Microsoft Excel

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

Course Content

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 1

03:20
The Inner Workings: Part 2

05:09
The Inner Workings: Part 3

11: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.

Team Fitness Testing Framework in Microsoft Excel

About Course

What Will You Learn?

Course Content

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 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.

Data Set Overview

In-table Calculations

Dashboard Planning

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.

Dynamic Scoring System Setup, Part 1

Dynamic Scoring System Setup, Part 2

Dynamic Scoring System Setup, Part 3

Connecting Custom Scores to the Data, Part 1

Connecting Custom Scores to the Data, Part 2

Metric Categories and Weightings

Controlling for Athletes Who Didn’t Complete All Tests

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

Building Our First Interactive Dashboard Component: A Table of Results

Adding Colors (Conditional Formatting), Part 1

Adding Colors (Conditional Formatting), Part 2

Interactive Graphs and Charts: The Setup

Interactive Graphs and Charts: Building Them Out

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.

Dynamic Drop-downs, Group Averages, and Making Things Pretty

The Finale

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.

Dynamic Graphs Using Table Filters, Part 1

Dynamic Graphs Using Table Filters, Part 2

Calling Out the Best and Worst Performers

A Confidential Chart Hack: Dynamic Average Lines and Horizontal Bar Charts

About Course

What Will You Learn?

Course Content

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 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.

Data Set Overview

In-table Calculations

Dashboard Planning

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.

Dynamic Scoring System Setup, Part 1

Dynamic Scoring System Setup, Part 2

Dynamic Scoring System Setup, Part 3

Connecting Custom Scores to the Data, Part 1

Connecting Custom Scores to the Data, Part 2

Metric Categories and Weightings

Controlling for Athletes Who Didn’t Complete All Tests

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

Building Our First Interactive Dashboard Component: A Table of Results

Adding Colors (Conditional Formatting), Part 1

Adding Colors (Conditional Formatting), Part 2

Interactive Graphs and Charts: The Setup

Interactive Graphs and Charts: Building Them Out

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.

Dynamic Drop-downs, Group Averages, and Making Things Pretty

The Finale

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.

Dynamic Graphs Using Table Filters, Part 1

Dynamic Graphs Using Table Filters, Part 2

Calling Out the Best and Worst Performers

A Confidential Chart Hack: Dynamic Average Lines and Horizontal Bar Charts

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.

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.