PERFORM SPREADSHEET FUNCTIONS (EXCEL) 2019 (24 HOURS)

PERFORM SPREADSHEET FUNCTIONS (EXCEL) 2019 (24 HOURS)

POPULAR Funded
Course Duration
24.0 hr(s)
Mode of Assessment

There will be a compulsory ICDL Certification Online Assessment for this course. Minimum 75% attendance is needed prior to the assessment.

Who Should Attend

Individuals who are interested in learning how to use a spreadsheet to produce accurate work output professionally.

Course Overview

Work smarter with Spreadsheets.

Rapid digitalisation and the growth of data have made analytical and quantitative skills some of the most important tools to improve productivity at work. By having the skill in Spreadsheets, you will be able to handle data accurately and produce precise work output regardless of your job responsibilities within the company. This course will equip you with the basic knowledge about the functions of Spreadsheets to ensure that you become a proficient user.

Course Schedule

Next available schedule

Course Objectives

Topic 1: Using the Application

  • Working with Spreadsheets
  • Enhancing Productivity

Topic 2: Cells

  • Insert, Select
  • Edit, Sort
  • Copy, Move, Delete

Topic 3: Managing Worksheets

  • Rows and Columns
  • Worksheets

Topic 4: Formulas and Functions

  • Arithmetic Formulas
  • Functions

Topic 5: Formatting

  • Numbers/Dates
  • Contents
  • Alignment, Border Effects

Topic 6: Charts

  • Create
  • Edit

Topic 7: Prepare Outputs

  • Setup
  • Check and Print

Pre-requisites

Mode of Training: F2F or Virtual Learning Class

(a) F2F Classes, these are the admission requirements.

  • Know the basic functions of a computer
  • Be able to read, write, speak and understand basic English
  • Have a keen interest to acquire new knowledge and willingness to learn a new skill

(b) Virtual Learning Classes, these are the admission requirements.

^Trainings will be conducted on Zoom platform, thus webcam and microphone are compulsory

  • Have a Windows OS PC prior to class with the software installed (Apple Mac OS is not applicable)
  • Know the basic functions of a computer
  • Be able to read, write, speak and understand basic English
  • Have a keen interest to acquire new knowledge and willingness to learn a new skill

Course Outline

  • Work with spreadsheets and save them in different file formats
  • Choose built-in options such as the ‘Help’ function within the application to enhance productivity
  • Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data
  • Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets
  • Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas
  • Format numbers and text content in a spreadsheet
  • Choose, create and format charts to communicate information meaningfully
  • Adjust spreadsheet page settings, check and correct spreadsheet content before finally printing spreadsheets

Certificate Obtained and Conferred by

Successful trainees will receive the internationally recognised ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore, a new initiative from ECDL Foundation.

This is a joint certification between SSG and ICDL Singapore.

Additional Details

Medium of Instruction & Trainer

  • Instructor Led Class
  • Teacher: Student Ratio is 1: 24

Price:

For Classes commencing until 31st Dec 2021

 

Individual Sponsored

Company Sponsored

Non-SME

SME

Before GST

With GST

Before GST

With GST

Before GST

With GST

Full Course Fee (For International Students)

$500.00 

$535.00  

$500.00 

$535.00  

$500.00 

$535.00  

For Singapore Citizens and PRs

 $100.00

$135.00 

 $100.00

$135.00 

 $50.00

$85.00 

For Singapore Citizens aged 40 years and above

 $50.00

$85.00 

 $50.00

$85.00 

 $50.00

$85.00 

 

For Classes commencing on or after 1st Jan 2022

 

Individual Sponsored

Company Sponsored

 

Non-SME

SME

Before GST

With GST

Before GST

With GST

Before GST

With GST

For International Students (Full Course Fee)

$500.00 

$535.00  

$500.00 

$535.00  

$500.00 

$535.00  

For Singapore Citizens and PRs

$250.00 

$285.00 

$250.00 

$285.00 

$150.00 

$185.00 

For Singapore Citizens aged 40 years and above

$150.00 

$185.00 

$150.00 

$185.00 

$150.00 

$185.00 

 

 

Funding Eligibility Criteria:

Individual Sponsored Trainee

Company Sponsored Trainee

  • Singapore Citizens or Singapore Permanent Residents
  • Trainee must achieve at least 75% attendance
  • Trainee must pass all prescribed tests / assessments, and attain 100% competency
  • NTUC LearningHub reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria
  • Singapore Citizens or Singapore Permanent Residents
  • Trainee must achieve at least 75% attendance
  • Trainee must pass all prescribed tests / assessments, and attain 100% competency
  • NTUC LearningHub reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria

 

Remarks:

Individual Sponsored Trainee

Company Sponsored Trainee

SkillsFuture Credit:

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding

 

PSEA:

  • Eligible Singapore Citizens can use their Post-Secondary Education Account (PSEA) funds to offset course fee payable after funding

 

UTAP:

  • NTUC Members can enjoy up to 50% funding (capped at $250 per year) under Union Training Assistance Programme (UTAP)

Absentee Payroll (AP) Funding:

  • $4.50 per hour, capped at $100,000 per enterprise per calendar year
  • AP funding will be computed based on the actual number of training hours attended by the trainee
  • Note: Courses / Modules under Professional Conversion Programme (PCP) will not be eligible for AP funding claim.

 

Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

 

Prices are subject to other LHUB miscellaneous fees.

 

What Others Also Enrolled In