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

  • Hello Team,

    I am having issues with the Dashboard. The pipeline efficiency of hiring is not populating. The rest of the fields are refreshing.

    please advise.

    Reply
  • Hello I buy this template for rental but I can set up can you tell me how to do it or any cell that I can call you ways

    Reply
  • Hi,

    I recently downloaded the Recruitment Manager template. I was wondering if it’s possible to get the excel file you’re reviewing in the product video demo, it would be very helpful to have the file as a reference for how a completed document looks and works.

    Thank You in advance for your help.

    Reply
  • Hello,
    Excellent work on this template!

    Is it possible in the Dashboard to change The Recruitment Funnel from percentage to numerical ?

    Reply
    • Hello

      Thank you for your feedback.

      It would require modifying data for the funnel chart. The numerical values are in the hidden HELP sheet.

      Best wishes

      Reply
  • I’m needing assistance with the Recruiter Manager spreadsheet. I am receiving a lot of errors when I use the applications page; therefore, it won’t allow me to see the actual information on the dashboard and job report. I am running on macOS High Sierra Version 10..13.5/Excel 2016. I have an application status and a decline reason. I have reviewed the step by step instructions and still can’t figure out why it is showing an error. Can you help, please?

    Reply
  • I added my 5 Developers, line by line (#4-8), in the Resources tab, but a roll up of the calculation doesn’t show. Why do multiple resource of the same skill group from the Resources tab not calculate on the Capacity or Surplus Deficit tabs? I can insert add other additional resources of the same skill group and they calculate, but not for the 1st sill group in my list (which is the most important).

    Reply
    • Thanks for purchasing the Resource Capacity Planner template. Thanks for emailing the file. I have responded to your email with screenshot. Please respond to the email with any questions.
      Thanks & Best wishes.

      Reply
  • Can the Recruitment Manager be converted to a google sheet? Or shared in a google drive with others?

    Reply
    • Hello,

      This template works on Excel. Its performance will be compromised if used over Google Drive.

      Best wishes

      Reply
    • Hello

      Please share the email id used to purchase the template or the order id.

      Best wishes

      Reply
    • Yes, it is one-time purchase. There is no recurring fee.
      Best wishes.

      Reply
  • Hello,

    I need to hide the formulas or the column that contain formulas ( don’t want them to appear to my data entry assistant) , but the moment I do that by protecting the sheet … the sheet stop working , as when I enter a new row by adding new JOB ID nothing changed…but when I unprotect the sheet everything goes back to normal

    P.S I made sure that I select which cells to be locked/hidden and which to be edited( unlocked) from the format cell options.

    Thanks.

    Reply
    • Thanks.
      The auto-expanding feature of Tables are disabled when we protect the sheet. That’s why I had to leave the sheet unprotected. This is a feature that Microsoft has not implemented yet in Excel.
      If you would like to not show columns, please hide them.
      Please let us know if there are any questions.
      Best wishes.

      Reply
      • thanks a lot for your reply, I have purchased this template but I haven’t received the coupon for the offer of buy one get one for free till now.
        thanks

        Reply

Leave a Reply

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