New tools in Microsoft Office Excel 2003 make it easier to work with Extensible Markup Language (XML). Learn how to use these tools to create XML lists and XML maps. XML lists have the same look and feel as regular Excel lists, but they take their data from XML files. XML maps are sets of links between the cells in a worksheet and the elements in an XML schema. You can import data into the map, modify the data, and then save the changed data or export it for others to use.
After completing this course you will be able to:
This course includes:
XML is now a widely accepted standard for sharing data among computer users and computer systems. Two new tools in Excel 2003 — XML lists and the XML Source task pane — make it easier than ever to use XML.
This course explains the concepts behind these new tools, and shows you how to use them to process XML data in Excel 2003.
To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.
The practices for this course require that you have either Microsoft Office Excel 2003 or Microsoft Office Professional Edition 2003. You can not complete the practices by using the version of Excel that comes with Microsoft Office Standard Edition 2003. You also need a basic understanding of XML (including schemas and well-formed data) as well as Excel lists. For more information about XML, see XML: What's it all about? For training on Excel lists, see Lists I: How to use lists in Excel 2003.
United Kingdom
