UEN No.: 198802365N

Workplace Productivity Using Excel

COURSE synopsis

Course Details

Training Provider:

Course Duration

17 HRS

Course Reference Number

TGS-2022016976

Funding Validity Period

08 Nov 2022 To
07 Nov 2024

Mode of Training

Classroom

COURSE SYNOPSIS

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.

COURSE OBJECTIVES

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

Target Audience

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

Assumed Skills

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

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

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

COURSE FEES

Company Sponsored

Funding Type Full Fee GST Funding Amount Nett Fee Payable (incl. GST)
SME $420 $33.60 $294 $159.60
Non-SME $420 $33.60 $210 $243.60
Non-SME
(MCES)
$420 $33.60 $294 $159.60

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 GST Funding Amount Nett Fee Payable (incl. GST)
MCES $420 $33.60 $294 $159.60
Normal $420 $33.60 $210 $243.60

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

Related Courses

IT

24 HRS

WSQ

IT

16 HRS

WSQ

IT

16 HRS

WSQ

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