Microsoft Excel Intermediate (1 day)

1 day

HRD Corp claimable

Runs in-house for your team

Overview

This programme is for clerks, officers, executives, supervisors, administrators and managers who know the Excel basics and want to do more with formulas, data and charts.

Participants practise relative, absolute and mixed references, then summarise data with COUNTA, AVERAGEA, COUNTIF, AVERAGEIF and SUMIF, and return results by condition with IF and IFERROR. They turn data ranges into tables, remove duplicates, sort and filter, and add subtotals. Conditional formatting, chart creation and chart formatting follow, along with arranging workbooks side by side for comparison.

Participants leave able to highlight values with conditional formatting and present data in clear, well-formatted charts.

Module topics

  • Relative, absolute and mixed references
  • Summary and conditional functions
  • Organising data with Excel tables
  • Conditional formatting rules
  • Creating and formatting charts
  • Managing multiple workbook windows

Who runs this programme

Anne Hui San Teoh

Excel, Power Query and Copilot trainer

Shalina Hj Mohd Salleh

Power BI, Excel, Google Workspace and AI tools trainer

Subashkaran Perumalu

Excel, Power BI and programming trainer

At a glance

1 day

In-house at your premises or a venue you choose

HRD Corp claimable

Prefer to chat? WhatsApp us on 012-600 4488.

Ask about this programme

Tell us your team size and preferred dates. Our team will reply with the outline and a quotation.

Programme enquiry