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.


  • Can this file be uploaded to Google Sheets or will it only work on Excel?

    • Thank you for showing interest in our template.

      Currently, we do not have the google sheet version of the template and excel template cannot be uploaded in Google Drive to use in Google Sheet due to features compatibility issues.

      You can upload the template to Microsoft OneDrive and use Excel Online which is similar to Google Sheet.

      Best wishes.

  • Hello,
    First – this is AMAZING! Truly, Thank you.

    I need 10 lines for the funnel. Can I change this?

  • Great template! But for some reason, my dashboard is not picking up all open jobs. I am aware of how to use Refresh All on the formulas. And I am also aware that if there are no applications against a job it will show to the right of the open positions. In my instance, I have 3 open jobs that have applications posting against them…but the dashboard only picks up 2 jobs. Any guidance on how to correct this issue? Thank you!

    • Thank you for sharing your valuable feedback and we regret the inconvenience.
      Requesting to share your sheet to with sample data and screenshots highlighting the issue to check further.
      Best wishes.

  • Its a pretty good dashboard when it works but kind of buggy. I keep getting error messages and now the dashboard will show zero data. Is it because I leave the dates blank for people that are not hired? I’ve tried to add an additional sheet to show other data and moved the dashboard closer to the left, is that causing the errors? Do I have to go back in and enter hundreds of candidates one by one? Kind of at my wits end right now.

  • Hey 🙂 really good template but I’ve got one issue – how can I leave some of the fields empty without creating an error? For example if a candidate didn’t have to do a certain stage throughout the interview proccess. Is this possible? Otherwise the dashboard doesn’t display it because it’s an error. thank!

    • Thanks for your feedback. Glad that you find it useful.
      Currently the date fields are required. Please enter the previous stage’s date if a stage is skipped.
      In the next version of the template, we will auto-calculate missing stages.
      Please let us know if any questions.
      Thanks & Best wishes.

  • hello
    i have several rows that are not showing up is there a way to unhide them or show 6-62 are not showing up

  • Hello,
    This seems like a very interesting template for my HRs!
    A question though: in our process, we interview candidate and then assign them to possible project but it seems in your template it works the other way around. So it means a candidate can be applied to multiple positions.
    Do you think we could still use your template properly?

    • Thanks for your interest.
      This template is designed to track candidates for specific job/position. If a candidate can be considered for more than 1 job (for example 3), then the candidate will be entered for 3 jobs separately. I am not sure if your reference to Project is similar to a Job/Position. The template also allows same candidate to be hired for multiple positions.
      Please let me know if any questions.
      Best wishes.


Leave a Reply

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