Perform Advanced Spreadsheet Functions (Advanced Excel 2019) EC

ICDL – Perform Advanced Spreadsheet Functions (Advanced Excel 2016/2019) (17 hrs)

Course Code: IC-PASF-E

*Classroom-based Learning*

Advanced Level

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 Certificate issued by ICDL.

  • 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

Duration : 2 days (17 hrs)
Time : 8:30am to 6:00pm

With effect from 1 Jan 2024

FeesIndividuals
Course Fee$490.00
Add: GST @ 9% of Course Fee$44.10
Total Fee Payable to SQC$534.10

(A course in partnership with James Cook Institute Pte. Ltd. [formerly known as Eagle Infotech] UEN198802365N)

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
Course Details

Duration : 2 days (17 hrs)
Time : 8:30am to 6:00pm

With effect from 1 Jan 2024

FeesIndividuals
Course Fee$490.00
Add: GST @ 9% of Course Fee$44.10
Total Fee Payable to SQC$534.10

(A course in partnership with James Cook Institute Pte. Ltd. [formerly known as Eagle Infotech] UEN198802365N)

Course Application

Details Registration
January 4, 2024 - January 5, 2024 (8:30 am - 6:00 pm)
[Classroom]
Closed
January 30, 2024 - January 31, 2024 (8:30 am - 6:00 pm)
[Classroom]
Closed
February 8, 2024 - February 9, 2024 (8:30 am - 6:00 pm)
[Classroom]
Closed
February 26, 2024 - February 27, 2024 (8:30 am - 6:00 pm)
[Classroom]
Closed
March 6, 2024 - March 7, 2024 (8:30 am - 6:00 pm)
[Classroom]
Closed
March 27, 2024 - March 28, 2024 (8:30 am - 6:00 pm)
[Classroom]
Closed
April 11, 2024 - April 12, 2024 (8:30 am - 6:00 pm)
[Classroom]
Closed
April 29, 2024 - April 30, 2024 (8:30 am - 6:00 pm)
[Classroom]
Closed
May 8, 2024 - May 9, 2024 (8:30 am - 6:00 pm)
[Classroom]
Closed
May 23, 2024 - May 24, 2024 (8:30 am - 6:00 pm)
[Classroom]
Register Now
June 11, 2024 - June 12, 2024 (8:30 am - 6:00 pm)
[Classroom]
Register Now
June 27, 2024 - June 28, 2024 (8:30 am - 6:00 pm)
[Classroom]
Register Now