< Return To Course List
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 Objectivesuse 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
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
113221_eng





