Tips for using corporate roster templates
Corporate Roster TemplatePreparation 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 Tips for Corporate Roster Templates
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: Hide the chapter list
Select the first line, hold down [shift+F] to open the "Find and Replace" dialog box, "Remarks to find all, hold down shift+A to select all, then close the dialog box, hold down [ctri+0] to hide
4: Quickly select specific columns
Select the table area, click the "Create from selected content" dialog box under the [Formula] tab, select "First Row", after the settings are completed, open the name box in the upper left corner, click the corresponding list to jump to the specified column.
Two-column name verification
If you want to check whether the name in Table 2 appears in Table 1, a formula can be used to do it immediately.
=IF(COUNTIF(A:A,C2),"Yes","No")
Recommended by the editor of Huajun Software Park
The corporate roster template is a very practical form, and most of the forms are for general purposes. If you just need to download the corporate roster template Excel form, download it quickly.Onboarding form template,Employee performance appraisal formIt is also a good form. Welcome to click to download and experience it!
it works
it works
it works