Microsoft Office 2000 - Beginning Excel


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
To provide an introduction to the core concepts of Microsoft Excel 2000

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel

Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration (hours)
4.8

Lesson Objectives

Microsoft Office 2000 - Beginning Excel

  • recognize the basic features of Excel, identify how to navigate within an Excel worksheet, and get help using the Office Assistant.
  • enter, modify, and find and replace data.
  • add data to and navigate a spreadsheet.
  • cut, copy, and paste data using the Edit menu or the Clipboard.
  • cut, copy, and paste data, and use the Office 2000 Clipboard.
  • recognize how to adjust column and row size and format cell appearance.
  • center cell data, merge cells, and shade cells.
  • recognize the different style options available in Excel 2000, and change font styles.
  • identify the different number formats in Excel 2000, and apply a number style to cells.
  • change a font size and color, and select a new number style.
  • create, open, and save an Excel workbook.
  • open and save a workbook, and save a workbook as a web page.
  • recognize the function of the print and print preview features.
  • insert a hyperlink into an Excel spreadsheet and recognize e-mail.
  • recognize how Excel uses formulas and functions, and create and edit a formula.
  • create and edit a formula.
  • identify the main features of the Fill Formula, AutoSum and AutoCalculate functions.

    • Course Number:
    111080_eng