Job Candidate Tracker a document that easily stores data of applicants for a particular post all in one sheet and further helps to track and scrutinize applicants efficiently.
Usually, HR requires workforce management during the recruitment process. They need to micromanage everything from receiving applications until the hiring of employees.
We have created a Job Candidate Tracker Excel Template for easy management of job applications.
This template can be useful for HR assistants, HR professional and other business entities to efficiently and effectively manage the recruitment process
You can download the same in Apple Numbers from the link below:
Recruitment Tracker Apple Numbers Template
Let us discuss the contents of the template in detail.
Contents of Job Candidate Tracker Template
This template consist of 3 sections
- Header Section
- Applicants Details Section
- Interview Process Section
1. Header Section
The header section consists of the company name, company logo and heading of the sheet ” Job Candidate Tracker.
Additionally, it consists of Job position criteria like job position, department and minimum experience.
When you define the minimum experience for the job position it will ease the initial scrutinizing process. We will discuss it later in the article.
2. Applicants Detail Section
Initial 10 columns of the sheet below the header contain the applicant’s data as given below:
Sr. No: Serial number of the applicant.
Application Receive Date: Enter the date on which you have received the application.
Name of Candidate: Name of the applicant for the required job posting.
Contact No.: Contact number of the applicant.
Consultant: Enter the consultant name if the applicant has come through any hiring agency/consultant.
Previous Organization: The name of the company where the applicant currently works or the last worked company.
Experience in Yrs: Applicant’s years of experience relevant to the job posting.
Division: Division in which the applicant currently performs his duty.
Application Status: This cell consists of a predefined logical formula to simplify your process of scrutinizing.
An IF statement has been used here to automatically rejects the application if the years of experience are below the required years.
If the years are less than the years mentioned in minimum experience it will display “Rejected” in the cell. You can change the criteria according to your needs.
The formula used here is =IF(G7=””, “”, IF(G7<$D$4, “Rejected”, “”)).
Remarks: The first remark section is for recommendations from the scrutinizer.
3. Interview Process Section
The interview process section consists of 3 step interview process.
1st Interview section consists of subheadings like date of interview, the name of interviewer, applicant’s status and remarks from the interviewer.
The applicant status consists of the drop-down list for approved, rejected and on hold. Select a relevant item from the drop-down menu.
Click here to learn how to create easily create a drop-down list.
Similarly, the columns for the second interview are also made.
The final interview section consists of additional sections like finalized CTC, level, offer status, remarks, tentative DOJ (date of joining), actual DOJ (date of joining).
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. I will be more than happy to assist you.