Spreadsheets Syllabus 6.0

This module covers the main concepts and skills needed to use spreadsheet software such as developing, formatting, modifying and using a spreadsheet as well as standard formulas and functions and data visualisation through creating and formatting graphs or charts.

15-20 hours per module
45 minutes per module
Arabic and English

On completion of this module you will be able to:

  • understand the key concepts of spreadsheets
  • use available help resources and shortcuts to enhance productivity
  • recognize good practice in inserting, editing, and deleting data
  • apply a range of mathematical and logical formulas and functions
  • know how to communicate information using charts and graphs

Syllabus Overview

CATEGORY SKILL SET
Using the Application
  • Working with Spreadsheets
  • Enhancing Productivity
Cells
  • Insert, Select
  • Edit, Sort
  • Copy, Move, Delete
Managing Worksheets
  • Rows and Columns
  • Worksheets
Formulas and Functions
  • Arithmetic Formulas
  • Functions
Formatting
  • Numbers/Dates
  • Contents
  • Alignment, Border Effects
Charts
  • Create
  • Edit
Prepare outputs
  • Setup
  • Check and Print

Downloads

Click here to download the Spreadsheets 6.0 Datasheet