Level Up Your Excel Skills (17 hrs)
Course Code: TGS-2022017320 | SSG Funded
*Classroom-based Learning*
Advanced Level
This course sets out advanced skills that can be used to perform complex mathematical and statistical calculations, to produce high quality management information and to use the advance features in a spreadsheet application to improve productivity.
Participants who fulfil all requirements will receive a Statement of Attainment (SOA) issued by SkillsFuture Singapore (SSG).
- Import and organise data sources
- Prepare worksheets for data entry and calculations
- Manage data and navigate cells effectively
- Perform efficient analyse of data
- Perform advanced calculations with Excel functions
- Collaborate and review workbooks
Gather data
- Import data
- Data consolidation
- Linking to cells, range, between applications, break links
Format and manage worksheets
- Custom number formats
- Data validation
- Worksheet grouping
- Paste special options
Advanced data handling
- Range name
- Go To special
Data analysis
- Using Quick Analysis
- Conditional formatting
- Advanced sorting
- Advanced filters
Advanced Excel functions
- Cell referencing
- Logical functions
- Nested functions
- Mathematical functions
- Date functions
- Text functions
- Lookup & reference functions
- Database functions
- Formula auditing
Collaborative editing
- Track changes
- Share workbook
- Compare and merge
Optional topic
- PivotTable and PivotChart
Participants go through a structured curriculum supplemented with hands-on exercises on computers.
This course is suitable for individuals who are required to prepare and analyse data using Microsoft Excel at an advanced level. The competencies covered in this course would be relevant to all industries and organisations of all sizes.
Prerequisites
Participants are assumed to:
- Have basic knowledge of Microsoft Excel
- Be able to operate a personal computer, use keyboard and mouse
- Be able to read, write, speak and understand English at Work Place Literacy Level 5
- Be able to manipulate numbers at a proficiency level equivalent to Work Place Numeracy Level 5
- Have minimum GCE ‘O’ level or ITE certificate education
- Have at least 1 year’s working experience in any industry
Duration : 2 days (17 hrs)
Time : 8:30am to 6:00pm
With effect from 1 Jan 2024
| Type | Individuals | |||
| Singapore Citizens and Permanent Residents (Aged ≥ 21 years old) | Employer-sponsored and Self-Sponsored Singapore Citizens aged ≥ 40 years old | SME-sponsored Singapore Citizens and Permanent Residents | Non-SME-sponsored Singapore Citizens and Permanent Residents | |
| Type of Funding | ||||
| SkillsFuture Funding (Baseline) | SkillsFuture Mid-career Enhanced Subsidy | SkillsFuture Enhanced Training Support for SMEs | SkillsFuture Training Support for Non-SMEs | |
| Course Fee | $480.00 | $480.00 | $480.00 | $480.00 |
| Less: SkillsFuture Funding | $240.00 | $336.00 | $336.00 | $240.00 |
| Total Nett Fee | $240.00 | $144.00 | $144.00 | $240.00 |
| Add: GST @ 9% of Course Fee | $43.20 | $43.20 | $43.20 | $43.20 |
| Total Fee Payable to SQC | $283.20 | $187.20 | $187.20 | $283.20 |
Skill Code: LOG-LDR-2006-1.1
Skill Title: Data and Statistical Analytics-2
Funding valid till 01 Dec 2026
* 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 James Cook Institute Pte. Ltd. [formerly known as Eagle Infotech] UEN198802365N)
- Import and organise data sources
- Prepare worksheets for data entry and calculations
- Manage data and navigate cells effectively
- Perform efficient analyse of data
- Perform advanced calculations with Excel functions
- Collaborate and review workbooks
Gather data
- Import data
- Data consolidation
- Linking to cells, range, between applications, break links
Format and manage worksheets
- Custom number formats
- Data validation
- Worksheet grouping
- Paste special options
Advanced data handling
- Range name
- Go To special
Data analysis
- Using Quick Analysis
- Conditional formatting
- Advanced sorting
- Advanced filters
Advanced Excel functions
- Cell referencing
- Logical functions
- Nested functions
- Mathematical functions
- Date functions
- Text functions
- Lookup & reference functions
- Database functions
- Formula auditing
Collaborative editing
- Track changes
- Share workbook
- Compare and merge
Optional topic
- PivotTable and PivotChart
Participants go through a structured curriculum supplemented with hands-on exercises on computers.
This course is suitable for individuals who are required to prepare and analyse data using Microsoft Excel at an advanced level. The competencies covered in this course would be relevant to all industries and organisations of all sizes.
Prerequisites
Participants are assumed to:
- Have basic knowledge of Microsoft Excel
- Be able to operate a personal computer, use keyboard and mouse
- Be able to read, write, speak and understand English at Work Place Literacy Level 5
- Be able to manipulate numbers at a proficiency level equivalent to Work Place Numeracy Level 5
- Have minimum GCE ‘O’ level or ITE certificate education
- Have at least 1 year’s working experience in any industry
Duration : 2 days (17 hrs)
Time : 8:30am to 6:00pm
With effect from 1 Jan 2024
| Type | Individuals | |||
| Singapore Citizens and Permanent Residents (Aged ≥ 21 years old) | Employer-sponsored and Self-Sponsored Singapore Citizens aged ≥ 40 years old | SME-sponsored Singapore Citizens and Permanent Residents | Non-SME-sponsored Singapore Citizens and Permanent Residents | |
| Type of Funding | ||||
| SkillsFuture Funding (Baseline) | SkillsFuture Mid-career Enhanced Subsidy | SkillsFuture Enhanced Training Support for SMEs | SkillsFuture Training Support for Non-SMEs | |
| Course Fee | $480.00 | $480.00 | $480.00 | $480.00 |
| Less: SkillsFuture Funding | $240.00 | $336.00 | $336.00 | $240.00 |
| Total Nett Fee | $240.00 | $144.00 | $144.00 | $240.00 |
| Add: GST @ 9% of Course Fee | $43.20 | $43.20 | $43.20 | $43.20 |
| Total Fee Payable to SQC | $283.20 | $187.20 | $187.20 | $283.20 |
Skill Code: LOG-LDR-2006-1.1
Skill Title: Data and Statistical Analytics-2
Funding valid till 01 Dec 2026
* 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 James Cook Institute Pte. Ltd. [formerly known as Eagle Infotech] UEN198802365N)
Course Application
| Details | Registration |
|---|---|
|
May 9, 2024 - May 10, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
May 15, 2024 - May 16, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
May 20, 2024 - May 21, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
May 28, 2024 - May 29, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
June 6, 2024 - June 7, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
June 12, 2024 - June 13, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
June 18, 2024 - June 19, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
June 24, 2024 - June 25, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
July 3, 2024 - July 4, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
July 8, 2024 - July 9, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
July 18, 2024 - July 19, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
July 29, 2024 - July 30, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
August 7, 2024 - August 8, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
August 15, 2024 - August 16, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
August 20, 2024 - August 21, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
August 29, 2024 - August 30, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
September 3, 2024 - September 4, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
September 12, 2024 - September 13, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
September 18, 2024 - September 19, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
September 26, 2024 - September 27, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Closed |
|
October 7, 2024 - October 8, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Register Now |
|
October 17, 2024 - October 18, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Register Now |
|
October 23, 2024 - October 24, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Register Now |
|
October 29, 2024 - October 30, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Register Now |
|
November 4, 2024 - November 5, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Register Now |
|
November 12, 2024 - November 13, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Register Now |
|
November 19, 2024 - November 20, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Register Now |
|
November 28, 2024 - November 29, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Register Now |
|
December 3, 2024 - December 4, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Register Now |
|
December 9, 2024 - December 10, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Register Now |
|
December 19, 2024 - December 20, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Register Now |
|
December 26, 2024 - December 27, 2024 (8:30 am - 6:00 pm)
[Classroom]
|
Register Now |
