Exchanging Data with Excel 2007

Overview/Description
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.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level or an equivalent.

Prerequisites
Some knowledge of word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality

Expected Duration (hours)
3.0

Lesson Objectives

Exchanging Data with Excel 2007

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