Product Details
System Requirements
Videos
Product Info
System Requirements
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. Videos
Part 1: General Setting
Overview: https://youtu.be/y2IQxouFsJ0
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
Product Info
HR Dashboard Excel Template
Dashboard DP01 – Combine HR Dashboard Vol 1: HR Overview and HR Dashboard Vol 2: Recruitment and Termination in one file
One Time database setup/record and shares data on both Dashboards
Basic Information
Template is suitable for small and medium-sized company.
Supports up to 4 levels of company structure: Division -> Department – >Section -> Position
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 Number of employee consideration:
You should also keep in 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.HR Dashboard Vol 1: 18 graphs
Orientation statistic. Number of holidays (Used/Unused). Number of temporary employees and alert before the contract expires. Number of employees with special needs/disables. Actual number of employees VS number according to plan (budget). Number of vacancies and positions that exceed the plan (budget). Number of employees, vacancies and over budget in each Division and Department. List of positions and the number of vacancies List and the number of position that exceed budget. Division and Department proportional graph (Treemap Chart available from Excel 2016 and up). Level/job grade, the number of employee and their total salary in proportion of the whole company. Proportion of local employees and expatriate. Proportion of marital status. Proportion of gender Number of employees divide by age and gender together. Ratio of education level and age together Number in each type of employment. Number of employee categorized by Year of Service.HR Dashboard Vol 2: 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 support@sweetexcel.com, 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.If the computer does not have the font that is set in the template, the display on your screen will not match the picture 100%. If you are not sure about the font, you can inquire font name by email or Facebook page: sweetexcelbymd. However, most of our templates use the font that comes with Microsoft Office 365.
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!
D009 Simple NPS Dashboard
Price range: ฿629.00 through ฿1,590.00 Select options This product has multiple variants. The options may be chosen on the product page - Sale!
D008 Personal Income Expense and Saving Tracker
Original price was: ฿1,190.00.฿749.00Current price is: ฿749.00. Select options This product has multiple variants. The options may be chosen on the product page - Sale!
D007 Team To Do List + Schedule (for 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
