ECDL / ICDL courseware using Microsoft Excel 2000, XP and 2007 courseware training manuals for IT trainers including ECDL syllabus 4 and ICDL syllabus 5 training courses for ICDL Module four

Training materials for::
Windows Vista
Windows 2000 / XP
Microsoft Word
Microsoft Excel
PowerPoint
Microsoft Access
Internet Explorer
Outlook
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
Expression Web
Computer Concepts
ECDL / ICDL Downloads

PLUS MANY MORE ...

ECDL / ICDL Module 4 (Syllabus Four) Courseware
Spreadsheets

PLEASE NOTE: The ECDL / ICDL Courseware Library includes versions for Office 2000, Office XP, Office 2003 & Office 2007. Plus versions for Windows 2000, Windows XP and Windows Vista

ECDL | ICDL Courseware Training Manual

1. USING THE APPLICATION

FIRST STEPS WITH SPREADSHEETS

What are Workbooks and Worksheets?
To start Excel using the Windows Start menu
To close Excel
To open an existing workbook
To select, and open a continuous block of files
To select, and open, multiple files which are not in a continuous block
To create a new default workbook
To save the workbook
To save a workbook (using a different name)
To save a file to a diskette
To save a file in a format other than Excel format, such as Lotus 123
To save a file in an earlier Excel format
To save an Excel file as a text file
What are Templates?
To save a workbook as a template file
To use a template
To save a file in a format suitable for posting on a Web site
To switch to a different worksheet within a workbook
To switch to a different, open workbook (using the Windows Status bar)
To switch to a different, open workbook (using the Window drop down menu)
Today's Tip
To display the Assistant
To hide the Assistant
To use 'what is this' Help within a dialog box
To close a spreadsheet

ADJUST SETTINGS

To zoom the view
To display or hide a toolbar
To freeze panes
To unfreeze panes
To modify basic preference options

2. CELLS

INSERT DATA

To enter numbers
To enter dates or times
To enter text into a cell

SELECT CELLS

To select a cell
To select non-adjacent cells
To select a range of cells by dragging the mouse
To select a range of adjacent cells (making up a rectangular block)
To select an entire worksheet
To select several worksheets
To select all worksheets
To select a range of adjacent rows
To select a range of non-adjacent rows
To select a column
To select a range of adjacent columns
To select a range of non-adjacent columns

ROWS AND COLUMNS

To insert a row into a worksheet
To insert a column into a worksheet
To delete a row or column
To change the width of a column
To set the column width to match the data automatically
To change the width of multiple columns to match the data
To set new default column widths
To change the height of a row
To automatically change a row height to match the data

EDIT DATA

To insert additional cell contents, or to modify existing cell contents
To replace existing cell contents
To undo a command
To redo a command

DUPLICATE, MOVE, DELETE

To copy a cell range within a worksheet
To copy a row or column within a worksheet
To copy a cell range between worksheets
To copy a row or column between worksheets
To copy a row or column from a worksheet in one workbook, to a worksheet in a different workbook
To use AutoFill
To see what AutoFill options are available
To move a cell range within a worksheet
To move a row or column within a worksheet
To move a cell range between worksheets
To move a row or column between worksheets
To move a cell range from a worksheet in one workbook, to a worksheet in a different workbook
To move a row or column from a worksheet in one workbook, to a worksheet in a different workbook
To delete the contents of a cell or range

SEARCH AND REPLACE

To find text in a worksheet
To find and replace text within a worksheet

SORT DATA

To sort a list using the Sort icons

3. WORKSHEETS

HANDLING WORKSHEETS

To insert a worksheet tab
To rename a worksheet tab
To delete a worksheet (by right-clicking)
To copy a worksheet within a workbook (the long way)
To copy a worksheet within a workbook (the quick way)
To copy a worksheet to another workbook
To move a worksheet within a workbook (the long way)
To move a worksheet within a workbook (the quick way)
To move a worksheet to another workbook

4. FORMULAS AND FUNCTIONS

ARITHMETIC FORMULAS

To enter formulas into the worksheet cell
To enter a cell or range reference by pointing
Operator evaluation order within Excel
Common formula error messages
On-line Help with formula error messages

CELL REFERENCING

What is relative addressing?
What is absolute addressing?

WORKING WITH FUNCTIONS

What is a function?
Common functions
To use the SUM function
To use the AVERAGE function
To use the MAX function
To use the MIN function
To use the COUNT function
The IF Function
To enter an IF( ) function

5. FORMATTING

NUMBERS/DATES

To change number formatting
To establish a fixed number of decimal places for cell formats
To apply comma formatting (to indicate thousands)
To format date styles
To format cells using currency symbols
To format numbers as percentages

To change text size
To modify the font type used by text
To format text as bold
To format text as italic
To format text as Underlined
To format text using double underlining
To change the colour used by the text
To change the background colour of a cell range
To copy formatting using the Format Painter.
To wrap text within selected cells

ALIGNMENT BORDER EFFECTS

To align data within a cell range, to the left, to the right or to centre data
To align data between the top and bottom of a cell
To merge and centre over a range
To rotate text to any angle
To apply a border to a cell range (using the Border icon)
To apply a border to a cell range (using the Format Cells/Border dialog box)
To remove a border from cells or ranges

6. CHARTS / GRAPHS

USING CHARTS/GRAPHS

To use the Chart Wizard to create a chart
To add a title or label to a chart
To remove a title or label from a chart
To change the background colour of a chart
To change the colour of a column, bar, line or pie slice within a chart
To use the Chart Type icon
To copy a chart within a worksheet
To copy a chart to a different worksheet within a workbook
To copy a chart to a worksheet within a different workbook
To move a chart within a worksheet
To move a chart to a different worksheet within a workbook
To move a chart to a worksheet within a different workbook
To re-size a chart
To delete a chart

7. PREPARE OUTPUTS

WORKSHEET SETUP

To modify margin values
To set orientation and page size
To force a worksheet to print on a single page
To use standard headers and footers
To create custom headers and footers
To add page numbering to a worksheet
To insert fields into a header or footer

PREPARATION

Always check your work prior to sending it to someone else!
To preview a worksheet
To turn on (or off) the printing of gridlines
To control the printing of row and column headings

PRINTING

To print a cell range from a worksheet
To print the entire active worksheet
To print a specified number of copies of a worksheet
To print the entire workbook (including all the worksheets within it)
To print a selected chart
To print a spreadsheet to a file

ECDL | European Computer Driving Licence
ICDL | International Computer Driving Licence

Other ECDL / ICDL Courseware Training materials

   © 1995-2008 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged. Terms & Conditions
   Course content subject to change without notice.

Now download complete samples of all our courses

Download Computer Training Sample Courses

    Consider the benefits of investing in quality computer courseware materials:
    For schools, colleges, professional IT trainers & computer training companies

    You get the duplication rights for all 150+ computer courses when you invest in the 'Courseware Library'

Cheltenham Courseware for Australian Schools & Computer Training Companies | You are not using a JavaScript enabled browser. The JS used on this site is used for presentational purposes only.

ECDL / ICDL Module 4 (Syllabus Four) CoursewareSpreadsheets