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
Fees | Individuals | |||
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)
- 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
Fees | Individuals | |||
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 |