Starting the recruitment and selection process is one of the most time-consuming tasks for the HR manager and HR team.
Information about the excel recruitment tracker template
At Kenjo, we've created this excel recruitment tracker template to facilitate daily tasks, and help you reduce the time spent on hiring.
With this template you can:
- See the number of positions available.
- Analyse the number of candidates available.
- Have a funnel of the complete selection process.
- Know the statistics of the candidates rejected by the company and the reasons why.
- Know the statistics of the reasons why a candidate has rejected the offer.
- Know the entry platforms that are generating the highest volume of candidates applying to you.
In addition, all this information can be personalised according to:
- Offer status.
- Department.
- Type of available positions.
- Offices.
- Opening dates of available positions.
How to use the Excel recruitment tracker template for companies?
STEP 1: Create a copy of the template
Follow this link to download the excel recruitment tracker template.
STEP 2: Edit the information with the data of your company
To complete the information with your company’s data, first read the instructions tab where you will find tips and recommendations to help you fill out the information correctly.
Once you have read the instructions, go to the following tabs:
- Data validation: Fill in your data such as the names of the departments, the open positions to hire new employees, companies (in case there is more than one), offices, status of the offers, types of contract, name of each phase of the recruiting funnel ...
- Employee information: Here you can insert the information of potential future employees with the information previously filled in the "Data validation" tab.
Excel template
STEP 3: Analyse the information on the dashboard
Have you already completed all the information? Wasn’t it easy?
Now you can analyse the data you entered in the “Employee Information” tab.
Go to the Dashboard tab to have an overview of the recruitment process.
- Number of candidates per open position
From here you can see the number of candidates for each available position.
In this manner, you can see how many candidates there are for the different available positions.
To make your life easier, you can filter the information to see only the positions related to a single department.
- Candidate funnel
Organize your funnel according to your needs, you can start with a first sentence that is "Curriculum Screen", continue with a "call", continue with "interview with manager" and finally close the process with "cultural interview" and "hired" .
Do you have your own recruiting funnel? Then let’s get going!
- Reasons for rejection (company and candidates)
*For this section we have developed an automated process so that only those candidates whose status begins with "7 - name" are shown, with the name being the one you want to give them.
Eg: Data validation → Recruitment funnel → "7 - rejected"
Through these graphs you will be able to analyse the main reasons why your company rejected candidates or why a potential candidate has rejected your offer.
- Reasons for rejection (company and candidates)
Portals are commonly used to attract candidates however their statistics are rarely analysed to show you which ones are working best for your organisation.
For this we have created a graph where you will be able to evaluate the different portals and see which ones are working best for your company.
Would you like to digitise the employee recruitment process and have all the human resources tools in a single platform?
If yes, get to know Kenjo, the all-in-one tool for HR managers.