Exchanging Data with Excel 2007

Course details

In Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in conjunction with Excel enables you to further manage and customize workbooks. This course explores creating links, importing text files, and creating database and web queries. Importing Excel 2007 data into other applications and using XML in Excel 2007 are also covered.

• create links to data
• identify how to import data
• embed a file in a workbook
• create database queries in Excel 2007
• import an entire Access table
• import Excel data into Access
• copy Excel data to Word
• import Excel data into Outlook
• embed a file in a workbook
• import data from a text file into Excel
• import data from a database into Excel
• use Excel data in a Word document
• retrieve data from an Access database using the Wizard
• create a manual query to retrieve data from an Access database
• identify how XML works in Excel
• recognize the components of a basic XML system
• create an XML map and map elements to it
• import XML data
• export XML data into mapped cells
• use XML data in Excel 2007