Your search for a simple and effective solution to manage your recruiting process ends here! Get key recruiting metrics and an amazing, fully interactive dashboard in Power BI with this template. Track status of applicants, view key recruiting metrics like the number of open positions, Conversion %, Hiring cost, to name a few, all in […]
Category: HR
2023 Employee Annual Bonus Planner Power BI Template
Download this free Microsoft Power BI template to get a fully automated employee bonus planner
2023 Employee Annual Bonus Planner Excel Template
Download this free Microsoft Excel template to get a fully automated employee bonus planner
2023 Leave Tracker Power BI Template
Download this free Power BI template to calculate and track employee leaves. Track vacation of multiple employees including partial days of leave.
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
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 […]