Registration form for graduates of ordinary colleges and universities

Registration form for graduates of ordinary colleges and universitiesIt is a registration form used by graduates of various academic education to fill in their obtained student status and graduation files. The free download of the Excel template of the general college graduate registration form template is provided by Huajun Software Park. The source file is in xlsx format. You can edit and modify the content and style by downloading the source file. More about the free download of the general college graduate registration form template. Please pay attention to Huajun Software Park.

Tips for using the registration form for graduates of general colleges and universities

​​​Registration form for graduates of ordinary colleges and universitiescontent:
​​​1. The graduate registration form must be taken seriously, and appraisers and appraisal agencies must treat it with caution.
​​​2. The graduate registration form must be filled in by yourself.
​​​3. Post a recent one-inch bareheaded photo.
​​​4. If there are other explanations, please attach a separate sheet of paper.

General tips for registration forms for graduates of general colleges and universities ​ ​ 1. Find duplicate content formula: =IF(COUNTIF(A:A,A2)>1, "Duplicate", "").
​ ​ 2. Use the year and month of birth to calculate the age formula: =TRUNC((DAYS360(H6, "2009/8/30", FALSE))/360,0).
3. Calculation formula from the birth year and month of the entered 18-digit ID number:
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2)).
​​ 4. To let the system automatically extract the gender from the entered ID number, you can enter the following formula:
=IF(LEN(C2)=15, IF(MOD(MID(C2,15,1),2)+1."Male","Female), IF(MOD(MID(C2,17, 1),2 )=1,"Male","Female")) "C2" in the formula represents the cell where the ID number is entered.
Recommended by the editor of Huajun Software Park

Registration form for graduates of ordinary colleges and universitiesIt is a very practical form, and most of the forms to be filled in are for general purposes. If you happen to need the registration form for graduates of ordinary colleges and universities, please download it quickly. also,Class statistics table,Class conduct rating formIt is also a good software. Welcome to click to download and experience it!