WSQ Microsoft Excel Advanced Course
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
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
*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 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 Name | Course Code | Venue | December 2024 | January 2025 | February 2025 | March 2025 | April 2025 | May 2025 | June 2025 |
---|---|---|---|---|---|---|---|---|---|
WSQ Microsoft Excel Advanced | TGS-2024045082 | International Plaza | - | - | 17-18 | - | 14-15 | - | 23-24 |
TGS-2024045082 | JTC Summit | - | 16-17 | - | 17-18 | - | 29-30 | - | |
TGS-2024045082 | Mountbatten Square | 05-06 | 23-24 | 24-25 | 20-21 | 28-29 | 13-14 | 19-20 | |
TGS-2024045082 | International Plaza (Weekends) | 18-19 | 22-23 | 29 Mar & 05 Apr | 26-27 |