By sector · In-house at your premises
Excel for HR — HRDF claimable Excel, Power BI and Copilot training for HR teams
Headcount, turnover, leave and payroll checks — and the one HR spreadsheet that pays for the training: your HRDF levy tracker.
Excel for HR teams in Malaysia covers headcount, payroll data and training records — and the training itself is HRDF claimable.
- HR holds more structured data than almost any other department, and most of it lives in spreadsheets exported from a payroll or HR system and then reworked by hand.
- Headcount by department, monthly joiners and leavers, leave balances, overtime, training attendance: each one starts as a raw export and ends as a table someone in management asked for.
- The skill that changes HR reporting is not a clever formula.
- It is keeping one clean employee list as the source of truth and building every report from it, so a headcount figure and a turnover figure never disagree because they came from two different versions of the same file.
- This page covers the HR data work our in-house courses are built around, the statutory payroll columns that make HR spreadsheets unusually easy to get wrong, and how to use Copilot for HR writing without putting personal data where it should not go.
The HR reports that eat the week
Headcount and turnover are the two numbers every management meeting asks for, and both depend on dates: join date, confirmation date, resignation date, last working day. Once the team can calculate tenure, count active staff as at any date with COUNTIFS, and group leavers by month and reason in a PivotTable, the monthly HR report becomes a refresh instead of a rebuild.
Leave and attendance follow the same logic at a larger scale — thousands of rows of leave transactions summarised into balances by person and type. Overtime and shift allowances add a calculation layer that benefits from lookup tables rather than rates typed into formulas.
Excel for HR: payroll reconciliation and the statutory columns
A Malaysian payroll export carries a set of statutory columns that HR or payroll staff check every month: EPF, SOCSO and EIS contributions, with separate employee and employer shares, and PCB, the Potongan Cukai Bulanan or monthly tax deduction remitted to LHDN. SOCSO and EIS are both administered by PERKESO; EIS falls under the Employment Insurance System Act (Act 800).
The spreadsheet work is reconciling those columns: this month against last month, the payroll register against the amounts remitted, and individual lines where a change in salary, a new joiner or a leaver should have changed the contribution. XLOOKUP against the previous month, a variance column and conditional formatting to flag anything unexpected turns a line-by-line check into an exception list.
The course teaches the technique on your own export layout. It does not teach contribution rates or tax computation, which change and belong to your payroll system and the agencies’ published schedules.
Tracking your HRDF levy and training claims
HR usually owns the HRDF relationship, and a simple tracker saves real money. Registered employers pay a levy of 1% of monthly wages once they have 10 or more Malaysian employees, with 0.5% optional at 5 to 9. Unutilised levy is forfeited after 2 years, down to a floor of RM10,000, and a successful claim resets the clock.
A tracker built in Excel lists each levy month, the claims made against it, grant applications pending and training records by employee, so HR can see which balance is closest to expiry and plan courses before it lapses. The same list answers the annual question of who has been trained in what.
| Tracker column | What it answers |
|---|---|
| Levy month and amount | How much was contributed, and when each amount reaches its two-year limit |
| Grant application date and status | Whether the application went in early enough for it to be approved at least 14 days before the training starts |
| Course, provider, dates, participants | Who attended what, for the training record and the claim |
| Claimed amount against the ACM ceiling | Whether a group claim is within RM10,500 per full day |
| Claim submitted and paid | Which balance has been used and which is still exposed |
HR dashboards in Power BI
Once headcount, turnover and leave come from one clean employee table, Power BI turns them into a dashboard that department heads can filter to their own team. The build is a small data model: an employee table, a date table, and fact tables for movements, leave and training.
Row-level security matters more in HR than anywhere else in the business. A dashboard shared across departments should show each manager their own people only, and the Power BI course covers when and how to apply it before a report is published.
Copilot for HR writing, with care over personal data
Copilot is useful for the writing side of HR: first drafts of job descriptions, policy wording, interview question sets and summaries of long guidelines. The Copilot course teaches prompting for these tasks and, as important, reviewing what comes back — a generated job description will confidently include duties or requirements you never asked for.
HR also handles the most sensitive personal data in the organisation, and processing personal data in commercial transactions in Malaysia is governed by the Personal Data Protection Act 2010 (Act 709). The practical rule taught on the course is to keep identifiable employee data out of prompts unless your organisation’s Microsoft 365 setup and policies have been cleared for it, and to confirm that position with your IT and data protection lead first.
Excel for HR: HRDF claimable courses that fit
Excel Training Malaysia
Two days at your office, taught on the spreadsheets your team already uses, from the first formula to a working dashboard.
Power BI Training Malaysia
Two days, at your office, ending with a report built on your own data and published for the people who need to see it.
Copilot Training Malaysia
One day at your office, on your own documents and meetings, so Copilot becomes part of the working week instead of a novelty.
Excel for HR: frequently asked questions
›What Excel skills does an HR executive need?
Clean data entry with Excel Tables, date functions for tenure and leave, COUNTIFS and SUMIFS for headcount and cost, XLOOKUP for matching payroll months, and PivotTables for turnover by department and reason. The two-day Excel course covers all of these on HR files.
›Can the course use our real payroll export?
It can use its layout without its contents. Send a file with names and IC numbers removed, or we build a look-alike with your columns and invented figures. Real employee data does not need to leave your systems for the course to work.
›Does the course teach EPF and PCB calculations?
No. It teaches reconciling and checking those columns in a spreadsheet. Rates and tax computation come from your payroll system and the agencies’ current schedules, which change over time.
›Is Copilot safe to use for HR documents?
It is safe for drafting generic content such as job descriptions and policy outlines. Identifiable employee data should only go into it once your IT and data protection lead have confirmed your setup allows it, in line with your obligations under the PDPA.
›Can HR training itself be claimed from HRDF?
Yes, where the provider and course are registered with HRDF and the grant is applied for before the training. An in-house course is capped at RM10,500 per group per full day under the January 2026 matrix.
Get a quote for HRDF claimable Microsoft training
Tell us the course, your team size, where you are and whether you pay the HRDF levy. Within one working day you get a suggested course shape, next steps on a quote, and how to claim it through HRDF.