Workplace Productivity using Excel– Intermediate Level

This image has an empty alt attribute; its file name is Path-181.svg1 Day Course
SkillsFuture Credit Eligible
PSEA, UTAP Eligible
Free Enquiry Book Class Corporate Booking

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

  1. Education Level:
    • Minimum: Primary Level
    • Language: Workplace Literacy and Numeracy Level 2 (WPLN: Speaking, Writing, Listening, reading, and Numeracy at ESS level 2).
  2. Pre-requisites:
    • Basic understanding in using Microsoft Excel.
  3. 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
Duration1 Day
8 hours
*Can be paid via SkillsFuture, Bank Transfer, PayNow

Available in: English

WhatsApp Chat Button

Book Class Now!

WhatsApp Chat Button