Available locations
No location has been published for this course yet. Please contact us if you need a specific venue.
Course Outline
Course Outline
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
Requirements
Requirements
Pre-requisites
Basic understanding in using Microsoft Excel.
Admission requirements:
- 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).
Course Overview
Course Overview
Course Objectives
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.
Who should attend
Anyone with basic Excel knowledge who wants:
- To improve their data-handling and analytical skills
- To work relevant Job Role(s): HR and Accountant, Administrative, Operations and Logistic
Examples of roles that should attend WSQ Intermediate Level Excel Course
- Administrative Officers / Executive Assistants
- Operations Executives
- Finance Executives / Accounts Officers
- HR Executives / HR Officers
- Sales Coordinators / Sales Executives
- Marketing Executives
- Business Support Officers
- Procurement Officers
Our course is conducted in a classroom setting, providing an interactive and engaging learning experience.
FAQs
FAQs
Frequently Asked Questions about this Workplace Productivity using Excel– Intermediate Level
How will this course help improve workplace productivity?
The course helps participants complete Excel-related tasks faster and more accurately, reduce manual work, and produce clearer reports for decision-making.
Is this course suitable for non-technical roles?
Yes. The course is designed for non-technical roles such as administrative, operations, HR, finance support, and coordination roles.
What tools or software are required?
Participants should have access to a computer with Microsoft Excel installed (recommended: Excel 2016 or later).
Upcoming classes
Showing 0 of 0 runs matching these filters. Clear filters
