WSQ Basic Excel Course in Singapore

Physical Training Available, Fundings Applicable.

Elevate your Microsoft Excel skills with our WSQ Basic Excel course in Singapore. This hands-on program guides you through essential aspects of Excel, including spreadsheet navigation, data entry, formulas, and functions. You'll learn how to efficiently organize and analyze data, create charts, and automate tasks.

Designed to equip participants with practical Excel skills crucial for various professional roles, this comprehensive course will boost your productivity and efficiency in data management. Enhance your career prospects in the dynamic fields of business and finance. Enroll now to improve your Excel proficiency and open up new opportunities. Excel in your career with WSQ Basic Excel training in Singapore.

What Will You Learn WSQ Basic Excel Course

Data Manipulation: Learn to handle collected data using basic Excel functions for effective configuration and distribution in worksheets and workbooks.
Data Collection and Analysis: Identify valuable data points for collection and apply business statistics using Excel formulas and functions.
Data Formatting: Master the formatting of data across a range of cells in Microsoft Excel.
Data Tabulation: Gain skills in performing data tabulation in Microsoft Excel.
Chart and Graph Creation: Learn to create charts and graphs using basic functionalities in Microsoft Excel.

WSQ Basic Excel Course Outline

Module One: Create And Manage Worksheets And Workbooks

Create Worksheets and Workbooks

Navigate Excel user interface
Use Excel commands
Create and save a workbook
Enter cell data
Import data from a delimited text file

Format Worksheets and Workbooks

Add a worksheet to an existing workbook
Rename a worksheet
Copy and move a worksheet
Change worksheet tab color
Insert and delete columns or rows
Adjust row height and column width

Configure Worksheets and Workbooks for Distribution

Set a print area
Modify page setup
Insert headers and footers
Print all or part of a workbook
Set print scaling
Display repeating row and column titles on multiple worksheets
Save workbooks in alternative file formats

Navigate in Worksheets and Workbooks

Search for data within a workbook
Navigate to a named cell, range, or workbook element
Insert and remove hyperlinks

Customize Options and Views for Worksheets and Workbooks

Hide or unhide columns and rows
Hide or unhide worksheets
Change workbook views
Change window views
Modify document properties
Change magnification by using zoom tools
Display formulas
Customize the Quick Access toolbar

Module Two: Perform Operations With Formulas And Functions

Summarize data by using functions

Insert references
Perform calculations by using the SUM function
Perform calculations by using MIN and MAX functions
Perform calculations by using the COUNT function
Perform calculations by using the AVERAGE function

Format and modify text by using functions

Format text by using RIGHT, LEFT, and MID functions
Format text by using UPPER, LOWER, and PROPER functions
Format text by using the CONCAT function

Perform conditional operations by using functions

Perform logical operations by using the IF & IFS function
Perform logical operations by using the SUMIF function
Perform logical operations by using the AVERAGEIF function
Perform statistical operations by using the COUNTIF function

Module Three: Manage Data Cells And Ranges

Insert data in cells and ranges

Replace data
Cut, copy, or paste data
Paste data by using special paste options
Fill cells by using Auto Fill
Insert and delete cells

Summarize and Organize data

Insert sparklines
Group and outline data
Insert subtotals
Apply (basic) conditional formatting

Format cells and ranges

Merge cells
Modify cell alignment and indentation
Wrap text within cells
Apply number formats
Format cells by using Format Painter

Module Four: Create Tables

Create and manage tables

Create an Excel table from a cell range
Convert a table to a cell range
Add or remove table rows and columns

Filter and sort a table

Filter records
Sort data by multiple columns
Change sort order
Remove duplicate records

Manage table styles and options

Apply styles to tables
Configure table style options
Insert total rows

Module Five: Create Charts And Objects

Create charts

Create a new chart
Add additional data series
Switch between rows and columns in source data

Format chart elements

Resize charts
Add and modify chart elements
Apply chart layouts and styles
Move charts to a chart sheet

Training fee:

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

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: $276.50 Payable: $154.05 (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: $276.50 Payable: $154.05 (including GST)	WSQ deductible: $197.5 Payable $233.05 (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: $276.50 Payable: $154.05 (excluding GST) (Can be offset by Skillsfuture credits if have)	WSQ deductible: $197.05 Payable $233.05 (excluding GST) (Can be offset by Skillsfuture credits if have)
	Passing Exam & Full Attendance required

Discount policy:

4 pax from a same group: 5% discount for each person
5 pax from a same group: 10% discount for each person

Assessment Plan:

Practical Performance: 1 Hour
Kindly help us process via Quiz