|
|
 ECDL / ICDL Module 4 (Syllabus Four) using Microsoft Excel 2007
Spreadsheets
Courseware
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
A FIRST LOOK AT EXCEL 2007
- Starting the Excel 2007 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 WITHIN EXCEL 2007
- 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
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 the cell or range contents
- Deleting cell contents
- Moving the contents of a cell or range
- Editing cell content
- Undo and Redo
- AutoFill
- Sorting a cell range
- Searching and replacing data
MANIPULATING WORKSHEETS
- Switching between worksheets
- Renaming a worksheet
- 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 formatting
- Decimal point display
- Comma formatting
- Currency symbol
- Date styles
- Percentages
FREEZING ROW AND COLUMN TITLES
- Freezing row and column titles
FORMULAS
- Creating formulas
- Easy way to create formulas
- Copying formulas
- Operators
- Formula error messages
CELL REFERENCING
- Relative cell referencing within in formulas
- Absolute cell referencing within formulas
FUNCTIONS
- What is a function?
- Common functions
- Sum function
- Average function
- Max function
- Min function
- Count function
- What are 'IF functions'?
- Using the IF function
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 a column, bar, line or pie slice colours
- 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
CUSTOMIZING EXCEL 2007
- Modifying basic options
- Minimising the Ribbon
- AutoCorrect options
PRINTING
- Worksheet margins
- Worksheet orientation
- Worksheet page size
- Headers and Footers
- Header and footer fields
- Scaling your worksheet to fit a page(s)
- Visually check your calculations
- Gridline display 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
|
