02 days –(Microsoft Excel 2013 - 17 hrs) Perform Spreadsheet Functions (ICDL Certification) (CRS-Q-0025169-ES)

Commencement Dates

Please contact us for schedules.


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


Mode of Training



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


Entry Requirement

  • Primary education without PSLE/PSPE Certificate or their equivalent 

Fees Structure


02 days –(Microsoft Excel 2013 - 17 hrs) Perform Spreadsheet Functions (ICDL Certification) (CRS-Q-0025169-ES)


Singaporean 25 to 39 & PR

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

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

Course Fee




SkillsFuture Funding




Total Gross Fee




GST 7%




SkillsFuture Credit Deduction/Cash




Participant need to pass the test to get subsidy

Eligible for Claim Period: 01 Oct 2015 - 19 Jan 2020

SSG Advice:

All Singaporean aged 25 and above can use their $500 SkillsFuture Credit to pay for a wide range of approved skills-related courses.

Visit the SkillsFuture Credit website (www.skillsfuture.sg/credit) to choose for the courses available on the SkillsFuture Credit course directory.

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