Microsoft Excel 2000 Intermediate: Functions, Formats, and Workbooks

Overview/Description
Description: This course, Microsoft Excel 2000 Intermediate: Functions, Formats, and Workbooks, discusses the basic operations for working with functions, formats, and workbook windows.

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:

Formatting Worksheets

  • Display and format data
  • Outline and group data
  • Validate data
  • Create and use styles
  • Create custom formats

    • Working with Functions

  • Enter date and time functions
  • Use financial and logical functions
  • Use absolute and relative references
  • Use named ranges
  • Look up values in a table

    • Managing Worksheets and Workbooks

  • Work with toolbars
  • Open and arrange windows
  • Split the workbook window
  • Work with multiple sheets in a workbook file
  • Link workbooks
  • Merge workbooks
  • Make Excel files Internet-ready


    • Course Number: MOFF0113