Intermediate Spreadsheets eBook

R 200.00 R 60.00

A spreadsheet stores data in a tabular format as an electronic document which enables a user to save, sort and manage data in an arranged form of rows and columns. An electronic spreadsheet is based on and is similar to the paper-based accounting worksheet. The compound word “spread-sheet” came to mean the format used to present bookkeeping ledgers with columns for categories of expenditures across the top, invoices listed down the left margin, and the amount of each payment in the cell where its row and column intersect.


Once you have worked through this manual you should be able to:

  1. Work with spreadsheets and save them in different file formats, locally or in the cloud.
  2. Use available help resources, shortcuts and the go to tool to enhance productivity.
  3. Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data.
  4. Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets.
  5. Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognize error values in formulas.
  6. Format numbers and text content in a spreadsheet and use available autoformat/table styles.
  7. Choose suitable charts, and create and format charts to communicate information meaningfully.
  8. Adjust spreadsheet page settings and check and correct spreadsheet content before printing.

This manual is based on ECDL Spreadsheets Syllabus 6

  1. Open, close a spreadsheet application. Open, close spreadsheet(s).
  2. Switch between open spreadsheets.
  3. Create a new spreadsheet.
  4. Save a spreadsheet to a location on a local, online drive.
  5. Save a spreadsheet as another file type.
  6. Set basic options/preferences in the application.
  7. Use available Help resources.
  8. Use magnification/zoom tools.
  9. Display, hide built-in toolbars. Restore, minimize the ribbon.
  10. Navigate within a spreadsheet.
  1. Understand that a cell in a worksheet should contain only one element of data.
  2. Recognize good practice in creating lists.
  3. Enter a number, date, text in a cell.
  4. Select a cell, range of adjacent cells, range of non-adjacent cells, entire worksheet.
  5. Edit cell content, modify existing cell content.
  6. Use the undo, redo command.
  7. Use the search command for specific content in a worksheet.
  8. Use the replace command for specific content in a worksheet.
  9. Sort a cell range by one criterion in ascending, descending order.
  10. Move the content of a cell, cell range.
  11. Copy the content of a cell, cell range.
  12. Delete cell contents.
  13. Use the autofill tool, copy handle tool to copy, increment data entries.
  1. Select a row, range of adjacent rows, range of non-adjacent rows.
  2. Select a column, range of columns, range of non-adjacent columns.
  3. Insert, delete rows and columns.
  4. Modify column widths, row heights.
  5. Freeze, unfreeze row and/or column titles.
  6. Switch between worksheets.
  7. Insert a new worksheet, delete a worksheet.
  8. Naming worksheets.
  9. Copy, move, rename a worksheet.
  1. Format cells to display numbers.
  2. Format cells to display a date style, currency symbol.
  3. Format cells to display numbers as percentages.
  4. Change cell content appearance.
  5. Apply formatting to cell contents.
  6. Apply different colours to cell content, cell background.
  7. Copy the formatting from a cell, cell range to another cell, cell range.
  8. Apply text wrapping to contents within a cell, cell range.
  9. Align cell contents.
  10. Merge cells and centre a title in a merged cell.
  11. Add border effects to a cell, cell range: lines, colours.
  1. Formula creation.
  2. Create formulas using cell references and arithmetic operators
  3. Identify and understand standard error values associated with using formulas.
  4. Understand and use relative, absolute cell referencing in formulas.
  5. Use sum, average, minimum, maximum, count, counta, round functions.
  6. Use the logical function if with comparison operator: =, >, <.
  1. Different types of charts.
  2. Create different types of charts from spreadsheet data.
  3. Select a chart.
  4. Change the chart type.
  5. Move, resize, delete a chart.
  6. Add, remove, edit a chart title.
  7. Add data labels to a chart: values/numbers, percentages.
  8. Change chart area background colour, legend fill colour.
  9. Change the column, bar, line, pie slice colours in the chart.
  10. Change font size and colour of chart title, chart axes, chart legend text.
  1. Change worksheet margins.
  2. Change worksheet orientation. Change paper size.
  3. Adjust page setup to fit worksheet contents on a specified number of pages.
  4. Add, edit, delete text in headers, footers in a worksheet.
  5. Insert and delete fields.
  6. Check and correct spreadsheet calculations and text.
  7. Turn on, off display of gridlines, display of row and column headings for printing purposes.
  8. Apply automatic title row(s) printing on every page of a printed worksheet.
  9. Preview a worksheet.
  10. Print options.

Click here to download the Table of Contents

Strategic Partners

Contact and Disclaimer

Privacy Policy

Phone (Office hours): (27) 79 028 4123
All images are copyrighted to their respective owners