Skip navigation

Extract components with FILTERXML

Extract components with FILTERXML: Working with Real-Time Data in Excel
Extract components with FILTERXML: Working with Real-Time Data in Excel

Extract individual nodes, or components, from an XML string using Excel’s FILTERXML function. Use basic XPath syntax to isolate and compare real-time elements from Weather Underground’s API feed, including temperature, precipitation, wind speed, and location. Understand the importance of using FILTERXML to process and organize XML data for analysis in Excel.

Resume Transcript Auto-Scroll
Skill Level Intermediate
1h 18m
Duration
97,190
Views
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now