Excel 2000 MOS: Worksheets and Workbooks
Product Code: E2KM05 Time: 3 Hour(s) CEUs: .30

Summary:

This course shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in Excel 2000 worksheets.

Objectives:

After completing this course, students will be able to:
  • Insert and delete rows and columns
  • Hide and unhide rows and columns
  • Freeze and unfreeze rows and columns
  • Move between worksheets in a workbook
  • Rename, insert, delete, move, and copy worksheets
  • Link worksheets, consolidate data, and check spelling

Outline:

  • Working with Rows and Columns
  • Working with Worksheets
  • Linking Worksheets and Consolidating Data
  • Zooming and Spell-Checking

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 Core certification exam.

Prerequisites:

Excel 2000 MOS: Working with CellsExcel 2000 MOS: Working with FilesExcel 2000 MOS: Formatting WorksheetsExcel 2000 MOS: Page Setup and Printing

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 © 2004 eLearningDepot.com. All rights reserved.