Excel 2000 MOS Expert Series: Formatting, Sorting, and Filtering Data
Product Code: e2ke03 Time: 3.0 hour(s) CEUs: Available

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:

  • 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


Topics:

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

Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Copyright Information:
Product names mentioned in this catalog may be trademarks/servicemarks or registered trademarks/servicemarks of their respective companies and are hereby acknowledged. All product names that are known to be trademarks or service marks have been appropriately capitalized. Use of a name in this catalog is for identification purposes only, and should not be regarded as affecting the validity of any trademark or service mark, or as suggesting any affiliation between MindLeaders.com, Inc. and the trademark/servicemark proprietor.

Terms of Use:

Copyright © 2006 MindLeaders. All rights reserved.