Preparation of class fee income and expenditure detailed form template:
(1) Personnel expenditure plan.
(2) Expenditures will be reviewed based on a combination of general principles and special circumstances.
(3) Project expenditures shall be prioritized and reasonably arranged according to the actual situation.
1: Quick sum and average
If you want to directly know the sum or average of certain numbers, just select those numbers to find out. After selection, summation, average, and count will be displayed in the bottom status bar.
2: Format brush
The use of Format Painter is very simple. Just click on Format Painter, then select the format you want to copy, and finally select the cells you want to modify. You can modify it in batches.
3: Conditional summation
Use the SUMIF function to calculate the total score of a class:
=SUMIF(D2:D5,F2,C2:C5)
4: SUMIF usage is:
=SUMIF(condition area, specified summation condition, summation area)
In layman’s terms, it can be described as:
If the class in the D2:D5 area is equal to the "first class" of the F2 cell, then sum the area corresponding to the C2:C5 cell.
The class fee income and expenditure detailed form template is a very practical form, and most of the forms are for general purposes. If you happen to need the class fee income and expenditure detailed form template Excel form download, come and download it quickly.Outdoor Advertising Registration Application Form,Customer complaint handling record formIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works