Skip To Content
ES WSQ - Perform Spreadsheet Functions [2016] (ICDL Certification Module: Spreadsheets) is a Program

ES WSQ - Perform Spreadsheet Functions [2016] (ICDL Certification Module: Spreadsheets)

Time limit: 24 days

Sorry! The enrollment period is currently closed. Please check back soon.

Full program description

ES WSQ - Perform Spreadsheet Functions [2016] (ICDL Certification Module: Spreadsheets)

What's In It For Me


Course Overview

Work smarter with Spreadsheets.

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.

Who Should Attend

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

Course Duration

24 hours 

Course Outline

  • 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 

Mode of Assessment

There will be a compulsory ICDL Certification Online Assessment for this course. Minimum 75% attendance is needed prior to the assessment.

Certification Obtained and Conferred by

Successful trainees 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.

This is a joint certification between SSG and ICDL Singapore 

Course Objectives

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

Medium of Instruction & Trainer

  • Instructor Led Class
  • Teacher: Student Ratio is 1:24

Funding Information

Course reference code in SkillsConnect:

  • For Training Grant application, please use the following reference code.

Reference code:

ES WSQ - Perform Spreadsheet Functions (Microsoft Excel 2013)

CRS-Q-0025517-ES

Perform Spreadsheet Functions WSQ ICDL 2016

CRS-Q-0030157-ES

Skills Development Fund (SDF) and SkillsFuture Funding:

  • Participants must attend at least 75% of the course, complete the exam with a pass or competent result.
  • Online applications are not applicable for companies applying for funding with Absentee Payroll.
  • Workforce Training Support (WTS) funding only applies to trainee who is 35 years old and above with a monthly income of $2,000 and below.

For Company Registration:

  • Customers who are applying for funding for trainee(s), please submit Training Grant applications in SkillsConnect website before registration.
  • Training Grant number is to be submitted together with the registrations.
  • Payment for the course must be using company cheque or via GIRO.
  • For more information on SDF Training Grant application, please click here

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. 

Price

Course Fee Payable 
Individual Pricing w/o GST w GST
 Course Fee $500.00 $535.00
SkillsFuture Funding, >=21 yrs old $100 $135.00
SkillsFuture Funding, >=40 yrs old $50 $85.00
WTS Funding (95%) $25.00 $60.00
Corporate Pricing
Non-SME w/o GST w GST
Course Fee $500.00 $535.00
SkillsFuture Funding, >=21 yrs old $100 $135.00
SkillsFuture Funding, >=40 yrs old $50 $85.00
WTS Funding (95%) $25.00 $60.00
SME w/o GST w GST
Course Fee $500.00 $535.00
Enhanced Training Support for SMEs Companies (90%)** $50 $85.00
WTS Funding (95%) $25.00 $60.00

Prices does not include pre & post assessment fees and subject to GST and other LHUB miscellaneous fees

Note: SkillsFuture Funding, >=21 yrs old : Applicable to Singapore Citizen/PR 

  SkillsFuture Funding, >=40 yrs old : Applicable to Singapore Citizen ONLY

3CDLE16