A full set of EXCEL financial statements how to do?

Make a full set of EXCEL financial statements steps are as follows: (demonstration of the use of WIN10 system, other Windows versions of the same operation)

1, first of all, open a blank Excel worksheet, add some borders.

2, second, in accordance with the personal family classification, fill in the appropriate content, in general, in accordance with the clothing, food, housing and transportation can be divided, can also be divided into more detailed, but in general, generally only a few categories.

3, then, to make a monthly financial statement, classification and the total statement of the same, pay attention to insert the sum formula, to record the progress of each day.

4, then, in the summary table linked to each month's data, using the formula approach, you can realize the automatic change, simple and convenient.

5, in the summary table linked to each month's total consumption data, also using the formula approach.

6, the balance of the insertion of the formula, with "income - expenditure" can be, simple and convenient