WSQ

Perform Spreadsheet Functions 24 hours

course details

Duration and Time

Training Time

9am - 6pm

Course Duration

24 HRS

Course Information

Course Reference Number

TGS-2023038008

Funding Validity Period

19 Sep 2023 To
18 Sep 2025

Mode of Training

Classroom

COURSE OVERVIEW

This course is a comprehensive 24-hour program designed to equip learners with essential spreadsheet skills. Starting with the basics of navigating and utilising a spreadsheet application, participants will progress through managing data, organising worksheets, and performing basic calculations. The course also covers data formatting, chart creation for data presentation, and
setting up worksheets with print options to ensure professional and effective spreadsheet use.

 

*This course includes an online assessment (ICDL).

By the end of this course, learners will be able to:
• Use fundamental features of a spreadsheet application.
• Identify areas for collection of data, collect and edit data.
• Manage rows, columns and worksheets to facilitate data manipulation.
• Create formulas and functions to create business statistics.
• Format data and cells.
• Create and format standard charts.
• Apply page setup options, preview and select print options.

Learning Unit 1: Getting started with a spreadsheet application
  • Using the application
  • Working with workbooks
  • Basic spreadsheet concepts
  • Using functionalities of the application
Learning Unit 2: Manage data in a spreadsheet
  • Good practices in managing data
  • Enter & edit data
  • Moving within a worksheet
  • Cell selection techniques
  • Copy, cut & paste
  • Find & replace
  • Sort & filter
Learning Unit 3: Manage worksheets
  • Insert, delete & format rows & columns
  • Insert, delete, rename, move & copy worksheets
Learning Unit 4: Perform calculations on data
  • Arithmetic formulas
  • Excel functions
  • Cell referencing
Learning Unit 5: Perform formatting of data
  • Format data
  • Format cells
Learning Unit 6: Create charts to present data
  • Create standard charts
  • Format charts
Learning Unit 7: Set up worksheets and select print option
  • Adjust page options
  • Header & footer
  • Preview worksheet
  •  Select print options

This course is intended for learners who wish to equip themselves with the necessary knowledge and skills to be proficient with using the core features of a spreadsheet application. The skills include understanding fundamental spreadsheet concepts, designing a spreadsheet and using basic functions within a spreadsheet.

  • Learners must be able to read, write, speak and listen to English at secondary school level
  • Learners to have minimum GCE ‘O’ level or ITE certificate education
  • Learner should have at least 1 year’s working experience in any industry.
  • Learners must be able to operate a personal computer, use keyboard and mouse
Course Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Small Medium Enterprises (SMEs) $720.00 $64.80 $504.00 (70% off course fee) $280.80
Non Small Medium Enterprises $720.00 $64.80 $360.00 (50% off course fee) $424.80
Singaporean Employees aged 40 years and above $720.00 $64.80 $504.00 (70% off course fee) $280.80

Course Fee Funding:
SME: 70% of course fee
Non-SME: 50% of course fee
Non-SME(MCES): 70% of course fee

$4.50 per training hour capped at $100,000 per enterprise per calendar year

Self-Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Singapore Citizens (40 years and above) $720.00 $64.80 $504.00 (70% off course fee) $280.80
Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) $720.00 $64.80 $360.00 (50% off course fee) $424.80

Course Fee Funding:
MCES: 70% of course fee
Normal: 50% of course fee

Related Courses

IT

24 HRS

WSQ

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761

SHARE THIS COURSE
Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration