WSQ Microsoft Excel Intermediate & Advanced Course in Singapore
Boost your Microsoft Excel expertise in Singapore with our WSQ Intermediate & Advanced Course. Learn advanced tools, improve your spreadsheet efficiency, and sharpen your data analysis skills for real-world impact.
WSQ
Singapore Workforce Skills Qualifications
SkillsFuture Eligible
PSEA
Post Secondary Education Account
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
The WSQ Microsoft Excel Intermediate & Advanced course is ideal for those looking to strengthen their Excel foundation and advance their skills in handling complex spreadsheet tasks.
Business professionals
Analyst
Entrepreneur
Training Professionals
Student
Course Completion Requirements
Minimum 75% attendance is required in order to complete the course and receive the course completion certificate
Above 16 years old
High School Level English
Basic internet & computer operation skills
WSQ Microsoft Excel - Intermediate & Advanced Course in Singapore
- 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 will be able to assist in generating business insight reports using data modeling and visualization, while adhering to data protection regulations.
- Learners can perform complex queries across multiple databases to extract key insights using data science techniques.
- Learners will identify appropriate statistical methods and machine learning techniques to analyze various datasets meaningfully.
- Learners will assist in transforming, cleaning, and validating data to ensure accuracy and present it in user-friendly formats.
- Learners can apply data mining, time series forecasting, and modeling methods to uncover and predict business trends using functional programming languages.
- Learners will understand data structures relevant to data science and summarize findings for business insight presentations.
- Learners can recognize the importance of domain-specific knowledge in creating targeted dashboards and reports for business performance and insights.
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.
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 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.