The payroll is used to collect statistics from the department to the wage statistics. It would be easier if only one department is used. Here I will introduce the department-specific practices of large companies, as shown below.
First, sort the departments
1. If the department is the same, sort the "basic salary" field in ascending order: Select "A2: M15" in the cell area and select "data ];
2. In the "sort" dialog box displayed, select "department" from the drop-down list of "main keywords", and select "descending order" on the right ], select basic salary from the secondary keyword drop-down list, select ascending on the right, and click OK]
Second, the summary of real-time wages
1. Select "A2: M15" and click "category summary" under "data ];
2. In the displayed category summary dialog box, select the department option from the category field drop-down list, and select sum from the summary method drop-down list ], select the pay-as-you-go check box in the selected summary items list box, retain the default settings for other options, and click OK;
3. Return to the worksheet and complete the classification and summary of the worksheet.
Well, the above is the whole process of making a summary and statistics on the employee payroll in excel. I hope this tutorial will help you.
