03 days – (Advanced Excel 2013 – 24 hrs) - Perform Advanced Spreadsheet Functions (ICDL Certification) (CRS-Q-0025167-ES)

Commencement Dates

Please contact us for schedules.


Course Duration

24 Hours

Target Audience

For beginner and professional who in need of Advanced Spreadsheets in order to produce higher quality management information.


Need to possess basic knowledge of Excel 2013


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 60 minutes 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



ICDL Advanced Spreadsheets is a high level certification program which presents candidates with the opportunity to bring their spreadsheet skills to an expert level. This allows them to use the full potential of the spreadsheet application to produce higher quality management information.

Individuals with ICDL Advanced Spreadsheets certified skills can:


  •  Produce higher quality information
  •  Pinpoint key information quicker and more easily
  • Provide more sharply-defined analysis
  •  Produce more sophisticated reports
  • Use advanced editing, data handling, functions and analysis features
  • Use macros within the spreadsheets application

Course Details



Section 1 – Introduction

Spreadsheet Design
Identify the Different Techniques to Use

Section 2 – Formatting

Split Windows
Use Conditional Formatting
Use Format as a Table
Use Paste Special
Transpose Data
Copy and Move Sheets

Section 3 – Protection       

Protect Cells
Hide & Unhide Columns & Rows
Create Read-Only Workbooks
Hide and Unhide Worksheets & Workbooks
Protect Workbooks
Hide Formulas

Section 4 - Cell Comments

Use Cell Comments
Display Comments
Create, Edit & Delete Comments

Section 5 – Names

Use Names
Create and Delete Names for Cell Ranges
Paste and Apply Names
Use Names in Formulas
Use Names with Go To

Section 6 – Templates


Create & Understand Templates
Use Templates
Edit Templates

Section 7 – Formulas

Display and Check Formulas
Understand Formulas that Produce Errors
Use Mixed Cell Referencing
Create Custom Number Formats

Section 8 – Outlines

Create an Outline
Expand and Collapse Outline Level Details

Section 9 – Scenarios

Create Scenarios
Use, Edit and Delete Scenarios
Create Scenario Summary Reports

Section 10 - Linking & Importing

Link Cells
Link between Worksheets & Workbooks
Link to a Word Document
Use Hyperlinks
Importing Delimited Data
Consolidate using 3D-Sum

Section 11 – Sorting

Sort Data
Perform Multiple Sorts
Create and Use Custom Lists
Perform Custom Sorts

Section 12 – Lists

Filter Lists using the AutoFilter
Use Custom Criteria with AutoFilter
Use the Advanced Filter
Filter using Complex Criteria
Extract Filtered Data
Add Subtotals to Lists

Section 13 - Pivot Tables

Understand PivotTables
Create a PivotTable
Update a PivotTable
Filter, Group and Sort Data in a PivotTable

Section 14 – Functions

Use Date and Time Functions
Use Lookup Functions
Use Mathematical and Statistical Functions
Use Financial Functions
Use Text and Database Functions
Use Nested Functions

Section 15 – Charts

Add and Remove Data Series
Change Chart Types
Change Chart Axis Scales
Create Combination Charts
Add Images to Charts

Section 16 - Data Tables

Create a One Input Data Table
Create a Two Input Data Table

Section 17 – Macros

Understand Macros
Record a Macro
Run a Macro
Assign a Macro to the Quick Access Toolbar

Section 18 – Auditing

Use Auditing Tools
Trace Precedents and Dependents
Add and Remove Tracer Arrows
Trace Errors
Add Data Validation

Section 19 – Tracking Changes

Track Changes in Worksheet
Share Workbooks
Merge Workbooks

Entry Requirement

  • Primary education without PSLE/PSPE Certificate or their equivalent  


Fees Structure


03 days – (Advanced Excel 2013 – 24 hrs) - Perform Advanced Spreadsheet Functions (ICDL Certification) (CRS-Q-0025167-ES)


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




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