WSQ Microsoft Excel Intermediate Course

Boost your data analysis and reporting skills in this Excel intermediate course covering formulas, charts, tables, and workbook management—perfect for professionals ready to go beyond the basics.

Course Description

This WSQ-certified intermediate Excel course builds on foundational skills to develop advanced spreadsheet capabilities for data analysis, formatting, and presentation. Aligned to the Skills Framework under the Technology Road Map (Data and Statistical Analytics), it covers advanced formulas, lookup functions, workbook protection, table formatting, and chart manipulation, with AI enablement throughout. Participants will learn to manage datasets with table, summarise and visualise data, while using AI to generate formula suggestions from natural language prompts and to diagnose and explain formula errors. 

Participants will manage complex data using logical and statistical functions, protect workbooks and worksheets, filter and sort large data sets, and visualise trends through dynamic charts. They will remove duplicates to clean datasets quickly and summarise a table with a PivotTable for accurate reporting. With AI, they will receive protection recommendations for data entry versus reporting use cases, identify data quality issues such as inconsistent text, duplicates and blanks, obtain step-by-step Advanced Filter guidance in natural language, and summarise tables to surface trends, outliers and totals. The course also covers advanced filtering and data validation. 

Designed for learners with basic Excel skills, this course equips participants to streamline workflows, create professional reports, and support process improvement decisions. Using AI, they will also ask for the most suitable chart type for their data and business question, generate charts from natural language, and produce AI-assisted insights.

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 Essentials or equivalent basic Excel skills. 

Course Objectives

At the end of the course, you will be able to:

• Use Excel for statistical analysis by organising cell ranges, managing formula errors, applying conditional logic, and employing lookup functions for data search and matching. 
• Manage large Excel data sets, including multiple worksheets and workbooks, and application of protection measures for the interpretation of the categorised data. 
• Organise data in Excel by sorting, filtering, and separating the contents into multiple sets to effectively interpret the collected data for categorisation of meaningful identified data. 
• Use features in Excel to create tables, including managing data sets and removing duplicate records. 
• Optimise Excel functionalities for process improvement in business statistics by creating and formatting charts, including displaying data through histograms. 

Certification

Upon successful completion of the WSQ Microsoft Excel Intermediate 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 Attendance by @ASK Training.

Course Outline

Fees and Subsidies

Course Fee:
S$490.5 (inclusive of 9% GST)

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