User name:
Password:
 

 

Copyright © 2006.
cisco-certificatiom.co.uk
All Rights Reserved
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 � 2006 Webteks. All rights reserved.