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

Course Code: TGS-2020504094

ICDL Advanced Spreadsheets is a high level certification programme which presents participants 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.

Participants who fulfil all requirements will receive a Statement of Attainment (SOA) issued by SkillsFuture Singapore (SSG).

  • 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

Considerations in designing spreadsheets

Formatting

  • Table AutoFormat
  • Conditional formatting
  • Apply data formats
  • Using multiple worksheets
  • Insert, move, remove spilt
  • Hide and show rows, columns, worksheet

Functions and formulas

  • 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

Charts

  • Using Custom Charts
  • Formatting charts

Analysis

  • Managing data in a spreadsheet
  • PivotTables
  • Data Tables
  • Scenario Manager
  • Sorting a database
  • Auto and Advanced Filters
  • Subtotals

Validating and auditing

  • Data validation
  • Auditing

Enhancing productivity

  • Range Names
  • Using Templates
  • Linking data
  • Inserting hyperlinks and bookmarks
  • Import data to Excel
  • Macros

Collaborative editing

  • Working with comments
  • File protection
  • Accessing and sharing data

Participants go through a structured curriculum supplemented with hands-on exercises on computers.

 

This course is intended for participants with ICDL certification and/or previous experience using computers and common software applications.

Prerequisites

Participants are assumed to:

  • Have completed ICDL – Perform Spreadsheet Functions 2016 / ICDL – Perform Spreadsheet Functions 2019

Duration : 3 days (24 hrs)
Time : 8:30am to 6:00pm

Course Fee : $600.00
Nett Fee Incl. 7% GST : $642.00
Nett Fee after Training Grant* : $102.00 (SMEs) | $234.00 (Non-SMEs / Self-Sponsored)
Nett Fee after MCES* : $102.00

* Please click HERE for detailed information on general terms and conditions.

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with Eagle Infotech)

Key Benefits
  • 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 Contents

Considerations in designing spreadsheets

Formatting

  • Table AutoFormat
  • Conditional formatting
  • Apply data formats
  • Using multiple worksheets
  • Insert, move, remove spilt
  • Hide and show rows, columns, worksheet

Functions and formulas

  • 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

Charts

  • Using Custom Charts
  • Formatting charts

Analysis

  • Managing data in a spreadsheet
  • PivotTables
  • Data Tables
  • Scenario Manager
  • Sorting a database
  • Auto and Advanced Filters
  • Subtotals

Validating and auditing

  • Data validation
  • Auditing

Enhancing productivity

  • Range Names
  • Using Templates
  • Linking data
  • Inserting hyperlinks and bookmarks
  • Import data to Excel
  • Macros

Collaborative editing

  • Working with comments
  • File protection
  • Accessing and sharing data
Learning Methodology

Participants go through a structured curriculum supplemented with hands-on exercises on computers.

 

Who Should Attend

This course is intended for participants with ICDL certification and/or previous experience using computers and common software applications.

Prerequisites

Participants are assumed to:

  • Have completed ICDL – Perform Spreadsheet Functions 2016 / ICDL – Perform Spreadsheet Functions 2019
Course Details

Duration : 3 days (24 hrs)
Time : 8:30am to 6:00pm

Course Fee : $600.00
Nett Fee Incl. 7% GST : $642.00
Nett Fee after Training Grant* : $102.00 (SMEs) | $234.00 (Non-SMEs / Self-Sponsored)
Nett Fee after MCES* : $102.00

* Please click HERE for detailed information on general terms and conditions.

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with Eagle Infotech)

Course Application

Details Registration
June 16, 2021 - June 18, 2021 (8:30 am - 6:00 pm)
[Dates: Jun 16, 17 & 18]
Closed
June 28, 2021 - June 30, 2021 (8:30 am - 6:00 pm)
[Dates: Jun 28, 29 & 30]
Closed
July 6, 2021 - July 8, 2021 (8:30 am - 6:00 pm)
[Dates: Jul 6, 7 & 8]
Closed
July 21, 2021 - July 23, 2021 (8:30 am - 6:00 pm)
[Dates: Jul 21, 22 & 23]
Closed
July 26, 2021 - July 28, 2021 (8:30 am - 6:00 pm)
[Dates: Jul 26, 27 & 28]
Closed
August 10, 2021 - August 12, 2021 (8:30 am - 6:00 pm)
[Dates: Aug 10, 11 & 12]
Closed
August 30, 2021 - September 1, 2021 (8:30 am - 6:00 pm)
[Dates: Aug 30, 31 & Sep 1]
Register Now
September 9, 2021 - September 13, 2021 (8:30 am - 6:00 pm)
[Dates: Sep 9, 10 & 13]
Register Now
September 20, 2021 - September 22, 2021 (8:30 am - 6:00 pm)
[Dates: Sep 20, 21 & 22]
Register Now
September 29, 2021 - October 1, 2021 (8:30 am - 6:00 pm)
[Dates: Sep 29, 30 & Oct 1]
Register Now
October 6, 2021 - October 8, 2021 (8:30 am - 6:00 pm)
[Dates: Oct 6, 7 & 8]
Register Now
October 19, 2021 - October 21, 2021 (8:30 am - 6:00 pm)
[Dates: Oct 19, 20 & 21]
Register Now
November 1, 2021 - November 3, 2021 (8:30 am - 6:00 pm)
[Dates: Nov 1, 2 & 3]
Register Now
November 15, 2021 - November 17, 2021 (8:30 am - 6:00 pm)
[Dates: Nov 15, 16 & 17]
Register Now
November 24, 2021 - November 26, 2021 (8:30 am - 6:00 pm)
[Dates: Nov 24, 25 & 26]
Register Now
December 1, 2021 - December 3, 2021 (8:30 am - 6:00 pm)
[Dates: Dec 1, 2 & 3]
Register Now
December 17, 2021 - December 21, 2021 (8:30 am - 6:00 pm)
[Dates: Dec 17, 20 & 21]
Register Now