Tips for using performance appraisal forms for administrative managers
Administrative Manager Performance Appraisal FormPreparation of:
1. Develop performance plan stage
Performance planning refers to a management process in which managers and employees discuss and communicate about the time, responsibilities, methods and processes to achieve goals, so as to determine what process employees will use to complete what kind of work and what performance goals they will achieve.
2. Preparation of performance evaluation indicators stage
Generally speaking, performance evaluation indicators can be set using the SMART principle.
3. Provide training to personnel responsible for performance evaluation
Performance evaluation is a very important task. It is necessary for us to provide relevant training to such personnel so that they can promote performance evaluation work realistically with high professional ethics and high work skills.
General Tips for Administrative Manager Performance Appraisal Form
1: How to sum text
In some relatively non-standard tables, there will be a problem of mixing text and numbers, which makes summation difficult.
Enter the formula in cell C12: =SUM(--SUBSTITUTE(C2:C11,"元",""))
Press the key combination to complete.
2: Sum of multiple worksheets
For example, some tables have performance statistics for several months, and Zhang Cheng’s position in each worksheet is the same. Find Zhang Cheng’s commission statistics from a certain month to a certain month.
Enter the formula in cell F5: =SUM('January:April'!C2), and press Enter to complete the filling.
Note: The above reference is supported in Excel, but it seems not supported in WPS. And please note that the structure or fixed position of the numbers in each table is the same before you can use this formula.
3: Multi-region joint calculation
In some worksheets, we do not need to sum continuous areas, but may be summing several discontinuous areas.
For example, there is a table that calculates the totals from January to February, March and May to June.
Enter the formula in cell H2, press the Enter key to complete and fill downwards.
=SUM(B2:C2,E2,G2)
Recommended by the editor of Huajun Software Park
The Administrative Manager Performance Appraisal Form is a very practical form, and most of the forms are for general purposes. If you happen to need to download the Excel form of the Administrative Manager Performance Appraisal Form, please download it quickly.List of original textbooks in foreign languages,Sales monthly plan templateIt is also a good form. Welcome to click to download and experience it!
it works
it works
it works