Working with RealTime Data in Excel

Working with Real-Time Data in Excel

Our Excel Workshop series shows how to develop key data science and analytics skills through applied learning in Excel. In this course, Chris Dutton focuses on using real-time data from a web API and supplemental data from the National Climatic Data Center (NCDC) to understand and quantify the impact of weather patterns on accident rates.

Topics include:

• Standardizing data
• Creating new data dimensions fields
• Joining data
• Analyzing trends in the data with COUNTIF
• Creating an API feed with WEBSERVICE
• Extracting components with FILTERXML
• Applying your new skill set