Spreadsheets in Microsoft Excel 2002

Overview/Description
To demonstrate the basic procedures for creating, editing, and working with spreadsheets and charts in Microsoft Excel 2002

Target Audience
End users wanting to become familiar with IT concepts; end users wanting to attain competency in the use of computers; end users wanting to attain competency in the use of word-processing, spreadsheet, database, presentation, web browsing, and e-mail applications; end users wanting to attain an ECDL or ICDL certification or equivalent; staff of businesses and public bodies needing to attain certification in computer proficiency; university or other students needing to attain a basic IT qualification; staff of public bodies or organizations seeking to reskill themselves for the technology-based workplace; staff at universities, schools, or other training centers teaching computer literacy skills

Prerequisites
No prerequisites

Expected Duration
445 Minutes

Objectives:

Spreadsheets in Microsoft Excel 2002

  • launch Excel 2002, describe the basic features of a workbook and worksheet, and use the help features.
  • open, save, and close workbooks and close the Excel 2002 application.
  • 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.
  • modify the Excel 2002 interface and toolbars.
  • save a new workbook and save an updated workbook in Excel 2002.
  • name an Excel file and save it as a specified file type.
  • save an Excel worksheet as a web page.
  • 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.
  • apply a range of currency and date formats, modify cell formats, and save in different file formats 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.
  • print a spreadsheet in Excel 2002.
  • enter and edit formulas to perform basic calculations in Excel 2002.
  • create a formula in Excel 2002.
  • use a variety of basic formulas and describe how to use absolute and relative cell references.
  • enter a formula that uses cell and name references in Excel 2002.
  • find and sort data in an Excel 2002 spreadsheet.
  • use functions to perform calculations in Excel 2002.
  • insert a function into an Excel worksheet using the Insert Function feature.
  • create a function to perform a basic calculation using the Insert Function feature.
  • insert graphics, text files, and other objects in an Excel 2002 spreadsheet.
  • insert a picture into a worksheet in Excel 2002.
  • create charts to display data in Excel 2002.
  • create a chart using the Chart Wizard in Excel 2002.
  • edit and format charts and graphs in Excel 2002.
  • format a chart and change a chart type in Excel 2002.


    • Course Number: 116397_eng