Forum Discussion
Macros For Performance Management
Hey everyone! I am an Excel novice and also and HR professional. Frankly, I usually use Excel for payroll and not advanced processes such as Macros and VBAs. I was tasked with creating a Perfo...
Creating a database of employees along with their departments.
Why need a database?
run sql?
What are the exact problems you want to solve?
Why need a database?
run sql?
What are the exact problems you want to solve?
Hey there,
Basically, I have the following problems:
1. The form has a few managers. I need each employee to be rated by 2 managers. Each of these two has to open the form and rate and the sum of their rating divided by two.
2. I don't necessarily need a database as in SQL but I do need to create a list of employees and a check box or drop list two choose employees.
3. The ratings need to have a dashboard to check employee performance over a period of time and compare to other employees.
- The form has a few managers. I need each employee to be rated by 2 managers. Each of these two has to open the form and rate and the sum of their rating divided by two.
Do you want to collect infomation from mutiple users/managers?
create a list of employees and a check box or drop list two choose employees.
UI should include a checkbox?
dashboard
Chart? or.just a table.
There are two solutions.
1,collect info by online form like ms form and data analysis.by sql
2,collect info by.email and cosolidate all.sheets data analysis by formula or power query。