| MP9002: Desktop Computing - Formatting, Sorting, and Filtering Data > Excel 2000 MOS Expert  | Formatting, Sorting, and Filtering Data | 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. | Topics: Formatting Numbers
Using and Applying Conditional Formats
Sorting and Grouping Data
Using a Data Form
Using a Data Filter
Objectives: 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
Duration: 3 Hours
|
|
|