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:

WPLN Level 5
Attended our WSQ Microsoft Excel Intermediate; OR
Some knowledge of Microsoft Excel skills and know how to work with Microsoft Excel function

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.

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