Microsoft Office 2000 - Intermediate Excel


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


Overview/Description
To equip students with the knowledge and skills required to accomplish common Excel 2000 tasks efficiently, and to prepare students for certification as Proficient Users of 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.3

Lesson Objectives

Microsoft Office 2000 - Intermediate Excel

  • recognize the methods for inserting, deleting, and moving worksheets.
  • insert or delete columns and rows, and freeze window panes in Excel 2000.
  • move a worksheet to a new workbook, create and rename a worksheet, insert a row, delete a column, and freeze panes.
  • recognize the features of the Zoom and spelling check tools.
  • spell check a worksheet and add a word to the custom dictionary.
  • recognize the page settings available in Exel 2000, and change layout, margin and header and footer settings.
  • identify the options available in the Print Preview feature, and set a print area.
  • change the page settings, and set and clear the print area of a worksheet.
  • recognize the use of functions in Excel and create a count and logical function.
  • recognize how Excel uses financial and date functions, and create a FV and NOW function.
  • find maximum and minimum values for a range of cells and create a logical function in Excel 2000.
  • recognize how to consolidate data using 3-D references.
  • to calculate the future value of an investment and display the present date and time in a worksheet.
  • identify how Excel uses charts to display worksheet data and create a chart.
  • insert an object and recognize how Excel uses AutoShapes.
  • create a chart sheet and insert a picture as an object.

    • Course Number:
    111081_eng