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

Being the most widely used spreadsheet tool, Microsoft Excel is an essential application for working with data – whether for data analytics, business, or research. Our Excel essential training course, part of the broader Microsoft courses catalogue is designed to impart you with essential working skills of Excel and how to use it managing data. It also doubles as a Corporate Excel upskilling program and a WSQ-approved Excel class for teams.

Our Excel Essentials Course lays the foundation in applying business statistics, analytical and quantitative skills in Excel. Throughout this course, you’ll gain valuable experience working with data sets and spreadsheets. The programme starts with spreadsheet basics such as navigating worksheets, entering labels & values, and selecting cells & ranges. You then move on to importing data, editing worksheets, using AutoFill, and applying business-statistics fundamentals through formulas, absolute & relative references, and essential statistical functions. The course also covers multi-column sorting, data filtering, worksheet management, rich formatting (borders, styles, conditional formatting), page setup & printing, plus chart creation and layout adjustments.

With strong focus on practice and applied learning in this course, you’ll have the opportunity to manipulate data and gain hands-on experience using Excel. By the end of this excel essential training, you will be equipped with the skills for real-world data analysis with Excel and everyday reporting tasks.

Prerequisites

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

WPLN Level 4
Minimum of GCE ‘O’ or equivalent; OR
NITEC/Higher NITEC; OR
Minimum computer literacy with one year working experience in any industry

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

Navigating a Worksheet
Entering Labels & Values
Editing Cell Contents
Selecting Cells & Ranges
Entering Content Automatically using AutoFill
Importing Data

Editing a Worksheet

Managing Worksheets

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

Working with Data Ranges

Sorting by One Column
Sorting by Multiple Columns
Filtering Data

Introduction to Formulas & Functions

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

Formatting a Worksheet

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

Managing Page Setup & Printing

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

Introduction to Charts

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

Assessment

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