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

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

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

Workplace Productivity Using Excel

Course Highlight

Course Duration

17 HRS

Training Time

8.30am - 6pm

Mode of Training

Classroom

Course Reference Number

TGS-2022016976

Corporate Subsidy
Individual Subsidy

Have More Questions?

Lets start a conversation to upgrade your skillset

Other relevant courses

Lorem ipsum dolor sit amet consectetur. Arcu eu diam urna eu lorem leo tellus lectus. Enim proin hac quis placerat maecenas aliquam nunc viverra quis.

NEW

Mastering Excel with AI and CoPilot
8 HRS Course

WSQ

Registered

Perform Spreadsheet Functions 24 hours
24 HRS Course
Power Query and Power Pivot (Excel 365)
8 HRS Course

UEN No.: 198802365N

Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration