Retrieve Real-time Weather Data from in Excel using FILTERXML

Download the exercise file here. Requires Excel 2013 or greater. These are new functions in Excel. You can import .XML data straight from the web into Excel with the WEBSERVICE( ) and FILTERXML( ) functions. In this lesson we will get real-time updates from Data source: View the YouTube tutorial here. Be sure […]