Synopsis
Excel 2000 MOUS Expert: Importing and Exporting Data shows users how to import data from other applications into Excel query a database application to extract data and export data from Excel to other applications.

Audience
This course is for anyone preparing for the MOUS Excel 2000 Expert certification exam.

Time
4 hours

Product Code: E2KE01
After completing Excel 2000 MOUS Expert: Importing and Exporting Data the user should be able to:

Import data from a text file
Import data from an application
Import a table from an HTML file
Query a database
Export data to an application

Importing Data Using the Text Import Wizard
Different types of text files
Using the Text Import Wizard

Importing Text by Other Methods
Linking to a text file
Copying and pasting data
Dragging data

Importing Data from an Application or File
Importing from another application
Formatting after the import
Importing a Web page
HTML round-tripping a worksheet

Querying a Database
Creating a database query
Linking the data
Refreshing linked data

Exporting Data to an Application
Saving a file as another type
Exporting to an Access database table

This course has the following features:

Exercises that allow users to practice in Excel 2000
A file containing the text of the exercises
Simulations that allow users to practice course skills even if they don't have access to Excel 2000
A glossary
A Skill Assessment

Excel 2000 MOUS: Working with Cells (E2KM01)
Excel 2000 MOUS: Working with Files (E2KM02)
Excel 2000 MOUS: Formatting Worksheets (E2KM03)
Excel 2000 MOUS: Page Setup and Printing (E2KM04)
Excel 2000 MOUS: Worksheets & Workbooks (E2KM05)
Excel 2000 MOUS: Formulas and Functions (E2KM06)
Excel 2000 MOUS: Charts and Objects (E2KM07)

Microsoft® is a registered trademark of Microsoft Corporation. Excel® is a registered trademark of Microsoft Corporation. Microsoft and the Microsoft Office User Specialist Logo are registered trademarks of Microsoft Corporation in the United States and other countries.