Excel 2003 Formulas and Functions


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
To provide an overview of the calculation features in Excel 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent

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 (hours)
2.7

Lesson Objectives

Excel 2003 Formulas and Functions

  • use formulas to perform basic calculations in Excel 2003.
  • create a formula in Excel 2003.
  • use references and names in Excel 2003 formulas.
  • enter a formula that uses cell references in Excel 2003.
  • use functions to perform calculations in Excel 2003.
  • use logical, financial, and date functions in Excel 2003.
  • use the Insert Function feature to insert basic and advanced functions.
  • use formulas and functions to perform calculations in Excel 2003.
  • Course Number:
    113221_eng