XML Master Certification

Excel and XML for Data Analysts
Learn how to understand XML documents in the context of commonly used companion codes for restricting content with XML Schema, navigating nodes with XPATH and transforming content with styles from XSLT.  BONUS: Validate XML with Microsoft Excel!

Lesson: Excel Statistical Functions

  • XML Structure and Syntax
  • Excel and XML
  • XML Schema Basics
  • XML Schema Gets Complex: Complex Elements
  • XML Validation
  • XML Mapping
  • XPATH Basics
  • XSLT Means Style

Lesson Demo: XML Schema Basics

Lesson Demo: XML Schema Gets Complex