ECDL Base: Spreadsheets Training Course & Certification Information

Spreadsheets
ECDL Base: Spreadsheets, current version

Spreadsheets is the fifth module of the ECDL course. This module will help you understand the concept of spreadsheets, basic spreadsheet functions to produce standard documents e.g. Open, create, save, formatting. And slightly more advanced functions such as insert/delete rows and columns, sort data, basic formulas, document setup. Printing Charts, graphs etc. Once the course is completed, you will be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet of limited scope ready for distribution. The module will cover how to generate and apply standard mathematical and logical formulas using standard formulas and functions, and will include how to create and format graphs and charts.

The syllabus for this module is as follows:

Module 5: Spreadsheets (6 hours)
- 5.1 Using the Application
  - a. Introduction
  - b. Working with Spreadsheets
  - c. Enhancing Productivity
- 5.2 Cells
  - a. Introduction
  - b. Insert, Select
  - c. Edit, Sort
  - d. Copy, Move, Delete
- 5.3 Managing Worksheets
  - a. Introduction
  - b. Rows and Columns
  - c. Worksheets
- 5.4 Formulas and Functions
  - a. Introduction
  - b. Arithmetic Formulas
  - c. Functions
- 5.5 Formatting
  - a. Introduction
  - b. Numbers/Dates
  - c. Contents
  - d. Alignment, Border Effects
- 5.6 Charts
  - a. Introduction
  - b. Create
  - c. Edits
- 5.7 Prepare Outputs
  - a. Introduction
  - b. Setup
  - c. Check and Print

For this module we say that it will take around 9 hours to finish as it is longest module in this course. The length of time taken depends entirely on how quickly you can study and absorb the material. You can proceed as quickly or slowly as you like, and there is no limit on how long you can take to do the course. Its up to you!

Click here for an overview of the ECDL Certification and its modules.

Click here to download a document showing the complete syllabus. [48 pages]

Have a question on this module or ECDL in general?

Let our Lecturers and Career Instructors hear it by filling out this form or;
Explore the ECDL Certification now and unravel it yourself:

Is the ECDL Accreditation right for you?

Will it take you to the job or career that you'd like to explore? If you are unsure or have a drop of doubt, we highly recommend that you experience our trial courses and assessments to get an accurate insight into the ECDL and it's modules. This is the perfect starting point to see which courses are best for you!

The right ingredients for your training is crucial for your chances to get certified and employment success.

Your future performance, interviews, decisions and abilities will be largely affected by your training experience. The ECDL certification training is designed for novices or casual computer users and will get you to a high computer literacy standard. The ECDL is the fastest growing IT user qualification in over 125 countries.

The unique training offered directly from us will ensure that you get the full comprehensive training, the right lecturers, labs and equipment and have everything you need at your disposal to get certified and create a career from your new profession.

In order to achieve the ECDL certification, individuals must pass a test for each of the 7 modules. ECDL Module 1 is a theoretical test of computing knowledge at a general level, while modules 2-7 are predominantly practical skills tests.

Upon passing your training and ECDL tests you will receive a course completion certificate which you can show to potential employers. The ECDL is recognised throughout professional IT industries and communities inside Europe.

Microsoft Office taught programs, as part of the ECDL training package - i.e. Word, Excel, Powerpoint - will help advance your career by giving you a crucial competitive edge for achieving success. Studies show that employers are more likely to hire candidates with these computer skills.

We have helped hundreds of students to reach their goal, obtaining jobs and certifications and an immense understanding of IT that some had thought unattainable. Do not allow your lack of experience or self-confidence deny you from a career in IT - it is a lot easier (and enjoyable too) than most people think.

We know where to plot you on the IT career map and how to set your foot in the door.