ICDL ECDL Module 4 Syllabus 5.0
ICDL ECDL Courseware Outline
ICDL ECDL Courseware Training Materials for IT Trainers
THE MICROSOFT Excel 2007 SCREEN
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
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
HELP
Getting help
Searching for Help
The Help 'Table of Contents'
Printing a Help topic
Alt key help
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
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
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
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
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
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
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
SEARCHING
Searching and replacing data
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
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
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
FONT FORMATTING
Font type
Font size
Bold, italic, underline formatting
Cell border formatting
Formatting the background colour
Formatting the font colour
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
ALIGNMENT FORMATTING
Aligning contents in a cell range
Centring a title over a cell range
Cell orientation
Text wrapping
Format painter
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
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
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
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
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
RELATIVE & ABSOLUTE CELL REFERENCING
Relative cell referencing within formulas
Absolute cell referencing within formulas
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
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
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
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
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
WORKSHEET SETUP
Worksheet margins
Worksheet orientation
Worksheet page size
Headers and footers
Header and footer fields
Scaling your worksheet to fit a page(s)
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
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