| Subsidy | Category of Individuals | ||
| Singapore Citizens and Singapore Permanent Residents | Employer-sponsored and Self-sponsered Singapore Citizens aged 40 years old and above | SME-sponsored local employees (i.e. Singapore Citizens and Singapore Permanent Residents) | |
| Funding Source | |||
| SkllsFuture Funding (Baseline) | SkillsFuture Mid-career Enhanced Subsidy | Skills Future Enhanced Training Support for SMES | |
| Course Fee | SGD 460.00 | SGD 460.00 | SGD 460.00 |
| SkillFuture Funding | SGD 230.00 | SGD 322.00 | SGD 322.00 |
| Total Net Fee | SGD 230.00 | SGD 138.00 | SGD 138.00 |
| GST (9% × SGD 460.00) | SGD 41.40 | SGD 41.40 | SGD 41.40 |
| Total Fee Payable | SGD 271.40 | SGD 179.40 | SGD 179.40 |
| Event Profile | |
| Course Code | TGS-2023018777 |
| Class/ Online | Classroom |
| Date | June 06 - 07, 2024 |
| Time | 8.30am to 5.30pm |
| Venue | Block 167 Jalan Bukit Merah #06-11A Connection One Tower 4 Singapore 150167 |
| Fee | 9% GST will apply SGD 460.00 |
| Activity | |
Course Objective
This module enables learner to understand how Excel functions manage data, and out-put data reports and charts. Able to collect data, gather data from system and external sources. Identify the Dataset that can provide the necessary information to answer the business questions. Understand how business statistics helps in business decisions.
On completion of this module each candidate will be able to:
• Work with Excel environment and save them in different file formats
• Enter data into cells, understand data types, apply basic formatting to numbers and text
• Apply formulas to compute, Understanding how Cell Reference is used in formulas
• Lookup functions to find values in a dataset, work in Excel Tables
• Charts, Page Layout, Views, Report Output
• Types of Errors and how to handle them
• Data Analysis, Data Types, Business Statistics
On completion of this module each candidate will be able to:
• Work with Excel environment and save them in different file formats
• Enter data into cells, understand data types, apply basic formatting to numbers and text
• Apply formulas to compute, Understanding how Cell Reference is used in formulas
• Lookup functions to find values in a dataset, work in Excel Tables
• Charts, Page Layout, Views, Report Output
• Types of Errors and how to handle them
• Data Analysis, Data Types, Business Statistics
Course Outline
• Business Statistics
• Data Analysis Process and its Stages
• Types of Data
• Sources of Data
• Excel environment
• Workbook and Worksheet Structure
• Data entry into worksheet, Copy, Paste data, Drag and Drop
• Date, Text, Numbers, Formulas,
• Functions
• Sum, Average, Min, Max, Count, CountA, Round, IF
• vLookup to extract data
• Cell Referencing in Formulae
• Working with Excel Tables, Sort and Filter
• Charts, Data Visualisations
• Page Layout
• Report Output
• Views, Page break
• Types of Errors
• Get Data from other source
• CSV files, Text Files
• Files from Folders
• Save, Open Files
• Data Analysis Process and its Stages
• Types of Data
• Sources of Data
• Excel environment
• Workbook and Worksheet Structure
• Data entry into worksheet, Copy, Paste data, Drag and Drop
• Date, Text, Numbers, Formulas,
• Functions
• Sum, Average, Min, Max, Count, CountA, Round, IF
• vLookup to extract data
• Cell Referencing in Formulae
• Working with Excel Tables, Sort and Filter
• Charts, Data Visualisations
• Page Layout
• Report Output
• Views, Page break
• Types of Errors
• Get Data from other source
• CSV files, Text Files
• Files from Folders
• Save, Open Files
Entry Requirement
* Minimal education qualification is PSLE with 1 year of relevant working experience.
* Speak, listen and read English at a proficiency level not lower than the WPL Level 3, and manipulate numbers at a not lower than the WPN Level 3.
* Speak, listen and read English at a proficiency level not lower than the WPL Level 3, and manipulate numbers at a not lower than the WPN Level 3.
