ICDL - Perform Advanced Spreadsheet Functions (Advanced Excel 2019) - SkillsPortal.sg

ICDL - Perform Advanced Spreadsheet Functions (3 Days)

Eagle Infotech Consultants Pte Ltd

  • $540.00
    Unit price per 

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 

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.

Overview of Module

  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

  1.  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

  1.  Charts

Using Custom Charts

Formatting charts

  1.  Analysis

Managing data in a spreadsheet


Data Tables

Scenario Manager

Sorting a database

Auto and Advanced Filters


  1.  Validating and Auditing

Data validation


  1.  Enhancing Productivity

Range Names

Using Templates

Linking data

Inserting hyperlinks and bookmarks

Import data to Excel


  1.  Collaborative Editing

Working with comments

File protection

Accessing and sharing data


Additional Info


3 Days


Customer Reviews

No reviews yet