Excel 2003 Formulas and Functions

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


160 Minutes

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