SCHEDULE:
Duration: 3 days
- 14,21 & 28 Jan 2024 (3xSun) – Bukit Merah
- 15,16 & 17 Jan 2024 (Mon-Wed) –Bukit Merah
- 20 & 27 Jan & 03 Feb 2024 (3xSat) –Bukit Merah
- 24,25 & 26 Jan 2024 (Wed-Fri)-Bukit Merah
- 26,27 & 28 Feb 2024 (Mon-Wed) –Bukit Merah
Time: 8.30am to 5.40pm
Venue: 167 Jalan Bukit Merah Connection One, Tower 4, #06-11A, Singapore 150167
COURSE OVERVIEW:
On completion of this module, each candidate will be to:
- Use intermediate to advanced excel formulas and functions to handle company data
- Get data from data course and prepare dataset for analysis
- Clean, transform and shape data for analysis
- Identify root cause for problems, categorise problems, Pareto Analysis to improve processes
Course Outline:
- Extract data with: Xlookup, Vlookup, Hlookup, Index and Match, Vstack, Hstack
- Data Handling: Understand data types, manage missing data, Correct inaccurate data, Separate data, Unpivot Data
- Learn excel formulas like: Countif, Sumif, Averageif
- Apply excel functions such as: Custom Sort and Filter, Advanced Filter, SubTotal, Data Validation
COURSE FEE AFTER FUNDING (with GST) for:
Self-sponsored:
Singaporeans aged 40 and above: $218.40
All PRs and Singaporeans aged below 40 : $330.40
Company-sponsored:
All Singaporeans and PRs from SME: $218.40
Singaporeans aged 40+ under Non-SMEs: $218.40
Singaporeans aged below 40 and all PRs under Non-SMEs: $330.40
Full Course Fee (with GST): $610.40
COURSE FEE AFTER FUNDING CAN BE CLAIMED THROUGH:
- SkillsFuture Credit: Singaporeans aged 25 and above can use their credits to pay for course fees.
- PSEA (Post-Secondary Education Account): Singaporeans aged 17 to 30 may use their account’s funds for fee payment. (Please Call PSEA Hotline 62600777 to check your balance)
- SkillsFuture Enterprise Credits (SFEC): Eligible employers will receive a one-off S$10,000 credit to cover up to 90% of out-of-pocket expenses on qualifying costs for supportable initiatives.
ABSENTEE PAYROLL:
Company-sponsored (NON-SME/SME) eligible to apply absentee payroll capped at $4.5/hr.
Entry Requirements:
- Apply basic formula and functions (i.e. SUM, AVERAGE, COUNT, COUNTA, MIN MAX, ROUND, IF)
- Understand how to use cell referencing (i.e. A1, $A$1)
- Minimum 1 year of working experience (with preference in using excel)
- Speak, listen and read English at a proficiency level not lower than the WPL Level 4, and manipulate numbers at a level not lower than the WPN Level 4
- Minimal educational qualification is GCE ‘O’ Level, GCE ‘N’ Level or ITE Certificate
Course code: TGS-2023018902
Genetic Computer School Pte. Ltd. (UEN: 198902296M)