WSQ Microsoft Excel Intermediate & Advanced Course in Singapore
WSQ
Singapore Workforce Skills Qualifications
SkillsFuture
Eligible
PSEA
Post Secondary Education Account
SFEC
Absentee
Payroll
3 DAYS
Course Days
21 HOURS
Course Duration
9:30 AM - 5:30PM
Course Timings
VENUE
10 Anson Road, 26-08A International Plaza, Singapore 079903
Course Start Date
WSQ Microsoft Excel Intermediate & Advanced in Singapore
The Microsoft Excel Intermediate & Advanced course is designed for anyone looking to build on their existing Excel skills and apply them in real-world business scenarios. It’s ideal for professionals who want to take their data analysis abilities to the next level using advanced Excel tools and techniques.
Professionals involved in data analysis, modelling, and reporting within their organizations.
Data Analysts who work with data on a regular basis and want to automate data manipulation and reporting tasks in Excel.
Finance professionals who rely on Excel for financial modelling, forecasting, and data analysis.
Accountants and finance professionals who use Excel for financial reporting and analysis.
Administrative staff who manage data, records, and reports using Excel.
Individuals who use Microsoft Excel regularly for tasks such as data analysis, reporting, budgeting, or project management.
What Will You Learn WSQ Microsoft Excel Intermediate & Advanced Course
Learners are able to prepare and assist in generating diverse business insight reports adhering to legal and ethical guidelines related to data protection using data modelling and data visualisation principles.
Learners are able to perform complex database queries across multiple tables/unions to extract pertinent data by employing techniques used in data science.
Learners are able to identify the statistical techniques and machine learning methods to conduct meaningful and relevant data analysis on distinct datasets.
Learners are able to apply data mining, time series forecasting and modelling techniques to identify and predict trends and patterns in data for business insights with applicable functional languages.
Learners are able to demonstrate an understanding of the underlying data structures involved in data science and summarise the data studies for business insights presentation.
Learners are able to recognise the significance of domain context in data science to produce performance dashboards and insight reports tailored to specific business domains.
Who Should Attend This WSQ Microsoft Excel Intermediate & Advanced
The WSQ Microsoft Excel Intermediate & Advanced is designed for individuals who are new to Microsoft Excel and want to establish a solid foundation in using this spreadsheet software.
Analyst
Turn insights into strategy
Business professionals
Drive smarter decisions
Entrepreneur
Innovate with AI power
Training Professionals
Upskill the future workforce
Student
Kickstart your AI journey
Entry Requirements
Above 16 years old
High School Level English
Basic internet & computer operation skills
Course Completion Requirements
Minimum 75% attendance is required in order to complete the course and receive the course completion certificate
Training fee: WSQ QuickBooks Training For Professionals Course
Before funding Bundle Course Fee: $550.00/pax + 9% GST
| Self-sponsor/ Non-SME Company Sponsor | SME Company Sponsor | |||
|---|---|---|---|---|
| Full Course Fee (no funding) |
Age 21-39 S/PRs (SkillsFuture Funding Baseline) |
Age 40 above (SkillsFuture Mid-career Enhanced Subsidy) |
SME Company Sponsor (SkillsFuture Enhanced Training support for SMEs) |
|
| Full Course Fee (bef funding) | $550.00 | $550.00 | $550.00 | $550.00 |
| SkillsFuture Funding (WSQ) | - $0.00 | - $275.00 | - $385.00 | - $385.00 |
| GST (On Full Fee) | + $49.50 | + $49.50 | + $49.50 | + $49.50 |
| Total Payable (After Funding and GST Included) |
$599.50 (After Funding and GST Included) |
$324.50 (After Funding and GST Included) |
$214.50 (After Funding and GST Included) |
$214.50 (After Funding and GST Included) |
Payable amount after WSQ funding is eligible for further support from SFEC, SkillsFuture, PSEA & UTAP where applicable
Grants available
WSQ
Singapore Workforce Skills Qualifications
WSQ Fund: Baseline funding deduction upto 70% for Singaporeans/ PRs. Further SFEC, Absentee Payroll and WSS applicable.
SkillsFuture Eligible
SkillsFuture Credit: Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees
PSEA
Post-Secondary Education Account
PSEA Funds: are available for Singaporean Citizens to cover the approved fees and charges related to WSQ programs.
SFEC
SkillsFuture Enterprise Credit
Absentee Payroll
Absentee Payroll
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
Automating Task
- Create and modify simply macros
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
See how MOCD Studio’s courses help our students grow and succeed
Top Most Related Courses
Learn WSQ Effective Business Presentation with PowerPoint Course in Singapore
WSQ Singapore Workforce Skills Qualifications SkillsFuture Eligible PSEA Post Secondary Education Account SFEC SkillsFuture Enterprise Credit Absentee Payroll Quick Enquiry...
Read More
WSQ Effective Business Presentation Soft Skill Training in Singapore
WSQ Singapore Workforce Skills Qualifications SkillsFuture Eligible PSEA Post Secondary Education Account SFEC SkillsFuture Enterprise Credit Absentee Payroll Quick Enquiry...
Read More
WSQ Effective Business Writing Skill Course in Singapore
WSQ Singapore Workforce Skills Qualifications SkillsFuture Eligible PSEA Post Secondary Education Account SFEC SkillsFuture Enterprise Credit Absentee Payroll Quick Enquiry...
Read More
WSQ Smartphone Videography and Video Editing Course in Singapore
WSQ Singapore Workforce Skills Qualifications SkillsFuture Eligible PSEA Post Secondary Education Account SFEC SkillsFuture Enterprise Credit Absentee Payroll Quick Enquiry...
Read More
WSQ Python Programming Course in Singapore
WSQ Singapore Workforce Skills Qualifications SkillsFuture Eligible PSEA Post Secondary Education Account SFEC SkillsFuture Enterprise Credit Absentee Payroll Quick Enquiry...
Read MoreFAQ for WSQ Microsoft Excel Intermediate & Advanced Course in Singapore
Who should take the WSQ Microsoft Excel Intermediate & Advanced Course?
This course is ideal for professionals who want to enhance their Excel skills for better data management, reporting, and analysis.
What if I fail/did not complete the assessment?
You will be considered non-competent and no Statement of Attainment (SOA) will be awarded. You are required to pay the complete course fee, which includes the SSG’s funding requirement.
Is there a prerequisite for this course?
Yes, participants should have basic knowledge of Excel or have completed an Excel beginner-level course.
How long is the course?
The course typically lasts 3 days, with both weekday and weekend schedules available
Will I receive a certificate after completing the course?
Yes, participants will receive a WSQ certificate upon successful completion of the course and assessments.
Is this course SkillsFuture Credit eligible?
Yes, the course is SkillsFuture Credit eligible for Singaporean citizens. Check with the training provider for specific details
How can I enroll in the course?
Please fill up the registration form at Course Registration Form | Inspizone Trainings
What topics are covered in the course?
The course covers advanced functions, formulas, pivot tables, data visualization, conditional formatting, and data analysis techniques.
ADDITIONAL SUPPORT
For Company
* Eligible companies can reimburse up to 90% of the payable amount via SFECFor Self-sponsor
* Singaporean can offset the payable amount via SkillsFuture Credit (Except Mid Career Credit) and/or PSEA * NTUC Union members can reimburse of up to 50% of the unfunded fee under UTAP Enjoy up to $250 UTAP support. More info: UTAP
Note: minimum 75% attendance & passing all the assessment are required for WSQ subsidy deduction.