Optimizing Excel 2002

Overview/Description
To provide an overview of the calculation, chart-creation, and web-enabled features in 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
255 Minutes

Objectives:

Optimizing Excel 2002

  • enter and edit formulas to perform basic calculations in Excel 2002.
  • create a formula in Excel 2002.
  • use references and names in Excel formulas.
  • enter a formula that uses cell and name references in Excel 2002.
  • 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.
  • use logical, financial, and date functions in Excel 2002.
  • insert a financial function into an Excel 2002 worksheet using the Insert Function feature.
  • create charts to display data in Excel 2002.
  • create a chart using the Chart Wizard in Excel 2002.
  • modify charts and chart source data in Excel 2002.
  • change the data series used in a chart in Excel 2002.
  • insert and modify a pie chart in Excel 2002.
  • insert and modify shapes and lines in Excel 2002.
  • insert a picture into a worksheet in Excel 2002.
  • save an Excel worksheet as a web page.
  • add a hyperlink to an Excel worksheet and run web queries.
  • create a hyperlink within an HTML spreadsheet in Excel 2002.
  • e-mail a workbook as an attachment in Excel 2002.
  • e-mail an Excel workbook as an attachment.
  • create and e-mail an HTML worksheet in Excel 2002.


    • Course Number: 115117_eng