WSQ Microsoft Excel Essentials Course

Master spreadsheets fast with our SkillsFuture-funded Excel course—gain data analysis, formulas, charts, and business statistics expertise, WSQ-certified for Singapore professionals today.

Download Course Brochure

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

Nett Course Fee
$175.50 after 70% SkillsFuture Subsidy

Overview of Our SkillsFuture-Funded Microsoft Excel Course

This WSQ Microsoft Excel course equips learners with essential Microsoft Excel 365 skills to organise, analyse, and present data efficiently for business or personal productivity. Aligned to the Skills Framework under the Technology Road Map (Data and Statistical Analytics), the course introduces participants to Excel’s core functions including data entry, cell formatting, formulas, and chart creation.

Participants will learn how to create, format, and manage workbooks and worksheets; apply statistical functions including descriptive statistics; use data sorting and filtering tools; and visualise data through various chart types. Learners will also explore key features for page setup and printing, such as print preview, how to set print area, and basic data importation from external sources. The course covers hands-on practical exercises with essential worksheet tools— Find & Replace, Spell Check, Text Formatting, and the Format Painter for copying formats—to streamline everyday tasks. Finally, we cover Conditional Formatting which automatically highlights key insights across your datasets.

The course is designed for adult learners with minimal or no prior experience in Excel or Excel formula training, helping them gain confidence in executing spreadsheet-based tasks.

Through guided exercises, demonstrations, and practical assessments, learners will apply their knowledge to real-world contexts, enabling them to produce clean, functional, and insightful Excel workbooks. By the end of the course, participants will be able to use Excel 365 effectively for data tracking, reporting, and presentation purposes.

Prerequisites

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

WPLN Level 4
Minimum of GCE ‘O’ or equivalent; OR
NITEC/Higher NITEC

Course Objectives

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

Identify the various types of business statistics, including descriptive statistics in Excel workbooks
Create and edit imported data from external sources in Excel
Create formulas and functions to calculate business statistics
Edit worksheet data and cells
Format cells and worksheets in Excel, and utilise conditional formatting to emphasise key data
Manage multiple worksheets and windows
Prepare and format worksheets for printing
Sort and filter data range
Create charts using existing data

Certification

Upon successful completion of the WSQ Microsoft Excel Essentials 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

Introduction to Business Statistics & Application Fundamentals

Types of Business Statistics
Descriptive Statistics
Excel Interface
Giving Commands
Using Command Shortcuts
Creating a New Workbook
Opening a Workbook
Saving a Workbook
Closing a Workbook
Using Help
Exiting Excel

Getting Started with Worksheets

Navigating a Worksheet
Entering Labels and Values
Editing Cell Contents
Selecting Cells and Ranges
Entering Data in a Selected Range
Entering Content Automatically
Importing Data from a Text File and an Access Database
Importing Data from the Web

Introduction to Formulas & Functions

Overview of Formulas and Cell References
Entering Formulas
Absolute and Relative References
Formulas with Multiple Operators
Using Essential Statistical Functions
Referencing External Data

Editing a Worksheet

Formatting a Worksheet

Formatting Text
Formatting Values
Adjusting Column Width and Row Height
Working with Cell Alignment
Adding Cell Borders and Background Colours
Copying Formatting
Applying and Removing Cell Styles
Using Document Themes
Applying Conditional Formatting

Managing Workbooks

Using Workbook Views
Selecting and Switching Between Worksheets
Inserting, Renaming and Deleting Worksheets
Moving and Copying Worksheets
Changing Worksheet Tab Colour
Splitting and Freezing a Window
Working with Multiple Workbook Windows
Hiding and Unhiding Rows, Columns and Worksheets

Managing Page Setup & Printing

Previewing and Printing a Worksheet
Setting the Print Area
Adjusting Page Margins and Orientation
Adjusting Paper Size and Print Scale
Adding Print Titles, Gridlines and Headings
Creating Headers and Footers
Printing a Selection, Multiple Worksheets and Workbooks

Working with Data Ranges

Sorting by One Column
Sorting by Multiple Columns
Filtering Data

Introduction to Charts

Choosing and Selecting the Source Data
Choosing the Right Chart
Inserting, Moving, Resizing and Deleting Charts
Changing Chart Layout and Styles
Changing Chart Type
Working with Chart Labels

Assessment

Written Examination: 20 minutes
Practical Assessment: 40 minutes

Fees and Subsidies

*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. Head to our UTAP Funding page for more information.

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.

This 2-day SkillsFuture Microsoft course equips learners with intermediate Excel skills to manage complex data, apply statistical functions, create dynamic charts and tables, streamline workflows, create professional reports, and support process improvement decisions using Excel. This course is ideal for learners who have completed out Excel Essentials course.

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

View course details here

WSQ Microsoft Excel Advanced Course

This 2-day WSQ Microsoft Excel Advanced course, meant for more experienced Excel users, covers regression analysis, scenario analysis, forecasting, trend analysis, PivotTables, external data handling, and macro recording to support complex data reporting and business decision-making. Less experienced learners can check out our WSQ Microsoft Essentials and Intermediate courses before considering this course.

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

View course details here

WSQ Microsoft Excel Essentials

Course Duration:



2 Days (9.00am – 6.00pm)

Course Fee Details:



$175.50 (incl. of 9% GST) after 70% SkillsFuture Subsidy



SkillsFuture Credits, PSEA & UTAP claimable

Course Code: TGS-2023041089

Course Schedule

Course	Duration	Months	Available Date(s)	Venue	Remarks
Microsoft Excel Essentials TGS-2023041089	2 Days (9:00am – 6:00pm)	August 2025	04-05	Mountbatten Square	Weekdays
			18-19	International Plaza	Weekdays
			27 Jul & 03 Aug	International Plaza	Weekends
		September 2025	04-05	JTC Summit	Weekdays
			06-07	Mountbatten Square	Weekends
			11-12	Mountbatten Square	Weekdays
		October 2025	04-05	International Plaza	Weekends
			06-07	Mountbatten Square	Weekdays
			21-22	International Plaza	Weekdays
		November 2025	01 & 08	Mountbatten Square	Weekends
			06-07	JTC Summit	Weekdays
			13-14	Mountbatten Square	Weekdays
		December 2025	08-09	Mountbatten Square	Weekdays
			18-19	International Plaza	Weekdays
			20-21	International Plaza	Weekends

FAQs

Have a few questions on your mind? See below for some frequently asked questions. Should you have further questions, please feel free to contact us.

What are the 5 most used basic Excel functions?

SUM, AVERAGE, COUNT/COUNTA, MIN and MAX. They let you total, average, tally entries and find extremes. Because they work on any size range, they’re the backbone for budgets, KPI trackers, quick outlier checks and sanity tests before moving on to more advanced analytics.

Is Excel difficult to learn?

. The ribbon layout, cell grid and basic formulas are intuitive—most learners produce functional sheets in a single afternoon of guided practice. Difficulty only rises when you add nested logic, external data and automation, so start small and build in layers.

Can I learn Excel in 7 days?

Yes—if you devote 1–2 focused hours daily. Day 1-2: navigation, formatting, relative vs. absolute references. Day 3-4: SUM/IF/LOOKUP functions. Day 5: basic charts. Day 6: tables and filtering. Day 7: mini-project tying it together. True mastery, however, needs sustained use.