ICDL - Perform Spreadsheet Functions (Excel 2003) EC Central Area, Central

Course details

This module enables candidates to understand the concept of spreadsheets and to demonstrate the ability to use a spreadsheet application. Candidates will understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet, in addition to using standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts.

On completion of this module each candidate will be able to:

• Work with spreadsheets and save them in different file formats
• Choose built-in options such as the Help function within the application to enhance productivity
• Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data
• Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets
• Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas
• Format numbers and text content in a spreadsheet
• Choose, create and format charts to communicate information meaningfully
• Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets

TARGET AUDIENCE

• This course is intended for users with little or no knowledge of using a spreadsheet application.

COURSE CONTENT

• Using the Application
• Working with Spreadsheets
• Enhancing Productivity
• Cells
• Insert, Select
• Edit, Sort
• Copy, Move, Delete
• Formatting
• Numbers/Dates
• Managing Worksheets
• Rows and Columns
• Worksheets
• Contents
• Alignment, Border Effects
• Formulas and Functions
• Arithmetic Formulas
• Charts
• Create
• Edit
• Functions
• Prepare Outputs
• Setup
• Check and Print