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.
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 Attendance 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
- Use Copilot to explain business statistics concepts (e.g. “Explain descriptive statistics in simple business terms”)
- Natural‑language command prompting (e.g. “Create a new workbook for monthly sales tracking”)
- Ask Copilot for Excel interface walkthroughs and shortcut explanations
- AI‑assisted Help & troubleshooting (e.g. “Why is my file not saving correctly?”)
- Excel Copilot Chat
- Contextual Help with AI explanations
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
- Generate sample business datasets using plain language (e.g. “Create a customer order list with 50 rows”)
- Copilot‑guided data entry and cleanup
- AI‑assisted data import explanations from text, databases, or web sources
- Generate sample business datasets using plain language (e.g. "Create a customer order list with 50 rows")
- Copilot-guided data entry and cleanup
- AI-assisted data import explanations from text, databases, or web sources
- Copilot for data generation
- Copilot prompts for data setup and navigation
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
- Convert natural language into formulas (e.g. "Calculate average sales by region")
- AI-generated suggestions for statistical functions
- Copilot formula generation
- Formula explanation in plain English
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
- Ask Copilot how to clean, reorganise, or restructure data
- AI guidance for Paste Special, find & replace scenarios
- Natural-language corrections (e.g. "Remove duplicates and fix spelling errors")
- Copilot data-cleaning guidance
- AI-assisted troubleshooting
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
- Apply professional formatting via prompts (e.g. "Format this as a finance report")
- AI recommendations for conditional formatting rules
- Copilot formatting suggestions
- Conditional formatting via AI prompts
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
- Ask Copilot to recommend best workbook views for analysis or presentation
- AI explanation of freeze panes, split windows, and multi-window usage
- Copilot organisational guidance
- Context-aware workbook explanations
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
- Natural-language page setup (e.g. "Fit this report onto one A4 page")
- AI suggestions for print-friendly layouts
- Troubleshoot common printing issues using Copilot
- Copilot print and layout instructions
- AI-driven formatting recommendations
Working with Data Ranges
- Sorting by One Column
- Sorting by Multiple Columns
- Filtering Data
- Ask Copilot how best to sort or filter data for business questions
- Explain multi-level sorting logic
- AI-assisted creation of filtered views for different stakeholders
- Copilot data analysis prompts
- AI-assisted filtering explanations
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
- Generate charts using plain-English requests (e.g. "Create a chart to show sales trends by month")
- Copilot recommends appropriate chart types
- Auto-explain charts and generate insights
- Copilot chart generation
- AI insight summaries from visual data
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$490.5 (inclusive of 9% GST)
Course Fee After Eligible SWDA Subsidies:
From S$175.50 (inclusive of 9% GST) after 70% SWDA Subsidies
Singaporean Citizens ≥ 40 years old
After SWDA 70% Funding
SkillsFuture Credits can be used on top of existing subsidies
After SWDA 70% Funding
SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies
After SWDA 70% Funding
SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies
Singaporean Citizens, PRs or LTVP+ Holders ≥ 21 years old
After SWDA 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.
After SWDA 70% Funding
SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies
After SWDA 50% Funding
SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies
| Learners | |
| Singaporean Citizens ≥ 40 years old | S$175.50 (after SWDA 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 SWDA 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 SWDA 70% Funding) SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies |
S$175.50 (after SWDA 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 SWDA 50% Funding) SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies |
WSQ Microsoft Excel Essentials
Course Code: TGS-2023041089
Course Schedule
Course Name: WSQ Microsoft Excel Essentials
Course Code: TGS-2023041089
Course Duration: 2 Days (9:00am - 6:00pm)
| Course Name | Duration | Month | Date | Venue | Remarks |
|---|---|---|---|---|---|
| WSQ Microsoft Excel Essentials TGS-2023041089 | 2 days (9:00am - 6:00pm) | October 2026 | 15,16 | International Plaza | Weekdays |
| 22,23 | JTC Summit | Weekdays | |||
| 26,27 | International Plaza | Weekdays | |||
| November 2026 | 02,03 | International Plaza | Weekdays | ||
| 05,06 | JTC Summit | Weekdays | |||
| 14,15 | International Plaza | Weekends | |||
| 16,17 | JTC Summit | Weekdays | |||
| 19,20 | International Plaza | Weekdays | |||
| 26,27 | International Plaza | Weekdays | |||
| 28,29 | International Plaza | Weekends | |||
| December 2026 | 03,04 | International Plaza | Weekdays | ||
| 05,06 | International Plaza | Weekends | |||
| 10,11 | JTC Summit | Weekdays | |||
| 21,22 | International Plaza | Weekdays | |||
| January 2027 | 02,03 | International Plaza | Weekends | ||
| 04,05 | International Plaza | Weekdays | |||
| 11,12 | JTC Summit | Weekdays | |||
| 21,22 | International Plaza | Weekdays | |||
| February 2027 | 01,02 | JTC Summit | Weekdays | ||
| 04,05 | International Plaza | Weekdays | |||
| 13,14 | International Plaza | Weekends | |||
| 15,16 | International Plaza | Weekdays | |||
| March 2027 | 01,02 | International Plaza | Weekdays | ||
| 06,07 | International Plaza | Weekends | |||
| 11,12 | JTC Summit | Weekdays | |||
| 22,23 | International Plaza | Weekdays |
Related Courses
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.