ECDL 4.5 Module 4 - Spreadsheets (Excel 2007) (Win) (workbook)

BeginnersLoan

In Module 4 the candidate will learn about the concepts of spreadsheets and will be able to demonstrate the ability to use a spreadsheet on a computer. The candidate will be able to develop, format, modify and use a spreadsheet of limited scope ready for distribution. This will involve creating formulas and using standard functions, and creating and formatting charts/graphs.

This publication is intended for people who wish to prepare for Module 4 - Spreadsheets of the ECDL Syllabus (Version 4.5) using Microsoft Excel 2007. This course assumes no prior knowledge of Microsoft Excel 2007 or a spreadsheet application. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system as the candidate will be required to start applications, work with and copy files, and locate file folders.

• Use best practice principles when creating new spreadsheets
• Work within the basic Excel environment
• Create a new workbook
• Open and navigate within workbooks and worksheets
• Find the information you need in Help
• Work with various elements of a worksheet
• Use a range of techniques to work with worksheets
• Copy, cut or fill data within a workbook
• Understand, create and work with formulas and functions used to perform calculations
• Understand and use formula cell referencing to create more complex formulas
• Use formatting techniques to greatly enhance the look of a worksheet
• Save workbooks in a variety of formats
• Apply a variety of page setup techniques
• Create and work with headers and footers
• Print your workbook data
• Sort data in a list in a worksheet
• Create effective charts in Microsoft Excel
• Create a range of common charts
• Move or copy charts within the same workbook or to different workbooks
• Modify Excel options

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

Windows operating system with Microsoft Excel 2007 installed.

40 hours

• JISC Digital Proficiency
• JISC Digital Proficiency
• Spreadsheets