#HariKhamis: “Seperti katak di bawah tempurung.”

Sepanjang kerjaya saya, MS Excel telah menjadi lebih daripada sekadar alat – ia telah menjadi senjata rahsia saya. Daripada analisis data yang mendalam kepada laporan yang elegan, Excel membuka banyak pintu untuk saya. Malah, berkali-kali, pujian daripada bos saya tentang kemahiran Excel saya membuatkan saya terasa terapung, dibawa ke awan ketujuh. Betul! Bayangkan duduk dalam … Read more

More HR Excel Formulas

Well, since you guys quite loved my post yesterday, here are some more of the formulas that I have actively used to help my job when I was still in corporate: 1. Confirmation Rate of New Employees. This metric helps assess the effectiveness of our onboarding process and training programs. A high confirmation rate indicates … Read more

Some Excel HR Formulas

1. Turnover Rate. Calculates the turnover rate, which shows the % of employees who left the company over a specified period. High turnover rate can indicate potential issues with recruitment, work environment, or job satisfaction. Monitoring this rate helps in retaining valuable employees and reducing recruitment costs. Formula: =(Number of Employees Who Left / Average … Read more

SMART HR Generalists

Setting SMART goals is crucial for all professionals as it provides clear direction and ensures that efforts are focused on achieving specific, measurable outcomes. HR included. However, the “Measurable” component is often challenging, as HR goals can be inherently qualitative. To overcome this, HR Generalists can focus on identifying key metrics that demonstrate their impact … Read more

Cracking the HR Code with Excel!

=IF(EmployeePerformance=”Excellent”, “More Work, Same Pay”, “Same Work, Less Pay”) =CONCATENATE(“Dear”, ” [EmployeeName],”, CHAR(10), ” We regret to inform you that”, CHAR(10), “No increment for you this year.”) =CHOOSE(MAX(MIN(1,ROUNDUP(CompanySales/50000,0)),6),”Boss is Confused”,”Boss is Grumpy”,”Boss is Meh”,”Boss is Satisfied”,”Boss is Happy”,”Boss is Ecstatic”) =CORRELATION(EmployeeEngagement, CoffeeConsumption) =IF(OfficeEvents=”Team Building”, “Forced Fun Time”, IF(OfficeEvents=”Performance Review”, “Anxiety Overdrive”, “Cake Day”)) =COUNTIFS(TeamMembers, “Swifties”, … Read more

Half Lie

What’s in the dark will come to light. Honesty is the best policy. Almost always. #Dugaan #InterviewTips

The Unemployed Chronicles: Paid Partnership

Today, I’m excited to share a paid partnership video with CAD Training Centre. It all started when Vyasa reached out to me on LinkedIn, “Just saw your TikTok la… Makcik Bebel!” We met and talked about some experimental ideas and today, I want to express my gratitude to Vyasa for being such a good sport … Read more

#HariKhamis: “Satu titik nila, rosak susu sebelanga.”

Kehadiran kita mungkin nampak kecil, tetapi ia boleh membawa impak besar kepada pasukan kita. Kerja berpasukan bermakna setiap anggota pasukan bergantung kepada yang lain untuk mencapai matlamat bersama. Bila kita tidak hadir atau lambat, seseorang anggota pasukan mungkin terpaksa menanggung beban lebih atau mengambil tanggungjawab tambahan yang sepatutnya kita pikul. Tugas-tugas yang tertangguh. Keputusan yang … Read more

#Ageism

Rejecting a candidate in their 50s for not being ‘long-term’ when your last three hires barely made it past 3 years. 🤨 #Dugaan #HiringLogic

Navigating Leave Approval

Another common question I receive is, “My leave was submitted weeks ago, but my boss just rejected it, citing a lack of manpower. Is this even legal?” Unfortunately, it is. Submitting leave and having it approved are two different things. When we request leave, it doesn’t automatically translate to approval. Legally, you need approval before … Read more

AuntyHR®

Also known as Professional Bimbo

Footer-01

Ku Sim Ling, fondly known as AuntyHR® on social media, is a seasoned HR expert with 20 years of experience in the workforce solutions industry. With half a million followers across LinkedIn, Instagram and TikTok, she's influencing the HR landscape from Malaysia.

CCN-Logo-03

Cursors Choice Network (M) Sdn Bhd
Registration: 202501053986 (1655392­V)

© AuntyHR™ 2026  ♡ Privacy Policy
All rights reserved. Site handcrafted by Eric Siew.