WSQ Microsoft Intermediate & Advanced Excel Course in Singapore
Work more efficiently with data using our WSQ Microsoft Excel Intermediate & Advanced Course in Singapore, designed for professionals ready to move beyond basics. This Microsoft Excel advanced training helps you learn how to work with complex formulas, data analysis, and business reporting tasks more effectively.
WSQ
Singapore Workforce Skills Qualifications
SkillsFuture Eligible
PSEA
Post Secondary Education Account
SFEC
SkillsFuture Enterprise CreditAbsentee
Payroll
Course Start Date
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 2025
- Register Now
Who Should Attend This WSQ Microsoft Excel Intermediate & Advanced
This WSQ intermediate to advanced Excel course is designed for working professionals and learners who already have basic knowledge and want to improve their skills in handling data, using formulas, and managing more complex spreadsheet tasks.
Business professionals
Analyst
Entrepreneur
Training Professionals
Student
Course Completion Requirements
To successfully complete this WSQ Intermediate & Advanced Excel training, participants must maintain a minimum of 75% attendance. The aim is to ensure consistent participation so learners can build advanced analytical skills and be eligible for the course completion certificate upon completion through this comprehensive Excel course.
Above 16 years old
High School Level English
Basic internet & computer operation skills
WSQ Microsoft Excel - Intermediate & Advanced Course in Singapore
This WSQ Microsoft Intermediate & Advanced Excel Course is built for users who are already comfortable with the basics of Microsoft Excel and want to take their spreadsheet skills to the next level. It helps you work more efficiently with structured data, apply advanced formulas, and handle larger datasets with better accuracy. This course is suitable for:
- Learners will be able to support business reports by turning data into clear and simple insights using basic modeling and visualization techniques.
- 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 will be able to support business reports by turning data into clear and simple insights using basic modeling and visualization techniques.
- Learners will learn to work with data from multiple sources and extract useful information for effective analysis.
- Learners will understand how to choose the right analysis methods based on different types of problems and datasets.
- Learners will be able to clean, organize, and validate data to ensure it is accurate, structured, and easy to understand.
- Learners will explore techniques to identify patterns and trends in data, including basic forecasting methods.
- Learners will gain an understanding of data structure and learn how to present findings in a clear and business-friendly way.
- Learners will recognize the importance of industry-specific knowledge in creating meaningful dashboards and reports.
Why Upgrade to Intermediate & Advanced Excel Skills?
Many professionals hit a ceiling with basic Excel when handling larger datasets, complex reports, or time-sensitive analysis. Tasks like building dynamic dashboards, automating workflows, or creating advanced formulas often feel overwhelming without proper guidance.
This Microsoft Intermediate & Advanced Excel course is designed to bridge that gap. You'll learn how to tackle sophisticated business challenges step by step—from advanced functions and pivot tables to macros and data visualization—empowering you to work faster, smarter, and more strategically.
Training fee: WSQ Microsoft Excel Intermediate & Advanced Course
| 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 (After Funding and GST Included) |
$324.50 (After Funding and GST Included) |
$214.50 (After Funding and GST Included) |
$214.50 (After Funding and GST Included) |
Payable amount after WSQ funding is eligible for further support from SFEC, SkillsFuture, PSEA & UTAP where applicable.
Discount policy:
- 4 pax from a same group: 5% discount for each person
- 5 pax from a same group: 10% discount for each person
Assessment Plan:
- Practical Performance: 1 hour
Unsure if this course is suitable for you? Take this Quick test to help you decide.
Grants available
WSQ
Singapore Workforce Skills Qualifications
WSQ : Baseline funding deduction upto 70% for Singaporeans/ PRs. Further SFEC, Absentee Payroll and WSS applicable.
SkillsFuture Eligible
SkillsFuture Credit : Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees
PSEA
Post-Secondary Education Account
PSEA : are available for Singaporean Citizens to cover the approved fees and charges related to WSQ programs.
SFEC
SkillsFuture Enterprise Credit
SFEC : Eligible companies can offset up to 90% of the payable amount via SFEC
Absentee Payroll
Absentee Payroll Funds : Eligible companies can reimburse $4.50 per hour/pax joining our courses from Absentee Payroll
WSQ Microsoft Excel Intermediate & Advanced Course Outline
Learn how to handle complex data challenges faster and improve strategic decision-making with this WSQ Intermediate & Advanced Excel Course module. You will cover all of this in just 3 days (21 hours) through intensive, practical training.
Module One: Create and Manage Worksheets and Workbooks
Manage Workbooks
- Reference data in another worksheet/workbook
- Reference data by using 3D reference
Manage Workbook Reviews
- 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
Automating Task
- Create and modify simply macros
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
Look up data using Functions
- Look up data by using the VLOOKUP
- Look up data by using the HLOOKUP function
- Look up data by using the MATCH function
- Look up data by using the INDEX function
Troubleshoot Formulas
- Trace precedence and dependence
- Monitor cells and formulas by using the Watch Window
- Validate formulas by using error checking values
- Evaluate formulas
Apply Advanced Logical & Statistical Functions
- Perform logical operations by using AND, OR, and NOT functions
- Perform logical operations by using nested functions
- Perform statistical operations by using SUMIFS, AVERAGEIFS, AND COUNTIFS
functions
Apply Advanced Date and Time Functions
- Reference the date and time by using the NOW and TODAY functions
- Serialize numbers by using date and time functions
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 GETPRIVOTDATA 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 this WSQ Microsoft Excel Intermediate & Advanced Course?
This course is perfect for professionals aiming to improve their Excel skills for efficient data handling, reporting, and analysis.
What if I fail/did not complete the assessment?
Participants deemed non-competent will not receive a Statement of Attainment (SOA) and must pay the full course fee, including SSG’s funding portion.
Is there a prerequisite for this course?
Yes, a basic understanding of Excel or completion of a beginner-level Excel course is required.
How long is the course?
The course runs for 3 days, with both weekday and weekend options available.
Will I receive a certificate after completing the course?
Yes, a WSQ certificate will be awarded upon successful completion and passing of the assessment.
Is this course SkillsFuture Credits eligible ?
Yes, Singaporean citizens can use SkillsFuture Credits. Please check with the training provider for eligibility and details.
How can I enroll in this course?
Please fill up the registration form at Course Registration Form | Inspizone Trainings
What topics are covered in this course?
Topics include advanced Excel functions, formulas, pivot tables, data visualization, conditional formatting, and techniques for data analysis.