WSQ Microsoft Excel Intermediate & Advanced Course in Singapore
Physical Training Available, Fundings Applicable.
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.
WSQ
Post Secondary Education Account
SkillsFuture Eligible
PSEA
Post Secondary Education Account
UTAP
NTUC members
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.
TRAINING FEE
*Course fee before funding: $ 550.00/pax + 9% GST
| 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 (After Funding and GST Included) |
$324.50 (After Funding and GST Included) |
$214.50 (After Funding and GST Included) |
$214.50 (After Funding and GST Included) |
Payable amount after WSQ funding is eligible for further support from SFEC, SkillsFuture, PSEA & UTAP where applicable
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:
- 3 pax from a same group: 5% discount for each person
- 4 pax from a same group: 10% discount for each person
Assessment Plan:
- Practical Performance: 1 Hour
- Kindly help us process via Quiz
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.
Training
Professionals
Business professionals
Entrepreneur
Students
WSQ Excel Training Intermediate And Advanced Course
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.
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
- Use Microsoft Copilot to analyse, troubleshoot, automate, and improve Excel workflows
- Generate business insights from complex datasets for decision-making
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.
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 Quality and Validation
- Identifying Data Issues
- Data Cleansing Techniques
- AI-Assisted Error Detection
Data Transformation and Preparation
- Cleaning and Restructuring Data
- Preparing Data for Analysis
- Automating Repetitive Spreadsheet Tasks
Productivity Enhancement with Copilot
- Prompting Techniques for Excel
- Best Practices for Working with AI
- Responsible Use of Copilot in Business Environments
ADDITIONAL SUPPORT
For Company
* Eligible companies can reimburse up to 90% of the payable amount via SFEC
For Self-sponsor
* Singaporean can offset the payable amount via SkillsFuture Credit (Except Mid Career Credit) and/or PSEA
* NTUC Union members can reimburse of up to 50% of the unfunded fee under UTAP
Enjoy up to $250 UTAP support. More info: UTAP
Note: minimum 75% attendance & passing all the assessment are required for WSQ subsidy deduction.