WSQ Microsoft Excel - Basic Level Course in Singapore
WSQ Microsoft Excel – Basic Level Course in Singapore. Acquire vital spreadsheet skills for efficient data management and analysis. Elevate your Excel proficiency today!
WSQ
Singapore Workforce Skills Qualifications
SkillsFuture Eligible
PSEA
Post Secondary Education Account
Course Start Date
Schedule
- Days: 2 Days
- Duration: 14 Hours
- Timings: 9:30 AM - 5:30 PM
- 10 Anson Road, 26-08A International Plaza, Singapore 079903
Why Choose Us
- Expert Local Trainers
- Hands-on Training by experts
- Certificate of Achievement
- 100% Satisfactory Record
SSG Course Details
- TGS-2023040846
- Mode of Training - Physical, in-class training
- Course Subsidy Validity - From 19 Dec 2023 to 18 Dec 2025
- Register Now
Who Should Attend This WSQ Microsoft Excel - Basic Level Course
The WSQ Microsoft Excel – Basic Level Course is designed for individuals who are new to Microsoft Excel and want to establish a solid foundation in using this spreadsheet software.
Business professionals
Analyst
Entrepreneur
Training Professionals
Student
Course Completion Requirements
Minimum 75% attendance is required in order to complete the course and receive the course completion certificate
Above 16 years old
High School Level English
Basic internet & computer operation skills
WSQ Microsoft Excel - Basic Level Course in Singapore
Master the essentials of Microsoft Excel in Singapore with our WSQ Microsoft Excel – Basic Level Course. Dive into hands-on learning that covers spreadsheet navigation, data entry, formulas, and functions. Gain proficiency in organizing and analyzing data, creating charts, and automating tasks.
This comprehensive program is designed to empower participants with practical Excel skills essential for various professional roles. Elevate your productivity and efficiency in data management. Enroll now to enhance your Excel proficiency and unlock new opportunities in the dynamic world of business and finance. Excel in your career with WSQ Basic Excel training in Singapore.
What Will You Learn WSQ Microsoft Excel - Basic Level Course
- Learners are able to manipulate the collected data applying basic Excel functions for configuration and distribution in Microsoft worksheets and workbooks
- Learners are able to identify areas with meaningful data for collection to apply business statistics using Excel formulas and functions
- Learners are able to apply formatting of data to a range of cells in Microsoft Excel
- Learners are able to perform data tabulation in Microsoft Excel
- Learners are able to produce charts and graphs with basic Microsoft Excel functionalities
Training fee: WSQ Microsoft Excel - Basic Level Course
| 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.
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
Unsure if this course is suitable for you? Take this Quick test to help you decide.
Grants available
WSQ
Singapore Workforce Skills Qualifications
WSQ : 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 : are available for Singaporean Citizens to cover the approved fees and charges related to WSQ programs.
WSQ BASIC EXCEL
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
Summarize data by using functions
- Insert references
- Perform calculations by using the SUM function
- Perform calculations by using the 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
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 Four: Create tables
Create a new chart
- 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
FAQ for WSQ Microsoft Excel Basic Course in Singapore
What is the WSQ Microsoft Excel Basic Course about?
The course introduces essential Excel skills, including creating spreadsheets, formatting data, using basic formulas, and managing workbooks effectively.
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.
Are there any prerequisites for enrolling?
What will I learn in this course?
You will learn Excel fundamentals, including entering data, formatting cells, creating charts, basic formulas, and managing simple data sets.
Is this course WSQ-certified?
Yes, the course is WSQ-certified, ensuring quality training and recognized certification upon successful completion.
How long is the course, and what is the schedule?
Will I receive support after completing the course?
Yes, participants can access post-course resources and support to reinforce their learning and apply Excel skills effectively.
Who is this course suitable for?
The course is ideal for beginners with little to no Excel experience who want to enhance their productivity and data management skills.