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.
|