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.

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 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; use sorting and filtering tools; and visualise data through various chart types. Learners will also explore key features for page setup, printing, and basic data importation from external sources. The course is designed for adult learners with minimal or no prior experience in Excel, 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
  • Copying and Moving Cells 
  • Controlling How Cells Are Pasted 
  • Checking Spelling 
  • Insert Cells, Rows, and Columns 
  • Delete Cells, Rows, and Columns 
  • Using Undo and Redo  
  • Finding and Replacing Content 
  • Notes 
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

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. 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.

Related Courses

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

WSQ Microsoft Excel Advanced Course

This 2-day course covers complex statistical formulas, data analysis, PivotTables, external data querying, and task automation with macros to ensure proficiency in effective data management and analysis.

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

CourseDurationMonthsAvailable Date(s)VenueRemarks
Microsoft Excel Essentials
TGS-2023041089
2 Days
(9:00am – 6:00pm)
July 202510-11JTC SummitWeekdays
17-18Mountbatten SquareWeekdays
August 202504-05Mountbatten SquareWeekdays
18-19International PlazaWeekdays
27 Jul & 03 AugInternational PlazaWeekends
September 202504-05International PlazaWeekends
06-07Mountbatten SquareWeekends
11-12Mountbatten SquareWeekdays
October 202504-05International PlazaWeekends
06-07Mountbatten SquareWeekdays
21-22International PlazaWeekdays
November 202501 & 08Mountbatten SquareWeekends
06-07JTC SummitWeekdays
13-14Mountbatten SquareWeekdays
December 202508-09Mountbatten SquareWeekdays
18-19International PlazaWeekdays
20-21International PlazaWeekends