Basic Features of Excel 2002


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



Overview/Description
To provide an overview of the basic features of Excel 2002

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)
3.4

Lesson Objectives

Basic Features of Excel 2002

  • launch Excel 2002, describe the basic features of a workbook and worksheet, and use the help features.
  • enter and edit data in cells, navigate a workbook, and filter data.
  • select, cut, copy, and paste a cell and a range of cells in Excel 2002.
  • insert and edit data in a cell in Excel 2002.
  • save a new workbook and save an updated workbook in Excel 2002.
  • name an Excel file and save it as a specified file type.
  • apply and adapt a range of Excel cell formats.
  • format and manipulate rows and columns in an Excel 2002 worksheet.
  • apply number formatting to a cell in Excel 2002.
  • apply formatting to cell content in Excel 2002.
  • insert, modify, and move worksheets in Excel 2002.
  • add and manipulate a new worksheet in Excel 2002.
  • add a worksheet, rename a worksheet, and format cells and numbers in Excel 2002.
  • use comments, run a spell check, and use the previewing features in Excel 2002.
  • adjust the Page Setup options before printing a document in Excel 2002.
  • use a range of printing-option features in Excel 2002.
  • adjust and preview printing options in Excel 2002.
  • Course Number:
    115096_eng