Download the exercise file here.
*Requires Excel 2013 or greater*
You can import .XML data straight from the web into Excel with the WEBSERVICE( ) and FILTERXML( ) functions.
In this video we will get real-time updates from Weather.gov. Data source: http://w1.weather.gov/xml/current_obs/
We will then build a dynamic input source to display current weather conditions for locations across Ohio (the heart of Excel!).