Workplace Productivity using Excel– Intermediate Level
 | 1 Day Course |
 | SkillsFuture Credit |
| UTAP Eligible |
- Course Overview
- Course Outline
- Requirments
- FAQs
Workplace Productivity using Excel – Intermediate Level
Course Duration: 1 Day (8 Hours)
Course Provider: ASSOCIATES CONSULTING PTE. LTD.
Course Reference Number: TGS-2024051267
UEN: 200006697N
Funding Validity Period: 22 Nov 2024 – 21 Nov 2026
Course Overview
This Intermediate Excel course builds upon the foundational knowledge presented in Workplace Productivity using Excel (Basic level) and will help start you down the road to creating intermediate and advanced level workbooks and worksheets that can help deepen your understanding of organisational intelligence. The ability to analyse massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organisation that is able to compete at a high level.
Course Title
Workplace Productivity using Excel – Intermediate Level
Mode of Training
This course will take place in person, in a classroom.
Available in:
This Excel Intermediate Level course is available in English
Course Funding Options
Eligible Singaporeans can use SkillsFuture Credit to offset course fees, while NTUC members can utilise UTAP for up to 50% funding (capped at $250 per year). Companies can also benefit from Absentee Payroll (AP) funding at $4.50 per hour, capped at $100,000 per year.
Funding Eligibility Criteria
| Individual Sponsored Trainee | Company Sponsored Trainee |
| – Singapore Citizens or Singapore Permanent Residents – From 1 October 2023, all attendance-taking for SkillsFuture Singapore’s (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses – Trainee must achieve at least 75% attendance – Trainee must pass all prescribed tests/assessments and attain 100% competency – We reserve the right to claw back the funded amount from trainee if he/she does not meet the eligibility criteria | – Singapore Citizens or Singapore Permanent Residents – From 1 October 2023, all attendance-taking for SkillsFuture Singapore’s (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses – Trainee must achieve at least 75% attendance – Trainee must pass all prescribed tests/assessments and attain 100% competencyWe reserve the right to claw back the funded amount from trainee if he/she does not meet the eligibility criteria |
Funding Types
| Individual Sponsored Trainee | Company Sponsored Trainee |
| SkillsFuture: – Eligible Singapore Citizens can use their SkillsFuture Credits to offset course fee payable after funding UTAP: – This course is eligible for Union Training Assistance Programme (UTAP) – NTUC members can enjoy up to 50% funding (capped at $250 per year) under UTAP | Absentee Payroll (AP) Funding: – $4.50 per hour, capped at $100,000 per enterprise per calendar year – AP funding will be computed based on the actual number of training hours attended by the trainee |
Workplace Productivity using Excel – Intermediate Level Content
LO 1: Use Microsoft Excel Functionalities
- Ranges
- Specialized Functions
- Logical Functions
- Date and Time Functions
- Text Functions
- Financial Functions
LO 2: Apply lists functionalities to interpret data categorization into areas for process improvement
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
LO 3: Use Conditional Formatting to enhance quality data collected by scrubbing and removing duplicates
- Create and Modify Tables
- Manage Workbook and Worksheet Views
- Insert, Delete, and Adjust Cells, Columns, and Rows
- Basic Conditional Formatting
- Intermediate Conditional Formatting
- Advanced Conditional Formatting
LO 4: Implement Lookup Functions and Formula Auditing to enhance the quality collected data.
- Formula Auditing
- Lookup Functions
Certification
You will receive a Statement of Attainment (SOA) from SkillsFuture Singapore upon successful completion of this module and its assessment
Visit this page for more Microsoft Office courses in Singapore.
Minimum Entry
Education Level:
- Recommended to have some working experience.
- Minimum: Primary Level
- Language: Workplace Literacy and Numeracy Level 2 (WPLN: Speaking, Writing, Listening, reading, and Numeracy at ESS level 2).
Pre-requisites:
- Basic understanding in using Microsoft Excel.
Working Experience
Relevant Job Role(s)
- HR and Accountant
- Administrative
- Operations
- Logistic
Workplace Productivity using Excel– Intermediate Level
Related Courses
Microsoft Office Excel Course
This Intermediate Excel course builds upon the foundational knowledge presented in Workplace Productivity using Excel (Basic level) and will help start you down the road to creating intermediate and advanced level workbooks and worksheets
$457.80
Microsoft Office Powerpoint Course
Microsoft Office Powerpoint Course equip learners with the knowledge and abilities to plan, design, and script presentations that fulfill defined objectives and meet the information needs of the target
$490.50
Present with Flair in PowerPoint
Advanced Microsoft Powerpoint Course is a certification programme for learners who wish to create effective, high-impact presentations using advanced features and who need to be able to prove their skills in this area.
$490.50
| FULL COURSE FEE (Non Singaporeans and Singaporeans/PRs Below 21) | $327.00 |
|---|---|
| SINGAPOREAN 40 YRS AND ABOVE (AFTER SUBSIDY) | $117.00 |
| SINGAPOREAN 21-39 YRS/PR (AFTER SUBSIDY) | $177.00 |
| Duration | 1 Day (8 hours) |
Available in: English
Book Class Now!
