Excel 2000 MOS Expert: Importing and Exporting Data

Summary:

This course shows users how to import data from Excel to other applications, query a database application to extract data, and export data from other applications into Excel.

Objectives:

After completing this course, students will 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

Outline:

Importing Data Using the Text Import Wizard
Importing Text by Other Methods
Importing Data from an Application or File
Querying a Database
Exporting Data to an Application

Features:

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

Applicability:

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

Prerequisites:

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 98 or higher. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher (5.5 or higher for MindLeaders Central) required. Macromedia Flash player 6.0 is recommended for full functionality, but not required to play the courses. Sound card, with speakers or headphones is recommended, but not required to play the courses. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

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

Terms of Use:

None