Excel XML, XPath and XSLT Workflows
Extend your advanced Excel skills with XML and XSLT processing
4.55 (300 reviews)
1,637
students
4 hours
content
Sep 2017
last update
$69.99
regular price
What you will 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.
Screenshots
1341248
udemy ID
9/4/2017
course created date
11/22/2019
course indexed date
Bot
course submited by