WSQ Microsoft Excel Intermediate & Advanced Course in Singapore
Physical Training Available, Fundings Applicable.
Master advanced Microsoft Excel skills in Singapore with our WSQ Intermediate & Advanced course. Elevate your spreadsheet proficiency, unlock powerful features, and enhance your data analysis capabilities.
WSQ
Post Secondary Education Account
SkillsFuture Eligible
PSEA
Post Secondary Education Account
UTAP
NTUC members
TRAINING FEE
*Course fee before funding: $ 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
Kindly note that you are required to achieve a minimum of 75% attendance and be certified competent in all the assessment components. Should you fail to meet the attendance/assessment requirements and/or terms and conditions of SSG's funding, you will not be eligible for the course fee funding and will have to bear the full course fees.
*SFEC, Absentee payroll and WSS funding also applicable for WSQ courses. For further details please refer to WSQ Funding by Skilllsfuture SG – Inspizone Trainings
Discount Policy:
- 3 pax from a same group: 5% discount for each person
- 4 pax from a same group: 10% discount for each person
Assessment Plan:
- Practical Performance: 1 Hour
- Kindly help us process via Quiz
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.
Training
Professionals
Business professionals
Entrepreneur
Students
WSQ Microsoft Excel Intermediate & Advanced in Singapore
This Microsoft Excel Intermediate & Advanced course is designed for individuals looking to elevate their data analysis skills for more complex business applications using Excel. The course is ideal for:
- Finance professionals involved in financial modeling, forecasting, and data analysis.
- Accountants who use Excel for financial reporting and detailed analysis.
- Administrative staff responsible for managing data, records, and generating reports in Excel.
- Project managers who rely on Excel for project planning, tracking, and reporting.
- Regular Excel users engaged in tasks such as data analysis, reporting, budgeting, or project management.
What Will You Learn WSQ Microsoft Excel Intermediate & Advanced Course
- Learners are equipped to prepare and assist in generating diverse business insight reports, ensuring compliance with legal and ethical data protection guidelines, using principles of data modeling and visualization.
- Learners can perform complex database queries across multiple tables and unions to extract relevant data, utilizing data science techniques.
- Learners are capable of identifying appropriate statistical techniques and machine learning methods to conduct meaningful data analysis on various datasets.
- Learners can assist with data transformation, quality checking, and cleansing, converting datasets into easily digestible formats.
- Learners are able to apply data mining, time series forecasting, and modeling techniques to identify and predict trends and patterns for business insights using applicable programming languages.
- Learners demonstrate an understanding of the underlying data structures in data science and can summarize data studies for business insights presentations.
- Learners recognize the importance of domain context in data science, enabling them to produce performance dashboards and insight reports tailored to specific business domains.
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
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
ADDITIONAL SUPPORT
For Company
* Eligible companies can reimburse up to 90% of the payable amount via SFEC
For 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.