T001 Sweet Column Chart 
T002 Sweet Column Chart 
T003 Sweet Column Chart 
T004 Sweet Pie Chart 
T005 Sweet Bar Chart 
T006 Sweet Combo Chart 
T007 Sweet Column Chart 
T008 Progress Pie Chart 
T009 Sweet Combo Chart 
T010 Sweet Column Chart 
T011 Sweet Combo Chart 
T012 Sweet Column Chart 
T031 Sweet Column Chart 
T034 Sweet Column Chart 
T018 Stacked Column Chart 
T036 Sweet Stacked Column Chart 
T037 Sweet Column Chart 
T028 Sweet Column Chart 
T017 Sweet Column Chart 
T016 Column Chart 
T033 Sweet Stacked Column Chart 
T047 Sweet Column Chart 
T044 Sweet Column and Line Chart 
T029 Sweet Doughnut Chart 
T026 Progress Pie Chart 
T013 Sweet Progress Pie Chart 
T025 Sweet Bar Chart 
T022 Sweet Line Chart 
T014 Sweet Column Chart 
T055 Sweet Gauge and Bar Chart 
T052 Sweet Radar Chart 
T042 Sweet Radar Chart 
T038 Sweet Timeline Chart 
T035 Sweet Guage Chart 
T020 Sweet Combo Chart 
T048 Progress Pie Chart 
T021 Sweet Column Chart 
T032 Sweet Pie Chart 
T045 Sweet Pie Chart 
T039 Sweet Butterfly Chart 
T024 Sweet Bar Chart 
T015 Sweet Column Chart 
T040 Sweet Column Chart 
T043 Sweet Column Chart 
T041 Sweet Line Chart 
T046 Sweet Column Chart 
T027 Sweet Column Chart 
T030 Sweet Bar Chart 
T051 Sweet Bar Chart 
T053 Sweet Column Chart 
T019 Sweet Pie Chart 
T023 Sweet Line Chart
Discount!
DP01 HR Combo Dashboard Vol 1 & Vol 2
฿5,099.00 – ฿6,290.00
- Share
Product Details
Product Info
*System Requirements
Videos
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@sweet-excel.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.
*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
Related products
-
Discount!
D009 Simple NPS Dashboard
฿629.00 – ฿1,590.00 Select options This product has multiple variants. The options may be chosen on the product page -
Discount!
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 -
Discount!
D007 Team To Do List + Schedule (for Google Sheet)
฿1,699.00 – ฿2,680.00 Select options This product has multiple variants. The options may be chosen on the product page -
Discount!
D004 Task Planner (Standard Version)
฿529.00 – ฿950.00 Select options This product has multiple variants. The options may be chosen on the product page -
Discount!
D003 Auto Organization Chart Generator
฿1,909.00 – ฿6,290.00 Select options This product has multiple variants. The options may be chosen on the product page
