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
Booking / availability