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: HR
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 […]
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 […]
Team Vacation Planner Google Sheet Template – Support
This article will present step by step instructions on how to use the Team Vacation Planner Google Sheet template. Purpose This Google Sheet template is designed to help calculate the number of employees available on any day and compare with the number of employees needed on that day in the company. This will help us […]
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 […]
PTO (Paid Time Off) Balance Calculator for Hourly Employee
Download this free Excel template to track and calculate Employee’s PTO accrual balances based on hours worked by the employee. Automatically calculates current PTO balance and projected future balance.