ECDL/ICDL 4 Module 4: Spreadsheets - Formulas and Functions in Excel 2003


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



Overview/Description
To demonstrate how to use formulas and functions in Excel 2003. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details.

Target Audience
End users wanting to attain competency in using a spreadsheet application; end users wanting to attain competency in using Microsoft Excel 2003; end users wanting to attain an ECDL or ICDL certification or equivalent; staff of businesses and public bodies needing to attain certification in computer proficiency; university or other students needing to attain a basic IT qualification; staff of public bodies or organizations seeking to reskill themselves for the technology-based workplace; staff at universities, schools, or other training centers teaching computer literacy skills

Prerequisites
Familiarity with basic IT concepts; familiarity with the Windows XP operating system

Expected Duration (hours)
2.2

Lesson Objectives

ECDL/ICDL 4 Module 4: Spreadsheets - Formulas and Functions in Excel 2003

  • 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 functions in Excel 2003.
  • use the Insert Function feature to insert basic functions.
  • Course Number:
    210897_eng