Great info. How can I create the "Job report" based on the stage chosen? I mean, I have observed that the sheet with the information changes based on the stage chosen, so How to do that? and regarding the current pipeline, how to configure it based on the Job ID chosen? Thank you!
Thank you for sharing your valuable feedback. Regarding Job Report, We use SMALL and IF function combined as an array formula to get the row of the data according to the selected filter (Stage) Regarding Current Pipeline, It just the COUNTIFS function. You will gain full access to the template on purchasing the template and you view the functions used in the template. You currently have a new version of this template with more advanced reports. Following is the link to the same for quick reference: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Thank you for showing interest in our template. On purchasing the template, you will have full access to the template. Hence, yes, you can replicate the same and build your own in your official system for your usage. Please check our license terms and conditions at the below link: indzara.com/license-terms/ Also we have a new version of the template with advance reports available at the below link: indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/ th-cam.com/video/zLNeR2ziaOw/w-d-xo.html Best wishes.
You are welcome and thank you for showing interest in our template. We have a new version of the template with advance reports is available at the below link: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
We regret the inconvenience caused. I am unable to replicate the highlighted issue. Please share your sheet to us at the below link to assist further: support.indzara.com/support/tickets/new Best wishes.
Hi, this tracker looks amazing! Great work - if I wanted to learn how to make this, do you guys have a video teaching how to make this? Or is there a resource you would recommend? Thanks
Thank you for showing interest in our template and sharing your valuable feedback. Currently, we do not have a tutorial video on how to build the template. We will update you when we create a tutorial. We have a new version of the template with advanced reports. Following is the link to the template for quick reference: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Thank you for showing interest in our template. We have a new version of this template and following is the link to the same for quick reference: indzara.com/product/recruitment-manager-excel-template/ If you want the version containing the dashboard present in this video, you can purchase the template from the above mentioned link and write to us at the below link to share you the same: support.indzara.com/support/tickets/new Best wishes.
Thank you for showing interest in our template. You can purchase our Recruitment Manager Google sheet template to track the applicants online. Following is the link to the template for quick reference: indzara.com/product/recruitment-manager-google-sheet-template/ Best wishes.
Thank you for showing interest in our template. Currently, we have a new version of the template with more advanced reports. If you want this version of the template, you can purchase the template and write to us at the below link to share you this version of the template: support.indzara.com/support/tickets/new Following is the link to the template for quick reference: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Thank you for showing interest in our template. We currently have new version of the template with more advanced dashboard reports. Following is the link to the template: indzara.com/product/recruitment-manager-excel-template/ If you want the version of the template that has the dashboard shown in this video, please write to us at the below link after purchasing the template and we will share you the same within 24 hours on Mon - Fri: support.indzara.com/support/tickets/new Best wishes.
Thank you for showing interest in our template. Our current version of the has 10 recruitment stages. Following is the video tour of the new version of the template: th-cam.com/video/zLNeR2ziaOw/w-d-xo.html Following is the template link: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Thank you. Days in Market reflects how long the job is in market (From Job Posted Date to Today/Hired date). Please let me know if there are any questions. Best wishes.
Thanks for your interest. Yes it will work with just Excel. It is a single regular Excel file. The latest version video is here th-cam.com/video/zLNeR2ziaOw/w-d-xo.html. Please let us know if any questions. Best wishes.
bought the dashboard but not satisfied with the customer services. It is not a friendly user. everything is so complicated. maybe you need to make a video to explain everything with baby steps
Thanks for purchasing. We are sorry that you are not satisfied with the service. We have a step-by-step user guide for how to use this template here. support.indzara.com/support/solutions/articles/62000220452-step-by-step-user-guide-recruitment-dashboard-excel-template-v3 Please let us know (our email is support@indzara.com) the details of your questions. We will do our best to address your questions as soon as possible. Thanks & Best wishes.
Thank you for showing interest in our template. Yes, the template will allow you to have custom stages and the data inside the slicers as per your requirement. I also would like to inform you that we have a new version of the template with advance reports. Following is the link to the template for quick reference: indzara.com/product/recruitment-manager-excel-template/ Following is the link to the demo video of the latest version of the template: th-cam.com/video/zLNeR2ziaOw/w-d-xo.html Best wishes.
Hello, I am looking for this template on your website. Can you please point out which one I'm supposed to choose as they look a bit different and I'm not sure. Thank you!
Thank you for showing interest in our template. The template demo shown in this video is an old version of the current Recruitment Manager template shown in our website at the below link: indzara.com/product/recruitment-manager-excel-template/ You can purchase the template from the above link and write to us at the below link to get the old version of the template: support.indzara.com/support/tickets/new Best wishes.
I don't have the tutorial for this template. However, I have videos explaining how to build the simplified version of this. Recruitment Tracker template. Video: th-cam.com/video/tgBXh6-DFQQ/w-d-xo.html Best wishes.
Thanks for purchasing. Yes, the slicers in the Dashboard allow you to filter to specific department(s). Similarly, you can filter to Jobs completed hiring in March month. indzara.com/product/recruitment-manager-excel-template/ Please let us know if any questions. Best wishes.
Thank you for showing interest in our template. The template demo present in the video is old version of our Recruitment Manager template, you can purchase the template and write to us at the below link to get the old version. The new version demo video is available at the below link: th-cam.com/video/zLNeR2ziaOw/w-d-xo.html You can purchase our template from the below link: indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/ Best wishes.
Thank you for showing interest in our template. You can purchase the template from the below link: indzara.com/product/recruitment-manager-excel-template/ However, we have updated the template and video for the new version of the template is available at the below link: th-cam.com/video/zLNeR2ziaOw/w-d-xo.html If you want the previous version of the template explained in this video, you can write to support@indzara.com after purchasing the template to get the same. Best wishes.
Hello Indzara i like the template and went to purchase it but something was wrong and payment doesnt go through. opened a ticket for 2 days and still no answer ticket No.#5687
Thanks. Can you please provide more details on your question? What information about the slicers would you like me to explain? Slicers are similar to filters where you can choose one or more values to filter the report/dashboards to. Best wishes.
Please see the Google Sheets version here: indzara.com/product/recruitment-manager-google-sheet-template/ Please let us know if any questions. Thanks & Best wishes.
The step by step user guide is available in following links: indzara.com/2016/07/user-guide-enter-data-recruitment-manager-template/ th-cam.com/video/vKR6R-UtCwE/w-d-xo.html If you are still facing issue, requesting you to share your sheet with sample data and screenshots of your concern to support@indzara.com. Best wishes.
Thank you for showing interest in our template. Trail version of the template with limited features is available at the below link: indzara.com/2015/09/recruitment-tracker-free-excel-template/ You can also purchase the template and use the template. If the template does not solve your requirement, you can let us know your requirement that is no solved in the template and we will initiate a full refund if your requirement is not fulfilled. Best wishes.
Sorry, we don't have a tutorial yet for this template. But there is a tutorial for a basic version of Recruitment tracker: th-cam.com/video/tgBXh6-DFQQ/w-d-xo.html Please let us know if any questions. Best wishes.
is there a way to see recruiting funnel by a specific job? it would be more useful to see how a job is converting through each stage versus the overall picture
The Dashboard has slicers such as Job Title, Location, etc. - You can filter by those to see the performance at a granular level. Please let us know if any questions. Best wishes.
I am very sorry. The payment processor supports credit/debit cards and PayPal only. Thank you so much for your interest. Please let me know if there are any questions. Best wishes.
Thank you for showing interest in our template. Currently, we do not have a tutorial video on how to make this template. We will update you when we create one. Best wishes.
Thank you for showing interest in our template. You can write us your requirement at support@indzara.com. Following is the link to the new version of the Recruitment manager template for your quick reference: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
Calculated fields are fields which are automatically calculated using formulas. When we enter data in input fields, calculated fields will auto-populate accordingly. This allows transfer of data that is entered in one sheet to another. Also, these are used in calculations of metrics displayed in Dashboard. Best wishes.
In the template, total cost is entered for each job after hiring. The factors that contribute to the cost are not separately spelled out. User can calculate costs separately and then enter the amount in the Cost column. Please let me know if there are any questions. Best wishes.
Dashboard uses data in JOBS sheet and APPLICATIONS Sheet. Location information is entered for each job in the JOBS sheet. Please let me know if there are any questions. Best wishes.
Please see the product page indzara.com/product/recruitment-manager-excel-template/ Please let me know if there are any questions. Thanks & Best wishes.
Thanks for feedback. We currently don't have varying prices by country. Sorry. We do have a 'buy one, post review and get one free' offer. indzara.com/2015/03/buy-one-write-review-get-one-free/ Best wishes.
Thank you for showing interest in our template. Yes, it is a paid template and this video describes an older version of the template. The video to the new version of the template is available at the below link: th-cam.com/video/zLNeR2ziaOw/w-d-xo.html The free version of the template with limited feature is available at the below link: indzara.com/free-excel-template-for-recruitment-tracker/ Best wishes.
![How to build an Interactive HR Dashboard in Excel | HR Analytics in Excel [2024]](http://i.ytimg.com/vi/0IFYY7a5pAo/mqdefault.jpg)
Wooow, this Excel table is piece of cake! Awesome!!!
Thank you for sharing your valuable feedback.
Best wishes.
Great info. How can I create the "Job report" based on the stage chosen? I mean, I have observed that the sheet with the information changes based on the stage chosen, so How to do that? and regarding the current pipeline, how to configure it based on the Job ID chosen? Thank you!
Thank you for sharing your valuable feedback.
Regarding Job Report,
We use SMALL and IF function combined as an array formula to get the row of the data according to the selected filter (Stage)
Regarding Current Pipeline,
It just the COUNTIFS function.
You will gain full access to the template on purchasing the template and you view the functions used in the template.
You currently have a new version of this template with more advanced reports. Following is the link to the same for quick reference:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
Can we get this template to check and create our own
Thank you for showing interest in our template.
On purchasing the template, you will have full access to the template. Hence, yes, you can replicate the same and build your own in your official system for your usage. Please check our license terms and conditions at the below link:
indzara.com/license-terms/
Also we have a new version of the template with advance reports available at the below link:
indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/
th-cam.com/video/zLNeR2ziaOw/w-d-xo.html
Best wishes.
Great, thanks for sharing
You are welcome and thank you for showing interest in our template.
We have a new version of the template with advance reports is available at the below link:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
Hello Indzara, great video and template.
Thank you for sharing your valuable feedback.
Best wishes.
I can't fill other values except 1 in application slide job id😢 how should i do?
We regret the inconvenience caused.
I am unable to replicate the highlighted issue. Please share your sheet to us at the below link to assist further:
support.indzara.com/support/tickets/new
Best wishes.
Hi, this tracker looks amazing! Great work - if I wanted to learn how to make this, do you guys have a video teaching how to make this? Or is there a resource you would recommend? Thanks
Thank you for showing interest in our template and sharing your valuable feedback.
Currently, we do not have a tutorial video on how to build the template. We will update you when we create a tutorial. We have a new version of the template with advanced reports. Following is the link to the template for quick reference:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
really awesome !!
Thank you for sharing your valuable feedback.
Best wishes.
How do I download template Please?
Thank you for showing interest in our template.
We have a new version of this template and following is the link to the same for quick reference:
indzara.com/product/recruitment-manager-excel-template/
If you want the version containing the dashboard present in this video, you can purchase the template from the above mentioned link and write to us at the below link to share you the same:
support.indzara.com/support/tickets/new
Best wishes.
Sir how should we make online applicat tracking system and talent lookup portal ? Please reply
Thank you for showing interest in our template.
You can purchase our Recruitment Manager Google sheet template to track the applicants online. Following is the link to the template for quick reference:
indzara.com/product/recruitment-manager-google-sheet-template/
Best wishes.
Dear ,
Can i get this excel templates?
Thank you for showing interest in our template.
Currently, we have a new version of the template with more advanced reports. If you want this version of the template, you can purchase the template and write to us at the below link to share you this version of the template:
support.indzara.com/support/tickets/new
Following is the link to the template for quick reference:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
Can I get the dashboard please
Thank you for showing interest in our template.
We currently have new version of the template with more advanced dashboard reports. Following is the link to the template:
indzara.com/product/recruitment-manager-excel-template/
If you want the version of the template that has the dashboard shown in this video, please write to us at the below link after purchasing the template and we will share you the same within 24 hours on Mon - Fri:
support.indzara.com/support/tickets/new
Best wishes.
Hi, can I edit hiring stages from 6 to be 9 stages?
Thank you for showing interest in our template.
Our current version of the has 10 recruitment stages. Following is the video tour of the new version of the template:
th-cam.com/video/zLNeR2ziaOw/w-d-xo.html
Following is the template link:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
This is vert best report but I have 1 question. What do you mean day in Mkt?
Thank you. Days in Market reflects how long the job is in market (From Job Posted Date to Today/Hired date). Please let me know if there are any questions. Best wishes.
Requested Sir,
How to download this sheet dataset , please share the drive link.
Following is the link to the template:
indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/
Best wishes.
Hi Team, please could you confirm if this will work with just excel, or does it require power Bi or other similar applications?
Thanks for your interest. Yes it will work with just Excel. It is a single regular Excel file. The latest version video is here th-cam.com/video/zLNeR2ziaOw/w-d-xo.html. Please let us know if any questions. Best wishes.
bought the dashboard but not satisfied with the customer services. It is not a friendly user. everything is so complicated. maybe you need to make a video to explain everything with baby steps
Thanks for purchasing. We are sorry that you are not satisfied with the service.
We have a step-by-step user guide for how to use this template here. support.indzara.com/support/solutions/articles/62000220452-step-by-step-user-guide-recruitment-dashboard-excel-template-v3
Please let us know (our email is support@indzara.com) the details of your questions. We will do our best to address your questions as soon as possible.
Thanks & Best wishes.
Hello sir, very nice tracker.. does it allow the user to custom the fileds in the slicer dashboard too?
Thank you for showing interest in our template.
Yes, the template will allow you to have custom stages and the data inside the slicers as per your requirement. I also would like to inform you that we have a new version of the template with advance reports. Following is the link to the template for quick reference:
indzara.com/product/recruitment-manager-excel-template/
Following is the link to the demo video of the latest version of the template:
th-cam.com/video/zLNeR2ziaOw/w-d-xo.html
Best wishes.
Hello, I am looking for this template on your website. Can you please point out which one I'm supposed to choose as they look a bit different and I'm not sure. Thank you!
Thank you for showing interest in our template.
The template demo shown in this video is an old version of the current Recruitment Manager template shown in our website at the below link:
indzara.com/product/recruitment-manager-excel-template/
You can purchase the template from the above link and write to us at the below link to get the old version of the template:
support.indzara.com/support/tickets/new
Best wishes.
Pls explain how have you prepared HR dashboard template along with formulas used
I don't have the tutorial for this template. However, I have videos explaining how to build the simplified version of this. Recruitment Tracker template. Video: th-cam.com/video/tgBXh6-DFQQ/w-d-xo.html
Best wishes.
Hi
If I filter department, would I get filtered info in dashboards?
For example I want to know how many hire do I have for March?
Thanks for purchasing.
Yes, the slicers in the Dashboard allow you to filter to specific department(s).
Similarly, you can filter to Jobs completed hiring in March month.
indzara.com/product/recruitment-manager-excel-template/
Please let us know if any questions.
Best wishes.
How do I get access to the templet
Thank you for showing interest in our template.
The template demo present in the video is old version of our Recruitment Manager template, you can purchase the template and write to us at the below link to get the old version. The new version demo video is available at the below link:
th-cam.com/video/zLNeR2ziaOw/w-d-xo.html
You can purchase our template from the below link:
indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/
Best wishes.
Hi, How do I download the template?
Thank you for showing interest in our template.
You can purchase the template from the below link:
indzara.com/product/recruitment-manager-excel-template/
However, we have updated the template and video for the new version of the template is available at the below link:
th-cam.com/video/zLNeR2ziaOw/w-d-xo.html
If you want the previous version of the template explained in this video, you can write to support@indzara.com after purchasing the template to get the same.
Best wishes.
Hello Indzara i like the template and went to purchase it but something was wrong and payment doesnt go through. opened a ticket for 2 days and still no answer
ticket No.#5687
Thanks for reaching out. We will respond today to your request. Thank you. Best wishes.
Can u please do a video explaining the slicer in detail
Thanks. Can you please provide more details on your question? What information about the slicers would you like me to explain? Slicers are similar to filters where you can choose one or more values to filter the report/dashboards to.
Best wishes.
Can you please show us the attrition analysis report??
Thanks for the suggestion. Will do my best.
Best wishes.
Hello! Do you have this in a Google Sheets version?
Please see the Google Sheets version here: indzara.com/product/recruitment-manager-google-sheet-template/
Please let us know if any questions. Thanks & Best wishes.
Where is the step by step demo? The dashboard is not populating.
The step by step user guide is available in following links:
indzara.com/2016/07/user-guide-enter-data-recruitment-manager-template/
th-cam.com/video/vKR6R-UtCwE/w-d-xo.html
If you are still facing issue, requesting you to share your sheet with sample data and screenshots of your concern to support@indzara.com.
Best wishes.
how to free download for sample
Thank you for showing interest in our template.
Trail version of the template with limited features is available at the below link:
indzara.com/2015/09/recruitment-tracker-free-excel-template/
You can also purchase the template and use the template. If the template does not solve your requirement, you can let us know your requirement that is no solved in the template and we will initiate a full refund if your requirement is not fulfilled.
Best wishes.
How to built this
Sorry, we don't have a tutorial yet for this template. But there is a tutorial for a basic version of Recruitment tracker: th-cam.com/video/tgBXh6-DFQQ/w-d-xo.html
Please let us know if any questions.
Best wishes.
is there a way to see recruiting funnel by a specific job? it would be more useful to see how a job is converting through each stage versus the overall picture
The Dashboard has slicers such as Job Title, Location, etc. - You can filter by those to see the performance at a granular level.
Please let us know if any questions.
Best wishes.
@@indzara Thanks. I didn't see that in the walkthrough. Can I get a screenshot of what that would look like?
The data is not auto populating. The applicants are not showing once I enter them in the fields.
Thanks for e-mailing the file. I have responded to your e-mail.
Thanks & Best wishes.
Thanks for e-mailing the file. I have responded to your e-mail.
Thanks & Best wishes.
Thanks for e-mailing the file. I have responded to your e-mail.
Thanks & Best wishes.
I want to purchase this but I dont have credit card? Can I pay through western union?
I am very sorry. The payment processor supports credit/debit cards and PayPal only.
Thank you so much for your interest. Please let me know if there are any questions.
Best wishes.
Can i get tutorial video of thi?
Thank you for showing interest in our template.
Currently, we do not have a tutorial video on how to make this template. We will update you when we create one.
Best wishes.
I M RUNING A PLACEMENT COMPANY IS DER ANY SHEET TO MAINTAIN DATA OF CANDIDATES ACORDING TO VACANCY..
Can you please clarify with more details? This template can track jobs posted and candidates who applied to those jobs.
Best wishes.
Hello my dear, we would like to create a recruitment dashboard how can we contact you?
Thank you for showing interest in our template.
You can write us your requirement at support@indzara.com. Following is the link to the new version of the Recruitment manager template for your quick reference:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
Do you have anything similar for recruitment companies or for consultants or freelancer recruiters???
Recruitment Companies or Freelancers can use the template as well. is there anything specific you are looking for? Please let me know.
Best wishes.
Yes, connect me with on koriraj003@gmail.com.
what data does row 5 contains in the application sheet?
Field names for the Applications table. Thanks.
can it still work when we upload the template to google sheet?
Sorry, this works only in Microsoft Excel.
Best wishes.
i have not understood the use of calculated field
Calculated fields are fields which are automatically calculated using formulas. When we enter data in input fields, calculated fields will auto-populate accordingly. This allows transfer of data that is entered in one sheet to another. Also, these are used in calculations of metrics displayed in Dashboard.
Best wishes.
What are the basis for the cost to recruit an applicant?
In the template, total cost is entered for each job after hiring. The factors that contribute to the cost are not separately spelled out. User can calculate costs separately and then enter the amount in the Cost column.
Please let me know if there are any questions. Best wishes.
In the dashboard how does it filter by location? is this done in the position? or is this reported from the candidate area?
Dashboard uses data in JOBS sheet and APPLICATIONS Sheet. Location information is entered for each job in the JOBS sheet. Please let me know if there are any questions. Best wishes.
How can I get this excel sheet ?
Please see the product page indzara.com/product/recruitment-manager-excel-template/
Please let me know if there are any questions.
Thanks & Best wishes.
Indzara according to Indian rupees it is not in the budget. Too much costly
Thanks for feedback. We currently don't have varying prices by country. Sorry. We do have a 'buy one, post review and get one free' offer. indzara.com/2015/03/buy-one-write-review-get-one-free/
Best wishes.
It's a paid template 😒
Thank you for showing interest in our template.
Yes, it is a paid template and this video describes an older version of the template. The video to the new version of the template is available at the below link:
th-cam.com/video/zLNeR2ziaOw/w-d-xo.html
The free version of the template with limited feature is available at the below link:
indzara.com/free-excel-template-for-recruitment-tracker/
Best wishes.
really awesome!
Thank you. Best wishes.