| ECDL Modules |
|---|
Computer Training Courses
Module 4 - Spreadsheets
This module consists of two sections; the first covering the basic tasks of spreadsheet manipulation, the second covering some more advanced tasks. The candidate must demonstrate the practical ability to manipulate a spreadsheet on a computer. The tests consist of basic and advanced tasks.
The individual shall have a sound knowledge of the functions of a spreadsheet application and understand the concept of spreadsheets. They will be able to accomplish common operations - creating a spreadsheet, making calculations and creating diagrams.
- Open a spreadsheet file, make changes to it, add rows, calculate new values
- Insert rows and columns - create a new row or column in a specific place
- Create a spreadsheet and enter data
- Numbers
- Text
- Formulae
- Format cells - e.g. size, decimal points, currency, etc
- Adjust column widths and format columns and rows
- Sort the data in the spreadsheet
- Use the basic mathematics and logical functions of a spreadsheet, such as;
- Totaling
- Averaging
- Print and save a spreadsheet
- Create a header and footer
- Use Help Functions
- Understand and use absolute and relative cell referencing in formulae
- Produce different types of charts and graphs from spreadsheet figures to analyse the data
- Retrieve graphs from diskette or disc
- Print graphs with titles and labels
- Move information between workbooks
Back to Top
| Click here to reserve a place on this course |
