WSQ

Level Up Your Excel Skills

course details

Duration and Time

Training Time

8.30am - 6pm

Course Duration

17 HRS

Course Information

Course Reference Number

TGS-2022017320

Funding Validity Period

02 Dec 2022 To
01 Dec 2026

Mode of Training

Classroom

COURSE OVERVIEW

This course sets out advanced skills that can be used to perform complex mathematical and statistical calculations, to produce high quality management information and to use the advance features in a spreadsheet application to improve productivity

By the end of this course, learners will be able to:

  • Import and organise data sources
  • Prepare worksheets for data entry and calculations
  • Manage data and navigate cells effectively
  • Perform efficient analyse of data
  • Perform advanced calculations with Excel functions
  • Collaborate and review workbooks

 

Course Content

Learning Unit 1 – Gather Data
  • Import data
  • Data consolidation
  • Linking to cells, range, between applications, break links
Learning Unit 2 – Format & Manage Worksheets
  • Custom number formats
  • Data validation
  • Worksheet grouping
  • Paste special options
Learning Unit 3 – Advanced Data Handling
  • Range name
  • Go To special
Learning Unit 4 – Data Analysis
  • Using Quick Analysis
  • Conditional formatting
  • Advanced sorting
  • Advanced filters
  • PivotTabel and PivotChart
Learning Unit 5 – Advanced Excel Functions
  • Cell referencing
  • Logical functions
  • Nested functions
  • Mathematical functions
  • Date functions
  • Text functions
  • Lookup & reference functions
  • Database functions
  • Formula auditing
Learning Unit 6 – Collaborative Editing
  • Track changes
  • Share workbook
  • Compare & merge

The job role(s)/occupations that this unit would be relevant for learners who are required to prepare data and analyse data using Microsoft Excel at an advanced level. The competencies covered in this course would be relevant to all industries and to organisations of all sizes.

 

  • Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 5
  • Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 5
  • Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 5
  • 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
  • Learners are expected to have basic knowledge of Microsoft Excel
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) $480.00 $43.20 $336.00 (70% off course fee) $187.20
Non Small Medium Enterprises $480.00 $43.20 $240.00 (50% off course fee) $283.20
Singaporean Employees aged 40 years and above $480.00 $43.20 $336.00 (70% off course fee) $187.20

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) $480.00 $43.20 $336.00 (70% off course fee) $187.20
Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) $480.00 $43.20 $240.00 (50% off course fee) $283.20

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

Related Courses

IT

24 HRS

WSQ

IT

24 HRS

WSQ

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