Kenjo blog logo
CATEGORIES
LOOKING FOR OUR WEBSITE?
Go to Website
LANGUAGES
Kenjo blog logo
Recruitment

Excel Recruitment Tracker Template

Starting the recruitment and selection process is one of the most time-consuming tasks for the HR manager and HR  team. 

 

 

template CTA

 

 

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.

 

 

template CTA

 

 

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 Recruitment Tracker Template

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.

New call-to-action