Introduction to the Approval Form for Excellent Graduates Excellent Graduate Approval FormProcess:
(一)班级民主评议,推荐符合条件的同学名单连同申报材料一并报系学生科;
(2) The Student Affairs Department of the branch will summarize and review the merit lists submitted by each class, and then report them to the Student Affairs Office after approval by the branch;
(3) The Student Affairs Office will review the outstanding graduates reported by each unit, summarize them and publish them in the college for one week. If there are no objections, they will be submitted to the dean's office meeting for approval.
General Tips for Excellent Graduate Approval Form
1: How to sum text
In some relatively non-standard tables, there will be a problem of mixing text and numbers, which makes summation difficult.
Enter the formula in cell C12: =SUM(--SUBSTITUTE(C2:C11,"元",""))
Press the key combination to complete.
2: Sum of multiple worksheets
For example, some tables have performance statistics for several months, and Zhang Cheng’s position in each worksheet is the same. Find Zhang Cheng’s commission statistics from a certain month to a certain month.
Enter the formula in cell F5: =SUM('January:April'!C2), and press Enter to complete the filling.
Note: The above reference is supported in Excel, but it seems not supported in WPS. And please note that the structure or fixed position of the numbers in each table is the same before you can use this formula.
3: Multi-region joint calculation
In some worksheets, we do not need to sum continuous areas, but may be summing several discontinuous areas.
For example, there is a table that calculates the totals from January to February, March and May to June.
Enter the formula in cell H2, press the Enter key to complete and fill downwards.
=SUM(B2:C2,E2,G2)
Recommended by the editor of Huajun Software Park
Excellent graduates approval formIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Final accounts,Import unit listDownload to get the source file, which you can edit, modify and replace. Download the Outstanding Graduate Approval Form and go to Huajun Software Park.




















Useful
Useful
Useful