WSQ Intermediate & Advanced Excel Course - Excel Training Singapore

WSQ Microsoft Excel Intermediate & Advanced in Singapore

Physical Training Available, Fundings Applicable.

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

Training fee:

*Course fee before WSQ funding: $550.00/pax + the new 9% GST rate will be applied for all registration made after 31st December 2023

WSQ Funding: (GST included)

*The funding amount mentioned is indicative and will be confirmed upon registration.

Course Fee Subsidies for SMEs	SINGAPORE CITIZENS AND PRS ≥ 21
	70% of Course Fees
	WSQ Deductible: $385.00 Payable: $214.5 (including GST)
	Passing Exam & Full Attendance required
Course Fee Subsidies for Non-SMEs	SINGAPORE CITIZENS ≥ 40	SINGAPORE CITIZENS < 40 AND PRS
	70% of Course Fees	50% of Course Fees
	WSQ Deductible: $385.00 Payable: $214.5 (including GST)	WSQ deductible: $275.00 Payable $324.5 (including GST)
	Passing Exam & Full Attendance required
Course Fee Subsidies for Self-sponsored Individuals	SINGAPORE CITIZENS ≥ 40	21⩽SINGAPORE CITIZENS < 40 AND 21 ⩽PRS
	70% of Course Fees	50% of Course Fees
	WSQ Deductible: $385.00 Payable: $214.5 (including GST) (Can be offset by Skillsfuture credits if have)	WSQ deductible: $275.00 Payable $324.5 (including GST) (Can be offset by Skillsfuture credits if have)
	Passing Exam & Full Attendance required

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