Microsoft Excel Intermediate (2 days)

2 days

HRD Corp claimable

Runs in-house for your team

Overview

For clerks, officers, executives, supervisors, administrators and managers who know the Excel basics, this programme adds intermediate formulas, data tools and charts.

Participants set up range names with the Name Box, Define Name and Name Manager, then work through COUNTIFS, SUMIFS, nested IF and IFS, and the database functions DSUM, DCOUNT and DAVERAGE. They build Excel tables, sort and filter data and set data validation rules using lists, dates and formulas.

Later sessions cover conditional formatting, charts and sparklines, and page setup with Page Break Preview and custom views. The aim is that participants can summarise data by condition, keep data entry clean and present results in charts.

Module topics

  • Cell references and range names
  • Conditional summary and logical functions
  • Database functions such as DSUM
  • Excel tables and data validation
  • Conditional formatting and charts
  • Adding and editing sparklines
  • Page views and multiple 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

2 days

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