- Learn the importance of functions in Microsoft Excel.
- Understand the importance of data analytics.
- Learn the process of data transformation and data analysis.
- Get an insight into chart making for data presentation.
DATA STORYTELLING WITH EXCEL
Duration: 16 Hours
Required Skills:
Basics Knowledge in Microsoft Excel
IT Savvy
Course Fee: $1,070
This course is eligible for:
Upcoming Course Dates : 7 & 14 May 2022 (9AM - 6PM) Via Zoom
In this course, participants will learn the knowledge and skills required to work with and analyze data with regards to business related scenarios using Microsoft Excel.
Programme Objectives:
Learning Outcomes:
Programme Objectives:
- To understand the basic functions of Microsoft Excel.
- To understand the different stages of a Data Life Cycle.
- To demonstrate competence in conducting data analysis.
- To demonstrate competence in conducting data transformation.
Learning Outcomes:
- MODULE 1: Basic Functions of MS-Excel.
- MODULE 2: Analyzing Data using Excel.
- MODULE 3: Referencing Data in Worksheets.
- MODULE 4: Data Transformation using Text-to-Column.
- MODULE 5: Analysis in Excel Tables.
- MODULE 6: Getting Insights using Charts.
- MODULE 7: Accessing data using Pivot Tables.
- MODULE 8: Automation using Power Query.
Participants are eligible for IBF enhanced course fee subsidies up to 90%.
Eligible Individuals Include:
Programme(s) Commencing between 1 Jan 2022 till 30 Jun 2022
- Company-sponsored individuals or self-sponsored participants
- Singapore Citizens or Singapore Permanent Residents, physically based in Singapore
- Successfully completed IBF-STS recognized programme (Achieve min. 75% attendance and pass all assessment components)
Programme(s) Commencing between 1 Jan 2022 till 30 Jun 2022
For Singaporeans
below the age of 40 & Singapore Permanent Residents of all age groups
below the age of 40 & Singapore Permanent Residents of all age groups
| Data Storytelling wtih Excel Course Fee |
$1,000 |
| Add 7% GST |
$70 |
| Deduct Enhanced Funding Support (80%) – Inclusive of GST |
$856 |
| Total fee payable by self-funded individual |
$214 |
For Singaporeans
Aged 40 and above
| Data Storytelling with Excel Course Fee |
$1,000 |
| Add 7% GST |
$70 |
| Deduct Enhanced Funding Support (90%) – Inclusive of GST |
$963 |
| Total fee payable by self-funded individual |
$107 |
This support is in addition to wage support provided under the Job Support Scheme, announced at the Resilience and Solidarity Budgets.
For more information, please refer to the links above in “this course eligible for”.
Participants are eligible for IBF enhanced course fee subsidies up to 90%.
Eligible Individuals Include:
Programme(s) Commencing between 1 Jan 2022 till 30 Jun 2022
- Company-sponsored individuals or self-sponsored participants
- Singapore Citizens or Singapore Permanent Residents, physically based in Singapore
- Successfully completed IBF-STS recognized programme (Achieve min. 75% attendance and pass all assessment components)
Programme(s) Commencing between 1 Jan 2022 till 30 Jun 2022
For Singaporeans
below the age of 40 & Singapore Permanent Residents of all age groups
below the age of 40 & Singapore Permanent Residents of all age groups
| Data Storytelling with Excel Course Fee |
$1,000 |
| Add 7% GST |
$70 |
| Deduct Enhanced Funding Support (80%) – Not including GST |
$800 |
| Total fee payable by self-funded individual |
$270 |
For Singaporeans
Aged 40 and above
Aged 40 and above
| Data Storytelling with Excel Course Fee |
$1,000 |
| Add 7% GST |
$70 |
| Deduct Enhanced Funding Support (90%) – Not including GST |
$900 |
| Total fee payable by self-funded individual |
$170 |
TAG is available for training programmes commencing between 1 Jul 2021 and 30 Jun 2022 (both dates inclusive) and completed no later than 30 September 2022
| Training Allowance Grant (TAG) at $10 per training hour for eligible company-sponsored individuals (paid out after course completion) |
For completing this course $160 |
This support is in addition to wage support provided under the Job Support Scheme, announced at the Resilience and Solidarity Budgets.
For more information, please refer to the links above in “this course eligible for”.
- IBF Programme Code
- SkillsFuture Programme Code
Please click here if the window does not open.