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

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

Self-paced

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

Full program description

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

 

Course Overview

For SEP Schedule, please click here.  

Bring your Spreadsheets skills to an expert level and be more confident, efficient and effective in using Spreadsheets.

Master the advanced functions of Spreadsheets applications to produce more sophisticated reports with deeper data analysis and complex mathematical calculations. With this, you will be able to draw out key insights from data and enhance your productivity and effectiveness at work.

Who Should Attend

Individuals who have successfully reached ES-ICDL basic skills levels and wish to further enhance their expertise in Advanced Spreadsheets.

Course Duration

24 Hours

Course Outline

Topic 1: Formatting

 

  • Worksheets

 

Topic 2: Functions and Formulas

 

  • Using Functions and Formulas

 

Topic 3: Charts

 

  • Creating Charts
  • Formatting Charts

 

Topic 4: Analysis

 

  • Using Tables
  • Sorting and Filtering
  • Scenarios

 

Topic 5: Validating and Auditing

 

  • Validating
  • Auditing

 

Topic 6: Enhancing Productivity

 

  • Naming Cells
  • Paste Special
  • Templates
  • Linking, Embedding and Importing
  • Automation

 

Topic 7: Collaborative Editing

 

  • Tracking and Reviewing
  • Security

 

 

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

 
 

Medium of Instruction & Trainer

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

Funding Information

SkillsFuture Funding:

 

  • Participants must attend at least 75% of the course and complete the exam with a pass or competent result.
  • Online applications are not applicable for companies applying for funding with Absentee Payroll.

 

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.
  • For Training Grant application, please use the following reference code: CRS-Q-0030566-ES

 

  • Payment for the course must be using company cheque or via GIRO.

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

     

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

     

SME

w/o GST

w GST

Course Fee

$500.00

$535.00

Enhanced Training Support for SMEs Companies (90%)**

$50

$85.00

     

Prices do 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

Please note that prices are subject to changes.

3ADLE16