Uploaded January 2024 | Updated November 2026, 1 day ago
Welcome to another insightful episode of Data to Decisions! In this video, we take our Excel skills up a notch by creating a dynamic visual representation of the latest NFL standings, broken down by division. Leveraging data from ESPN.com, we integrate win-loss records and division information to craft a comprehensive standings table. Perfect for Excel users who want to apply dynamic data visualization in their projects, be it for sports analytics or business applications.
π What You'll Learn:
1:32 Connect the Division table to the Standings table using Excel functions
3:13 Get the standings data for one division using dynamic, powerful Excel functions like FILTER, INDEX, SORT, and SEQUENCE
7:35 Copy the formula used in the previous step to get standings data for the rest of the divisions
9:21 Apply Conditional Formatting to enhance your visual output
π Check our previous videos in this series:
1. Creating the NFL Grid Visual with Logos of Teams - youtu.be/ulbA8NvS0Iw
2. Converting NFL schedule grid matrix to a list of NFL games - youtu.be/b9omuLU0VCk
3. Data clean up of NFL Standings table - youtu.be/TQ8Qjrgjby4
4. Creating an interactive NFL weekly schedule visual - youtu.be/6Lsj9L2a1LI
5. Creating an interactive NFL Team Schedule visual - youtu.be/9hhqAnp3PN4
Check our related blog posts here:
indzara.com/filter-non-adjacent-columns-in-excel
For tutorials that address common Excel problems, visit indzara.com/datatodecisions
Keep an eye out for our upcoming videos where we'll explore more data visualization and Excel functionalities.
Thank you for watching! If you find this tutorial useful, please like, share, and subscribe for more data-driven content. We value your feedback and suggestions in the comments below.
Welcome to another insightful episode of Data to Decisions! In this video, we take our Excel skills up a notch by creating a dynamic visual representation of the latest NFL standings, broken down by division. Leveraging data from ESPN.com, we integrate win-loss records and division information to craft a comprehensive standings table. Perfect for Excel users who want to apply dynamic data visualization in their projects, be it for sports analytics or business applications.
π What You'll Learn:
1:32 Connect the Division table to the Standings table using Excel functions
3:13 Get the standings data for one division using dynamic, powerful Excel functions like FILTER, INDEX, SORT, and SEQUENCE
7:35 Copy the formula used in the previous step to get standings data for the rest of the divisions
9:21 Apply Conditional Formatting to enhance your visual output
π Check our previous videos in this series:
1. Creating the NFL Grid Visual with Logos of Teams - youtu.be/ulbA8NvS0Iw
2. Converting NFL schedule grid matrix to a list of NFL games - youtu.be/b9omuLU0VCk
3. Data clean up of NFL Standings table - youtu.be/TQ8Qjrgjby4
4. Creating an interactive NFL weekly schedule visual - youtu.be/6Lsj9L2a1LI
5. Creating an interactive NFL Team Schedule visual - youtu.be/9hhqAnp3PN4
Check our related blog posts here:
indzara.com/filter-non-adjacent-columns-in-excel
For tutorials that address common Excel problems, visit indzara.com/datatodecisions
Keep an eye out for our upcoming videos where we'll explore more data visualization and Excel functionalities.
Thank you for watching! If you find this tutorial useful, please like, share, and subscribe for more data-driven content. We value your feedback and suggestions in the comments below.










