UEN No.: 198802365N

WSQ ICDL

ICDL – Perform Advanced Spreadsheet Functions (Advanced Excel 2019) EC

course details

Duration and Time

Training Time

8.30am-6pm

Course Duration

24 HRS

Course Information

Course Reference Number

TGS-2020504094

Funding Validity Period

02 Jun 2020 To
31 Dec 2022

Mode of Training

Classroom

COURSE OVERVIEW

ICDL Advanced Spreadsheets is a high level certification programme which presents learners 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
1.    Considerations in designing spreadsheets
2.    Formatting
  • Table AutoFormat
  • Conditional formatting
  • Apply data formats
  •  Using multiple worksheets
  •  Insert, move and remove split
  • Hide and show rows, columns, worksheet
3.    Functions and formula
  • Using cell references in formula
  • Function syntax and categories
  • Logical functions
  • Nested functions
  • Nested functions
  • Mathematical functions
  • Statistical functions
  • Date and Time functions
  • Financial functions
  • Text functions
  • Lookup and Reference functions
  • Database functions
  • Creating Three-D worksheets
  • Paste Special options
4.    Charts
  • Using Custom Charts
  • Formatting charts
5.    Analysis
  • Managing data in a spreadsheet
  • PivotTables
  • Data Tables
  • Scenario Manager
  • Sorting a database
  • Auto and Advanced Filters
  • Subtotals
6.    Validating and Auditing
  • Data validation
  • Auditing
7.    Enhancing Productivity
  • Range Names
  • Using Templates
  • Linking data
  • Inserting hyperlinks and bookmarks
  • Import data to Excel
  • Macros
8.    Collaborative Editing
  • Working with comments
  • File protection
  • Accessing and sharing data

Prospective learners should ideally have the ICDL certification and/or previous experience using computers and common software applications. Typically, these would be individuals who use a wide range of advanced functionalities within a spreadsheet application in a personal or professional context. Spreadsheet applications enable learners to manipulate and produce precise information and conduct crucial data analysis. The ICDL Advanced Spreadsheets certification has been specifically designed to provide learners with the skills to exploit the full potential of the spreadsheet application.

Course Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Small Medium Enterprises (SMEs) $0 $0 $0 (70% off course fee) $0
Non Small Medium Enterprises $0 $0 $0 (50% off course fee) $0
Singaporean Employees aged 40 years and above $0 $0 $0 (70% off course fee) $0

Course Fee Funding:
SME: 70% of course fee
Non-SME: 50% of course fee
Non-SME(MCES): 70% of course fee

$4.50 per training hour capped at $100,000 per enterprise per calendar year

Self-Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Singapore Citizens (40 years and above) $0 $0 $0 (70% off course fee) $0
Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) $0 $0 $0 (50% off course fee) $0

Course Fee Funding:
MCES: 70% of course fee
Normal: 50% of course fee

REGISTER TODAY

Select a date below

Looking at in-house training or have an enquiry? Contact us!

Related Courses

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761

SHARE THIS COURSE
Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration