Indzara

Recruitment Manager Excel Template V2 – Support Page

Thanks for visiting the support page for Recruitment Manager Excel Template which can help simplify your recruitment process tracking.

The following are the support articles to help you get started with using the template. If there are any questions not addressed here, please drop a comment and I will add article/video demo about that topic.

Support Articles

  • Please see this article on 5 Important Tips before using the template
    1. Do not edit calculated cells
    2. Input Data is always visible & can be edited easily
    3. Backup by saving file regularly
    4. Do not rename fields used in Pivot Tables
    5. Refresh Calculations when Pivot Tables are used
  • This template uses Excel tables for data entry. If you are not very familiar with Excel tables, please see this article on How to enter data using Excel Tables?
    • What is a Table?
    • Why do we use Tables?
    • Components of a Table
    • 3 Basic Data Entry Operations
    • 5 Essential Tips to avoid mistakes
  • Step by Step User Guide 
    • Step by Step instructions on entering data
  • Most Frequently Asked Question (Answered)
    • Why Dashboard does not reflect the data I entered in Jobs and Applications sheets?

If you have any questions on the template, please post them in the comments section below. I will respond as soon as I can. If it will benefit others, I will also publish a blog post and video answering your question.

170 Comments

  • The calculating fields are no longer pulling the data across to show me the number hired/number to hire/days in market/number of apps despite still entering new jobs in exactly the same way as always- it worked fine up to job/row 117 then it stopped. Any help would be appreciated

    Reply
    • Thanks for using our template.

      A broken link could be a reason behind this. Please check the links and the formulas.

      In case the problem persists, please email your file along with the list of issues to contact@indzara.com

      Best wishes

      Reply
  • How can I add more recruitment stages? I need 10 different stages

    Reply
    • Hello

      As of now this template supports six stages of the hiring process. You may rename a stage. In our future release, we might add more stages.

      Best wishes

      Reply
    • Thanks for using our template.

      The template is designed to handle six stages now. In the future, we might add more stages. However, you may rename the stages as per your requirement.

      Best wishes

      Reply
        • Hello

          As of now this template supports six stages of the hiring process. You may rename a stage. In our future release, we might add more stages.

          Best wishes

          Reply
  • How do I continue the drop down for “Hired” or “Not Hired” throughout the spreadsheet? Appears as though the field no longer lets me and I have to type in manually.

    Reply
    • Hello

      This can be due to the deletion of some lists in the hidden columns. Please ensure none of the formulae, links are broken. You can download a fresh copy or send your file with the list of issues to contact@indzara.com

      Best wishes

      Reply
  • Hello there,

    It’s a great dashboard, however I would like to replace the title stage “Onsite Interview” to “Pre-Employment Tests/ Checks”.

    It’s just a header change in the dashboard and I don’t know how/ where to do it; please assist.

    If this is not possible please process the refund.

    Thank You, Rui

    Reply
    • Hello
      Please change the stage name in the settings tab. Then change the same in corresponding columns. Finally, the dashboard has images for each stage, which you need to update.
      Best wishes

      Reply
  • The template works great! the only thing i can’t get working is the pipeline efficiency of hiring and the monthly metrics. they don’t show any data on my dashboard, can you please help?

    Reply
    • On the application sheet the HIRED DATE (green colored) gives an error on its formula. It states that there are existing arrow or a circle reference is in the code…

      Reply
    • Hello

      Please ensure that you refresh the data to get the pivots active.

      Thanks

      Reply
  • Good Morning,
    I am interested in downloading the invoice tracker from small business. Unfortunately it’s not letting me download it. Can you give me a suggestion on downloading it or can you email it to me at msvjack@gmail.com? Thanks!!

    Reply
  • HI, great spreadsheet, easy to use. Can I change the word Application to Applicant throughout the spreadsheet ? Or, would this affect the functionality? Thanks..

    Reply
    • Hello

      The name of the sheet is used in formulas for calculation, hence, it might affect the working.

      Thanks

      Reply
  • Hi, I am loving this tool and get so much valuable data out of it. In the cost per hire, is there a chance I can add or have added another area where I can track the relocation costs for the candidate, I want to be able to keep this separate from the other costs like agency and advertising costs. Can this be done?

    Reply
    • Thanks for sharing positive feedback.
      The cost of hiring can be added in the cell or you can add the data in different sheet and show the sum in the cost column.

      Best wishes

      Reply

Leave a Reply

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