Level Up Your Excel Skills

Funding Validity Period

2 December 2022

1 December 2026

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

Skills Acquired

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

Learning Modules

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

Import data
Data consolidation
Linking to cells, range, between applications, break links

Custom number formats
Data validation
Worksheet grouping
Paste special options

Range name
Go To special

Using Quick Analysis
Conditional formatting
Advanced sorting
Advanced filters
PivotTabel and PivotChart

Cell referencing
Logical functions
Nested functions
Mathematical functions
Date functions
Text functions
Lookup & reference functions
Database functions
Formula auditing

Track changes
Share workbook
Compare & merge

Who is this course is for

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.

Academic prerequisites

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 Fees

Company Sponsored

Fees	Small Medium Enterprises (SMEs)	Non Small Medium Enterprises	Singaporean Employees aged 40 years and above
Full Fee	$540.00	$540.00	$540.00
9% GST (on full course fee)	$48.60	$48.60	$48.60
Funding Amount	$378.00 (70% off course fee)	$270.00 (50% off course fee)	$378.00 (70% off course fee)
Nett Fee Payable (incl. GST)	$210.60	$318.60	$210.60

SME: Company registered or incorporated in Singapore AND employment size of not more than 200 or with annual sales turnover of not more than $100 million
Non-SME (MCES): Employee is Singaporean aged 40 years and above

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

Eligible for Absentee Payroll Funding

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

Eligible for SkillsFuture Enterprise Credit (SFEC)

Self sponsored

Fees	Singapore Citizens (40 years and above)	Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above)
Full Fee	$540.00	$540.00
9% GST (on full course fee)	$48.60	$48.60
Funding Amount	$378.00 (70% off course fee)	$270.00 (50% off course fee)
Nett Fee Payable (incl. GST)	$210.60	$318.60

MCES: Singaporean aged 40 years and above
Normal: Singaporean / PR aged 21 years and above

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

Eligible for UTAP funding
Eligible for SkillsFuture Credit
Eligible for PSEA Funds