Carbonik Blog

Thoughts on Human Resources


Card image cap

Excel Timesheet

Learn how to use Excel to build timesheet that encourage colleagues to fill in

Read More
Card image cap

Excel DataBase - Reporting Lines

Learn how to use function of "vlookup" and "match". Use Excel to sort out who are the supervisors and who are the sub-orindates.

Read More
Card image cap

How to Work Out HR Budget for Next Year?

We can rely on new business plan of coming year, together with the unit cost of each product or service, to calculate the required HR expense of the coming year.

Read More
Card image cap

Replace "Appraisal" by "Check-in"! - (Cont)

Implement "Check In" step-by-step. Using automated HR system to put "Check In" discussion into record. Adopting a more flexible compensation policy to better reflect performance and importance of individual staff.

Read More
Card image cap

How to Work Out HR Budget for Next Year?

Normally we will rely on current-year actual amount (with decent increment) or add together requests from each departments. On the other hand, we can also rely on new business plan of coming year to calculate the required HR expense in an objective manner.

Read More
Card image cap

Regulations HR Practitioners Should Pay Attention

《Competition Ordinance》,《Anti-Discrimination Ordinance》,《Employment Ordinance》are key regulations that HR practioners need to know. Also, will HR practioners be liable to actions of the company?

Read More
Card image cap

Choosing the Right HR System to Improve Efficiency

Set up clear guidelines and streamline work processes. Spare sufficient human resources to choose and implement automated HR system.

Read More
Card image cap

HR System for Appraisal

Appraisal is only part of the HR control cycle. What we need is a comprehensive system for performance management and talent management.

Read More
Card image cap

Use Excel to Build Leave Calendar

Learn how to use function of "choose", "data validation", "countif" and "share workbook". Use Excel to build simple leave calendar and HR System for more sophisticated one.

Read More
Card image cap

How to use Google Form for appraisal?

How to use Google Form for appraisal? We can use Google Form to do survey. With some effort in design we can also conduct appraisal with Google Form before automating with HR system.

Read More
Card image cap

How to use Excel for Shift Management?

Use "Substitute" , "Len" , "Find" , "Indirect" , "Countifs" and "Conditional Formatting" to helf Shift Management.

Read More
Card image cap

How to use Excel to Annual Leave?

How to use Excel to Annual Leave? What is meant by "Anniversary Basis", "Individual Leave Year", "Calendar Year Basis" and "Common Leave Year"?

Read More
Card image cap

HR Book List: The Silo Effect

Learn how "Silo" impacts your company

Read More
Card image cap

Reason of Change in Performance Rating

Avoid over-simplifying the result of performance review and avoid "Simpson Paradox".

Read More
Card image cap

Frequent Appraisal - No More Annual "Headache"

Say goodbye to annual headache of "appraisal" by utilizing automatic HR software with "performance review" capability, so that we can easily and more frequently appraise staff members, provide timely feedback and adjust objectives accordintly.

Read More
Card image cap

Consideration of Hiring Expatriates

Refer to General Employment Policy (GEP), Admission Scheme for Mainland Talents and Professionals (ASMTP) and Immigration Arrangements for Non-local Graduates (IANG) to Hire Expatriates

Read More
Card image cap

Predictive Candidate's Performance

Predicting candidate's performance by General Mental Ability Test, Work Sample Test, Structured Employee Interview, Peer Rating, Job Knowledge Test and T&E Behavioral Consistency Method.

Read More
Card image cap

How to use Excel to Calculate Salary, MPF or Conduct Appraisal?

Learn how to use funtions of "networkdays" , "mmult" , "countif" and data validation in Excel to calculate salary, MPF and conduct appraisal

Read More
Card image cap

Year of Rooster

What to Do in New Year?

Read More
Card image cap

How to Rate Subordinates' Performance?

Sample Comments in Performance Review and Appraisal - Leadership Quality, Communication Skill, Initiative, Team Work, Quality of Work & Customer Service

Read More
Card image cap

Difference between Departments

Using Analysis of Variance (ANOVA) to understand if there is difference in in results between departments.

Read More
Card image cap

How to Conduct Performance Review in an Objective Manner?

Adopting Behaviourally Anchored Rating Scale: listing out different behaviour examples which will be treated as benchmark for evaluating performance target or core competency.

Read More
Card image cap

Giving Negative Feedback & Suggestion for Improvement

An Indispensible Step in Performance Review Pay attention to timeliness of comment and focus on subordinate's need. Last but not least, let your subordinates know how fair you are treating everyone.

Read More
Card image cap

Replace "Appraisal" by "Check-in"!

Annual review is not sufficient. We need more frequent review and speedy feedback.

Read More
Card image cap

Performance Review (Appraisal) 101

How to conduct appraisal and performance review? Remember to align performance review with company's KPI and company's schedule. Let everyone understand its importance and ensure a smooth process of appraisal.

Read More
Card image cap

6 principal of setting appraisal objective

There must be "objectives" before you can "review" anything. Objectives must be specific and consider both teams and individuals.

Read More
Card image cap

Data Privacy of Employee Information in Big Data Era

Data Privacy of Employee Information in Big Data Era

Read More