Computer Based Training - Excel 2000 MOS Expert: Formatting, Sorting, and Filtering Data

Summary:

This course shows users how to format numeric data, create custom and conditional formats, sort and group data, use data forms for data entry and retrieval, and use filters to extract data.

Objectives:

After completing this course, students will be able to:

Apply accounting, currency, and number formats to data
Create a custom number format
Use and apply conditional formatting
Sort data
Generate subtotals
Group and outline data
Use a data form for data entry and retrieval
Create a data filter
Extract data

Outline:

Formatting Numbers
Using and Applying Conditional Formats
Sorting and Grouping Data
Using a Data Form
Using a Data Filter

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:

Excel 2000 MOS Expert: Importing and Exporting DataExcel 2000 MOS Expert: Working with Templates, Links, and Report Manager

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. 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