templates/tpl-school.php-7954-10900-pd

PERFORM ADVANCED SPREADSHEET FUNCTIONS (ICDL ADVANCED SPREADSHEETS)

The ICDL Foundation is an international organisation dedicated to raising digital competence standards in the workforce, education and society. The ICDL certification programmes, delivered through an active network in more than 100 countries, enable individuals and organisations to assess, build and certify their competence in the use of computers and digital tools to the globally-recognised ICDL standard.

This module sets out advanced skills that can be used to produce sophisticated reports, to perform complex mathematical and statistical calculations, and to improve productivity using a spreadsheet application.

Contact Us to Check

Class Dates:

To Be Advised

Class Timing:

9.00 AM – 6.00 PM

Successful candidates will be able to:

  • Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets.
  • Use functions such as those associated with logical, statistical, financial and mathematical operations.
  • Create charts and apply advanced chart formatting.
  • Work with tables and lists to analyse, filter and sort data. Create and use scenarios.
  • Validate and audit spreadsheet data.
  • Enhance productivity by working with named cell ranges and macros.
  • Use linking, embedding and importing features to integrate data.
  • Compare and merge spreadsheets. Apply spreadsheet security features.
  1. Formatting

    1.1 Cells
    1.2 Worksheets

  2. Formulas and Functions

    2.1 Using Formulas and Functions

  3. Charts

    3.1 Creating Charts
    3.2 Formatting Charts

  4. Analysis

    4.1 Using Tables
    4.2 Sorting and Filtering
    4.3 Scenarios

  5. Validating and Auditing

    5.1 Validating
    5.2 Auditing

  6. Enhancing Productivity

    6.1 Naming Cells
    6.2 Paste Special
    6.3 Linking, Embedding and Importing
    6.4 Automation

  7. Collaborative Editing
    7.1 Reviewing and Security

3 days (24 hours)

23 (Training Hours)
1 (Assessment Hour)

Part Time
Full Time

Demonstrate listening, speaking, reading, and writing skills (English) at a level equivalent to Employability Skills System (ESS) Literacy Level 4.

Demonstrate numeracy skills at a level equivalent to Employability Skills System (ESS) Numeracy Level 4.

Course Fee: $540.00
GST: $37.80

ONLINE ENQUIRY FORM