Retention Dashboard – Excel Template – Support Page

Posted on

Thanks for visiting the support page for Retention Dashboard Excel Template which can help simplify employee retention tracking in your organization.

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 Important Tips before using the template
    • Input Data is always visible & can be edited easily
    • Refresh Calculations after entering or updating input data
    • Backup by saving file regularly
  • 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

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.

9 thoughts on “Retention Dashboard – Excel Template – Support Page

  1. Hi!

    I have successfully used the template to determine 2020 turnover over the last 12 months. However, I now would like to use the template to obtain the numbers for turnover from august 2018 to September 2019. Is there a way to modify the formulas so that I can capture this time frame? I entered the employee data for these dates already, just trying to get the calculations to populate.

  2. Indzara,

    I’ve worked on the worksheet however, the retention data work sheet is not updating. I’m working on a 10 year cycle and not 12 months. The other sheets have updated accordingly. Do advise on how best to resolve this.

    Regards

    1. Thanks for using our template.
      Please review the user guide at https://indzara.com/2019/12/retention-dashboard-user-guide/.

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

      Best wishes

  3. I need to change to parameters to 1500 employees. How do you do that?

    1. Hello

      The template has a hidden sheet named HELP which is limited to 1000 rows. That table needs to be extended down to more rows. Then, automatically the dashboards will pick up more than 1000 rows entered in the Employees Data sheet.

      Thanks

  4. Good Morning,

    What information should be entered into employee id? Should that be active or exit status?

    1. Good Morning,
      Employee ID can be any unique number or alpha numeric value. If the employee is still with the company, please do not enter exit date. It will be considered active employee. If there is an exit date, it will be counted as Exit employee.
      Best wishes.

  5. Dear Mr Indzara
    I purchased Retention Dashboard and I have some issued with SNAPSHOT DASHBOARD & EXIT DASHBOARD the data did not come to those page

    1. Thanks for purchasing our template.

      Please share your file with the list of issues that you are facing. We will try to fill the issues as feasible.

      Best wishes

Leave a Reply

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