|
|
ECDL / ICDL Module 4 (Syllabus Four) Courseware
Spreadsheets
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
CONTENTS
- 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
|
