skip to navigation skip to content
Self-taught course

Provided by: University Information Services


Booking

This course is self taught (Materials may be loaned out).

Bookings cannot be made on this course (Course is not taking bookings).



Booking / availability

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


Description

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.

Prerequisites

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.

Topics covered
  • 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
Format

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

System requirements

Windows operating system with Microsoft Excel 2007 installed.

Duration

40 hours

Themes

Booking / availability

Override user: