How to use Excel to make a software to calculate the performance appraisal of various departments?

Method steps.

Choose? "Start"?Procedure" ?microsoft office→?Microsoft Office Excel 2007 command to open a new workbook.

Enter the contents of ** in sheet1 in the worksheet in book1, and adjust the column width of ** so that the data in the cells can be displayed.

Select the title line of **, switch to the "Start" tab, click the "Center After Merge" button in the "Alignment" option group, and set the font to "Chinese Kai", font size to "18", bold effect, etc.

Select (A10:D11)** below the assessment results, click the Center After Merge button in the Alignment option group, then right-click the cell where the title is located, select the Format Cells option from the shortcut menu that pops up, the Format Cells dialog box will pop up, switch to the Alignment tab, select the Word Wrap checkbox in the Text Control option group, select anything other than the title, switch to the Start tab, and in the Alignment option group, click the Vertical Center button.

Select the range of cells that need to set the border, and then right-click, select the "Format Cells" option from the pop-up shortcut menu, and open ? Format Cells dialog box. Switch to the "Border" tab, select a single line in the "Style" option group, select the "Outer Border" and "Inner Border" options in the "Preset" option group, select the 4th line of **, right-click, select the "Insert" option from the pop-up shortcut menu, you can insert a blank line, enter "Fraction Segment" in the B4 cell of the blank line, enter "Grade" in the D4 cell, switch to the "Start" tab, click the "Bold" button in the "Font" option group, the effect is as shown below.

Select cell B5:B9, switch to the "Data" tab, and click the "Data Validity" button in the "Data Tools" option group. In the Data Validity dialog box, select the Sequence option in the Allow drop-down list, enter the items to be included in the drop-down list in the ** text box, enter below 60 points, 60-80 points, and more than 80 points, and click OK to complete the setting.

Select cell d5:d9, switch to the "Data" tab, and click the "Data Validity" button in the "Data Tools" option group. In the "Data Validity" dialog box, select the "Sequence" option in the "Allow" drop-down list, and enter the items to be included in the drop-down list in the "**" text box, enter "Qualified, Good, Excellent" here, click the "OK" button, you can complete the setting operation and return to the excel sheet, at this time, move the cursor to the cell or cell area with the data validity set, the prompt information will be displayed automatically, click the drop-down arrow on the right side of the cell, In the pop-up menu, select the specified scope.

Install flashing tools on your computer, such as flashing wizards, flashing masters, etc., and install the drivers. Generally, when connected to the computer, it will automatically match the corresponding model and recommend the corresponding ROM version, and it is recommended to use the stable and lite version of the ROM. Select the ROM and check the data that needs to be backed up,Follow the interface prompts step by step to complete the flashing,During the flashing process, you need to pay attention to whether the power is sufficient,If there is any important data, you need to transfer or back up first。

After completion, the flashing operation is being carried out.

It depends on your specific content and requirements.

The first is to establish performance appraisal standards. Establishing performance appraisal standards is a basic task for enterprises. The determination of performance appraisal criteria is also based on job analysis, and the results of job analysis determine the performance appraisal criteria.

Secondly, in order to determine the content of performance appraisal and implement performance appraisal. Generally speaking, the content of employee performance appraisal mainly focuses on two aspects: work performance and behavioral performance, and the relevant personnel make objective records of the actual achievements and performance of the evaluated employees, and determine the performance level on different indicators.

Finally, it is necessary to identify comments and improvement measures. At this stage, the work of the evaluated employees is comprehensively evaluated, the final evaluation grade is determined, and its advantages and disadvantages are pointed out and improvement plans are formulated.