Is your question like this: use excel to express the average daily balance of deposits and loans and the data increased last month. If so, I'll design a table for you, and you can draw a ladle. Open an excel, select several cells in the first row to merge as needed, and enter "20 10 Annual Deposit Balance List". In the second line, cell a2 is diagonally divided into two parts, with the month entered in the upper right corner and the item entered in the lower left corner, and B2-N2 entered 1 month and February ...1February. In the third line, a3 enters the deposit, B3-N3 enters the data of the current month, the fourth line, a4 enters the deposit withdrawal, B4-N4 enters the data of the current month, the fifth line, a5 enters the deposit balance, b5 enters the formula "=b3-b4", c5 enters the formula "=c3-c4", and so on, and the sixth line, a6 enters it. Enter the formula "=b5/ day" in b6 (day refers to the number of days in a month), and so on. In the seventh line, enter the increase or decrease of last month in a7, b7 is 65438+ 10 with no comparison, enter the formula "=c5-b5" in c7, and so on. The name of the project is non-professional and you can use it. Loan to create another table, in the same way.