Excel for HR & Payroll Analysts
Teacher: Paolo Mendoza
About this course
Excel remains the everyday workhorse of Philippine HR and payroll teams, even in companies running a full HRIS. This course builds the practical spreadsheet muscle memory analysts need: pulling clean data from exports, matching records across sheets, summarizing headcount and payroll movement, and presenting numbers management can trust.
Rather than teaching Excel as an abstract tool, every lesson uses realistic HR scenarios: 201 file trackers, payroll registers, SSS/PhilHealth/Pag-IBIG contribution schedules, and monthly headcount reports for management committees.
- Use VLOOKUP, INDEX-MATCH, and XLOOKUP to reconcile employee and payroll data across sheets
- Build pivot tables to summarize headcount, attrition, and payroll cost by department
- Clean messy exports from biometric, payroll, and HRIS systems before analysis
- Reconcile payroll registers against statutory contribution schedules
- Design management-ready dashboards using conditional formatting and charts
- Apply data validation and protection to reduce errors in shared HR files
Course curriculum
8 ModulesStudent reviews
4.5Building our first real headcount dashboard with pivot tables and charts made our monthly HR committee report look genuinely professional.
Paolo explains everything with actual HR examples, not generic finance ones, so it clicked immediately for our payroll team.
The payroll reconciliation module using SUMIFS against our SSS and Pag-IBIG schedules directly fixed a recurring discrepancy we had every cut-off.
Very practical for HR admins like me who inherited messy spreadsheets. Would have liked a bit more on Power Query but the core lessons delivered.
I've used VLOOKUP for years but never really understood INDEX-MATCH until this course. My 201 file reconciliation now takes half the time.
Solid fundamentals course, though as someone already comfortable with pivot tables I wished the later modules went a bit deeper into automation.
Recommended courses
ERPat HRIS Administrator Bootcamp
This bootcamp is built for HR and IT staff who own the ERPat HRIS configuration for their company. You will move beyond …
Performance Management & Appraisals
Performance management is one of the most sensitive responsibilities a Filipino manager carries — it shapes pay, promoti…
Cybersecurity Awareness for Employees
Every employee is a target for cybercriminals, whether they realize it or not. This course builds the everyday habits th…
Payroll Processing Masterclass
This masterclass walks payroll practitioners through a complete Philippine payroll run, from validating attendance and t…
Recruitment Pipeline to Employee Conversion
Hiring the right person is only half the job — the other half is building a pipeline that is fast, fair, and fully docum…
Data Privacy Act Compliance (RA 10173)
The Data Privacy Act of 2012 (RA 10173) governs how Philippine organizations collect, use, and store personal informatio…
Onboarding Experience Design
A candidate's first impression of your company is sealed long before day one, and reinforced or ruined in the first nine…