The value of diversity in employees has been recognized and appreciated more in recent times. Diversity in all aspects is good for a company. In this article, I will explain how you can calculate a Diversity Percentage % KPI for your company. I will use Racial Diversity in my example below. However, this concept can […]
Category: Ask Your Excel Question
Calculating Gender Diversity % in Excel
Gender diversity is one among many different aspects of diversity, A measure of Gender diversity has become a critical part of Human Resource management in recent years. For more on this topic, please see A study by Mckinsey on ‘Women in the Workplace 2020’ An article by Forbes on ‘What to come in 2021 for […]
Calculating Average Employee Tenure in Excel
In this article, we will calculate a common HR KPI – Average Employee Tenure, using simple formulas in Excel. Data Let’s assume the dataset has a list of employees with a Status column to indicate Active vs Inactive employees. The table is converted to an Excel Table with name T_EMP Definition Tenure is the time […]
Calculating Number of Employees in Excel
HR metric – # of Employees A very common metric in HR domain is # of Employees. How many employees are active in our company? Employees who have not started should not be counted as active. Employees who have given notice but still employed as of today should be counted. Essentially, only employees who are […]
Ask Your Excel Question – New Video Series – How to create drop down list in Excel
Welcome to a new series ‘Ask Your Excel Question’. In this series, I provide solutions (with video demos) to questions that I receive from our community. These videos will be short and to the point, addressing a specific feature or concept or a formula. If you would like to be notified of these videos, please […]
