Tips for using employee salary tableEmployee salary scheduleContent list:
Salary can be divided into basic salary, commission, performance and additional allowances, etc.:
Basic salary: It is a fixed amount per period per month.
Commission: It is based on the turnover of individual employees such as salesmen, salesmen, real estate agents, travel agency tour guides, etc., the more you work, the more you get.
Performance: It is the amount of output produced by the company's employees in their labor.
Subsidies: including high temperature allowance, mid-night shift allowance, transportation allowance, rent allowance, telephone allowance, meal allowance, etc.
General tips for employee salary table forms
1. Modify the font
First, let’s start with input and adjust the font. You can find the font tool box at the beginning of the toolbar, where you can quickly change the font type, size, color, etc.
2. Insert and delete cells
In the cell tool box, you can quickly insert or delete cells with one click. For example, sometimes when typing, a row of data is missed. Here, click "Insert Row" in "Insert Cell" under "Rows and Columns" and it will be OK.
3. Fill merged cells
As long as the data range is selected, unmerge the cells first. Then press Ctrl+G to locate the null value. Then enter the equal sign, press the up arrow of the direction key, and finally press Ctrl+Enter.
Recommended by the editor of Huajun Software Park Employee salary scheduleIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Details of salary payment to retired personnel,Time deposit detailsDownload to get the source file, which you can edit, modify and replace. To download the employee salary table, go to Huajun Software Park.
it works
it works
it works