Advanced Data Exchange in Excel 2003

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
To describe how to use Excel 2003 to share data between people, applications, and on the Web

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites
Familiarity with the Windows 2000 or XP user environments

Expected Duration (hours)
3.7

Lesson Objectives

Advanced Data Exchange in Excel 2003

link worksheets and workbooks and embed files in Excel 2003.

link and embed data in a workbook in Excel 2003.

import data from text files into an Excel 2003 workbook.

create a query in Excel 2003.

import data from Excel 2003 into other applications.

import external data into Excel 2003 and import Excel data into another application.

import data from the Web into Excel 2003.

create a web query in Excel 2003.

outline core XML concepts and work with XML files in Excel 2003.

create an XML document in Excel 2003.

create a simple XML document in Excel 2003.

Course Number:
119748_eng