WSQ Microsoft Excel – Intermediate & Advanced Level Course in Singapore
WSQ Microsoft Excel – Intermediate & Advanced Level Course
Master advanced Microsoft Excel skills in Singapore with our WSQ Intermediate & Advanced course. Elevate your spreadsheet proficiency, unlock powerful features, and enhance your data analysis capabilities.
Eligible companies can enjoy enhanced funding support when sponsoring staff for training:
* Claim up to $4.50/hour per participant under Absentee Payroll
* Receive up to 90% funding of the payable course fees through SFEC
This is on top of the existing WSQ course fee subsidies, helping companies significantly reduce their overall training costs.
Schedule
- Days: 3 Days
- Duration: 21 Hours
- Timings: 9:30 AM - 5:30 PM
- 10 Anson Road, 26-08A International Plaza, Singapore 079903
Why Choose Us
- Expert Local Trainers
- Hands-on Training by experts
- Certificate of Achievement
SSG Course Details
- TGS-2023040845
- Mode of Training: Physical, in-class training
- Course Subsidy Validity - From 19 Dec 2023 to 18 Dec 2027
Training fee:
*Course fee before WSQ funding: $550.00/pax + the new 9% GST
Funding: (GST included)
*The funding amount mentioned is indicative and will be
confirmed upon registration.
| Self-sponsor/ Non-SME Company Sponsor | SME Company Sponsor | |||
|---|---|---|---|---|
| Full Course Fee (no funding) |
Age 21-39 S/PRs (SkillsFuture Funding Baseline) |
Age 40 above (SkillsFuture Mid-career Enhanced Subsidy) |
SME Company Sponsor (SkillsFuture Enhanced Training support for SMEs) |
|
| Full Course Fee (bef funding) | $550.00 | $550.00 | $550.00 | $550.00 |
| SkillsFuture Funding (WSQ) | - $0.00 | - $275.00 | - $385.00 | - $385.00 |
| GST (On Full Fee) | + $49.50 | + $49.50 | + $49.50 | + $49.50 |
|
Total Payable (After Funding and GST Included) |
$599.50 | $324.50 | $214.50 | $214.50 |
Payable amount after WSQ funding is eligible for further support from SFEC, SkillsFuture, PSEA & UTAP where applicable.
Kindly note that you are required to achieve a minimum of 75% attendance and be certified competent in all the assessment components. Should you fail to meet the attendance/assessment requirements and/or terms and conditions of SSG’s funding, you will not be eligible for the course fee funding and will have to bear the full course fees.
Discount Policy:
- 4 pax from a same group: 5% discount for each person
- 5 pax from a same group: 10% discount for each person
Grants Available
WSQ
Singapore Workforce Skills Qualifications
Baseline funding deduction upto 70% for Singaporeans/ PRs. Further SFEC, Absentee Payroll and WSS applicable.
SkillsFuture
Eligible
Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees
PSEA
Post-Secondary Education Account are available for Singaporean Citizens to cover the approved fees and charges related to WSQ programs.
SFEC
Eligible companies can offset up to 90% of the payable amount via SFEC
Absentee Payroll
Eligible companies can reimburse $4.50 per hour/pax joining our courses from Absentee Payroll
Who Should Attend
Student
Business professionals
Entrepreneur
Analyst
Course Completion Requirements
Minimum 75% attendance & Passing the assessment by the end of the course is required in order to complete the course and receive the course completion certificate as well as course fee subsidy funding
Above 16 years old
High School Level English
Basic internet & computer operation skills
WSQ Microsoft Excel Intermediate & Advanced Course
This Microsoft Excel Intermediate & Advanced course is catered to a diverse range of audience seeking to enhance their existing data analysis skills for more advanced applications in a business context using Excel applications. Target audiences for this course include:
- Professionals involved in data analysis, modelling, and reporting within their organizations.
- Data Analysts who work with data on a regular basis and want to automate data manipulation and reporting tasks in Excel.
- Finance professionals who rely on Excel for financial modelling, forecasting, and data analysis.
- Accountants and finance professionals who use Excel for financial reporting and analysis.
- Administrative staff who manage data, records, and reports using Excel.
- Project managers who use Excel for project planning, tracking, and reporting.
- Individuals who use Microsoft Excel regularly for tasks such as data analysis, reporting, budgeting, or project management.
What Will You Learn WSQ Microsoft Excel Intermediate & Advanced Course
- Learners are able to prepare and assist in generating diverse business insight reports adhering to legal and ethical guidelines related to data protection using data modelling and data visualisation principles.
- Learners are able to perform complex database queries across multiple tables/unions to extract pertinent data by employing techniques used in data science.
- Learners are able to identify the statistical techniques and machine learning methods to conduct meaningful and relevant data analysis on distinct datasets.
- Learners are able to provide assistance with data transformation, quality checking and cleansing of data set into easily digestible formats.
- Learners are able to apply data mining, time series forecasting and modelling techniques to identify and predict trends and patterns in data for business insights with applicable functional languages.
- Learners are able to demonstrate an understanding of the underlying data structures involved in data science and summarise the data studies for business insights presentation.
- Learners are able to recognise the significance of domain context in data science to produce performance dashboards and insight reports tailored to specific business domains.
WSQ Microsoft Excel Intermediate & Advanced Course Outline
Module One: Create and Manage Worksheets and Workbooks
Manage Workbooks
- Reference data in another worksheet/workbook
- Reference data by using 3D references
Manage Workbook Review
- Configure formula calculation options
- Restrict editing
- Protect a worksheet
- Protect workbook structure
- Encrypt workbooks with a password
Module Two: Apply Custom Data Formats and Layouts
Apply Custom Data Formats and Validation
- Create custom number formats
- Populate cells by using advanced Fill Series options
- Configure data validation
Apply Advanced Conditional Formatting
- Create custom conditional formatting rules
- Create conditional formatting rules that use formulas
- Manage conditional formatting rules
Module Three: Create Advanced Formulas
Define Named Ranges and Objects
- Name cells
- Name data ranges
- Name tables
Automating Task
- Create and modify simply macros
Format cells and ranges
- Merge cells
- Modify cell alignment and indentation
- Wrap text within cells
- Apply number formats
- Format cells by using Format Painter
Module Four: Perform Data Analysis and Business Intelligence
Managing External Data
- Import, transform, combine, display, and connect to data
- Consolidate data
Performing What-If Analysis
- One & Two Variable Data Tables
- Achieve Target Value by using Goal Seek
- Present multiple values with Scenarios
- Forecast data
Module Five: Create Advanced Charts
Create Advanced Charts
- Add trend lines to charts
- Create dual axis charts
- Save a chart as a template
Module Six: Analyze Data with PivotCharts & PivotTables
Create and Manage Pivot Tables
- Create PivotTables
- Modify field selections and options
- Format data
- Group PivotTable data
- Create slicers & timelines
- Reference data in a PivotTable by using the GETPIVOTDATA function
- Add calculated fields
- Using report filter pages
- Drill down details
Create and Manage PivotCharts
- Create PivotCharts
- Manipulate options in existing PivotCharts
- Apply Styles to PivotCharts
FAQ for WSQ Microsoft Excel Intermediate & Advanced Course in Singapore
Who should take the WSQ Microsoft Excel Intermediate & Advanced Course?
This course is ideal for professionals who want to enhance their Excel skills for better data management, reporting, and analysis.
What if I fail/did not complete the assessment?
You will be considered non-competent and no Statement of Attainment (SOA) will be awarded.
You are required to pay the complete course fee, which includes the SSG’s funding requirement.
Is there a prerequisite for this course?
Yes, participants should have basic knowledge of Excel or have completed an Excel beginner-level course.
How long is the course?
The course typically lasts 3 days, with both weekday and weekend schedules available
Will I receive a certificate after completing the course?
Yes, participants will receive a WSQ certificate upon successful completion of the course and assessments.
Is this course SkillsFuture Credit eligible?
Yes, the course is SkillsFuture Credit eligible for Singaporean citizens. Check with the training provider for specific details
How can I enroll in the course?
What topics are covered in the course?
ADDITIONAL SUPPORT
For Company
* Eligible companies can reimburse up to 90% of the payable amount via SFEC
For Self-sponsor
* Singaporean can offset the payable amount via SkillsFuture Credit (Except Mid Career Credit) and/or PSEA
* NTUC Union members can reimburse of up to 50% of the unfunded fee under UTAP Enjoy up to $250 UTAP support. More info: UTAP
Note: minimum 75% attendance & passing all the assessment are required for WSQ subsidy deduction.
Master Data Skills with WSQ Microsoft Excel Intermediate & Advanced Certification Course
Master Data Analysis & Productivity with WSQ Microsoft Excel Intermediate & Advanced Course Today
© 2026 All Rights Reserved.
