Microsoft Excel 97 Introduction: Creating Charts, Enhancing Worksheets

Overview/Description
This course, Microsoft Excel 97 Introduction: Creating Charts, Enhancing Worksheets, discusses creating charts, applying intermediate formatting techniques such as text boxes, headers and footers, and pictures, and performing simple functions. The course also includes a review of introductory Excel features.

Target Audience
This course requires that you have a working knowledge of basic Excel operations.

Expected Duration
This course, including the practice exercises, will take up to 4 hours to complete.

Objectives:

Creating Charts

  • Create a chart
  • Change the chart type
  • Add chart enhancements
  • Modify chart options
  • Print a chart

    • Enhancing a Worksheet File

  • Use AutoFormat
  • Use conditional formatting
  • Add comments to cells
  • Add a text box
  • Work with shapes and pictures
  • Enter header and footer text
  • Change the page layout

    • Using Functions

  • Name a cell
  • Use the Sum function
  • Use labels in formulas
  • Use statistical functions
  • Conduct a test
  • Review basic spreadsheet and graph operations


    • Course Number: MOFF0012