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.
Overview: https://youtu.be/y2IQxouFsJ0
First Time Setup: https://youtu.be/pJHv068j0to
Data Input and Other Techniques: https://youtu.be/u1s0AbCpaTw
HR Dashboard Template – Company Snapshot
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 Number of employee consideration:
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 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.
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!
D011 SWOT Analysis Dashboard
Price range: ฿219.00 through ฿649.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!
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
