Microsoft Excel Foundation to Intermediate

2 days

HRD Corp claimable

Runs in-house for your team

Overview

This programme takes clerks, officers, executives, supervisors, administrators and managers from the basics of Excel to intermediate skills for day-to-day business work.

The early sessions cover the interface, data entry, formatting, number formats and worksheet management, then formulas with SUM, AVERAGE, COUNT, MAX and MIN. Participants also compare workbooks side by side and set up reports for printing. The intermediate part adds relative and absolute references, named ranges, COUNTIF, SUMIF, IF and IFERROR, Excel tables with sorting and filtering, and charts.

By the end, participants can analyse data with conditional functions, manage it in tables and present it in charts.

Module topics

  • Getting started in Excel
  • Formatting reports and managing worksheets
  • Basic formulas and functions
  • Comparing worksheets and workbooks
  • Setting up reports for printing
  • Relative, absolute and named references
  • Conditional and logical functions
  • Managing data with Excel tables
  • Charts and chart elements

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