24hrs – ICDL Perform Advanced Spreadsheet Functions (Excel Advanced) 

Course Code: CRS-Q-0026883-ES

Course Objective – 24hrs – ICDL Perform Advanced Spreadsheet Functions (Excel Advanced)

During the midst of the course, 24hrs – ICDL Perform Advanced Spreadsheet Functions (Excel Advanced) , you will be able to:

  1. Use advanced formatting, formulae and charts features to enhance a spreadsheet
  2. Analyse, validate and audit data in a spreadsheet
  3. Use advanced spreadsheet functions to enhance productivity
  4. Manage collaborative editing to a spreadsheet

In completion of this course, participants may think of doing a recap either via Microsoft Excel 2013 – Basic , Microsoft Excel 2013 – Intermediate and Microsoft Excel 2013 – Advanced


  • Course Dates and Venue

    Course Duration: 3 days (24 hours) 9am – 6pm

    24hrs - ICDL Perform Advanced Spreadsheet Functions (Excel Advanced)JTC Summit26-2829-3112-1419-21
    JTC Summit (Weekend)01, 08 & 15--01 & 08 & 15
    Mountbatten Square12-1424-2628-3026-28

    September 2015

  • Advanced Formatting

    • Considerations in Designing a Spreadsheet
    • Working with Cell Styles & Document Themes
    • Apply, Create & Manage Conditional Formatting
    • Creating a Custom Number Format

    Working with Tables

    • Create a Table & working with the Total Row
    • Sorting & Filtering a Table
    • Formatting the Table
    • Converting to a Range

     Advanced Functions and Formulas

    • Formulas with Multiple Operators
    • Using and Managing Defined Names
    • Using Mixed Cell Referencing
    • Date and Time Functions
    • Using Logical Functions (IF, AND and OR)
    • Using Lookup Functions
    • Mathematical and Statistical Functions
    • Using Financial, Text & Database Functions
    • Using 3D Reference within SUM Function

    Validating Data and Auditing Worksheets

    • Using Data Validation
    • Auditing Tools
    • Displaying and Tracing Formulas
    • Understanding Formula Errors

    Managing Charts

    • Editing, Adding, and Removing Chart Data
    • Changing Chart Data
    • Change Scales and Display Unit of the Axis
    • Add Secondary Axis & Change Series Chart Type
    • Changing and Aligning Data Labels and Chart Legend

    Working with Data Ranges

    • Sorting by a Custom List
    • Creating a Custom AutoFilter
    • Using Advanced Filter

    Working with PivotTables

    • Creating a PivotTable
    • Specifying PivotTable Data
    • Changing a PivotTable’s Calculation
    • Filtering and Sorting a PivotTable
    • Working with PivotTable Layout
    • Grouping PivotTable Items
    • Updating & Formatting a PivotTable
    • Creating a PivotChart
    • Using Slicers between PivotTables

    Analyzing Data

    • Creating Scenarios
    • Working with Data Tables
    • Using Goal Seek
    • Using Text to Columns
    • Grouping and Outlining Data
    • Using Subtotals
    • Consolidating Data by Position or Category

    Managing Templates

    Linking and Importing Data

    • Inserting a Hyperlink
    • Linking Data & Managing External Links
    • Importing Data
    • Working with Existing Data Connections

    Working with Macros

    • Recording a Macro
    • Playing and Deleting a Macro
    • Adding a Macro to the Quick Access Toolbar

    Managing Collaborative Editing

    • Working with Comments to Cells
    • Tracking Changes
    • Protecting Worksheets and Worksheet Elements
    • Protecting a Workbook
  • The course, ICDL Excel – Advanced, is meant for people who have good basic to intermediate level of knowledge on Microsoft Excel and would like to further extend the knowledge on more advanced functions of Excel to become more productive and make the most of Excel.

    This course is most suitable for Account Executive, Admin Executive, and HR Personnel who deals with number reporting. It allows them to create managed worksheets, create charts, do calculations to manage reports such as inventory listing, payrolls, invoices, payment and product pricing even more professionally.

  • “Bee Hoon is a skillful trainer and has expertise in sharing her thoughts. She is indeed a competent trainer to inject a soft skills to new learners. Teaching environment was so good.” – Ayyadurai Sundarapandian (12, 19 & 26 Nov 2016)

    “The knowledge and skills that were taught are useful to my job.” – Rasida Bte Abdul Rashid (12, 19 & 26 Nov 2016)

Fees and Grants

$556.40 per participant (Inc. GST)

SMEs Company Sponsored Singaporean/PR only: $88.40 (Inc. GST).
Click here for more details on Grant.

SDF subsidy: WSQ Courses. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

Applicants may use SkillsFuture Credit for this course


Click here to download registration form for company-sponsored trainees.

Click here to download registration form for self-sponsored trainees.

Course Feedback

Click here to download our course feedback form.

Apply Online

24hrs – ICDL Perform Advanced Spreadsheet Functions (Excel Advanced)  (CRS-Q-0026883-ES)

All registration should be submitted at least 1 week before course commencement. Please call us directly to check on the class status.

A. Company Particulars

Company Name*

Company Address*

Postal Code*

B. Training Coordinator / Contact Person

TC / Contact Person Name*

TC / Contact Person Email*

Contact Number*

Fax Number

C. Billing Information

Billing Contact Person Name*

Billing Contact Person Email*

Billing Contact Number*

Billing Fax Number

Business Unit (BU / SBU)

For Businesses or Government Agencies using the e-invoice system only.

Are you applying for SDF Grant?

Applicable to some select IT and Softskills Courses.

D. Participants

Participant 1*

Course Start Date*

Course End Date*

Participant 2

Course Start Date*

Course End Date*

Participant 3

Course Start Date*

Course End Date*

Have more than 3 participants?

Attach their particulars here (PDF, Word .doc, Excel .xls)

I have Read and Agree to the Terms and Conditions

We do not sell or share your information with anyone else.