Sign Form for HR Free

How to make hr policy

hello and welcome to another excel template from ins Ericom if you are in the process of recruiting for an open position then you will find this template helpful in keeping all the information around your applications in one place in an organized way and it will easily allow you to identify how many candidates are in the active pipeline where in the recruitment funnel our candidates falling off top reasons why the candidates are being rejected for the job in this video we will go through how to easily use this excel template to begin with we will have the job title recruiter name and the job posted date and you can enter any of the information according to your needs and then you have the set of stages there are four stages maximum allowed in this template by default you have application phone screen interview and offer but if in your scenario you want to call them differently not a problem at all so you can just call it something else and the template will automatically update let me just leave it as application for now the fifth stage is actually hiring so once the person is offered and the offer is accepted then the fifth stage is completed I will discuss the fifth stage of hiring just in a couple of minutes but let's keep going with the four stages so we have these four in between stages and we are actively hiring for this job now you will enter the applicants information in this table here so we already have about 12 applications entered and the way this table works is that each row is a unique application and the and the name of the applicant is entered in this column and then there are four date columns so the date columns are nothing but the dates when each of the applicant entered these four stages so for example this applicant one entered the application stage on 10th August so that means the application applicant submitted the application on 10th August and then a phone screen was done 15 August and an interview was done on 16th August and so essentially the four stages are tracked by just entering the dates when each applicant cross that stage if it is decided that a candidate will not go past a certain stage for example the applicant one after the interview it was decided that the candidate will not go forward and so in that scenario you just change the status to closed that means that this candidate or this application is now completed for this specific jobs point of view and when you enter the status closed make sure that you also enter a declined reason you can enter any reason you would like I've just given some examples here whether it's a technical skills or the lack of experience or the culture fit you can have more reasons in your scenario now after that you can...