Uploaded January 2024 | Updated November 2026, 2 days ago
Join us in this exciting episode of #datatodecisions, where we dive into the process of extracting and cleaning NFL standings data from ESPN.com for dynamic dashboard creation in Excel. This tutorial is a must-watch for anyone keen on mastering data manipulation and visualization techniques.
π In This Video:
0:59 Extracting NFL Standings Data: We start by pulling the latest 2023 NFL standings data into #excel directly from ESPN.com using Power Query
4:00 Data Cleanup in Excel: Learn how to use simple formulas to clean and prepare the data for visualization.
π Key Highlights:
Step-by-Step Data Extraction: Follow the process of extracting data from a web source directly into Excel using Power Query.
Handling Inconsistent Data: Discover techniques to deal with data irregularities, such as varying team name formats, and extract their abbreviations using the RIGHT and CODE functions in Excel.
Practical Application: Learn how these techniques can be applied in real-world scenarios, making your data work for you.
π Check our Previous Videos in the NFL 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
π What's Next: Stay tuned for our upcoming videos, where we'll take this cleaned data to create visually appealing and interactive dashboards for NFL data.
Check our related blogs here:
indzara.com/extract-upper-case-text-from-end-of-string
For tutorials that address common Excel problems, visit indzara.com/datatodecisions
Thanks for watching! If you found this tutorial helpful, please like, share, and subscribe for more data-driven content.
Join us in this exciting episode of #datatodecisions, where we dive into the process of extracting and cleaning NFL standings data from ESPN.com for dynamic dashboard creation in Excel. This tutorial is a must-watch for anyone keen on mastering data manipulation and visualization techniques.
π In This Video:
0:59 Extracting NFL Standings Data: We start by pulling the latest 2023 NFL standings data into #excel directly from ESPN.com using Power Query
4:00 Data Cleanup in Excel: Learn how to use simple formulas to clean and prepare the data for visualization.
π Key Highlights:
Step-by-Step Data Extraction: Follow the process of extracting data from a web source directly into Excel using Power Query.
Handling Inconsistent Data: Discover techniques to deal with data irregularities, such as varying team name formats, and extract their abbreviations using the RIGHT and CODE functions in Excel.
Practical Application: Learn how these techniques can be applied in real-world scenarios, making your data work for you.
π Check our Previous Videos in the NFL 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
π What's Next: Stay tuned for our upcoming videos, where we'll take this cleaned data to create visually appealing and interactive dashboards for NFL data.
Check our related blogs here:
indzara.com/extract-upper-case-text-from-end-of-string
For tutorials that address common Excel problems, visit indzara.com/datatodecisions
Thanks for watching! If you found this tutorial helpful, please like, share, and subscribe for more data-driven content.










