Advanced Data Exchange in Excel 2003

Course details

• Describe how Excel 2003 is used to share data between people and applications, and through the Web
• Creating links in Excel 2003
• © s After completing this topic, you should be able to link spreadsheets and books, and embed files in Excel 2003.
• Linking workbooks in Excel 2003
• © s After completing this topic, you should be able to link and embed data in an Excel 2003 workbook.
• Importing data from text files in Excel 2003
• © s After completing this topic, you should be able to import data from a text file into an Excel 2003 workbook.
• Creating queries in Excel 2003
• © s After completing this topic, you should be able to create a query in Excel 2003.
• Importing data from Excel 2003 to another application
• © s After completing this topic, you should be able to import data from Excel 2003 in other applications.
• Working with data from other applications in Excel 2003
• © s After completing this topic, you should be able to import external data into Excel 2003 and import Excel data into another application.
• Use of Web data in Excel 2003
• © s After completing this topic, you should be able to import data from the Web in Excel 2003.
• Creating Web queries in Excel 2003
• © s After completing this topic, you should be able to create a Web query in Excel 2003.
• Introduction to XML in Excel 2003
• © s After completing this topic, you should be able to identify the key concepts of XML and work with XML files in Excel 2003.
• Creating XML documents in Excel 2003
• © s After completing this topic, you should be able to create an XML document in Excel 2003.
• Creating an XML document from Excel 2003
• © s After completing this topic, you should be able to create a simple XML document in Excel 2003.