Current location - Recipe Complete Network - Catering franchise - How to use Excel to do an inventory
How to use Excel to do an inventory

Specific steps are as follows:

1. In the first line, enter the name of the material, date, outgoing, incoming and balance information. As shown in the figure:

2. Will be the balance of the use of the formula = the number of incoming + the number of incoming + ... - the number of outgoing - the number of outgoing ..., enter a good formula click on the enter button. The following material as long as the calculation has been completed by dragging down the lower left corner of the balance of the cell, that is, to generate the same formula.

Note: The general warehouse inventory list as long as the name of the material and information such as in and out of the warehouse to write clearly, can be done at a glance, has reached the production of the inventory table for the purpose.