ECDL Spreadsheets is the fourth course of the ECDL course program and gives you an introduction to spreadsheets. The course will teach you how to develop the skills you need to make the best use of Microsoft Excel, and sit for the relevant part of the ECDL qualification.

Who is the course for?

ECDL 4 - Spreadsheets is ideal for administrators, team leaders, managers, business owners and anyone whose role includes the handling, storage or management of numbers and text.

There are no entry requirements, but basic numeracy skills and the ability to use a computer is expected. Ideally, users will have already completed the first two ECDL courses.

To get the most from this course access to Microsoft Excel is advised. Those wishing to focus on a particular version of Microsoft Excel may wish to choose from Excel 2000, Excel 2003 or Excel XP courses, although these courses do not link to the ECDL qualification.

What will you get from this course?

When you have completed this course, you will be able to:

• describe what a spreadsheet is
• know why and when to use a spreadsheet
• create, open and move between worksheets
• enter, move and copy data
• change the way your worksheet looks
• make calculations using a variety of formulas and functions
• create, update and print charts
• organise and print complex data
• share data with other applications.

Course features

You can start your online course straight away and access it at any time, providing you have access to a computer with an internet connection. The course will be available for up to six months from the date first accessed.

This course offers a smooth path through Excel’s key functions and features. A diagnostic test at the beginning of each chapter will highlight areas where this course will help to improve your knowledge.

Real-life scenarios and interactive activities make learning relevant and enjoyable. Each module includes exercises to help consolidate your learning and check that you’re ready to move on.

The course finishes with an interactive spreadsheet project which you can complete in your own time. The project is based on realistic situations and gives you the opportunity to try out your new skills.

Course modules

• Creating a Simple Spreadsheet
• Editing and Organising Data
• Changing the Look of Data
• Creating Basic Formulas
• Creating Simple Charts
• More Data Formatting
• Manipulating Worksheets
• More About Functions
• More About Charts
• Working with Large Amounts of Data
• Sharing Data

Does the course lead to a formal qualification?

This course, in conjunction with the six other courses featured in the ECDL Skills Suite, can be used to work towards the ECDL qualification. The required assessments for the qualification must be purchased separately from an approved ECDL test centre.

This course covers the material required for syllabus 4.5.

Course code

104080BT004