Uploaded January 2024 | Updated September 2026, 2 weeks ago
Welcome to our latest tutorial on "Data to Decisions"! In this video, we're embarking on an exciting journey, transforming raw NFL schedule data from ESPN.com into a stunning visual display using Microsoft Excel. Whether you're a sports enthusiast, data analyst, or Excel aficionado, this tutorial is packed with valuable insights and tips.
đź”— What's Inside:
00:00:00 - Introduction to Data Visualization Project
00:00:32 - Extracting NFL Schedule Data from ESPN
00:01:25 - Identifying and Selecting Data Tables
00:01:48 - Cleaning and Transforming Data in Power Query
00:03:26 - Adjusting Rows and Setting Headers
00:04:09 - Understanding the NFL Schedule Data Structure
00:06:49 - Loading Cleaned Data into Excel
00:07:44 - Creating Dynamic Logos with Excel Formulas
00:08:07 - Finding Logo URL Structure on ESPN
00:09:01 - Writing Formulas for Dynamic Logo Retrieval
00:10:08 - Adjusting Formulas for Team Abbreviations
00:11:02 - Applying Formulas Across Multiple Cells
00:12:04 - Handling Bye Weeks in the Schedule
00:13:23 - Conditional Formatting for Road Games
00:15:49 - Recap and Conclusion of the Visualization Process
đź“Š Key Highlights:
Data Extraction: Learn to pull data directly from websites into Excel.
Data Cleaning: Discover techniques to clean and organize your data effectively.
Visual Representation: Master the art of transforming data into dynamic visuals with team logos.
Excel Tricks: Gain insights into advanced Excel features like conditional formatting to enhance your data presentation.
👉 Stay Tuned: Don't forget to subscribe and hit the bell icon to stay updated on our latest videos. If you have any suggestions or topics you'd like us to cover, feel free to comment below.
Check our blogs on extracting data and images from a web URL:
indzara.com/extract-data-from-web-into-excel
indzara.com/extract-images-from-web-into-excel
For tutorials that address common Excel problems, visit indzara.com/datatodecisions
🙏 Thank You: A big thank you to our viewers for your continued support. Your feedback and engagement help us create content that makes data fun and accessible.
Welcome to our latest tutorial on "Data to Decisions"! In this video, we're embarking on an exciting journey, transforming raw NFL schedule data from ESPN.com into a stunning visual display using Microsoft Excel. Whether you're a sports enthusiast, data analyst, or Excel aficionado, this tutorial is packed with valuable insights and tips.
đź”— What's Inside:
00:00:00 - Introduction to Data Visualization Project
00:00:32 - Extracting NFL Schedule Data from ESPN
00:01:25 - Identifying and Selecting Data Tables
00:01:48 - Cleaning and Transforming Data in Power Query
00:03:26 - Adjusting Rows and Setting Headers
00:04:09 - Understanding the NFL Schedule Data Structure
00:06:49 - Loading Cleaned Data into Excel
00:07:44 - Creating Dynamic Logos with Excel Formulas
00:08:07 - Finding Logo URL Structure on ESPN
00:09:01 - Writing Formulas for Dynamic Logo Retrieval
00:10:08 - Adjusting Formulas for Team Abbreviations
00:11:02 - Applying Formulas Across Multiple Cells
00:12:04 - Handling Bye Weeks in the Schedule
00:13:23 - Conditional Formatting for Road Games
00:15:49 - Recap and Conclusion of the Visualization Process
đź“Š Key Highlights:
Data Extraction: Learn to pull data directly from websites into Excel.
Data Cleaning: Discover techniques to clean and organize your data effectively.
Visual Representation: Master the art of transforming data into dynamic visuals with team logos.
Excel Tricks: Gain insights into advanced Excel features like conditional formatting to enhance your data presentation.
👉 Stay Tuned: Don't forget to subscribe and hit the bell icon to stay updated on our latest videos. If you have any suggestions or topics you'd like us to cover, feel free to comment below.
Check our blogs on extracting data and images from a web URL:
indzara.com/extract-data-from-web-into-excel
indzara.com/extract-images-from-web-into-excel
For tutorials that address common Excel problems, visit indzara.com/datatodecisions
🙏 Thank You: A big thank you to our viewers for your continued support. Your feedback and engagement help us create content that makes data fun and accessible.
