IEA: INTERMEDIATE EXCEL ANALYTICS
INTERMEDIATE EXCEL ANALYTICS
Course Duration
Mode of Assessment
Written Assessment, Practical Performance
Who Should Attend
- Individuals holding supervisory or management roles in their organisation and are leading a team or a department or division.
- Job Roles from the Retail trade and other sectors who has the responsibility to do basic data analysis using Microsoft Excel at intermediate level
- Operations Executive
- Marketing Executive
- Procurement Executive
Course Overview
The Intermediate Excel Analytics course is designed to elevate your Excel skills to an intermediate and beyond level, focusing on practical applications for data analysis. Throughout the course, you will delve into the details of collected data, gaining insights into categorization for process improvement. Additionally, you'll explore intermediate Excel functionalities, equipping yourself with valuable tools to enhance data quality and conduct meaningful analysis.
Course Schedule
Next available schedule
Course Objectives
Upon completing this course, participants will be able to:
- Understanding data details to identify areas for process improvement.
- Develop proficiency in intermediate Microsoft Excel functionalities to utilize Excel spreadsheets for in-depth data analysis.
- Learn techniques to enhance collected data quality through scrubbing and removing duplicates.
Pre-requisites
The admission requirements are:
- Read, write, and speak English at WPL Level 4
- Manipulate numbers at WPN Level 4
Course Outline
Learning Unit 1. Details of the Collected Data: Explore the interpretation of collected data, focusing on categorization for process improvement.
Learning Unit 2. Intermediate Excel Analytics: Gain proficiency in intermediate Microsoft Excel functionalities and apply them to enhance data quality through scrubbing and removal of duplicates.
Certificate Obtained and Conferred by
- Statement of Attainment (SOA) from SkillsFuture Singapore
After passing the assessment(s), participants will receive a SOA from SkillsFuture Singapore, certifying that they have achieved the following Competency Standard(s):
-
- LOG-LDR-2006-1.1 Data and Statistical Analysis
Additional Details
Medium of Instruction: English
Trainer to trainee ratio: 1:20
Mode of Delivery: Physical class
Price
|
|
Individual Sponsored |
Company Sponsored |
||||
|
Non-SME |
SME |
|||||
|
Before GST |
After GST |
Before GST |
After GST |
Before GST |
After GST |
|
|
Full Course Fee (For Foreigners and those not eligible for subsidies) |
$600.00 |
$654.00 |
$600.00 |
$654.00 |
$600.00 |
$654.00 |
|
For Singapore Citizens aged 39 and below and For all Singapore Permanent Residents (The minimum age for individual sponsored trainees is 21 years) |
$300.00 |
$354.00 |
$300.00 |
$354.00 |
$180.00 |
$234.00 |
|
For Singapore Citizens aged 40 years and above |
$180.00 |
$234.00 |
$180.00 |
$234.00 |
$180.00 |
$234.00 |
Funding Eligibility Criteria
|
Individual Sponsored Trainee |
Company Sponsored Trainee |
|
|
Remarks
|
Company Sponsored Trainee |
|
|
SkillsFuture Credit:
UTAP:
PSEA:
|
Absentee Payroll (AP) Funding:
|
PSEA SkillsFuture eligibility & TGS-code Options
To check for Post-Secondary Education Account (PSEA) eligibility for this course, visit:
SkillsFuture (TGS-2023021825) for Face-to-Face class
Terms & Conditions apply. NTUC LearningHub reserves the right to make changes or improvements to any of the products described in this document without prior notice.
Prices are subject to other LHUB miscellaneous fees.
| Batch ID | Course Period | Course Title | Funding Available |
Duration (Hours) |
Session (Hours) |
Venue | Available Seats |
Online Payment |
|---|
