Workplace Productivity using Excel– Intermediate Level
1 Day Course |
SkillsFuture Credit Eligible |
PSEA, UTAP Eligible |
Course Overview
Workplace Productivity using Excel – Intermediate Level
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
Entry Requirements
- Education Level:
- 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:
- Recommended to have some working experience.
Relevant Job Role(s)
- Administrative
- Operations
- Logistic
- HR and Accountant
Course Content
Course 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.
- Lookup Functions
- Formula Auditing
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.
Course Feature
Course Feature
Course Provider: Associates Consulting Pte. Ltd.
UEN: 200006697N
Course Reference Number: TGS-2024051267
Mode Of Training: Classroom
Funding Validity Period: 22 Nov 2024 – 21 Nov 2026
FULL COURSE FEE (Non Singaporeans and Singaporeans Below 21) | $327.00 |
---|---|
SINGAPOREAN 40 YRS AND ABOVE (AFTER SUBSIDY) | $117.00 |
SINAGPOREAN 21-39 YRS/PR (AFTER SUBSIDY) | $177.00 |
Duration | 1 Day 8 hours |
Available in: English