ECDL/ICDL 4 Module 4: Spreadsheets - Basic Features of Excel 2003

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

---

Overview/Description
To provide an overview of the basic features of 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)
3.3

Lesson Objectives

ECDL/ICDL 4 Module 4: Spreadsheets - Basic Features of Excel 2003

outline the basic features of a spreadsheet and identify the main interface and Help features of Excel 2003.

create a workbook and navigate through the worksheets in it.

enter data and text in a worksheet in Excel 2003.

save a new workbook and distinguish between the different file formats used to save workbooks in Excel 2003.

enter data in a workbook and save it.

edit data and filter cells in an Excel 2003 worksheet.

copy and move a cell and a range of cells in Excel 2003.

insert, edit, copy, and move worksheets.

insert a worksheet, move data between worksheets, and copy a worksheet to another workbook in Excel 2003.

add and modify data and a worksheet in Excel 2003.

Course Number:
210894_eng