WSQ Microsoft Excel Intermediate & Advanced Course in Singapore

WSQ

Singapore Workforce Skills Qualifications

SkillsFuture Eligible

PSEA

Post Secondary Education Account

UTAP

Union Training Assistance Programme

SFEC

SkillsFuture Enterprise Credit

Absentee
Payroll

Master advanced Microsoft Excel skills in Singapore with our WSQ Intermediate & Advanced course. Elevate your spreadsheet proficiency, unlock powerful features, and enhance your data analysis capabilities.

FAQ

Course Start Date

15/08/2026 | 09:30 to 17:30

Weekend

Book now

19/08/2026 | 09:30 to 17:30

Week Days

Book now

30/08/2026 | 09:30 to 17:30

Weekend

Book now

16/09/2026 | 09:30 to 17:30

Week Days

Book now

28/09/2026 | 09:30 to 17:30

Week Days

Book now

03/10/2026 | 09:30 to 17:30

Weekend

Book now

14/10/2026 | 09:30 to 17:30

Week Days

Book now

18/10/2026 | 09:30 to 17:30

Weekend

Book now

04/11/2026 | 09:30 to 17:30

Week Days

Book now

21/11/2026 | 09:30 to 17:30

Weekend

Book now

02/12/2026 | 09:30 to 17:30

Week Days

Book now

Schedule

Days: 3 Days

Duration: 21 Hours

Timings: 9:30 AM - 5:30 PM

10 Anson Road, 26-08A International Plaza, Singapore 079903

Register Now

Why Choose Us

Expert Local Trainers
Hands-on Training by experts
Certificate of Achievement

Course Details

TGS-2023040845

Mode of Training - Physical, in-class training

Course Subsidy Validity - From 19 Dec 2023 to 18 Dec 2027

Register Now

Who Should Attend This WSQ Microsoft Excel Intermediate & Advanced

The WSQ Microsoft Excel Intermediate & Advanced is designed for individuals who are new to Microsoft Excel and want to establish a solid foundation in using this spreadsheet software.

Analyst

Business professionals

Entrepreneur

Training Professionals

Student

Course Completion Requirements:

Minimum 75% attendance is required in order to complete the course and receive the course completion certificate

Entry Requirements

Above 16 years old

High School Level English

Basic internet & computer operation skills

WSQ Microsoft Excel Intermediate & Advanced in Singapore Course Overview

This advanced Excel course equips learners with the skills to manage complex workbooks, automate repetitive tasks, perform sophisticated data analysis, and create insightful business reports.
Participants will also learn how to leverage Microsoft Copilot in Excel to enhance productivity, improve formula creation, analyse data more efficiently, and troubleshoot spreadsheets using AI assisted techniques.
Through hands-on exercises and practical business scenarios, learners will gain confidence in applying advanced Excel functions, PivotTables, data modelling techniques, automation tools, and business intelligence features to support workplace decision-making.

python programming certification singapore

Target Participants

This course is suitable for:

Working professionals who regularly use Excel for reporting and analysis
Administrative and operations personnel
Finance, accounting, and business support staff
Data analysts and business analysts
Supervisors and managers who work with large datasets
Existing Excel users seeking to leverage Microsoft Copilot to improve productivity

Prerequisites

Participants should have:

Intermediate proficiency in Microsoft Excel
Ability to create and format worksheets
Familiarity with basic formulas and functions (e.g. SUM, AVERAGE, IF)
Experience working with tables and simple charts
Basic understanding of data management concepts
Access to Microsoft Excel with Microsoft Copilot enabled (recommended for hands-on practice)

Learning Outcomes

By the end of this course, participants will be able to:

Manage workbook settings, data models, and workbook security
Create and manage advanced formulas and functions
Use lookup and reference functions effectively
Apply advanced conditional formatting techniques
Automate repetitive tasks using macros
Import, consolidate, and analyse data from multiple sources
Perform what-if analysis and forecasting
Create advanced charts and visualisations
Build and manage PivotTables and PivotCharts
Generate business insights from complex datasets for decision-making
Use Microsoft Copilot to analyse, troubleshoot, automate, and improve Excel workflows

Expected Outcome

Upon completion of this course, participants will be able to confidently manage complex Excel workbooks, perform advanced calculations and analysis, automate repetitive tasks, build professional reports and dashboards, and utilise Microsoft Copilot effectively to enhance productivity, accuracy, and decision-making in the workplace.

Training fee:

*Course fee before WSQ funding: $550.00/pax + 9% GST

Funding: (GST included)

*The funding amount mentioned is indicative and will be confirmed upon registration.

WSQ Microsoft Excel – Intermediate & Advanced Level TGS: TGS-2023040845 Valid Till: 19-12-2023 to 18-12-2027		Self-sponsor/ Non-SME Company Sponsor		SME Company Sponsor
	Full Course Fee (no funding)	Age 21-39 S/PRs (SkillsFuture Funding Baseline)	Age 40 above (SkillsFuture Mid-career Enhanced Subsidy)	SME Company Sponsor (SkillsFuture Enhanced Training support for SMEs)
Full Course Fee (bef funding)	$550.00	$550.00	$550.00	$550.00
SkillsFuture Funding (WSQ)	- $0.00	- $275.00	- $385.00	- $385.00
GST (On Full Fee)	+ $49.50	+ $49.50	+ $49.50	+ $49.50
Total Payable (After Funding and GST Included)	$599.50	$324.50	$214.50	$214.50

Kindly note that you are required to achieve a minimum of 75% attendance and be certified competent in all the assessment components. Should you fail to meet the attendance/assessment requirements and/or terms and conditions of SSG's funding, you will not be eligible for the course fee funding and will have to bear the full course fees.

*) SFEC, Absentee payroll and WSS funding also applicable for WSQ courses. For further details please refer to WSQ Funding by Skilllsfuture SG – Inspizone Trainings

Discount policy:

4 pax from a same group: 5% discount for each person
5 pax from a same group: 10% discount for each person

Assessment Plan:

Practical Performance: 1 hour

An entrance test is required before the course, kindly help us process via Entrance Quiz (Est time to complete: 10 min).

Grants available

WSQ

Singapore Workforce Skills Qualifications

WSQ Fund: Baseline funding deduction upto 70% for Singaporeans/ PRs. Further SFEC, Absentee Payroll and WSS applicable.

SkillsFuture Eligible

SkillsFuture Credit: Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees

PSEA

Post-Secondary Education Account

PSEA Funds: are available for Singaporean Citizens to cover the approved fees and charges related to WSQ programs.

SFEC

SkillsFuture Enterprise Credit

SFEC Funds: Eligible companies can offset up to 90% of the payable amount via SFEC

Absentee Payroll

Absentee Payroll Funds: Eligible companies can reimburse $4.50 per hour/pax joining our courses from Absentee Payroll

UTAP

UTAP : NTUC members can claim up to 50% of the unfunded course fees.

NTUC Members' Benefit

Complete this eligible AI course and you may qualify for subscription fee support for selected AI tools under the NTUC AI Tools initiative (available from 1 May 2026 to 30 April 2028), subject to NTUC's eligibility criteria and approval.

Contact us to learn more about eligible courses and how to apply.

WSQ MICROSOFT EXCEL INTERMEDIATE & ADVANCED COURSE OUTLINE

Module 1: Managing Workbook Options and Settings

Data Models and Data Validation

Introduction to Data Models
Data Modelling & Validation Techniques
Using Copilot to Create and Apply Data Validation Rules

Business Visualisations

Importance of Data Visualisation
Types of Business Visualisations
Excel Visualisation Tools

Workbook Management

Referencing Data Across Worksheets & Workbooks
Working with 3D References
Using Copilot to Explain and Generate References

Workbook Security and Protection

Formula Calculation Options
Restricting Editing Access
Worksheet & Workbook Structure Protection
Password Protection and Encryption
Using Copilot to Configure Workbook Security

Module 2: Managing Databases and Automating Tasks

Database Management

Using Subtotal Functions
Advanced Filtering Techniques
Database Functions for Summary Calculations
Using Copilot to Generate Database Analysis

Advanced Conditional Formatting

Creating Custom Conditional Formatting Rules
Formula-Based Conditional Formatting
Managing Multiple Rules
Using Copilot to Create and Optimise Formatting Rules

Task Automation

Introduction to Macros
Recording Simple Macros
Editing and Modifying Macros
Understanding Copilot's Role in Automation
Generating VBA Macros with Copilot

Module 3: Creating Advanced Formulas

Named Ranges and Objects

Creating Named Ranges
Naming Tables and Objects
Managing Named References
Using Copilot to Generate and Explain Named Ranges

Advanced Logical Functions

Using AND, OR, and NOT Functions
Nested Logical Functions
Complex Decision-Making Formulas
Using Copilot to Build Logical Formulas

Statistical Functions

SUMIFS
AVERAGEIFS
COUNTIFS
Multi-Criteria Analysis with Copilot

Lookup and Reference Functions

VLOOKUP
HLOOKUP
XLOOKUP
MATCH
INDEX
Cross-Sheet and Cross-Workbook Lookups
Using Copilot to Build Lookup Formulas

Advanced Date and Time Functions

TODAY and NOW Functions
Date Calculations and Serial Numbers
Business Date Analysis
Using Copilot to Apply Date-Based Logic

Formula Auditing and Troubleshooting

Trace Precedents and Dependents
Watch Window
Error Checking
Formula Evaluation
Using Copilot to Diagnose and Resolve Formula Errors

Module 4: Data Analysis and Business Intelligence

Managing External Data

Importing Data from External Sources
Consolidating Data
Data Preparation Techniques
Using Copilot to Summarise Imported Data

What-If Analysis and Forecasting

One-Variable Data Tables
Two-Variable Data Tables
Scenario Manager
Goal Seek
Forecasting Techniques
Using Copilot for Scenario Analysis

Module 5: Data Mining and Pattern Identification

Data Analysis Techniques

Introduction to Data Analysis in Excel
Data Preparation and Cleansing
Exploratory Data Analysis
Excel Data Analysis ToolPak
Descriptive Statistics
Histogram Analysis
Using Copilot for Statistical Analysis

Advanced Charting

Sparklines
Trendlines
Dual-Axis Charts
Chart Templates
Business Data Visualisation Best Practices
Using Copilot to Create Advanced Charts

Module 6: PivotTables

Creating PivotTables

Building PivotTables
Managing Fields and Layouts
Summary Calculations
Built-in Value Calculations
Formatting PivotTables
Slicers and Timelines
Refreshing and Updating PivotTables
Using Copilot to Build and Modify PivotTables

Managing PivotTables

GETPIVOTDATA Function
Calculated Fields
Report Filter Pages
Drill-Down Analysis
Using Copilot to Analyse PivotTable Data

Module 7: PivotCharts

Creating PivotCharts

Creating Interactive PivotCharts
Linking PivotCharts to PivotTables

Managing PivotCharts

Modifying Chart Options
Applying Styles and Formatting
Creating Interactive Dashboards
Enhancing Data Presentation

Advanced Microsoft Copilot Applications

AI-Assisted Workbook Analysis

Understanding Workbook Structure
Explaining Complex Formulas
Workbook Auditing

Data Transformation and Preparation

Cleaning and Restructuring Data
Preparing Data for Analysis
Automating Repetitive Spreadsheet Tasks

Data Quality and Validation

Identifying Data Issues
Data Cleansing Techniques
AI-Assisted Error Detection

Productivity Enhancement with Copilot

Prompting Techniques for Excel
Best Practices for Working with AI
Responsible Use of Copilot in Business Environments

Reviews of our students

Sarah Lah

4 months ago

Great excel course by Bee Hoon for 3 Days. Trainer was humorous and contextualised the info learnt in real life examples. Exercise files were easy to follow also.

Arun Dixit

11 months ago

I attended the excel course, our trainer Valene was really patient and well versed. The training environment was really good, I will definitely go again. Will recommend to my friends and family for sure.

Cara Chan

4 days ago

Attended WORDPRESS WEBSITE CREATION COURSE on 25 Sep 2023. Really appreciate the training made simple for beginners like myself. The trainer Mr Abhinay gave clear explanations and repeated many times to make sure we understood. Understanding how Wordpress works enabled me to navigate my company website and make updates efficiently. Unfortunately, the plug-in used by my company website was not taught in the course; which is understandable given the many different types of plug-ins available.The staffs were helpful and understanding when I was unable to log-in my singpass for attendance. It was overall an enjoyable experience to me. Snacks and beverages at the pantry was a bonus, too! Thank you, Inspizone!

Joanna

10 months ago

Thank you for the practicable courses. Lessons were conducted at a comfortable pace. Trainer Ms Mridula is knowledgeable, very helpful and encourages class participation to liven up the sessions. She also shared about how the tools can be applied in our work. Both intermediate and advanced excel courses exceeded my expectations. Thank you.

Guido Sudero

11 months ago

The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.

Avira Dixit

a year ago

I attended their 3 days excel training. I must say this is one of the best training places here at Singapore. They provide full training materials, you dont even need to bring your own laptop. Their course content was appropriate and examples used for explanation were relatable. The instructor was very patient and cleared all our doubts. Highly recommend!!

Leanie Lee

a year ago

I have just completed my excel levels 1 & 2. Trainer Bee Hoon is great. Her training was clear, audible & practical. A professional trainer indeed. Initially I was having some difficulties in my enrolment, but both the administrators Emma & Huyen were very helpful, patient, accommodating & efficient in their service, making it a pleasant experience I have had with InspiZone. InspiZone Highly recommended.

Wenyan Yeo (W)

7 months ago

Attended the MS Excel course (Beginner & Intermediate) on 25 & 26 Aug. Ms Koh Bee Hoon was the trainer for the above mentioned course. Ms Koh is very knowledgeable and patient, she makes sure everyone in the class understands the current topic before she moves on to the next. The lesson pace is very manageable too. After attending the course, I have learnt much more functions about MS Excel! Highly recommend this course to anyone who wish to learn more about MS Excel.

Lucia

a year ago

I have attended their MICROSOFT OFFICE EXCEL 2016 – INTERMEDIATE & ADVANCED LEVELS training. The trainer Bee Hoon is knowledgeable, patient and made online training an enjoyable hands-on experience. I would recommend the course for anyone wanting practical training, and I hope that there will be more online classes in the future.

J Quek

2 years ago

I am so glad that I had clicked on the site of Inspizone and decided to give a try on one of their courses, Master Excel Training. And I've got more than what I expected, I have done the course many years back but the trainers were never generous with their tips but Bee Hoon, a big "WOOW" she is very generous with the tips and know-how that I had never known before and she is very patient ...gosh! Fantastic trainer!! The Training Coordinator, Sophia, she was very helpful from the moment I send in my request and questions, she patiently guided me from registration, claiming my skill future till the approval and giving me the class schedule. A big thank you and great service! The school, wow!! I never have seen a school supplying such a well-stocked and premium snacks for students/trainees, the class welfare is really great and taken care of!! Thank you! I will definitely recommend Inspizone and I will keep a lookout for other courses that they have.

Katherine Ang

a year ago

I have researched on a few training centres before deciding on Inspizone. Very happy that I have chosen the right one! I have attended Microsoft Excel Intermediate & Advanced Class by Bee Hoon. She is super good, knowledgeable and clear with the online class. If you have any doubts she will also guide you patiently and ensure that you know how the functions work. If you are a beginner or you want to brush up your excel skills Bee Hoon will be my number one recommendation! 🙂 My training coordinator Emma has been very helpful towards my question too. Will definitely sign up for more courses with Inspizone!

Patricia Tong

5 years ago

Attended MS Excel 2013 Intermediate and Advanced levels. IT Trainer Ms Asha was patient and knowledgeable. Her lessons were conducted systematically. Additionally, their Project Coordinator Ms Huyen took efforts to text reminder a day before; kept the place neat and clean; and making sure refreshments were ready and adequate.

alex koh ming

3 years ago

BEST EXCEL TRAINING

Jacqueline Lee

2021-09-22

Went for a accounting course, Steven was friendly and helpful

Guido Sudero

2021-09-01

The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.

THIRUMALA DEVI

2021-09-15

Here i attended two courses. The Teacher is more knowledgeable person. I attend here accounts and Corporate Tax Singapore courses. really ill recommend this institute.

Lachu Gandhi

2021-09-07

Content of the course is appropriate. Trainer valene was very good and interactive. The place, course materials, the presentation and content of the material everything were clear and precise and she gave proper response to the queries raised. The place is well maintained too. Overall, a good experience and sure, I will recommend inspizone to my friends who are keen on upgrading themselves.

shengwei tan

2021-07-01

Stella is a great lecturer, the lesson taught are well orderly manner for each day which preps in beforehand and learning better.

Grace CH Ong

2021-06-11

A very useful course with laptops provided and sample datasets for our training. Training was very well-paced and clear, helpful for learning. Trainer also was happy to go around assisting when needed and managed queries well for us. Happy to have participated in a course at Inspizone 🙂