1. First, open a blank excel file. Use this form to record elements such as time, income, expenditure and balance

2. Click the blank cell A1 with the mouse, and then a blank "value" will appear behind the toolbar A1, and the content entered here will appear in the cell A1, which is called the key value of A1. Here, A1 column is defined as time column.

3. Then define B1 as "revenue", C1 as "expenditure" and D1 as "balance", and you can define the function. Click the D2 grid, and then fill in "=b2-c2" in the D2 key value.

4. According to the actual situation, the balance should be equal to the balance of the current day plus the previous balance, so define the key value of D3 "=b3-c3+d2", and then click the D3 cell with the mouse and drop it down, so that all blank cells in column D will follow the function of D3 for calculation.

5. When applying this form, you only need to fill in the entry time and enter the income and expenditure at that time, so that the form will automatically generate other data.