UEN No.: 198802365N

Search
Contact Us

WSQ

Workplace Productivity Using Excel

REGISTER TODAY

course details

Duration and Time

Training Time

8.30am - 6pm

Course Duration

17 HRS

Course Information

Course Reference Number

TGS-2022016976

Funding Validity Period

08 Nov 2022 To
07 Nov 2026

Mode of Training

Classroom

COURSE OVERVIEW

This module provides fundamental knowledge and skills for utilising spreadsheet applications effectively in the workplace. Participants will learn to gather, manage, and edit data across worksheets and workbooks. The course covers essential features necessary to compile, format, and analyse data to generate meaningful reports. Learners will become proficient in creating and using formulas and functions, managing rows and columns, and formatting data and cells. This introductory course is designed to enhance productivity and enable efficient data management for beginners

 

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
Getting Started With A Spreadsheet Application
  • Using the application
  • Working with workbooks
  • Basic spreadsheet concepts
  • Using functionalities of the application
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
Manage Worksheets
  • Insert, delete & format rows & columns
  • Insert, delete, rename, move & copy worksheets
Perform Calculations
  • Arithmetic formulas
  • Excel functions
  • Cell referencing
Perform Formatting Of Data
  • Format data
  • Format cells
Create Charts
  • Create standard charts
  • Format charts
Set Up Worksheets And Select Print Options
  • Adjust page options
  • Header & footer
  • Adjust sheet display options
  • Preview worksheet
  • Select printing options

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

 

  • 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 Outline

Download the PDF below for a summary of the course outline.

DOWNLOAD PDF 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) $420.00 $37.80 $294.00 (70% off course fee) $163.80
Non Small Medium Enterprises $420.00 $37.80 $210.00 (50% off course fee) $247.80
Singaporean Employees aged 40 years and above $420.00 $37.80 $294.00 (70% off course fee) $163.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

$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) $420.00 $37.80 $294.00 (70% off course fee) $163.80
Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) $420.00 $37.80 $210.00 (50% off course fee) $247.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

REGISTER TODAY

Select a date below

02 Jan , 03 Jan
13 Jan , 14 Jan
05 Feb , 06 Feb
17 Feb , 18 Feb
06 Mar , 07 Mar
24 Mar , 25 Mar
07 Apr , 08 Apr
05 May , 06 May
22 May , 23 May
09 Jun , 10 Jun
26 Jun , 27 Jun
07 Jul , 08 Jul
24 Jul , 25 Jul
11 Aug , 12 Aug
28 Aug , 29 Aug
08 Sep , 09 Sep
25 Sep , 26 Sep
06 Oct , 07 Oct
23 Oct , 24 Oct
03 Nov , 04 Nov
20 Nov , 21 Nov
08 Dec , 09 Dec
18 Dec , 19 Dec
SHARE
Course Outline

Looking at in-house training or have an enquiry? Contact us!

Related Courses

Data Analytics Courses in Singapore

Advanced Data Visualisation using Power BI

IT

24 HRS

WSQ

Excel Courses in Singapore

Perform Spreadsheet Functions 24 hours

IT

24 HRS

WSQ

Office Productivity

Dashboards using Power Query

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

message US

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

whatsapp US

Training hotline

Give us a call at
+65 6737 5761

CALL US
IT Courses
Soft Skills Courses
About Us
Resources

Offering an extensive range of courses conducted by our pool of accredited trainers, we take pride in providing training solutions to meet your learning and professional objectives.

Connect With Us

© Copyright James Cook Institute 2024

Data Privacy Notification

UEN No.: 198802365N

Search

SERVICES

Contact Us
SHARE THIS COURSE
Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration