skip to navigation skip to content
Self-taught course

Provided by: University Computing Service


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

Theme
Spreadsheets

Booking / availability

Override user: