ES WSQ – 2 Days – Perform Spreadsheets Functions (Ms Excel 2013 – 17 hrs) (ICDL Certification Module: Spreadsheets)

Commencement Dates

19/11/2018 to 20/11/2018 [Mon / Tue]
Genetic (Aljunied)
Blk 118 Aljunied Avenue 2, #02-100
Book Now
19/11/2018 to 20/11/2018 [Mon / Tue]
Genetic (Jurong Gateway)
21 Jurong Gateway #03-09/10 CPF Jurong Building Singapore 608546
Book Now
25/11/2018 to 2/12/2018 [Sun / Sun]
Genetic (Jurong Gateway)
21 Jurong Gateway #03-09/10 CPF Jurong Building Singapore 608546
Book Now


Course Duration

17 Hours 

Target Audience

For beginner and professional who in need of spreadsheet in order to create and to produce accurate work outputs.


Need to possess the knowledge of basic PC


Successful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore. This is a joint certification between SSG and ICDL Singapore. Student must take a 45 min online assessment at the end of the course.

Course Pathway

For more information on the ICDL Progression Pathway please refer to the link below:

ICDL Courses Progression Pathways


This module enables candidates to understand the concept of spreadsheets and to demonstrate the ability to use a spreadsheet application. Candidates will understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet, in addition to using standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts.

On completion of this module each candidate will be able to:

  1. Work with spreadsheets and save them in different file formats

  2. Choose built-in options such as the Help function within the application to enhance productivity

  3. Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data

  4. Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets

  5. Create mathematical and logical formulas using standard spreadsheet functions. Use good practice 
    in formula creation and recognize error values in formulas

  6. Format numbers and text content in a spreadsheet

  7. Choose, create and format charts to communicate information meaningfully

  8. Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets

Course Details



Section 1 : Introducing Excel 2013

Starting Excel Interface
Excel Screen
Navigating Ribbon
Worksheet Window
Getting Help
Set Preferences

Section 2 : Workbook Management

Workbook Open & Close
Opening Multiple Workbooks
Create & Save a New Workbook
Save in Different Formats & Template
Save & Share Files Online

Section 3 : Data Entry

Enter Labels & Numbers
Enter Formulas - Autosum
Check for Errors
Check Spelling

Section 4 : Worksheet Formatting

Multiple Worksheets
Copy & Move
Insert & Delete
Switch Workbooks

Section 5 : Data Manipulation

Edit & Delete
Undo & Redo
Fill Handles
Flash Fill
Copy & Move Cells
Finding & Replacing Text
Sorting & Filtering

Section 6 : Printing and Output

Printing In Excel
Page Setup - Size, Orientation & Layout
Setting Margins
Printing Selections - Setting a Print Area
Setting Headers & Footers
Printing Titles
Preview Prints

Section 7 : Cell Formatting

Apply Formatting
Fonts, Font Size & Font Styles
Number Formatting
Formatting Dates & Times
Adding Cell Colours & Borders
Alignment & Rotation
Zoom & Freeze Panes
Inserting & Deleting Sheets
Changing Column Width & Row Height
Inserting & Deleting Rows & Columns

Section 8 : Formulas

Introduction to Excel Calculations
Writing Formulas
Order of Operations
Relative & Absolute Cell Addressing
Troubleshoot Errors

Section 9 : Functions

Writing Functions
Count Numbers
Average & Round
Maximum & Minimum
Logical Function - IF

Section 10 : Charts

Introducing Charts
Chart Recommendation
Creating Charts
Moving Charts Between Worksheets
Chart Types
Copy, Move & Resize Charts
Formatting Charts
Setting Charts Options


Fees Structure


ES WSQ – 2 Days – Perform Spreadsheets Functions (Ms Excel 2013 – 17 hrs) (ICDL Certification Module: Spreadsheets)


Singaporean 25 to 39 & PR

Mid-Career Enhanced & Subsidy >=40 years old born on /before 1978

WTS, > = 35 years old  born on/before 1983

Course Fee




SkillsFuture Funding




Total Gross Fee




GST 7%




SkillsFuture Credit Deduction/Cash





SME: Small and Medium Enterprise

WTS: Workfare Training Support

Participant need to pass the test to get subsidy

Thank you for your enquiry. One of our course consultants will keep in touch with you shortly.

Request more information

What would you like to request?


Adobe authorized training center
WSQ work skills qualification training center
ICDL test center
EduTrust CPE Singapore
Registration No: 198902296M
24 June 2015 to 23 June 2019
Main Office
Block 118 Aljunied Avenue 2
#02-100 Singapore 380118
Tel: +65 6339 7588
Bedok Branch
Blk 209 New Upper Changi Road
#04-643 Singapore 460209
Tel: +65 6913 4572
Jurong Branch
CPF Jurong Building 21
#03-09/10 Jurong Gateway Road
Singapore 150167
Tel: +65 6912 4316
Bukit Merah Branch
Blk 167 Jln Bt Merah Tower 4, Connection One
#06-11A Singapore 150167
Tel: +65 6928 0735