WSQ Microsoft Excel Mastery Course

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

Nett Course Fee
$234 after 70% SkillsFuture Subsidy

Course Description

Microsoft Excel serves as a gateway to various data technologies and platforms widely utilised in the ICT sector, including databases, business intelligence tools, and data visualisation software.

Excel mastery-level allows professionals to seamlessly integrate Excel with these technologies, facilitating smooth data exchange, analysis, and reporting across multiple systems. This integration enhances collaboration, interoperability, and overall efficiency within ICT teams and across departments.

Excel mastery-level proficiency is crucial for ICT sector employees to maintain competitiveness, efficiency, and effectiveness in their roles.

The WSQ Microsoft Excel Mastery course aims to equip professionals with expertise in performing sophisticated data analysis using advanced formulas, functions, and visualization techniques. This proficiency enables them to identify patterns, trends, and anomalies more effectively, thereby supporting informed decision-making and problem-solving.

Prerequisites

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

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

Course Objectives

At the end of the course, you will be able to:

Distinguish essential probability computations, distribution, and the logic of hypothesis testing.
Analyse relationships and trends between categorical or numerical data sets using advanced statistical functions.
Analyse data sets for big data analysis using advanced statistical tools.
Interpret the relationships between data sets using data modeling techniques.
Evaluate a series of array and summary functions to rectify issues in big data analytics.

Certification

Upon successful completion of the WSQ Microsoft Excel Mastery assessment, participants who have attended at least 75% of the course will receive a SkillsFuture WSQ Statement of Attainment (SOA) along with a Certificate of Achievement by @ASK Training.

Course Outline

Probability and Statistics

Starting with the fundamentals of probability and statistics provides a solid foundation for understanding data analysis. It includes the basics of probability, how to calculate probability, and the concepts of probability distribution, which are crucial for analysing data variability and making predictions. This knowledge is essential for effectively utilising advanced statistical functions and tools in Learning Units 2 and 3.

Advanced Statistical Functions

Building on the foundational knowledge, this unit focuses on using advanced statistical functions to identify value deviation, determine the degree of variation, compute quartiles, and analyse correlations between variables. Additionally, learners will learn to identify ranked high and low values, enhancing their ability to perform sophisticated data analysis in Excel.

Advanced Statistical Tools

This unit provides practical learning to learners to perform natural language queries on data for intuitive analysis, conduct ANOVA (Analysis of Variance) to compare datasets, and calculate moving averages to identify trends. It also covers rank and percentile calculations to determine data positions and sampling techniques for accurate data representation.

Managing PivotTable Reports

This unit dives deeper into leveraging PivotTables for robust data analysis and reporting. The learners will learn to create integrated reports using data models, generate multiple reports from a single dataset, and drill down into details for deeper insights. It also covers applying built-in analysis calculations and working with custom-calculated fields to tailor reports to specific needs.

Array and Summary Functions

Leveraging the knowledge acquired from previous learning units, the learners will learn array functions and spill ranges, change data layouts using TRANSPOSE, and sort data dynamically with SORT and SORTBY. They will also learn to extract unique values with UNIQUE, perform data lookups using XMATCH and XLOOKUP, and compute summary values with AGGREGATE and SUMPRODUCT.

Fees and Subsidies

*Eligible for Singaporean Citizens, Permanent Residents, and Long-Term Visit Pass Plus Holders

Course Fee:
S$600 (exclusive of 9% GST)

Course Fee After Eligible SSG Subsidies:
From S$234 (inclusive of 9% GST) after 70% SSG Subsidies

Learners
Singaporean Citizens ≥ 40 years old	S$234 (after SSG 70% Funding) SkillsFuture Credits can be used on top of existing subsidies
Singaporean Citizens, PRs or LTVP+ Holders ≥ 21 years old	S$354 (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$234 (after SSG 70% Funding) SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies	S$234 (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$354 (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. Head to our UTAP Funding page for more information.

Important Reminder: Your PSEA claim needs to be submitted at least 1 month before the course’s commencement date. Should you miss this deadline, an alternative payment method must be used to secure your spot in the course. After the disbursement of your PSEA funds to us, we will reach out to initiate the refund process.

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

This 2-day course covers complex statistical formulas, data analysis, PivotTables, external data querying, and task automation with macros to ensure proficiency in effective data management and analysis.

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

View course details here