Recruitment-Template-Excel

Looking for recruitment Tracker template excel for managing applicant hiring process? MS Excel based (Advanced Excel +Macros) We have #1 template according to your requirement.

You can request us for video and custom template editing. Recruitment template is available with either single license or multi user license. Just like resource capacity planner, you can manage entire recruitment process easily.

  1. Pipeline Efficiency Chart with In-process application stages
  2. Application sources chart (PIE CHART)
  3. Decline Reasons of candidates against particular job
  4. Location Department with job status
  5. Recruitment Tracker is available in bundle with HR system of single template
  6. Template colour and others details is editable

In this article, you can access to download premium recruitment tracker template with complete HR system (Training + HR KPI) as well as you can also calculate HR system regarding employee performance, Salary and other KPI detail.

Recruitment-Template-Excel

What is a Recruitment Tracker? Key Features of Template

Recruitment Tracker works well for the screening purpose of the applying candidates. Recruitment process is divided into several steps and needs special attention. The templates available just make the job easier. From filtering the candidate on the basis of qualities mentioned on the job description to getting the employee on board all is managed by the recruitment tracker quite easily.

  1. In data sheet, you must fill candidate’s information like FIRST & LAST NAME, PH:NO ETC
  2. In Job data, fill this sheet with department, Job type, Grade, Hiring Manager and job location, Job posted Date, Position ETC
  3. Make sure, some fields are required, some not
  4. You can manage entire department or multiple department candidates

Moreover, it keeps the data of the applicants save which can be utilise later for some other job opening. The efficiency of this process defines the future success of the company. The recruiter hunts the best suited candidate for the available job.

Depending upon the complexity of the recruitment procedure the tracker system is developed by external help or if the managers are capable, they can develop the system on their own.

Related HR Template: HR strategy Template

Purpose of Recruitment Tracker:

Recruitment tracker software lessens the burden on the HR team for going through hundreds of job applications against one job ad or position. The process of getting a job application to the hiring of the suitable employee is just done easily and smoothly by recruitment tracker.

The core purpose of the recruitment tracker is to improve the efficiency of the process by making it transparent. These templates manage several hundreds of profiles like a pro with no chances of any mistake. Recruitment tracker saves time and energy both. The uniformity in the recruitment process sets the standards for the hiring system.

Candidates Hiring Process in Excel

Templates can be modified according to the scale and the need of your recruitment process. The main purpose is to run the recruitment process smoothly while keeping all records. The data is recorded in the spreadsheets for the evaluation and screening. In the spreadsheet in the first column most importantly the applicant’s name is recorded.

Phone number is added in the next column while email addresses in the next one. Keeping the record of contact details is very important. Also position or the job the title for which the applicant is applying is also clearly mentioned. When applying for a job application an automated question comes up “by whom you are referred?”

Details of the reference are recorded in case needed for verification in future. Date of application and expected salary are added for the screening purpose. Other columns can be added according to your specific screening criteria. Generalise ones are added in this template.

What are Premium Key Features of Recruitment Tracker?

Each template has its distinguishing features depending upon the quality of work they are providing. But there are some key features of recruitment tracker template which are common in almost all of them;

Updated job ads:

The recruitment system is highly professional; it has its own system developed by the technical and HR team. But to have an updated career page with an attractive outlook gets the attention of the job seekers.

Brand identity:

An employer is highly invested in setting up a good image in front of the job seeker. And this brand image can be developed by using creative techniques in the job description and the application process.

Application process:

Keep your application process as wide as you can. The more the applicant the more chances of getting the right fit for the job description will be. Try to make the application process simple and ask good enough questions that will be helpful in the screening process.

Interviews management:

After the screening the best suited candidates are called for the interview. And the ones who actually are capable are further shortlisted for the next steps of the recruitment.

Mass communication:

System is developed for the collective invite for the interview or other ongoing steps of the recruitment. This needs to be efficient and precise.

Candidates Management System in Excel:

It is quite difficult to keep the record of hundreds of the candidates manually. Each small- or large-scale company develops their personalised candidate management system to reduce the burden on the recruitment team. This system is broken down into steps which are mentioned below;

  1. As soon as the applications are received the management system starts working. Data of the applicants are received by the recruitment tracking software.
  2. Data is managed on the template. Important essential details are recorded and resumes are saved for screening purposes.
  3. The system developed is technically sound. When the new application is dropped in the system the recruiter receives a notification. So, that no application is missed or ignored.
  4. The recruiter is free to respond to the applicant either the application is accepted or rejected. But at times a candidate has the potential but not fit for the description so notes are added with his/ her resume.
  5. Candidates are sorted on the basis of the recruiter responses.
  6. After the sorting, applicants are contacted through phone call, text or email for the interview.

How to Create Recruitment Tracker in Excel (Categorise Template)

Now in this section, we are going to breakdown some main function of Recruitment system. For clear understanding about this template, you can also watch video and start editing in this template.

Recruitment-Dashboard-Excel

Overview or Recruitment Dashboard

First of all, you can overview fully detail of this template through dashboard. I image below, you can experience the look of recruitment tracker.

Recruitment KPI

  1. How many candidates hiring over particular period?
  2. Days to Hiring
  3. Cost of Hiring
  4. Open position about particular job
  5. Days in MKT
  6. HIRED candidates

With these stats, you can experience other charts in different section help to manage applicants.

Candidates Hiring Tracking Charts

In this row, you can experience 3 different charts, help to identify candidate’s selection process through different selected channel.

  1. Pipeline Efficiency of Hiring stages
  2. In -Process Application stages
  3. Candidates Hiring Performance

In 2nd row of recruitment dashboard, you can experience others charts like;

  1. Monthly Hiring performance (12 Month Report)
  2. Application Stages (Agency, Website, LinkedIn)
  3. Decline applicant reason chart

At last of this Recruitment Tracker Template Excel dashboard, you can view Location/Department Wise Job status.

Candidates Job Report Sheet in Excel

You just need to enter value in “JOB POST ID” for desire candidates job report, you can export this sheet in PDF via click button left side of this template.

candidates-job-report-sheet

Candidates Job DATA

In this sheet, you must fill some desired column of every candidates. We already mentioned, which is required fill column or which not. SO, in this case, you can easily manage this sheet of excel and get desire result without gone confuse.

Job-Data-Sheet

Candidates Application

This is another data sheet of candidate’s application, Interview stages column, decline reasons, against particular candidate’s name and department. Other data column you can see in this image below of recruitment tracker template.

Candidates Data

Another data sheet, final one for entering information of each applicant. If you interested some more information and overview this kind of information in dashboard, so you can edit this template or request us for custom changes.

Candidates-Data-Sheet

How projecTimes.Net team can Help in Recruitment Tracker?

In addition, you need some requirement related to your HR system and recruitment process. You can contact ProjecTimes.net team of excel developer.

Excel124

About The Author

Leave a Reply

Your email address will not be published. Required fields are marked *