Tips for using personnel rosters
personnel rosterPreparation of:
First, the basic information of the worker, including the worker’s name, gender, citizen ID number, household registration address and current address;
The second is the form of employment, including full-time employment, part-time employment, labor dispatch, etc.;
The third is the starting time of labor, that is, the time when workers actually provide labor.
The fourth is the term of the labor contract, including fixed term, no fixed term or a term based on the completion of certain work tasks.
General Roster Tips
1: Double-click to quickly apply functions
There is no need to type the same function one by one. When you have set the function for the cells in the first row, just move the cursor to the lower right corner of the cell, wait until it turns into a small plus sign, double-click, and the formula will be applied to all the remaining cells in the column. Gerry.
Isn’t this much easier than dragging with the mouse?!
2: Quickly add or delete a column
For those of you who have to deal with Excel all day long, this trick may save you a little time. When you want to quickly insert a column, type Ctrl + Shift + '=' (Shift + '=' is actually the + sign) to insert a column to the left of the selected column, and Ctrl + '-' (minus sign) ) will delete the column you selected.
Recommended by the editor of Huajun Software Park
The personnel roster is a very practical form, and most of the filling forms are for general purposes. If you happen to need to download the personnel roster Excel form, please download it quickly.Recruitment data statistics table,System Approval FormIt is also a good form. Welcome to click to download and experience it!
it works
it works
it works