Current location - Plastic Surgery and Aesthetics Network - Wedding planning company - How to make the performance bonus table of company personnel with excel?
How to make the performance bonus table of company personnel with excel?
1. First, you need to open an excel table, and enter the main title of the table in cell A 1: annual sales performance statistics of real estate companies.

2. Enter serial number, real estate project, sales amount, growth rate, remarks and other information from left to right in the next line.

3. Format the table title: select cells A 1 to E 1, select "Center after merging" in the upper toolbar, and set the font of the table title to 20 bold. ..

4. Select cells A2 to E2, and select "Center" in the toolbar above. The font is set to Song Dynasty and the font size is 12.

5. Select cells A2 to E8, click the right mouse button, select "Cell Format", and select and set the appropriate border.

6. Select cells A2 to E2, set the fill color to gray, and beautify the table.

7. Then enter the data.