Applicant tracking system in Excel with Recruitment Metrics in HR Dashboard - Simple HR Analytics

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024

Комментарии • 98

  • @martindimitroff4962
    @martindimitroff4962 3 года назад +2

    Wooow, this Excel table is piece of cake! Awesome!!!

    • @indzara
      @indzara  3 года назад +1

      Thank you for sharing your valuable feedback.
      Best wishes.

  • @sharatchandran6469
    @sharatchandran6469 2 года назад +1

    really awesome !!

    • @indzara
      @indzara  2 года назад

      Thank you for sharing your valuable feedback.
      Best wishes.

  • @HireME-
    @HireME- Год назад +1

    Great, thanks for sharing

    • @indzara
      @indzara  Год назад +1

      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.

  • @kellycolig7883
    @kellycolig7883 3 года назад

    Hello Indzara, great video and template.

    • @indzara
      @indzara  3 года назад

      Thank you for sharing your valuable feedback.
      Best wishes.

  • @spainey1712
    @spainey1712 2 года назад +1

    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

    • @indzara
      @indzara  2 года назад +2

      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.

  • @KB-ie7zu
    @KB-ie7zu Год назад +1

    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!

    • @indzara
      @indzara  Год назад

      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.

  • @shaguntiwari8801
    @shaguntiwari8801 2 года назад +1

    Sir how should we make online applicat tracking system and talent lookup portal ? Please reply

    • @indzara
      @indzara  2 года назад

      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.

  • @prakhanintaramas9341
    @prakhanintaramas9341 7 лет назад +1

    This is vert best report but I have 1 question. What do you mean day in Mkt?

    • @indzara
      @indzara  7 лет назад

      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.

  • @rahulravindran3810
    @rahulravindran3810 2 года назад +1

    Hi Team, please could you confirm if this will work with just excel, or does it require power Bi or other similar applications?

    • @indzara
      @indzara  2 года назад

      Thanks for your interest. Yes it will work with just Excel. It is a single regular Excel file. The latest version video is here ruclips.net/video/zLNeR2ziaOw/видео.html. Please let us know if any questions. Best wishes.

  • @RockChetu1995
    @RockChetu1995 Год назад +1

    Can we get this template to check and create our own

    • @indzara
      @indzara  Год назад

      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/
      ruclips.net/video/zLNeR2ziaOw/видео.html
      Best wishes.

  • @nilarhtetmon9119
    @nilarhtetmon9119 11 месяцев назад

    I can't fill other values except 1 in application slide job id😢 how should i do?

    • @indzara
      @indzara  11 месяцев назад

      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.

  • @maryammirza1916
    @maryammirza1916 Год назад

    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!

    • @indzara
      @indzara  Год назад

      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.

  • @ArabSadeqAbuarab
    @ArabSadeqAbuarab 2 года назад +1

    Hi, can I edit hiring stages from 6 to be 9 stages?

    • @indzara
      @indzara  Год назад

      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:
      ruclips.net/video/zLNeR2ziaOw/видео.html
      Following is the template link:
      indzara.com/product/recruitment-manager-excel-template/
      Best wishes.

  • @simonemynhardt7001
    @simonemynhardt7001 Год назад +1

    How do I download template Please?

    • @indzara
      @indzara  Год назад

      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.

  • @faizanghojariya358
    @faizanghojariya358 2 года назад +1

    Dear ,
    Can i get this excel templates?

    • @indzara
      @indzara  2 года назад

      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.

  • @eloifiedacan4567
    @eloifiedacan4567 2 года назад

    Hello sir, very nice tracker.. does it allow the user to custom the fileds in the slicer dashboard too?

    • @indzara
      @indzara  2 года назад +1

      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:
      ruclips.net/video/zLNeR2ziaOw/видео.html
      Best wishes.

  • @taliatehilahz7437
    @taliatehilahz7437 2 года назад +1

    Hello my dear, we would like to create a recruitment dashboard how can we contact you?

    • @indzara
      @indzara  2 года назад

      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.

  • @HR-Mukesh
    @HR-Mukesh 2 года назад +1

    Can I get the dashboard please

    • @indzara
      @indzara  2 года назад

      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.

  • @AbadyALRaffa3
    @AbadyALRaffa3 3 года назад

    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

    • @indzara
      @indzara  3 года назад

      Thanks for reaching out. We will respond today to your request. Thank you. Best wishes.

  • @captainmartine
    @captainmartine Год назад

    Requested Sir,
    How to download this sheet dataset , please share the drive link.

    • @indzara
      @indzara  Год назад

      Following is the link to the template:
      indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/
      Best wishes.

  • @taliatehilahz7437
    @taliatehilahz7437 2 года назад

    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

    • @indzara
      @indzara  2 года назад

      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.

  • @susansimmons-stevenson2411
    @susansimmons-stevenson2411 4 года назад

    Where is the step by step demo? The dashboard is not populating.

    • @indzara
      @indzara  4 года назад

      The step by step user guide is available in following links:
      indzara.com/2016/07/user-guide-enter-data-recruitment-manager-template/
      ruclips.net/video/vKR6R-UtCwE/видео.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.

  • @bhaveshchauhan3359
    @bhaveshchauhan3359 2 года назад +1

    Hi, How do I download the template?

    • @indzara
      @indzara  2 года назад

      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:
      ruclips.net/video/zLNeR2ziaOw/видео.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.

  • @nunegrigoryan6408
    @nunegrigoryan6408 4 года назад

    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?

    • @indzara
      @indzara  4 года назад

      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.

  • @Kptravelogues
    @Kptravelogues 5 лет назад

    Pls explain how have you prepared HR dashboard template along with formulas used

    • @indzara
      @indzara  5 лет назад

      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: ruclips.net/video/tgBXh6-DFQQ/видео.html
      Best wishes.

  • @iamthealbertliao
    @iamthealbertliao 4 года назад

    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

    • @indzara
      @indzara  4 года назад

      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.

    • @iamthealbertliao
      @iamthealbertliao 4 года назад

      @@indzara Thanks. I didn't see that in the walkthrough. Can I get a screenshot of what that would look like?

  • @audreywatson2103
    @audreywatson2103 5 лет назад

    The data is not auto populating. The applicants are not showing once I enter them in the fields.

    • @indzara
      @indzara  5 лет назад

      Thanks for e-mailing the file. I have responded to your e-mail.
      Thanks & Best wishes.

    • @indzara
      @indzara  5 лет назад +1

      Thanks for e-mailing the file. I have responded to your e-mail.
      Thanks & Best wishes.

    • @indzara
      @indzara  5 лет назад

      Thanks for e-mailing the file. I have responded to your e-mail.
      Thanks & Best wishes.

  • @rohullahdilawanen9850
    @rohullahdilawanen9850 7 лет назад

    I want to purchase this but I dont have credit card? Can I pay through western union?

    • @indzara
      @indzara  7 лет назад

      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.

  • @danahancock6418
    @danahancock6418 2 года назад

    Hello! Do you have this in a Google Sheets version?

    • @indzara
      @indzara  2 года назад

      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.

  • @rajkori9819
    @rajkori9819 4 года назад

    Do you have anything similar for recruitment companies or for consultants or freelancer recruiters???

    • @indzara
      @indzara  4 года назад

      Recruitment Companies or Freelancers can use the template as well. is there anything specific you are looking for? Please let me know.
      Best wishes.

    • @rajkori9819
      @rajkori9819 4 года назад

      Yes, connect me with on koriraj003@gmail.com.

  • @Snaidu2803
    @Snaidu2803 5 лет назад

    Can you please show us the attrition analysis report??

    • @indzara
      @indzara  5 лет назад

      Thanks for the suggestion. Will do my best.
      Best wishes.

  • @rupaltomar2495
    @rupaltomar2495 4 года назад

    Can u please do a video explaining the slicer in detail

    • @indzara
      @indzara  4 года назад

      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.

  • @lusanatsobo3350
    @lusanatsobo3350 Год назад

    How do I get access to the templet

    • @indzara
      @indzara  Год назад

      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:
      ruclips.net/video/zLNeR2ziaOw/видео.html
      You can purchase our template from the below link:
      indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/
      Best wishes.

  • @TheRubansingh
    @TheRubansingh 6 лет назад

    I M RUNING A PLACEMENT COMPANY IS DER ANY SHEET TO MAINTAIN DATA OF CANDIDATES ACORDING TO VACANCY..

    • @indzara
      @indzara  6 лет назад

      Can you please clarify with more details? This template can track jobs posted and candidates who applied to those jobs.
      Best wishes.

  • @CKNguyen
    @CKNguyen 6 лет назад

    can it still work when we upload the template to google sheet?

    • @indzara
      @indzara  6 лет назад

      Sorry, this works only in Microsoft Excel.
      Best wishes.

  • @bishalgupta7058
    @bishalgupta7058 7 лет назад

    what data does row 5 contains in the application sheet?

    • @indzara
      @indzara  7 лет назад

      Field names for the Applications table. Thanks.

  • @rohullahdilawanen9850
    @rohullahdilawanen9850 7 лет назад

    What are the basis for the cost to recruit an applicant?

    • @indzara
      @indzara  7 лет назад

      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.

  • @missi010
    @missi010 6 лет назад

    i have not understood the use of calculated field

    • @indzara
      @indzara  6 лет назад

      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.

  • @pradeepkumar-lv9pd
    @pradeepkumar-lv9pd 2 года назад

    how to free download for sample

    • @indzara
      @indzara  2 года назад

      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.

  • @cesiagama3682
    @cesiagama3682 6 лет назад

    In the dashboard how does it filter by location? is this done in the position? or is this reported from the candidate area?

    • @indzara
      @indzara  6 лет назад

      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.

  • @pritihathi9037
    @pritihathi9037 2 года назад

    How to built this

    • @indzara
      @indzara  2 года назад

      Sorry, we don't have a tutorial yet for this template. But there is a tutorial for a basic version of Recruitment tracker: ruclips.net/video/tgBXh6-DFQQ/видео.html
      Please let us know if any questions.
      Best wishes.

  • @shefalisaini6549
    @shefalisaini6549 2 года назад

    Can i get tutorial video of thi?

    • @indzara
      @indzara  2 года назад

      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.

  • @captainmartine
    @captainmartine Год назад

    It's a paid template 😒

    • @indzara
      @indzara  Год назад

      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:
      ruclips.net/video/zLNeR2ziaOw/видео.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.

  • @gunkapoor
    @gunkapoor 7 лет назад +1

    really awesome!

    • @indzara
      @indzara  7 лет назад

      Thank you. Best wishes.

  • @rawatac1
    @rawatac1 6 лет назад

    How can I get this excel sheet ?

    • @indzara
      @indzara  6 лет назад

      Please see the product page indzara.com/product/recruitment-manager-excel-template/
      Please let me know if there are any questions.
      Thanks & Best wishes.

    • @rawatac1
      @rawatac1 6 лет назад

      Indzara according to Indian rupees it is not in the budget. Too much costly

    • @indzara
      @indzara  6 лет назад

      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.