Microsoft Excel 97 Intermediate: Functions, Windows, Advanced Charts

Overview/Description
This course, Microsoft Excel 97 Intermediate: Functions, Windows, Advanced Charts, discusses intermediate techniques such as using the date and time and vlookup functions, working with multiple windows and workbooks within Excel, and modifying and enhancing charts.

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:

Working With Functions

  • Use date and time functions
  • Use the vlookup function

    • Working with Workbook Windows

  • Open and arrange multiple windows
  • Split a window into panes
  • Work with sheets in a workbook
  • Link data
  • Merge workbooks

    • Performing Advanced Chart Operations

  • Add text to a chart
  • Reformat chart axes
  • Add gridlines and objects to a chart
  • Modify data in a chart, and change chart data


    • Course Number: MOFF0013