Excel XML, XPath and XSLT Workflows

Extend your advanced Excel skills with XML and XSLT processing

Created by: Grant Gamble
Developer, trainer and author

What Will I Learn?

• You will learn the basics of XML and the role played by DTDs and schema documents in XML validation.
• You will learn how to import and export XML data into and out of Microsoft Excel.
• You will learn how to use XML mapping to target specific parts of the XML documents you are importing.
• You will learn how to use the WEBSERVICE function to retrieve data from an online web service.
• You will learn how to use Excel's FILTERXML function to extract data from both online and local XML data sources.
• You will how to construct XPath statements to target specific locations within an XML document.
• You will learn how to use XSLT stylesheets to reshape XML documents into an Excel-friendly structure.
• You will learn the basic syntax used in XSLT stylesheets and how XPath is used within XSLT.

Requirements

• Microsoft Excel 2016, 2013, 2010 or 2007.

Target audience

• This course is designed for experienced Excel users who are used to working with formulas and functions. No knowledge of XML, XPath or XSLT is assumed.