Full program description

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

What's In It For Me

  • Understand the advanced formatting options of Excel 
  • Use functions such as statistical, financial and mathematical operations etc 
  • Analyse, filter & sort data based on the tables and data needed

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

  • Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets
  • Use functions such as those associated with logical, statistical, financial and mathematical operations
  • Create charts and apply advanced chart formatting features
  • Work with tables and lists to analyse, filter and sort data. Create and use scenarios
  • Validate and audit spreadsheet data
  • Enhance productivity by working with named cell ranges, macros and templates
  • Use linking, embedding and importing features integrate data
  • Collaborate on and review spreadsheets. Apply spreadsheet security features

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

Course reference code in SkillsConnect:

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

Reference code:

Perform Advanced Spreadsheet Functions (Office 2013 Standard Courseware)

CRS-Q-0025289-ES

Perform Advanced Spreadsheet Functions (Excel) 2016 (24 Hours)

CRS-Q-0030566-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 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 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 Pricingw/o GSTw 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-SMEw/o GSTw 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
SMEw/o GSTw 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

3ADLE13