fbnoscript

WSQ Microsoft Excel Advanced Course

WSQ Microsoft Excel up to 70% SkillsFuture Singapore Funding Diagram - SkillsFuture Credit, PSEA & UTAP Claimable

Nett Course Fee
$175.50 after 70% SkillsFuture Subsidy

Course Description

The WSQ Microsoft Excel Advanced course is structured around a part-to-whole sequencing method, unfolding through six progressively linked learning units. It kicks off, Advanced Formulas and Functions, where participants dive into complex business statistical formulas and functions.

This unit covers summarising and analysing both categorical and numerical data sets, including the use of nested conditions, and
lookup, text, date, and time functions.

Next, learners will leverage Excel’s built-in data analysis tools, Managing and Analysing Data Ranges, to discern trends and patterns. This focus on data analysis paves the way to next learning unit, Organising and Summarising Data, where common statistical software applications and techniques for data organisation and summary, including scenario reports and consolidation of data, are taught.

For the next learning unit, Working with PivotTables, it equips learners with the skills to create and customise PivotTables with slicers. Moving to the stage, Working with Web and External Data, learners apply their knowledge to query data from multiple sources, extracting relevant information for stakeholders using techniques from statistical software. On the last learning unit, Working with Macros, where participants learn to automate repetitive tasks and data management through macro recording.

This structured approach ensures that by the end of the course, participants are adept at utilising advanced statistical formulas and functions, summarising and analysing data, creating PivotTables, working with external data sources, and automating tasks with macros, equipping them with the comprehensive skills needed for effective data management and data analysis. 

Prerequisites

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

  • (≥ 16 years old); or
  • 1 year working experience

Course Objectives

Upon completion of this course, participants should be able to:

  • Use a series of business statistical formulas and functions for summarising and analysing categorical or numerical data sets, including utilising nested conditions, lookup, text, date, and time functions.
  • Harness the skills needed to use Excel’s built-in data analysis tools to analyse data sets and identify trends and patterns.
  • Distinguish between Excel’s built-in statistical functions and tools to conduct statistical analyses, taking into account the needs and objectives of stakeholders.
  • Utilise PivotTable to understand and analyse the core data structures that include summarising datasets for the presentation of actionable business insights to stakeholders.
  • Adopt relevant statistical software techniques to perform data queries across multiple sources to extract pertinent data for stakeholders.
  • Apply macro recording functionality to aid automation of working with data sets and performing repetitive tasks.

Course Outline

Advanced Formulas and Functions
  • Formulas with Multiple Operators
  • Inserting and Editing a Function
  • AutoCalculate and Manual Calculation
  • Cell and Range Names
  • Displaying and Tracing Formulas
  • Understanding Formula Errors
  • Using Financial Functions (PMT)
  • Using Logical Functions (IF, AND, OR, Nested IFs)
  • Using Lookup Functions (VLOOKUP, HLOOKUP, MATCH & etc)
  • Using Text Functions (CONCATENATE, UPPER, LEFT & etc)
  • Using Date & Time Functions
Managing and Analysing Data Ranges
  • Working with Scenarios & Creating a Scenario Summary Report
  • Working with Data Tables
  • Using Goal Seek & Solver
  • Using Text to Columns
  • Grouping and Outlining Data
  • Using Subtotal
  • Consolidating Data by Position or Category
  • Consolidating Data Using Formulas
  • Sharing a Workbook
  • Track changes
  • Compare and Merge Workbooks
Organising and Summarising Data
  • Creating a Custom AutoFill List
  • Applying Conditional Formatting
  • Create & Manage Conditional Formatting Rules
  • Sorting by a Custom List
  • Filtering Data
  • Creating a Custom AutoFilter
  • Using Advanced Filter
  • Using Data Validation
Working with PivotTables
  • Create and Specifying PivotTable Data
  • Changing a PivotTable’s Calculation
  • Using Multiple PivotTable Fields
  • Filtering & Sorting a PivotTable
  • Working with PivotTable Layout
  • Grouping PivotTable Items
  • Update & Format a PivotTable
  • Create a PivotChart
  • Using Slicers & Sharing Slicers Between PivotTables
Working with Web and External Data
  • Inserting a Hyperlink
  • Importing Data from a Text File and an Access Database
  • Importing Data from the Web Working with Existing Data Connections
Working with Macros
  • Recording a Macro
  • Playing and Deleting a Macro
  • Adding a Macro to the Quick Access Toolbar

Fees and Subsidies

Up to 70% SkillsFuture Singapore Funding Diagram - SkillsFuture Credit, PSEA & UTAP Claimable

*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
Singaporean Citizens, PRs or LTVP+ Holders ≥ 21 years old S$175.50 (after SSG 70% Funding)

SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies
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. Sign up https://ntuc.co/ask-edm.

Related Courses

WSQ Microsoft Excel Essentials Course

The WSQ Microsoft Excel Essentials course focuses on using Microsoft Excel, the widely used spreadsheet tool, for tasks related to data analytics, business, and research. It covers foundational concepts in applying business statistics, analytical skills, and quantitative techniques within the Excel environment as well as practical hands-on skills in manipulating data for your needs.

Course Duration:
2 Days (9.00am – 6.00pm)

View course details here

WSQ Microsoft Excel Intermediate Course

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

2 Days (9.00am – 6.00pm)

Course Fee Details:

$175.50 (incl. of 9% GST) after 70% SkillsFuture Subsidy

SkillsFuture Credits & UTAP claimable

Course Code: TGS-2024045082

Course Schedule

Course NameCourse CodeVenueDecember 2024January 2025February 2025March 2025April 2025May 2025June 2025
WSQ Microsoft Excel AdvancedTGS-2024045082International Plaza--17-18-14-15-23-24
TGS-2024045082JTC Summit-16-17-17-18-29-30-
TGS-2024045082Mountbatten Square05-0623-2424-2520-2128-2913-1419-20
TGS-2024045082International Plaza (Weekends)18-1922-2329 Mar & 05 Apr26-27