Data clean up of NFL Standings table in Microsoft Excel @indzara
Data clean up of NFL Standings table in Microsoft Excel  @indzara
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.
Data clean up of NFL Standings table in Microsoft ExcelHow to Create Bar within a Bar Chart in Excel?Vacation & Attendance Tracker Dashboard - Ch 4 Lesson 3 - Employee Report - Calendar Months & DatesHow to Create a Dynamic Column Chart Sorted by Measure in Excel?Free, Customizable & Print-Friendly 2024 Excel CalendarInstant Dumbbell (Round) Charts in ExcelHijri Calendar 2025 + 24 stunning calendar designs | Download Now!Instant Charts: Column with Line & Highlights for Time Series DataCreate a Dynamic Waterfall Chart in Microsoft ExcelCreate Custom 100% Stacked Bar Charts with Totals in Excel – Quick Tutorial!Mastering Excels XLOOKUP FunctionCreate Multi-Series Bar Charts in Excel – Easy Guide!
Indzara - Simple and Effective Templates |

Data clean up of NFL Standings table in Microsoft Excel

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER