WSQ Intermediate & Advanced Excel Course

WSQ Microsoft Excel Intermediate & Advanced in Singapore

Singapore Excel Basic Course

Physical Training Available, Fundings Applicable.

WSQ Microsoft Excel Intermediate & Advanced in Singapore

This Microsoft Excel Intermediate & Advanced course is designed for individuals looking to elevate their data analysis skills for more complex business applications using Excel. The course is ideal for:

  • Finance professionals involved in financial modeling, forecasting, and data analysis.
  • Accountants who use Excel for financial reporting and detailed analysis.
  • Administrative staff responsible for managing data, records, and generating reports in Excel.
  • Project managers who rely on Excel for project planning, tracking, and reporting.
  • Regular Excel users engaged in tasks such as data analysis, reporting, budgeting, or project management.

What Will You Learn WSQ Microsoft Excel Intermediate & Advanced Course

  • Learners are equipped to prepare and assist in generating diverse business insight reports, ensuring compliance with legal and ethical data protection guidelines, using principles of data modeling and visualization.
  • Learners can perform complex database queries across multiple tables and unions to extract relevant data, utilizing data science techniques.
  • Learners are capable of identifying appropriate statistical techniques and machine learning methods to conduct meaningful data analysis on various datasets.
  • Learners can assist with data transformation, quality checking, and cleansing, converting datasets into easily digestible formats.
  • Learners are able to apply data mining, time series forecasting, and modeling techniques to identify and predict trends and patterns for business insights using applicable programming languages.
  • Learners demonstrate an understanding of the underlying data structures in data science and can summarize data studies for business insights presentations.
  • Learners recognize the importance of domain context in data science, enabling them to produce performance dashboards and insight reports tailored to specific business domains.

WSQ Microsoft Excel Intermediate & Advanced Course Outline

Module One: Create And Manage Worksheets And Workbooks

Manage Workbooks

  • Reference data in another worksheet/workbook
  • Reference data by using 3D references

Manage Workbook Review

  • Configure formula calculation options
  • Restrict editing
  • Protect a worksheet
  • Protect workbook structure
  • Encrypt workbooks with a password

Module Two: Apply Custom Data Formats And Layouts

Apply Custom Data Formats and Validation

  • Create custom number formats
  • Populate cells by using advanced Fill Series options
  • Configure data validation

Apply Advanced Conditional Formatting

  • Create custom conditional formatting rules
  • Create conditional formatting rules that use formulas
  • Manage conditional formatting rules

Module Three: Create Advanced Formulas

Define Named Ranges and Objects

  • Name cells
  • Name data ranges
  • Name tables

Look up data using Functions

  • Look up data by using the VLOOKUP
  • Look up data by using the HLOOKUP function
  • Look up data by using the MATCH function
  • Look up data by using the INDEX function

Troubleshoot Formulas

  • Trace precedence and dependence
  • Monitor cells and formulas by using the Watch Window
  • Validate formulas by using error checking values
  • Evaluate formulas

Apply Advanced Logical & Statistical Functions

  • Perform logical operations by using AND, OR, and NOT functions
  • Perform logical operations by using nested functions
  • Perform statistical operations by using SUMIFS, AVERAGEIFS, AND COUNTIFS functions

Apply Advanced Date and Time Functions

  • Reference the date and time by using the NOW and TODAY functions
  • Serialize numbers by using date and time functions

Module Four: Perform Data Analysis And Business Intelligence

Managing External Data

  • Import, transform, combine, display, and connect to data
  • Consolidate data

Performing What-If Analysis

  • One & Two Variable Data Tables
  • Achieve Target Value by using Goal Seek
  • Present multiple values with Scenarios
  • Forecast data

Module Five: Create Advanced Charts

Create Advanced Charts

  • Add trend lines to charts
  • Create dual axis charts
  • Save a chart as a template

Module Six: Analyze Data With PivotCharts & PivotTables

Create and Manage Pivot Tables

  • Create PivotTables
  • Modify field selections and options
  • Format data
  • Group PivotTable data
  • Create slicers & timelines
  • Reference data in a PivotTable by using the GETPRIVOTDATA function
  • Add calculated fields
  • Using report filter pages
  • Drill down details

Create and Manage PivotCharts

  • Create PivotCharts
  • Manipulate options in existing PivotCharts
  • Apply Styles to PivotCharts

Training fee:

*Course fee before WSQ funding: $550.00/pax + the new 9% GST rate will be applied for all registration made after 31st December 2023

WSQ Funding: (GST included)

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

Course Fee Subsidies for SMEs


70% of Course Fees

WSQ Deductible: $385.00

Payable: $214.5 (including GST)

Passing Exam & Full Attendance required

Course Fee Subsidies for Non-SMEs



70% of Course Fees

50% of Course Fees

WSQ Deductible: $385.00

Payable: $214.5 (including GST)

WSQ deductible: $275.00

Payable $324.5 (including GST)

Passing Exam & Full Attendance required

Course Fee Subsidies for Self-sponsored Individuals



70% of Course Fees

50% of Course Fees

WSQ Deductible: $385.00

Payable: $214.5 (including GST)  (Can be offset by Skillsfuture credits if have)

WSQ deductible: $275.00

Payable $324.5 (including GST)   (Can be offset by Skillsfuture credits if have)

Passing Exam & Full Attendance required

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
phone icon+65 8421 2824
Send Enquiry
chat iconChat With Us
phone email enquiry whatsapp whatsapp