Product Details
Recommended to use with Excel 2019 and above 
The minimum that can be used is Excel Version 2013 However, with version 2013 and 2016, the stability of the application will not be as good as the newer versions.
Part 1: General Setting
First Time Setup: https://youtu.be/pJHv068j0to
Input Data and other Technique: https://youtu.be/u1s0AbCpaTw
Part 2: Recruitment and Termination
Overview: https://youtu.be/KWNfl7bOjok
Setting and Input Data: https://youtu.be/-0dDWjNeDS8
Recruitment Dashboard
Basic Information
Template is suitable for small and medium-sized company.
10 Divisions 45 Departments 1 Division can have a maximum of 15 Departments, but altogether can have 45 Departments maximum. 75 Sections 1 Department can have a maximum of 20 Sections, but altogether can have 75 Sections maximum. 150 Positions Department/Section can have a maximum of 30 Positions, but altogether can have 150 Positions maximum. 1,500 Employee Records Noted: You should also keep i mind count of all recording (resigned, current, new employees). For example, with 300 current employees, there will be room left to record another 1,200 new employee records. If an average of 10 people enter and exit per month, it can be used for another 10 years without having to modify the formula or remove old data. If exceed 1,500 record, you can edit the formula yourself or remove old data in order to continue recording.
Alternatively, you can use the service from our website to increase the number of employee records. Please contact us for further details and estimate charges.Details of all 27 graphs
1. Number of vacancies 2. Number of requests for new employees 3. Number of applicants at different stages of recuriment for the non-complete request (Pipeline) 4. Number of applicants who have not given a response after the Offer Graph that filter by time period only
5. Cost per interview/lead 6. Cost per hire Graph that filter by time period and department
7. Statistics of applicants at different stages for completed request (Recruitment Funnel) 8. Reasons and number of applicant rejected by company 9. Reasons and number of applicants that rejected offers from company 10. Hire Rate 11. Acceptance Rate 12. Offer Decline Rate 13. Withdrawal Rate 14. Fail Probation Rate 15. Fail Hire Rate 16. Days to Hire 17. Days to Fill 18. Number of interviews/lead 19. Number of employment (Hire) 20. Interview per hire ratio 21. Interviews compared to hiring from different channels (Sources) 22. Number of resignations separate into Turnover and Attrition. 23. Reasons and number of resignations 24. Number of turnovers categorized by gender and age 25. Number of resignations categorized by length of service Graphs that filter by year and department
26. Number of new join VS terminate for each month 27. Company-wide turnover rate for each month compared to each department
Note:
The template is designed to be simple, beautiful and easy to use. Easy to maintain, no VBA (some companies block the use of VBA, so we avoid adding VBA). You can customize everything as needed. Initially, there is a Setting page provided.
The price stated is for ready-made templates only (layout, graph, formulas, data structure) not including setup employee data and any additional modifications. If you want a setup services or additional modifications, we also provide these services. Please ask for the quotation via e-mail md@sweet-excel.om, the price will depends on the details required.
The graph may move slightly depending on each computer setting/specification. This can be fixed simply by moving the object as usual method.You may also like...
Related products
- Sale!
D013 Balanced Scorecard & KPI Tracker (Google Sheet)
Price range: ฿1,699.00 through ฿2,680.00 Select options This product has multiple variants. The options may be chosen on the product page - Sale!
D010 Inventory Management Dashboard
Price range: ฿3,190.00 through ฿4,890.00 Select options This product has multiple variants. The options may be chosen on the product page - Sale!
D005 Task Planner (Pro Version)
Price range: ฿950.00 through ฿1,699.00 Select options This product has multiple variants. The options may be chosen on the product page - Sale!
D003 Auto Organization Chart Generator
Price range: ฿1,909.00 through ฿6,290.00 Select options This product has multiple variants. The options may be chosen on the product page
