Microsoft Excel 2000 Intermediate: Reviewing Charts and Lists

Overview/Description
This course, Microsoft Excel 2000 Intermediate: Reviewing Charts and Lists, presents intermediate techniques for creating and formatting charts, creating and managing lists, and importing and exporting files and file elements.

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:

Performing Advanced Chart Operations

  • Create a basic chart
  • Add text to a chart
  • Reformat chart axes
  • Add gridlines and objects to a chart
  • Modify data in a chart

    • Creating and Using Excel Lists

  • Create a list
  • Modify a list
  • Search for records in a list
  • Sort records in a list
  • Filter a list

    • Importing and Exporting Data

  • Import a text file
  • Insert an object
  • Insert a database
  • Import an HTML file
  • Export files


    • Course Number: MOFF0114