Workplace Productivity Using Excel

Funding Validity Period

8 November 2022

7 November 2026

Course Overview

This module sets out indispensable knowledge relating to understanding the concept of using
a spreadsheet application and skills relating to using the application to effectively compile,
format and analyse data and to generate meaningful reports. Learners will also acquire the
necessary skills in using the spreadsheet application efficiently so as to enhance their
productivity at the workplace.

Skills Acquired

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

Use fundamental features of a spreadsheet application
Gather and edit data
Manage rows and columns in a worksheet
Manage worksheets in a workbook
Create formulas and functions
Format data and cells
Create and format standard charts
Select spreadsheet settings
Preview a spreadsheet and select print options

Learning Modules

Learning Unit 1 Getting started with a spreadsheet application

Using the application
Working with workbooks
Basic spreadsheet concepts
Using functionalities of the application

Learning Unit 2 Manage Data In A Spreadsheet

Good practices in managing data
Enter & edit data
Moving within a worksheet
Cell selection techniques
Copy, cut & paste
Find & replace
Sort & filter

Learning Unit 3 Manage Worksheets

Insert, delete & format rows & columns
Insert, delete, rename, move & copy worksheets

Learning Unit 4 Perform Calculations

Arithmetic formulas
Excel functions
Cell referencing

Learning Unit 5 Perform Formatting Of Data

Format data
Format cells

Learning Unit 6 Create Charts

Create standard charts
Format charts

Learning Unit 7 Set Up Worksheets And Select Print Options

Adjust page options
Header & footer
Adjust sheet display options
Preview worksheet
Select printing options

Using the application
Working with workbooks
Basic spreadsheet concepts
Using functionalities of the application

Good practices in managing data
Enter & edit data
Moving within a worksheet
Cell selection techniques
Copy, cut & paste
Find & replace
Sort & filter

Insert, delete & format rows & columns
Insert, delete, rename, move & copy worksheets

Arithmetic formulas
Excel functions
Cell referencing

Format data
Format cells

Create standard charts
Format charts

Adjust page options
Header & footer
Adjust sheet display options
Preview worksheet
Select printing options

Who is this course is for

This training is relevant to all staff tasked with collating, managing and analysing data of the
organisations to determine current performance and then develop recommendations for
improvement to senior management

Academic prerequisites

Be able to listen and speak English at a proficiency level equivalent to the Employability Skills Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 4
Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 4
Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 4
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 have basic computer skills, i.e. be able to operate a personal computer, use keyboard and mouse

Course Fees

Company sponsored

Fees	Small Medium Enterprises (SMEs)	Non Small Medium Enterprises	Singaporean Employees aged 40 years and above
Full Fee	$480.00	$480.00	$480.00
9% GST (on full course fee)	$43.20	$43.20	$43.20
Funding Amount	$336.00 (70% off course fee)	$240.00 (50% off course fee)	$336.00 (70% off course fee)
Nett Fee Payable (incl. GST)	$187.20	$283.20	$187.20

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	$480.00	$480.00
9% GST (on full course fee)	$43.20	$43.20
Funding Amount	$336.00 (70% off course fee)	$240.00 (50% off course fee)
Nett Fee Payable (incl. GST)	$187.20	$283.20

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