Home > Training > ECDL (European Computer Driving Licence)

ECDL Module 4 - Excel

Course can be run for versions 2000, 2002 & 2003

Duration
2 days

Course Objectives
This course is designed to provide delegates with a solid foundation in using Excel to produce professionally presented spreadsheets, containing formulae to link information. It is a hands-on course containing varied and relevant exercises for delegates to practise and reinforce the techniques learnt.

This course prepares delegates for the European Computer Driving Licence (ECDL) Syllabus for Module 4 - Spreadsheets.

Outline
Excel Basics
The Excel environment
Displaying and hiding toolbars
Entering text, numbers and dates
The formula bar
AutoComplete
Moving around a worksheet
Saving, opening and closing workbooks
The formatting toolbar
Selecting cells, rows and columns
Adjusting the column width
Adding and deleting rows and columns
Copying, moving and erasing cells
Using AutoFormat
Sorting data
Undoing mistakes

Formulae
Cell referencing and ranges
Writing formulae
Order of operations used by Excel
Copying formulae
Checking calculations
Understanding and resolving errors

Fast Data Entry Techniques
Filling adjacent cells using the fill handle
Incrementing a series of numbers and dates

Functions
The Sum function and the AutoSum button
Average, Minimum, Maximum and Count functions
The AutoCalculate feature

Modifying Options
Setting the user name
Changing the default directory

Formatting Data
Font formatting
Cell alignment
Borders, patterns and colours
Number formatting

Printing
The Print dialog box
Inserting and removing page breaks
Setting margins
Inserting headers and footers
Inserting fields in headers and footers
Setting print titles
Displaying and showing gridlines

Advanced Formulae
Relative cell references
Absolute cell references
Linked values
Moving cells contained in formulae
Using the logical IF function

Working in Workbooks
Multiple sheets
Naming worksheets
Multiple windows
Splitting windows
Freezing panes

Charts
Creating charts
- pie charts, bar charts, 3D charts etc
Moving, resizing and deleting charts
Modifying charts
- chart AutoFormat
- changing colours and fonts
- adding labels and titles

Assumed Knowledge
Delegates attending this course should have familiarity with PCs and experience of using Windows. It is also beneficial, but not essential, to have used Word.

Course Times
10:00am to 5:00pm

Comprehensive course manual included.
Refreshments and lunch are provided on all courses at the Information Horizons Training Centre.

Back to the top