Uploaded January 2024 | Updated November 2026, 3 days ago
Welcome to the “Data to Decisions”.
In this video, you'll learn how to turn raw data from the NFL regular season 2023 from ESPN’s website into a series of polished, interactive, and dynamic Excel visuals.
We cover every step needed to transform a basic dataset into a dynamic set of NFL tables and visuals, including:
0:31 Creating a Grid Visual of the NFL Schedule: View the full season at a glance with team logos extracted from a web URL using the IMAGE function.
18:56 Data Transformation of the NFL Schedule: Techniques to dynamically visualize weekly NFL schedules, Converting grid data into detailed game lists using Power Query
27:21 Data cleanup of the NFL Standings data: Discover how to tidy up the NFL Standings table using advanced text manipulation techniques. Watch and learn as we employ Excel functions like Power Query and custom formulas to refine our data set.
37:36 Building an Interactive NFL Weekly Schedule: Dive into conditional formatting and other Excel tricks to make a schedule that responds to your inputs.
53:12 Building an Interactive NFL Team Schedule: Focus on one team at a time with a schedule that filters based on the team selected.
1:07:29 Creating a Visual NFL Standings Table: Use Excel's powerful data visualization tools to represent team standings vividly and informatively.
This video is perfect for Excel enthusiasts, sports statisticians, and NFL fans who want to elevate their data-handling skills. With these skills, you can easily track your favorite teams, analyze their progress throughout the season, and make predictions based on standings and weekly matchups. Whether you're preparing for your fantasy league or just love crunching sports data, this guide will help you become an Excel MVP!
For tutorials that address common Excel problems, visit indzara.com/datatodecisions
Welcome to the “Data to Decisions”.
In this video, you'll learn how to turn raw data from the NFL regular season 2023 from ESPN’s website into a series of polished, interactive, and dynamic Excel visuals.
We cover every step needed to transform a basic dataset into a dynamic set of NFL tables and visuals, including:
0:31 Creating a Grid Visual of the NFL Schedule: View the full season at a glance with team logos extracted from a web URL using the IMAGE function.
18:56 Data Transformation of the NFL Schedule: Techniques to dynamically visualize weekly NFL schedules, Converting grid data into detailed game lists using Power Query
27:21 Data cleanup of the NFL Standings data: Discover how to tidy up the NFL Standings table using advanced text manipulation techniques. Watch and learn as we employ Excel functions like Power Query and custom formulas to refine our data set.
37:36 Building an Interactive NFL Weekly Schedule: Dive into conditional formatting and other Excel tricks to make a schedule that responds to your inputs.
53:12 Building an Interactive NFL Team Schedule: Focus on one team at a time with a schedule that filters based on the team selected.
1:07:29 Creating a Visual NFL Standings Table: Use Excel's powerful data visualization tools to represent team standings vividly and informatively.
This video is perfect for Excel enthusiasts, sports statisticians, and NFL fans who want to elevate their data-handling skills. With these skills, you can easily track your favorite teams, analyze their progress throughout the season, and make predictions based on standings and weekly matchups. Whether you're preparing for your fantasy league or just love crunching sports data, this guide will help you become an Excel MVP!
For tutorials that address common Excel problems, visit indzara.com/datatodecisions










