Daily HR Ops & Excel Automation

I’m looking for reliable support with the full run of our daily HR administration. The bulk of the work centres on two areas that urgently need tightening up: attendance and leave. Right now everything is logged manually in paper sheets or basic Excel tabs, so I need you to rebuild this into a smarter workbook that:

• calculates working hours automatically from in-out times,
• refreshes attendance data in real time (as soon as new rows are entered), and
• produces clear monthly summaries I can forward straight to management.

Alongside that core file, you’ll handle routine HR tasks—entering new-hire data, maintaining personnel records, tracking leave balances, and preparing official letters or notices. Accurate payroll data will flow from the cleaned attendance sheets, so precision in every cell is essential.

You’ll be working in Microsoft Excel and Word every day, so strong command of formulas, pivot tables, conditional formatting, and clean document layout is a must. I’ll share legacy templates, you’ll migrate or improve them, and each update must be delivered on the deadlines we agree.

If you’re meticulous with data, comfortable with HR documentation standards, and quick in Excel, let’s streamline these processes together.