Fortune Telling Collection - Fortune-telling birth date - Excuse me, how does Excel do the daily purchase, unit price, inventory details and sales of fruit supermarkets, and then automatically summarize and calculate the inventory?

Excuse me, how does Excel do the daily purchase, unit price, inventory details and sales of fruit supermarkets, and then automatically summarize and calculate the inventory?

You can create a table in the EXCEL of the computer, including the name of the fruit, the previous carry-over, and the daily purchase and sale figures. Then, according to the actual situation, you can set the calculation formula in the cell of the inventory. The specific setting method is as follows:

1. Create a new EXCEL table on the computer and enter the basic header data.

2. Enter the actual fruit name, unit price and data carried forward from the previous period in the corresponding cell.

3. Enter the formula =B5+(F5+H5+J5+L5)-(E5+G5+I5+K5) in the cell of inventory, that is, the sum of inventory figures carried forward from the previous period+daily purchase volume-daily sales volume.

4. At this time, you can enter the corresponding sales quantity and purchase quantity according to the daily actual situation, and you can see the automatic inventory accounting.

5. Pull down the inventory formula of the first example to the required cell, and then input the daily purchase and sale figures in turn to realize the automatic accounting of other fruit inventories.