When leaders want to know the length of service of all employees, I hope you can make a statistical analysis chart of the length of service and make an analysis report of the length of service of employees. At the same time, they hope to analyze from two dimensions, one is the length of service structure of employees, and the other is the performance sales with different length of service.
Generally, we need to make a summary of the length of service first, and then make a summary statistical analysis according to the performance of different lengths of service. In the process of statistical analysis, we need to set the formulas of different length of service in EXCEL. After calculating the length, our table may still look a little messy, so we were busy for a while and adjusted the data of the table to make the whole table look much fresher.
Then, we began to move the data in the table. In this process, we may need to spend more time setting function parameters, object formats and so on in EXCEL. Although the dynamic chart of seniority structure analysis that leaders want can be made eventually, the efficiency of leaders' analysis and decision-making will be discounted if the time for making analysis report is too long.