Perform Spreadsheet Functions 24 hours

Funding Validity Period

19 September 2023

18 September 2027

Course Overview

This course is a comprehensive 24-hour program designed to equip learners with essential spreadsheet skills. Starting with the basics of navigating and utilising a spreadsheet application, participants will progress through managing data, organising worksheets, and performing basic calculations. The course also covers data formatting, chart creation for data presentation, and setting up worksheets with print options to ensure professional and effective spreadsheet use.

*This course includes an online assessment (ICDL).

Skills Acquired

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

Use fundamental features of a spreadsheet application.
Identify areas for collection of data, collect and edit data.
Manage rows, columns and worksheets to facilitate data manipulation.
Create formulas and functions to create business statistics.
Format data and cells.
Create and format standard charts.
Apply page setup options, preview 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 on data

Arithmetic formulas
Excel functions
Cell referencing

Learning Unit 5: Perform formatting of data

Format data
Format cells

Learning Unit 6: Create charts to present data

Create standard charts
Format charts

Learning Unit 7: Set up worksheets and select print option

Adjust page options
Header & footer
Preview worksheet
Select print 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
Preview worksheet
Select print options

Who is this course is for

This course is intended for learners who wish to equip themselves with the necessary knowledge and skills to be proficient with using the core features of a spreadsheet application. The skills include understanding fundamental spreadsheet concepts, designing a spreadsheet and using basic functions within a spreadsheet.

Academic prerequisites

Learners must be able to read, write, speak and listen to English at secondary school level
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

Course Fees

Fees	Small Medium Enterprises (SMEs)	Non Small Medium Enterprises	Singaporean Employees aged 40 years and above
Full Fee	$720.00	$720.00	$720.00
9% GST (on full course fee)	$64.80	$64.80	$64.80
Funding Amount	$504.00 (70% off course fee)	$360.00 (50% off course fee)	$504.00 (70% off course fee)
Nett Fee Payable (incl. GST)	$280.80	$424.80	$280.80

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)

Fees	Singapore Citizens (40 years and above)	Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above)
Full Fee	$720.00	$720.00
9% GST (on full course fee)	$64.80	$64.80
Funding Amount	$504.00 (70% off course fee)	$360.00 (50% off course fee)
Nett Fee Payable (incl. GST)	$280.80	$424.80

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