Practical training for modern teams Plan an in-house programme

Office Productivity & Data Tools

Microsoft Excel (Basic to Advanced)

Progress from confident spreadsheet basics to formulas, analysis and reporting techniques that improve speed and accuracy.

Course overview

Turn learning into workplace capability.

Progress from confident spreadsheet basics to formulas, analysis and reporting techniques that improve speed and accuracy. Participants work through realistic Malaysian workplace scenarios, guided practice and structured reflection so they can apply the learning immediately.

The programme combines concise instruction, guided discussion, practical exercises and an action plan. Examples can be tailored to your industry, policies and participant roles for in-house delivery.

By the end

Learning outcomes

  • Structure, format and validate clean spreadsheet data.
  • Use logical, statistical and lookup formulas correctly.
  • Summarise data with PivotTables and visual reports.
  • Apply efficient workflows that reduce repetitive work and errors.

Practical curriculum

What participants will cover

A focused sequence designed for application, reflection and measurable next steps.

01

Excel Foundations and Data Entry

Explore excel foundations and data entry through concise instruction, relevant examples and a guided Microsoft Excel (Basic to Advanced) workplace activity.

02

Essential Formulas and References

Explore essential formulas and references through concise instruction, relevant examples and a guided Microsoft Excel (Basic to Advanced) workplace activity.

03

Logical and Lookup Functions

Explore logical and lookup functions through concise instruction, relevant examples and a guided Microsoft Excel (Basic to Advanced) workplace activity.

04

Tables and Data Cleaning

Explore tables and data cleaning through concise instruction, relevant examples and a guided Microsoft Excel (Basic to Advanced) workplace activity.

05

PivotTables and Charts

Explore pivottables and charts through concise instruction, relevant examples and a guided Microsoft Excel (Basic to Advanced) workplace activity.

06

Advanced Productivity and Controls

Explore advanced productivity and controls through concise instruction, relevant examples and a guided Microsoft Excel (Basic to Advanced) workplace activity.

Who should attend

Executives, administrators, finance teams, analysts and regular spreadsheet users.

01

Public class
Join a scheduled small-group programme at our Petaling Jaya venue.

02

In-house team
Customise the examples, timing and exercises for your organisation.

03

Live online
Instructor-led virtual delivery with activities and real-time feedback.

Course questions

What organisations usually ask

Is Microsoft Excel (Basic to Advanced) HRD Corp claimable?

The programme can be proposed as HRD Corp claimable training, subject to the employer’s eligibility, current scheme rules, course registration and final approval.

Who should attend this course?

Executives, administrators, finance teams, analysts and regular spreadsheet users.

How long is the course and how can it be delivered?

The standard duration is 2 days. Delivery can be arranged face-to-face, live online or in-house for your team, subject to trainer availability.

Build a stronger team

Bring Microsoft Excel (Basic to Advanced) to your organisation.

Tell us your preferred dates, team size and learning priorities. We will prepare a tailored programme and quotation.

*HRD Corp claimability is subject to employer eligibility, current scheme rules, course registration and approval. Public fees are indicative until confirmed in writing. Certification pathways may carry additional requirements set by the relevant authority or awarding body.

WA