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 the same group: 5% discount for each person
- 5 pax from the 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.
UTAP
Union Training Assistance Programme
NTUC members can claim up to 50% of the unfunded course fees.
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
NTUC Members' Benefit
Complete this eligible AI course and you may qualify for subscription fee support for selected AI tools under the NTUC AI Tools initiative (available from 1 May 2026 to 30 April 2028), subject to NTUC's eligibility criteria and approval.
Contact us to learn more about eligible courses and how to apply.
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 Excel Training Intermediate And Advanced
This advanced Excel course equips learners with the skills to manage complex workbooks, automate repetitive tasks, perform sophisticated data analysis, and create insightful business reports. Participants will also learn how to leverage Microsoft Copilot in Excel to enhance productivity, improve formula creation, analyse data more efficiently, and troubleshoot spreadsheets using AI assisted techniques. Through hands-on exercises and practical business scenarios, learners will gain confidence in applying advanced Excel functions, PivotTables, data modelling techniques, automation tools, and business intelligence features to support workplace decision-making.
Target Participants
This course is suitable for:
- Working professionals who regularly use Excel for reporting and analysis
- Administrative and operations personnel
- Finance, accounting, and business support staff
- Data analysts and business analysts
- Supervisors and managers who work with large datasets
- Existing Excel users seeking to leverage Microsoft Copilot to improve productivity
Prerequisites
Participants should have:
- Intermediate proficiency in Microsoft Excel
- Ability to create and format worksheets
- Familiarity with basic formulas and functions (e.g. SUM, AVERAGE, IF)
- Experience working with tables and simple charts
- Basic understanding of data management concepts
- Access to Microsoft Excel with Microsoft Copilot enabled (recommended for hands-on practice)
Learning Outcomes
By the end of this course, participants will be able to:
- Manage workbook settings, data models, and workbook security
- Create and manage advanced formulas and functions
- Use lookup and reference functions effectively
- Apply advanced conditional formatting techniques
- Automate repetitive tasks using macros
- Import, consolidate, and analyse data from multiple sources
- Perform what-if analysis and forecasting
- Create advanced charts and visualisations
- Build and manage PivotTables and PivotCharts
- Generate business insights from complex datasets for decision-making
- Use Microsoft Copilot to analyse, troubleshoot, automate, and improve Excel workflows
Expected Outcome
Upon completion of this course, participants will be able to confidently manage complex Excel workbooks, perform advanced calculations and analysis, automate repetitive tasks, build professional reports and dashboards, and utilise Microsoft Copilot effectively to enhance productivity, accur acy,and decision-making in the workplace.
WSQ Microsoft Excel Intermediate & Advanced Course Outline
Module 1: Managing Workbook Options and Settings
Data Models and Data Validation
- Introduction to Data Models
- Data Modelling & Validation Techniques
- Using Copilot to Create and Apply Data Validation Rules
Business Visualisations
- Importance of Data Visualisation
- Types of Business Visualisations
- Excel Visualisation Tools
Workbook Management
- Referencing Data Across Worksheets & Workbooks
- Working with 3D References
- Using Copilot to Explain and Generate References
Workbook Security and Protection
- Formula Calculation Options
- Restricting Editing Access
- Worksheet & Workbook Structure Protection
- Password Protection and Encryption
- Using Copilot to Configure Workbook Security
Module 2: Managing Databases and Automating Tasks
Database Management
- Using Subtotal Functions
- Advanced Filtering Techniques
- Database Functions for Summary Calculations
- Using Copilot to Generate Database Analysis
Advanced Conditional Formatting
- Creating Custom Conditional Formatting Rules
- Formula-Based Conditional Formatting
- Managing Multiple Rules
- Using Copilot to Create and Optimise Formatting Rules
Task Automation
- Introduction to Macros
- Recording Simple Macros
- Editing and Modifying Macros
- Understanding Copilot's Role in Automation
- Generating VBA Macros with Copilot
Module 3: Creating Advanced Formulas
Advanced Conditional Formatting
- Using Subtotal Functions
- Advanced Filtering Techniques
- Database Functions for Summary Calculations
- Using Copilot to Generate Database Analysis
Advanced Logical Functions
- Using AND, OR, and NOT Functions
- Nested Logical Functions
- Complex Decision-Making Formulas
- Using Copilot to Build Logical Formulas
Statistical Functions
- SUMIFS
- AVERAGEIFS
- COUNTIFS
- Multi-Criteria Analysis with Copilot
Lookup and Reference Functions
- VLOOKUP
- HLOOKUP
- XLOOKUP
- MATCH
- INDEX
- Cross-Sheet and Cross-Workbook Lookups
- Using Copilot to Build Lookup Formulas
Advanced Date and Time Functions
- TODAY and NOW Functions
- Date Calculations and Serial Numbers
- Business Date Analysis
- Using Copilot to Apply Date-Based Logic
Formula Auditing and Troubleshooting
- Trace Precedents and Dependents
- Watch Window
- Error Checking
- Formula Evaluation
- Using Copilot to Diagnose and Resolve Formula Errors
Module 4: Data Analysis and Business Intelligence
Managing External Data
- Importing Data from External Sources
- Consolidating Data
- Data Preparation Techniques
- Using Copilot to Summarise Imported Data
What-If Analysis and Forecasting
- One-Variable Data Tables
- Two-Variable Data Tables
- Scenario Manager
- Goal Seek
- Forecasting Techniques
- Using Copilot for Scenario Analysis
Module 5: Data Mining and Pattern Identification
Data Analysis Techniques
- Introduction to Data Analysis in Excel
- Data Preparation and Cleansing
- Exploratory Data Analysis
- Excel Data Analysis ToolPak
- Descriptive Statistics
- Histogram Analysis
- Using Copilot for Statistical Analysis
Advanced Charting
- Sparklines
- Trendlines
- Dual-Axis Charts
- Chart Templates
- Business Data Visualisation Best Practices
- Using Copilot to Create Advanced Charts
Module 6: PivotTables
Creating PivotTables
- Building PivotTables
- Managing Fields and Layouts
- Summary Calculations
- Built-in Value Calculations
- Formatting PivotTables
- Slicers and Timelines
- Refreshing and Updating PivotTables
- Using Copilot to Build and Modify PivotTables
Managing PivotTables
- GETPIVOTDATA Function
- Calculated Fields
- Report Filter Pages
- Drill-Down Analysis
- Using Copilot to Analyse PivotTable Data
Module 7: PivotCharts
Creating PivotCharts
- Creating Interactive PivotCharts
- Linking PivotCharts to PivotTables
Managing PivotCharts
- Modifying Chart Options
- Applying Styles and Formatting
- Creating Interactive Dashboards
- Enhancing Data Presentation
Advanced Microsoft Copilot Applications
AI-Assisted Workbook Analysis
- Understanding Workbook Structure
- Explaining Complex Formulas
- Workbook Auditing
Data Quality and Validation
- Identifying Data Issues
- Data Cleansing Techniques
- AI-Assisted Error Detection
Data Transformation and Preparation
- Cleaning and Restructuring Data
- Preparing Data for Analysis
- Automating Repetitive Spreadsheet Tasks
Productivity Enhancement with Copilot
- Prompting Techniques for Excel
- Best Practices for Working with AI
- Responsible Use of Copilot in Business Environments
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.
