Download this template for free from indzara.com/2015/09/recruitment-tracker-free-excel-template/ For a premium version to track multiple jobs with dashboard and report, please visit indzara.com/product/recruitment-manager-excel-template/ Best wishes.
great Work Bro. It would be great if we can add start date column in Data Sheet, if so how will formula change to Reflect it on days to hire nested formula
Great step by step tutorial! I actually use a ready-to-use Recruitment Tracker template I purchased from Someka. However, it's good to know how to prepare a basic recruitment tracker from scratch. Thank you for the video:)
Thank you for watching our video and sharing your valuable feedback. Our premium version of ready to use template is available at the below link: Excel: indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/ Google Sheets: indzara.com/product/hr-excel-templates/recruitment-manager-google-sheet-template/ Power BI: indzara.com/product/hr-excel-templates/power-bi-templates-recruitment-dashboard-excel-templates/ Best wishes.
I also received recruitment template from someka however it's password protected and I tried using XML file solution also but not working could you help with a template link which is open for work
Thank you so much for giving back knowledge to others, you are amazing. I have small doubt when I implement the formula TODA()-Job post date - cell locked +1, the result was 25 Jan 1903 when I changed it to general I got huge number that is 1121, could you please help to get the correct DAYS TO HIRE.
You are welcome and thank you for sharing your valuable feedback. Can you let us know what was the job posted date. Since all dates in excel are numbers by default. 1 refers to 01-Jan-1900 and this is the minimum valid date in excel. Today 25-Feb-2022 refers to 44617 days from 01-Jan-1900. Hence subtracting the TODAY()-Job Posted Date+1 is a simple arithmetic function with two numbers and if it returns 1121, then it must be 1121 days between job posted date and today. If you are still facing issue, requesting to share your sheet to support@indzara.com to check further. Best wishes.
Thank you for showing interest in our template. No, currently, this template is used to track only one hire at a time. We have a premium version of the template, which has more features including multiple jobs and multiple hiring option. Following is the link to the template: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Love this video! Thank you so much so useful...one question I have, if I am volume recruiting how do I get that to show on the tracker, if I'm hiring 5 candidates for example can I select multiple candidates from the Hired drop down box ?
Thank you for showing interest in our template and you are welcome. If you want to manage multiple hires, requesting to check our Recruitment Manager template at the below link: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Thank you watching our video and sharing your valuable feedback. To add more stage, you will need to add additional columns next to offer date column and duplicate the formulas used for each stage referring to the the newly added column. We have a premium version of the template with advance report and 10 recruitment stages. Following is the link to the template for your reference: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
You are welcome. Please see indzara.com/product/recruitment-manager-excel-template/ for a template that can manage multiple jobs and multiple positions per job. Please let us know if any questions. Best wishes.
thanks for sharing! I tried doing the calculated stages formula on a different sheet on the workbook but it keeps giving me an error. What am I doing wrong?
Thank you for watching the video and you are welcome. Requesting to check for the named ranges and table names in the formula. Click Formulas and Name Manager in the ribbon to check the same. If you are unable to fix the same, you can share us your sheet to support@indzara.com to check further. Best wishes.
Dear Its great effort and thank you for this but its a static filter based summary, I would request you to please teach us how to make a dynamic dashboard for recruitment tracking and record for all position in the company and recruitment record using pivot tables slicers etc etc. that is of next level utility.
Thank you for showing interest in our tutorial. Currently, we do not have the requested tutorial video but the requested feature is available in our Recruitment Manager premium template. Following is the link to the template. indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Thanks Indara for wonderful excel - But could let me know , if we need to hire multiple candidate on same position /title how we can represent here in recruitment Tracker ... Thanks
You are welcome. Please see Recruitment manager template for managing multiple jobs (multiple positions of one job as well). indzara.com/product/recruitment-manager-excel-template/ Please let us know if any questions. Best wishes.
Its a great video many thanks , pls help me , i copy many sheets same in the same file for different positions, but when i add one application in one sheet the count showing same in all sheets !! Any help ?
Thank you for sharing your valuable feedback. The formulas will be referring to the same named ranges and same table ranges, due to which the output is similar in all the copied and moved sheet. Requesting to check our Recruitment Manager template at the below link, through which you can manage multiple positions: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
You are amazing personality in helping Millions of user around the globe Thank you so much. Therefore, i stuck on when i remove the hired applicant, its doesn't change the hired to hiring. Can you help me Please!
Thank you for showing interest in our template and sharing your valuable feedback. Please share your copy of the template with sample data and some screenshots highlighting your concern at the below link and we will be glad to assist you: support.indzara.com/support/tickets/new Best wishes.
When I look back at this tracker, say a few months after we have hired someone, it starts counting the DAYS TO HIRE part backward. So for example, mine says =250. My formula is identical to yours though, so I can't figure out what is going wrong
Thank you for showing interest in our template. Requesting to share your sheet with some screenshots highlighting your concern to support@indzara.com to check further. Best wishes.
Thank you for sharing your valuable feedback and you are welcome. Requesting to share your sheet to support@indzara.com with some screenshot highlighting the above mentioned issue to check further. Best wishes.
Hello! The video is very helpful. Thank you. But it’s kind of blurry and I couldn’t read the formulas especially the long IF ones. Can you share them on the video description for the stage, time to fill, application etc? Thanks!!
You can add a column to mark an application as internal or external. Then you can use sumif formula to calculate the number of applications. In our premium version of the template you can use the Custom column to enter the same. Following is the link to the premium version of the template: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Thank you for sharing your valuable feedback. Currently, we do not have a tutorial video to create the template but we have a premium version of the template with more features and interactive dashboard. Following is the link to the template: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
@@ms0015488 You are welcome. The premium version of the template is a paid product. You can purchase from indzara.com/product/recruitment-manager-excel-template/ Please let us know if any questions. Thanks & Best wishes.
@@indzara I will be interested. Is there a way I can communicate with you. Thought I will email you the type of raw data I extract from my ATS. You could examine and confirm if the product I buy would be able to support that and derive the dashboard as presented in the recruitment manager tracker.?
You are welcome. Please see Recruitment Manager template that supports tracking hiring multiple jobs and each job having multiple positions. indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Thank you for showing interest in our template. Adding more stages involves complicated modifications. Hence requesting to check our Recruitment Manager template, which supports upto 6 stages. Following is the link to the product. indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Thank you for showing interest in our template. Our premium version of the template will allow you to track multiple jobs in a single template along with advance dashboard with multiple recruitment metrics. Following is the link to the template for quick reference: Excel: indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/ Google Sheets: indzara.com/product/hr-excel-templates/recruitment-manager-google-sheet-template/ Power BI: indzara.com/product/hr-excel-templates/power-bi-templates-recruitment-dashboard-excel-templates/ Best wishes.
I am having trouble with the name value when trying to create a drop down list for the hired cell input. I used actual names instead of APP 1 as you did but i cant seem to get all the names in.
Thank you. I have not had a chance yet to create that tutorial. The template that handles multiple jobs is available indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Thank you for sharing your valuable feedback. Currently, the requested feature of having more than 1 open position for a single job is handled in our premium version of the template. Following is the link to the same for quick reference: indzara.com/product/hr-templates/recruitment-manager-excel-template/ The premium version of the template also have option to track multiple job posing in the same file. Best wishes.
Thank you for watching our video. If an applicant ID is rejected after Stage one, enter stage one date and mark the status as closed. I also would like to inform you that we have advanced version of the template. Requesting to check the same at the below link: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
I'm looking for a template that would allow me to track multiple hires for the same position for a trucking company. I have two companies that I recruit for within the same organization - Just two different locations or terminals. I also need to track several recruiting sources like Indeed, Tenstreet, Facebook, etc....to show where the candidates came from. Do you have a template for this, please??
Part 2: th-cam.com/video/1aax7030mWA/w-d-xo.html Part 3: th-cam.com/video/aceTjezeaI8/w-d-xo.html Part 4: Not recorded yet. :) will be published on 31st March Best wishes.
How can I track the number of candidates each recruiter ha Has Not necessarily how many job titles are being hired more less how many people are being hired not just a particular job site.
The recruitment manager template indzara.com/product/recruitment-manager-excel-template/ allows tracking multiple jobs while each job can have multiple openings. Best wishes.
Thank you for showing interest in our template. Following is the template download link for quick reference: indzara.com/free-excel-template-for-recruitment-tracker/ Best wishes.
Recruitment tracker is designed for tracking one job with one hire. Recruitment manager is designed for multiple positions. indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Thank you for showing interest in our template. You can download the template from the link below: indzara.com/2015/09/recruitment-tracker-free-excel-template/ Best wishes.
Please see Recruitment Manager template that can handle multiple positions and hires. indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Download this template for free from indzara.com/2015/09/recruitment-tracker-free-excel-template/
For a premium version to track multiple jobs with dashboard and report, please visit indzara.com/product/recruitment-manager-excel-template/
Best wishes.
Thank you!! This video is exactly what I've been looking for. I appreciate your detail
You are welcome. Thank you for the appreciation.
Best wishes.
Great video, I easily managed to create a new recruitment tracker that was free and easy to use thanks :)
Glad to hear that it is useful. You are very welcome.
Best wishes.
@@indzara I second that!
Thank you for the tutorial :)
Amazing video searching for long time. Thanks a lot Sir. Will help a lot to many.
Thank you for the compliment and you are welcome.
Best wishes.
great Work Bro. It would be great if we can add start date column in Data Sheet, if so how will formula change to Reflect it on days to hire nested formula
Great step by step tutorial! I actually use a ready-to-use Recruitment Tracker template I purchased from Someka. However, it's good to know how to prepare a basic recruitment tracker from scratch. Thank you for the video:)
Thank you for watching our video and sharing your valuable feedback.
Our premium version of ready to use template is available at the below link:
Excel:
indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/
Google Sheets:
indzara.com/product/hr-excel-templates/recruitment-manager-google-sheet-template/
Power BI:
indzara.com/product/hr-excel-templates/power-bi-templates-recruitment-dashboard-excel-templates/
Best wishes.
I also received recruitment template from someka however it's password protected and I tried using XML file solution also but not working could you help with a template link which is open for work
Thank you so much for giving back knowledge to others, you are amazing.
I have small doubt when I implement the formula TODA()-Job post date - cell locked +1, the result was 25 Jan 1903 when I changed it to general I got huge number that is 1121, could you please help to get the correct DAYS TO HIRE.
You are welcome and thank you for sharing your valuable feedback.
Can you let us know what was the job posted date.
Since all dates in excel are numbers by default. 1 refers to 01-Jan-1900 and this is the minimum valid date in excel. Today 25-Feb-2022 refers to 44617 days from 01-Jan-1900. Hence subtracting the TODAY()-Job Posted Date+1 is a simple arithmetic function with two numbers and if it returns 1121, then it must be 1121 days between job posted date and today.
If you are still facing issue, requesting to share your sheet to support@indzara.com to check further.
Best wishes.
Great tool, can i still use this if i am looking for more than 1 person for the same role?
Thank you for showing interest in our template.
No, currently, this template is used to track only one hire at a time. We have a premium version of the template, which has more features including multiple jobs and multiple hiring option. Following is the link to the template:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
Love this video! Thank you so much so useful...one question I have, if I am volume recruiting how do I get that to show on the tracker, if I'm hiring 5 candidates for example can I select multiple candidates from the Hired drop down box ?
Thank you for showing interest in our template and you are welcome.
If you want to manage multiple hires, requesting to check our Recruitment Manager template at the below link:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
If I have to prepare on my own instead of buying
Amazing at the outcome! This will be helpful. Thank you.
Thank you for sharing your valuable feedback and you are welcome.
Best wishes.
These are great videos! Glad I found this.
Thank you for sharing your valuable feedback.
Best wishes.
Nice Tracker only one question if we want to add more stages like after offer letter id card, insurance card, in short, all steps in one tracker.
Thank you watching our video and sharing your valuable feedback.
To add more stage, you will need to add additional columns next to offer date column and duplicate the formulas used for each stage referring to the the newly added column.
We have a premium version of the template with advance report and 10 recruitment stages. Following is the link to the template for your reference:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
what about if we have more than one vacancy could we add different designations on the same page ?
Thank you! Have you tried to create one dashboard for tracking multiple jobs?
You are welcome.
Please see indzara.com/product/recruitment-manager-excel-template/ for a template that can manage multiple jobs and multiple positions per job.
Please let us know if any questions.
Best wishes.
It's really Helpful, Thank you for Sharing..
Glad to hear. You are welcome.
Best wishes.
Great Man you know Excel
Thank you. I know very very little of what Excel can do. Learning every day.
Best wishes.
thanks for sharing! I tried doing the calculated stages formula on a different sheet on the workbook but it keeps giving me an error. What am I doing wrong?
Thank you for watching the video and you are welcome.
Requesting to check for the named ranges and table names in the formula. Click Formulas and Name Manager in the ribbon to check the same.
If you are unable to fix the same, you can share us your sheet to support@indzara.com to check further.
Best wishes.
Dear Its great effort and thank you for this but its a static filter based summary, I would request you to please teach us how to make a dynamic dashboard for recruitment tracking and record for all position in the company and recruitment record using pivot tables slicers etc etc. that is of next level utility.
Thank you for showing interest in our tutorial.
Currently, we do not have the requested tutorial video but the requested feature is available in our Recruitment Manager premium template. Following is the link to the template.
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
Dis you manage to get what you asked? I have to create a weekly tracker amd metrics of all jobs in my new job too if any 1 can help ?
Thank you sir, this is super helpful!
You are welcome. Glad it was helpful.
Best wishes.
Thanks Indara for wonderful excel - But could let me know , if we need to hire multiple candidate on same position /title how we can represent here in recruitment Tracker ... Thanks
You are welcome.
Please see Recruitment manager template for managing multiple jobs (multiple positions of one job as well).
indzara.com/product/recruitment-manager-excel-template/
Please let us know if any questions.
Best wishes.
Its a great video many thanks , pls help me , i copy many sheets same in the same file for different positions, but when i add one application in one sheet the count showing same in all sheets !! Any help ?
Thank you for sharing your valuable feedback.
The formulas will be referring to the same named ranges and same table ranges, due to which the output is similar in all the copied and moved sheet.
Requesting to check our Recruitment Manager template at the below link, through which you can manage multiple positions:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
You are amazing personality in helping Millions of user around the globe Thank you so much. Therefore, i stuck on when i remove the hired applicant, its doesn't change the hired to hiring. Can you help me Please!
Thanks for feedback.
Please email file to support@indzara.com with your question.
Best wishes.
Very good video. Thank you 😊
Thank you. You are welcome.
Best wishes.
Love the video and the excel, the only problem I am having is with the Stage section, for some reason that formula was not working for me.
Thank you for showing interest in our template and sharing your valuable feedback.
Please share your copy of the template with sample data and some screenshots highlighting your concern at the below link and we will be glad to assist you:
support.indzara.com/support/tickets/new
Best wishes.
Thank you very much for the amazing video!
You are welcome. Glad to know you found it useful.
Best wishes.
When I look back at this tracker, say a few months after we have hired someone, it starts counting the DAYS TO HIRE part backward. So for example, mine says =250. My formula is identical to yours though, so I can't figure out what is going wrong
Requesting to share your sheet to support@indzara.com to check further.
Best wishes.
Hi..This is really good. I want to use this template but unable to copy and work on mt my data. Please support
Thank you for showing interest in our template.
Requesting to share your sheet with some screenshots highlighting your concern to support@indzara.com to check further.
Best wishes.
Thank you, this is awesome! but for some reason when I go to the 2nd video with the help sheet I get a 0 instead of 1
Thank you for sharing your valuable feedback and you are welcome.
Requesting to share your sheet to support@indzara.com with some screenshot highlighting the above mentioned issue to check further.
Best wishes.
Thanks a lot. This is great!
You are welcome. Thank you for sharing your valuable feedback.
Best wishes.
Hello! The video is very helpful. Thank you. But it’s kind of blurry and I couldn’t read the formulas especially the long IF ones. Can you share them on the video description for the stage, time to fill, application etc? Thanks!!
Thanks. Please download the full template with formulas here: indzara.com/2015/09/recruitment-tracker-free-excel-template/
Best wishes.
Is there a way you can include internal/external applicant?
You can add a column to mark an application as internal or external. Then you can use sumif formula to calculate the number of applications.
In our premium version of the template you can use the Custom column to enter the same. Following is the link to the premium version of the template:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
Thanks for the information and for sharing
You are welcome. Thanks for feedback.
Best wishes.
Very impressive.! Any videos to create recruitment dashboard for a number of positions and interactive status update?
Thank you for sharing your valuable feedback.
Currently, we do not have a tutorial video to create the template but we have a premium version of the template with more features and interactive dashboard. Following is the link to the template:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
@@indzara Thank you for sharing this. Does one need to pay for the services or is it freely downloadable?
@@ms0015488 You are welcome. The premium version of the template is a paid product. You can purchase from indzara.com/product/recruitment-manager-excel-template/ Please let us know if any questions. Thanks & Best wishes.
@@indzara I will be interested. Is there a way I can communicate with you. Thought I will email you the type of raw data I extract from my ATS. You could examine and confirm if the product I buy would be able to support that and derive the dashboard as presented in the recruitment manager tracker.?
@@ms0015488 Yes, Sure. please email us at support@indzara.com Best wishes.
Thank you! Really helpful :)
You are welcome. We are glad that our video was helpful.
Best wishes.
Thank you Indzara!
You are welcome.
Best wishes.
Thank you for the video but how we can create if there are 4 candidates have been hired for this position
You are welcome.
Please see Recruitment Manager template that supports tracking hiring multiple jobs and each job having multiple positions. indzara.com/product/recruitment-manager-excel-template/
Best wishes.
thank you for sharing!!!!
Our pleasure!!
You are welcome.
Best wishes.
If we have 6stages then how come we make the formula with dates?
Thank you for showing interest in our template.
Adding more stages involves complicated modifications. Hence requesting to check our Recruitment Manager template, which supports upto 6 stages. Following is the link to the product.
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
Very helpful
Thank you for sharing your valuable feedback.
Best wishes.
Thank you but you need to be slowly so the beginners can follow your steps
You are welcome and thank you for sharing your feedback. We will try to improve the speed in our upcoming videos.
Best wishes.
How can we do this with the HR Dashboard? I wish I could pull this for all the jobs.
Thank you for showing interest in our template.
Our premium version of the template will allow you to track multiple jobs in a single template along with advance dashboard with multiple recruitment metrics. Following is the link to the template for quick reference:
Excel:
indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/
Google Sheets:
indzara.com/product/hr-excel-templates/recruitment-manager-google-sheet-template/
Power BI:
indzara.com/product/hr-excel-templates/power-bi-templates-recruitment-dashboard-excel-templates/
Best wishes.
I am having trouble with the name value when trying to create a drop down list for the hired cell input. I used actual names instead of APP 1 as you did but i cant seem to get all the names in.
Oh never mind!!! I messed around and figured it out!!
Glad to hear that everything is good.
Best wishes.
Sir,
this was an excellent share .
Can you share us how to create a report when there are multiple openings
Thank you.
I have not had a chance yet to create that tutorial.
The template that handles multiple jobs is available indzara.com/product/recruitment-manager-excel-template/
Best wishes.
great video, but how do we make the same tracker if the hired people are more than 1 ?
Thank you for sharing your valuable feedback.
Currently, the requested feature of having more than 1 open position for a single job is handled in our premium version of the template. Following is the link to the same for quick reference:
indzara.com/product/hr-templates/recruitment-manager-excel-template/
The premium version of the template also have option to track multiple job posing in the same file.
Best wishes.
How would I add a "Closed" stage if I decided not to move forward?
Thank you for watching our video.
If an applicant ID is rejected after Stage one, enter stage one date and mark the status as closed.
I also would like to inform you that we have advanced version of the template. Requesting to check the same at the below link:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
In need of student recruitment tracker by school (different locations) suggestions?
Please try Recruitment Manager indzara.com/product/recruitment-manager-excel-template/
Best wishes.
I'm looking for a template that would allow me to track multiple hires for the same position for a trucking company. I have two companies that I recruit for within the same organization - Just two different locations or terminals. I also need to track several recruiting sources like Indeed, Tenstreet, Facebook, etc....to show where the candidates came from. Do you have a template for this, please??
Requesting to check our following product which provides the requested feature:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
🎉❤❤❤
Thank you. 🙏
Welcome sir ji
thanks for sharing that's amazing
You are welcome.
Best wishes.
you are amazing really but please i couldn't implement rule IF. i would be grateful if you type it here.
Thank you. Can you please specify the exact part you need help with? Please email support@indzara.com
Best wishes.
Where is the next video? :)
Part 2: th-cam.com/video/1aax7030mWA/w-d-xo.html
Part 3: th-cam.com/video/aceTjezeaI8/w-d-xo.html
Part 4: Not recorded yet. :) will be published on 31st March
Best wishes.
How can I track the number of candidates each recruiter ha
Has Not necessarily how many job titles are being hired more less how many people are being hired not just a particular job site.
The recruitment manager template indzara.com/product/recruitment-manager-excel-template/ allows tracking multiple jobs while each job can have multiple openings.
Best wishes.
Is there any place where we can download these templates?
Thanks for your interest.
Free templates: indzara.com/free-excel-templates/
Premium Templates: indzara.com/shop/
Best wishes.
Please share the template download link
Thank you for showing interest in our template.
Following is the template download link for quick reference:
indzara.com/free-excel-template-for-recruitment-tracker/
Best wishes.
For more than one hired ?? how the formula works
Recruitment tracker is designed for tracking one job with one hire.
Recruitment manager is designed for multiple positions. indzara.com/product/recruitment-manager-excel-template/
Best wishes.
How to download this template???
Thank you for showing interest in our template.
You can download the template from the link below:
indzara.com/2015/09/recruitment-tracker-free-excel-template/
Best wishes.
What if there is a multiple hires.
Please see Recruitment Manager template that can handle multiple positions and hires. indzara.com/product/recruitment-manager-excel-template/
Best wishes.
Where is part 2?
Thank you for watching our video.
Following is the link to the second part of the template:
th-cam.com/video/1aax7030mWA/w-d-xo.html
Best wishes.
Thanks alot
You are welcome.
Best wishes.
Hi this is a very good tool but I am struggling to download
Please visit indzara.com/2015/09/recruitment-tracker-free-excel-template/
Best wishes.
What is pasword sir
The password to unprotect the sheet is indzara.
support.indzara.com/support/solutions/articles/62000137281-how-to-unprotect-sheets-
Best wishes.