Skip navigation

Extract components with FILTERXML

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

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.

  • Overview
  • Transcript
  • View Offline
Resume Transcript Auto-Scroll
Skill Level Intermediate
1h 18m
Duration
52,524
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