Personnel statistics tableHow to fill in?
1. Responsible for formulating the company's sales and order digitalization goals, decomposition goals, and move management.
2. Responsible for the follow -up and analysis of the completion of the sales target and inventory index, and submit the feasibility solution;
3. Responsible for the work specifications and operation processes of product management, organize product MD meetings, organize commodity allocation related training;
4. Responsible for the analysis of the company's operating status,
5. Preparation of production plans
6. Supervision of production planning
7. Production progress tracking
8. Production data statistics
9. Task order
10. Daily production scheduling managementPersonal statistical table universal skills 1: SUM function (mathematics)
In daily work and learning, SUM is a widely used application and as an entry -level function to learn. Therefore, overall, the SUM function is not difficult, but it is widely used. However, you can't look down at Sum because of simplicity. It also has some unknown tips! First, the accumulation and as shown below are the sales performance of a certain company every day. It is required to calculate the daily accumulated amount.
For example, enter the formula in the D2 cell: = SUM (C $ 2: C2), and fill it down after pressing the ENTER key.
Note: At this time, the C $ 2 must be locking the line label, so that during the pull -down process, a reference area from the second line to the bottom line will be generated.
2: The sum of the sum of the qualified cell
The sum of the merger of cells has always been a problem that is more headache for novices.
Select the D2: D13 cell area, and then enter the formula in the formula editing column: = SUM (C2: C13) -sum (D3: D14), and then press it. Note: Be sure to pay attention to the area range of the second SUM function. Misplays, otherwise an error will be reported.
3: Unit in a small plan
How can a cell with a small plan ask for peace? In the C9 cell is the input formula: = Sum (C2: C8)/2, and press the ENTER key to complete.
Note: This is the process of using the small plan and the puppets of self -use. The above data is repeatedly calculated.
Personnel statistics tableIt is a very practical form, and most of the forms are used in common purposes. If you just need a personnel statistical table, come and download it. also,Hospital visiting hospital registration form,Inventory table for the year -end warehouse cargo inventoryIt is also a good software, please click to download the experience!
it works
it works
it works