Creating an NFL Standings visual in Microsoft Excel @indzara
Creating an NFL Standings visual in Microsoft Excel  @indzara
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.
Creating an NFL Standings visual in Microsoft ExcelVacation & Attendance Tracker Dashboard - Ch 4 Lesson 4 - Employee Report - Start and End DatesVacation & Attendance Tracker Dashboard in Excel - Chapter 3 Lesson 5 - Calendar Data Named RangesRSI Strategy Backtesting Template for Microsoft ExcelOptimize Your Trades with Smart Backtesting!How to Unpivot Data in Excel using formulas?MACD Strategy Backtester Excel TemplateConverting NFL schedule grid matrix to a list of NFL games in Microsoft ExcelStock Portfolio Tracker in Microsoft ExcelHow to create a dynamic monthly calendar in Excel with a single formula?How to Use Gantt Chart for HR Performance Management Tracking?Master Resource Management with Our Free Excel Capacity Calculator Template
Indzara - Simple and Effective Templates |

Creating an NFL Standings visual in Microsoft Excel

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER