Build an interactive and dynamic NFL schedule and Standings Table in Excel @indzara
Build an interactive and dynamic NFL schedule and Standings Table in Excel  @indzara
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
Build an interactive and dynamic NFL schedule and Standings Table in ExcelExcel Tutorial: Creating Column Charts for Multiple Series ComparisonColour of Column in Column Chart | Excel Quick TutorialVacation & Attendance Tracker Dashboard - Ch 4 Lesson 6 - Employee Report - Conditional FormattingQuick Excel Charts: Stunning Multi-Series Chart in Just 60 Secs!Vacation & Attendance Tracker Dashboard - Ch 4 Lesson 7 - Employee Report - Monthly SummaryVacation & Attendance Tracker Dashboard in Excel - Chapter 3 Lesson 2 - User InputsRecruitment Tracker Dashboard | Thank you for the feedbackQuick Excel Charts: Creating 100% Stacked Column Charts with TotalsExcel for Visualization: Slider Chart in 60 Seconds!Create a Nested Column Chart in Excel in a Minute!9 Box Grid Excel Template for Talent Management - HR Template
Indzara - Simple and Effective Templates |

Build an interactive and dynamic NFL schedule and Standings Table in Excel

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER