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
- Do not edit calculated cells
- Input Data is always visible & can be edited easily
- Backup by saving file regularly
- Do not rename fields used in Pivot Tables
- 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
Color me stupid but what does the DT mean?
Thanks for your message.
“DT” means date. The dates when interviews are held.
Best wishes
the “applicant tab”, is it limited to a certain number? After 37, the solid line that is normally below the new applicant doesnt move down, nor are the columns (from row 37 and down) formatted for “date”. They all say “general” instead. Im sure i can have more than 36 apps, right? I use this for a trucking company that hires multiple positions.
Thanks for using our template.
The data is entered in a table format. Please extend the table down and the data format would be extended.
If it still does not work, please email your file along with the list of issues to contact@indzara.com
Best wishes
got it, thx!
Hi,
I have filled all the information required but the dashboard is completely blank. Why is this happening?
Thanks
Thanks for using the template. Please see this https://indzara.com/2018/05/recruitment-manager-why-dashboard-not-updated/ for common reasons and solutions.
If there are further questions, please email file to support@indzara.com
Best wishes.
Thanks for using our template.
Please ensure that you have refreshed the dashboard.
Best wishes
After reading and watching your intros, I really like this template. However, I would like to take it a bit further. Does the template come protected or can I customize it further?
Thanks for your interest in our template.
As a whole, you can use this template after buying. You can make a few changes as needed. However, the stages of recruitment are limited. Also, while making changes, ensure that you do not delete any formula.
Best wishes
Hi,
I am unable to get the dashboard to populate. I have no errors, and I watched the video on the most common causes of not populating. I can’t find any issue that would be the cause.
I do have jobs in Open, Completed, and Cancelled status. I also have populated eighteen applications in hired and not hired status with no errors.
Thanks for purchasing our template.
Please ensure that you have filled the dates for each stage. Also, the job posting date should be prior to dates of any stage.
In case it still does not work, please email your file with the list of issues to contact@indzara.com
Best wishes
Hi, how can I add a couple of stages? Such as, final interview and credentialing?
Thanks for your message.
As of now, this template can handle 6 stages. You may rename a stage. We might be able to add more in the future release.
Best wishes
Hello,
My question is regarding the reporting dashboard. If I am looking for reporting by specific job do I need to use a separate worksheet per job? Are you able you sort data so the dashboard report can provide total activity or per job?
Thanks for your question.
The Dashboard has several filters such as Job Location and Job Title that allow narrowing down the scope. If you need a specific job ID, please try the JOB REPORT sheet, which shows metrics for one Job ID and candidates for the specific job and specific Recruiting Stage. Also, in the Applications sheet, you can filter by Job ID to see all the applications for that Job ID.
Please let us know if any questions.
Thanks & Best wishes.
hello
can I change the language of the template?
The language cannot be easily changed across the entire template. Most Input data can be entered in any language and is not a problem. However, there are certain specific values such as Application Status values that are used in formulas. Using a different language input will require changing those formulas as well.
To only enter input data such as Employee Name, location, etc. in a different language is fine. Completely converting every word in template to a different language will not be easy.
Thanks & Best wishes.
Hi,
Is there a possible way where I dont need to input ALL my candidates applications name etc (rejected candidates) as its hundreds for each role. Can the calculations for the dashboard be still done without this info?
Thanks for using our template.
The dashboard considers all the applications received, also, the reports will not show you the clear picture.
Best wishes
Hi
I have downloaded the Calendar 2017, I want to modify the names of the months and the days names this due I wanted to use it for RPG game can you explain me where is the data and how I can modify.
Hello
Please use “indzara” as a password to unhide the hidden sheets and edit the details.
Best wishes
Thank you so much
Welcome!!!