WSQ Microsoft Excel Advanced Course

WSQ Microsoft Excel up to 70% SkillsFuture Singapore Funding Diagram - SkillsFuture Credit, PSEA & UTAP Claimable

Nett Course Fee
$175.50 after 70% SkillsFuture Subsidy

Course Description

This WSQ course equips experienced Excel users with advanced tools and analytical functions to manage complex datasets, perform business statistical analysis, and automate workflows. Aligned with the Skills Framework for Engineering Services (Technology Road Map – Data and Statistical Analytics), this course focuses on high-level spreadsheet techniques including nested formulas, regression analysis, PivotTables, scenario analysis, and macros.

Learners will deepen their understanding of Excel’s powerful functions for data consolidation, trend analysis, and forecasting. Participants will apply advanced logical, lookup, and statistical functions; create sophisticated PivotTables and PivotCharts; import and manage data from external sources; and automate repetitive tasks using macros. Designed for professionals and analysts, this course supports decision-making through efficient data management and visual storytelling.

Through hands-on exercises, participants will gain confidence in streamlining data workflows and presenting findings clearly and accurately using Excel 365.

Prerequisites

To enrol in this course, you should possess the following:

WPLN Level 4
Minimum of GCE ‘O’ or equivalent; OR
NITEC/Higher NITEC.
Completed WSQ Microsoft Excel Intermediate or equivalent skills.

Course Objectives

Upon completion of this course, participants should be able to:

Use a series of business statistical formulas and functions for summarising and analysing categorical or numerical data sets, including utilising nested conditions, lookup, text, date, and time functions.
Harness the skills needed to use Excel’s built-in data analysis tools to analyse data sets and identify trends and patterns.
Distinguish between Excel’s built-in statistical functions and tools to conduct statistical analyses, taking into account the needs and objectives of stakeholders.
Utilise PivotTable to understand and analyse the core data structures that include summarising datasets for the presentation of actionable business insights to stakeholders.
Adopt relevant statistical software techniques to perform data queries across multiple sources to extract pertinent data for stakeholders.
Apply macro recording functionality to aid automation of working with data sets and performing repetitive tasks.

Certification

Upon successful completion of the WSQ Microsoft Excel Advanced assessment, participants who have attended at least 75% of the course will receive a SkillsFuture WSQ Statement of Attainment (SOA) along with a Certificate of Achievement by @ASK Training.

Course Outline

Advanced Formulas and Functions

Using Nested Logical Functions
Using Conditional Summary Functions
Analysing Data Set using Statistical Functions
Performing Advanced Lookups
Using Text Functions
Using Date and Time Functions

Managing and Analysing Data Ranges

Using Flash Fill
Using Data Validation
Generating Descriptive Statistics
Using Histogram Analysis Tool
Performing Regression Analysis

Organising and Summarising Data

Working with Data Tables
Working with Scenarios
Creating a Scenario Summary Report
Using Goal Seek
Grouping and Outlining Data
Using Subtotal
Consolidating Data by Position or Category
Consolidating Data Using Formulas
Sharing Workbooks
Tracking Changes

Working with PivotTables

Creating a PivotTable
Specifying PivotTable Data
Using Multiple PivotTable Fields
Changing a PivotTable’s Calculation
Filtering and Sorting a PivotTable
Working with PivotTable Layout
Grouping PivotTable Items
Updating a Pivot Table
Formatting a PivotTable Creating a PivotChart
Using Slicers
Sharing Slicers Between PivotTables

Working with Web and External Data

Inserting a Hyperlink
Importing Data from a Text File and an Access Database
Importing Data from Web
Working with Existing Data Connections

Working with Macros

Recording a Macro
Playing and Deleting a Macro
Adding a Macro to the Quick Access Toolbar

Assessment

Written Examination: 20 minutes
Practical Assessment: 40 minutes

Fees and Subsidies

Up to 70% SkillsFuture Singapore Funding Diagram - SkillsFuture Credit, PSEA & UTAP Claimable

*Eligible for Singaporean Citizens, Permanent Residents, and Long-Term Visit Pass Plus Holders

Course Fee:
S$450 (exclusive of 9% GST)

Course Fee After Eligible SSG Subsidies:
From S$175.50 (inclusive of 9% GST) after 70% SSG Subsidies

Learners

Singaporean Citizens ≥ 40 years old

S$175.50 (after SSG 70% Funding)

SkillsFuture Credits can be used on top of existing subsidies

Singaporean Citizens, PRs or LTVP+ Holders ≥ 21 years old

S$265.50 (after SSG 50% Funding)

For Singapore Citizens learners aged ≥ 25 years old SkillsFuture Credits can be used on top of existing subsidies.

For Singapore Citizens aged 17-30 Post Secondary Education Account Funds can be used.

Learners	SMEs	Non-SMEs
Singaporean Citizens ≥ 40 years old	S$175.50 (after SSG 70% Funding) SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies	S$175.50 (after SSG 70% Funding) SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies
Singaporean Citizens, PRs or LTVP+ Holders ≥ 21 years old		S$265.50 (after SSG 50% Funding) SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies

All prices are inclusive of 9% GST.

You may use U-tap to defray 50% of the unfunded course fee, capped at $250/year. NTUC members aged 40 and above can enjoy higher funding support up to $500/year for courses attended between 01 April 2022 to 31 March 2023. Sign up https://ntuc.co/ask-edm.

Important Reminder: Your PSEA claim needs to be submitted at least 1 month before the course’s commencement date. Should you miss this deadline, an alternative payment method must be used to secure your spot in the course. After the disbursement of your PSEA funds to us, we will reach out to initiate the refund process.

The WSQ Microsoft Excel Essentials course focuses on using Microsoft Excel, the widely used spreadsheet tool, for tasks related to data analytics, business, and research. It covers foundational concepts in applying business statistics, analytical skills, and quantitative techniques within the Excel environment as well as practical hands-on skills in manipulating data for your needs.

Course Duration:
2 Days (9.00am – 6.00pm)

View course details here

WSQ Microsoft Excel Intermediate Course

This 2-day course will cover advanced Excel features to enhance productivity with data management and reporting, including statistical formulas, data analysis, PivotTables customization, external data querying, and task automation with macros.

Course Duration:
2 Days (9.00am – 5.00pm)

View course details here