Summary

In this chapter, you learned

• What XML is and how it can be used to create and exchange data with others, regardless of the computer systems or software applications that they use.

• How to use Excel 2002 to open, import, and analyze XML data.

• How to use Access 2002 to import and export XML data.

In the next chapter, “Extending Office Data Analysis Features with Code,” you will learn how to work with code macros, procedures, and object models to create automated data analysis solutions using Excel, Access, the Microsoft Office Web Components, and Microsoft Data Analyzer.