The European Computer Driving Licence (ECDL) is an internationally recognised qualification for IT skills. There are 7 modules in total. This Module 4: Spreadsheets covers the basic concepts of spreadsheets.

The European Computer Driving Licence (ECDL) is an internationally recognised qualification for IT skills. There are 7 modules in total. Written in a lively but straightforward and easy-to-follow style, this book will be an indispensable guide for all students studying for the ECDL qualification. Module 4: Spreadsheets. This module covers the basic concepts of spreadsheets. You will learn how to use a spreadsheet application to keep records of numerical and financial data, perform calculations and what-if analyses, draw charts and graphs. Step-by-step ECDL

Chapter 4.1 What is a spreadsheet?
Moving around the worksheet
The Zoom tool
Toolbars
Changing defaults and preferences
Using the Help functions
Entering data
Editing data
Deleting the contents of a cell
Inserting and deleting rows and columns
Saving your work
Chapter 4.2 Formulae
Selecting Cells
Formatting cell contents
Inserting a border
Entering formulae
Automatic recalculation
Standard error values
Entering formulae by pointing
Formatting numbers
Chapter 4.3 Columns of Data
Changing column widths
Formatting decimals
Adding column of numbers
Renaming a worksheet
Inserting and deleting sheets
Copying a worksheet
Moving worksheets
Chapter 4.4 Functions
The SUM function
The AVERAGE function
MAXand MIN functions
The COUNT function
Copying data between sheets
Filling a series
Hiding and unhiding rowns &
columns
Freezing row and column titles
Unfreezing panes
Opening several workbooks
Saving under another name
Saving as different file type
Chapter 4.5 Charts
Sorting data
Drawing a bar chart
Moving and sizing a chart
Deleting the title
Adding axis titles
Changing the background colour
Changing the colour of the bars
Chapter 4.6 Pie Charts
Creating a pie chart
Formatting the data labels
Copying and pasting the chart type
Deleting a chart
Chapter 4.7 Printing
Printing a chart
Printing an entire worksheet
Printing a cell range
Printing an entire workbook
Printing row and column headings
Printing the title row on each page
Hiding/ Unhiding gridlines on printouts
Printing row and column headers
Paper Orientation
Paper Size
Changing the margins
Preparation
Chapter 4.8 Cell Referencing
Relative and absolute cell referencing
Calculating a percentage
The currency format
Merge and centre cell contents
Adding a date field
Wrapping cell content
Adding borders
Find and replace
Headers and Footers
Chapter 4.9 If...Then...Else
Changing font style and size
Adding the formulae
IF statements
Changing the font colour
Changing the background fill colour
Aligning dell content
Cell content orientation