Category: HR

Calculating Diversity Percentage % in Excel

Calculating Diversity Percentage % in Excel

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 […]

Calculating Gender Diversity % in Excel

Calculating Gender Diversity % in Excel HR KPI Gender Diversity

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

Calculating Average Employee Tenure in Excel HR KPI Avg. tenure

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

Calculating Number of Employees in Excel HR KPI Number of Emp

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 […]

Human Resource Toolkit – Excel Templates – Support

This is the support page for the Human Resources Toolkit – Excel Templates. Our Human Resource Toolkit – Excel Template Page This product is a bundle of 8 individual Excel Templates. The following are links to those individual templates. Please visit them for help material around each of them. If you have questions about the bundle, […]

Employee Retention Dashboard Google Sheet Template – User Guide

In this article, we will explain step by step how to use the Retention Dashboard Google Sheet Template. To learn more about the features of the template and to download, please visit the Product page. OVERVIEW OF STEPS Enter data in Employees Data sheet Refresh Calculations View/Interact with 3 Dashboards STEP 1: ENTER DATA IN […]

Employee Vacation Planner – Free Google Sheet Template

Employee Vacation Planner – Free Google Sheet Template

As a team leader or a manager of a team, it is important to know the staff coverage available every day, especially during the holiday season. This Google Sheet Template is developed to provide a simple and effective solution to help assess the coverage of team members’ availability during a particular month.  This Google Sheet […]

Retention Dashboard – Excel Template – Step by Step User Guide

In this article, we will explain step by step how to use the Retention Dashboard Excel Template. To learn more about the features of the template and to download, please visit the Product page. OVERVIEW OF STEPS Enter data in Employees Data sheet Refresh Calculations View/Interact with 3 Dashboards VIDEO DEMO STEP 1: ENTER DATA […]

Retention Dashboard – Excel Template – Support Page

Thanks for visiting the support page for Retention Dashboard Excel Template which can help simplify employee retention tracking in your organization. The following are the support articles to help you get started with using the template. If there are any questions not addressed here, please drop a comment and I will add article/video demo about […]