Course Duration

24.0 hr(s)

Mode of Assessment

Students must complete written question and practical performance assessments during class.

Who Should Attend

  • Individuals who are interested in learning how to use a spreadsheet to produce accurate work output professionally.

Course Overview

Rapid digitalisation and the growth of data have made analytical and quantitative skills some of the most important tools to improve productivity at work. By having the skill in Spreadsheets, you will be able to handle data accurately and produce precise work output regardless of your job responsibilities within the company. This course will equip you with the basic knowledge about the functions of Spreadsheets to ensure that you become a proficient user.

Course Schedule

Next available schedule

Course Objectives

Upon course completion, learners will be able to:

  • Work with spreadsheets and save them in different file formats
  • Choose built-in options such as the ‘Help’ function within the application to enhance productivity
  • Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data
  • Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets
  • Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas
  • Format numbers and text content in a spreadsheet
  • Choose, create and format charts to communicate information meaningfully
  • Adjust spreadsheet page settings, check and correct spreadsheet content before finally printing spreadsheets


Required Prerequisites:

(a) F2F Classes, these are the admission requirements.

  • Know the basic functions of a computer
  • Be able to read, write, speak and understand basic English
  • Have a keen interest to acquire new knowledge and willingness to learn a new skill

(b) Virtual Learning Classes, these are the admission requirements.

Trainings will be conducted on Zoom platform, thus webcam and microphone are compulsory

  • Have a Windows OS PC prior to class with the software installed (Apple Mac OS is not applicable)
  • Know the basic functions of a computer
  • Be able to read, write, speak and understand basic English
  • Have a keen interest to acquire new knowledge and willingness to learn a new skill

Course Outline

Topic 1: Using the Application

  • Working with Spreadsheets
  • Enhancing Productivity

Topic 2: Cells

  • Insert, Select
  • Edit, Sort
  • Copy, Move, Delete

Topic 3: Managing Worksheets

  • Rows and Columns
  • Worksheets

Topic 4: Formulas and Functions

  • Arithmetic Formulas
  • Functions

Topic 5: Formatting

  • Numbers/Dates
  • Contents
  • Alignment, Border Effects

Topic 6: Charts

  • Create
  • Edit

Topic 7: Prepare Outputs

  • Setup
  • Check and Print

Certificate Obtained and Conferred by

This course prepares for trainees to sit through the ICDL external examinations. It is optional for trainees to take the examinations. A registration is needed with the exams unit department of LHUB. Trainees will need to sign and up and register in order to sit for the exam. 

Successful trainees who pass the exams will receive the internationally recognised ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore, a new initiative from ECDL Foundation.

  • Certificate of completion from NTUC LearningHub

Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from NTUC LearningHub.

Additional Details

Medium of Instruction: English
Trainer: Trainee ratio is 1:20


Course Fee and Government Subsidies


Individual Sponsored

Company Sponsored

Before GST

After GST

Before GST

After GST

Full Course Fee
(For Foreigners and those not eligible for subsidies)





For Singapore Citizens aged 50 years and above






Union Training Assistance Programme (UTAP):

  • NTUC members enjoy UTAP* benefit of up to $250 each year when you sign up for courses with NTUC LearningHub.

* UTAP supports 50% of the course fees paid cap at $250 per year. You must be a union member throughout the course duration and at the time of claim. You must achieve a minimum of 75% attendance for each application and have sat for all prescribed examinations. Other terms and conditions apply.

Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees.

What Others Also Enrolled In