ECDL / ICDL Module 4 
Syllabus Five 

Microsoft Excel 2007

Courseware for ECDL Training Courses

A FIRST LOOK AT EXCEL

• Starting the Excel program
• What is the Active Cell?
• The Excel cell referencing system
• Entering numbers and text
• Default text and number alignment
• Adding a column of numbers
• Worksheets and Workbooks
• Saving a workbook
• Closing a workbook
• Creating a new workbook
• Opening a workbook
• Switching between workbooks
• Saving a workbook using another name
• Saving a workbook using a different file type

HELP

• Getting help
• Searching for Help
• The Help 'Table of Contents'
• Printing a Help topic
• Alt key help

SELECTION TECHNIQUES

• Why are selection techniques important?
• Selecting a cell
• Selecting a range of connecting cells
• Selecting a range of non-connecting cells
• Selecting the entire worksheet
• Selecting a row
• Selecting a range of connecting rows
• Selecting a range of non-connected rows
• Selecting a column
• Selecting a range of connecting columns
• Selecting a range of non-connecting columns
• Good practice when creating of editing lists

MANIPULATING ROWS AND COLUMNS

• Inserting rows into a worksheet
• Inserting columns into a worksheet
• Deleting rows within a worksheet
• Deleting columns within a worksheet
• Modifying column widths
• Modifying column widths using 'drag and drop'
• Automatically resizing the column width to fit contents
• Modifying row heights

COPYING, MOVING AND DELETING

• Copying a cell or range contents within a workbook.
• Deleting cell contents
• Moving the contents of a cell or range within a workbook
• Editing cell content
• Undo and Redo
• Copying the contents of a cell or range between worksheets (within the same workbook)
• Moving the contents of a cell or range between worksheets (within the same workbook)
• Moving the contents of a cell or range between worksheets (in different workbooks)
• Copying the contents of a cell or range between worksheets (in different workbooks)
• AutoFill
• Sorting a cell range

SEARCHING

• Searching and replacing data

MANIPULATING WORKSHEETS

• Switching between worksheets
• Renaming a worksheet
• Good practice with naming worksheets
• Inserting a new worksheet
• Deleting a worksheet
• Copying a worksheet within a workbook
• Moving a worksheet within a workbook
• Copying or moving worksheets between workbooks

FONT FORMATTING

• Font type
• Font size
• Bold, italic, underline formatting
• Cell border formatting
• Formatting the background colour
• Formatting the font colour

ALIGNMENT FORMATTING

• Aligning contents in a cell range
• Centring a title over a cell range
• Cell orientation
• Text wrapping
• Format painter

NUMBER FORMATTING

• Number formats
• Decimal point display
• Applying and removing comma style formatting (to indicate thousands)
• Currency symbol
• Date styles
• Percentages
• Applying Percentage formatting to a cell or range

FREEZING ROW AND COLUMN TITLES

• Techniques for freezing row and column titles

FORMULAS

• Creating formulas
• Good Practice: The easy way to create formulas
• Copying formulas
• Operators
• Formula error messages

RELATIVE & ABSOLUTE CELL REFERENCING

• Relative cell referencing within formulas
• Absolute cell referencing within formulas

FUNCTIONS

• What is a function?
• Common functions
• Sum function
• Average function
• Max function
• Min function
• Count function
• The COUNTA function
• The COUNTBLANK function
• What are 'IF functions'?
• Using the IF function

USING CHARTS

• Inserting a column chart
• Inserting a line chart
• Inserting a bar chart
• Inserting a pie chart
• Resizing a chart
• Deleting a chart
• Chart title or labels
• Chart background colour
• Changing the column, bar, line or pie slice colours in a chart
• Modifying the legend fill colour
• Changing the chart type
• Modifying charts using the Layout tab
• Copying and moving charts within a worksheet
• Copying and moving charts between worksheets
• Copying and moving charts between workbooks

CUSTOMISING EXCEL

• Modifying basic Excel options
• Minimising the Ribbon
• AutoCorrect options

WORKSHEET SETUP

• Worksheet margins
• Worksheet orientation
• Worksheet page size
• Headers and footers
• Header and footer fields
• Scaling your worksheet to fit a page(s)

PREPARING TO PRINT A WORKSHEET

• Visually check your calculations
• Displaying gridlines when printing
• Printing titles on every page when printing
• Printing the Excel row and column headings
• Spell checking
• Previewing a worksheet
• Comparing workbooks side by side
• Zooming the view
• Printing options

    

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

Other ECDL / ICDL Courseware Training materials

• 1800+ Practice questions / Student handouts for ICDL / ICDL
  
• ECDL  / ICDL Syllabus 5.0 Module 1
• ECDL  / ICDL Syllabus 5.0 Module 2
• ECDL  / ICDL Syllabus 5.0 Module 3
• ECDL  / ICDL Syllabus 5.0 Module 4
• ECDL  / ICDL Syllabus 5.0 Module 5
• ECDL  / ICDL Syllabus 5.0 Module 6
• ECDL  / ICDL Syllabus 5.0 Module 7
  
  
• ECDL  / ICDL Advanced 2.0 - AM3
• ECDL  / ICDL Advanced 2.0 - AM4
• ECDL  / ICDL Advanced 2.0 - AM5
• ECDL  / ICDL Advanced 2.0 - AM6