Current location - Recipe Complete Network - Catering franchise - How to make warehouse inventory in EXCEL?
How to make warehouse inventory in EXCEL?
Tools to be prepared: EXCEL software, computer.

1. First, create a new worksheet and enter the inventory account contents into the table.

2. Merge and center the cells with the heading "Inventory" to enter and exit the table. Font changed to Song Ti, 20 and bold.

3, "the balance of last month, this month, this month. In the middle of cell merger.

4. Put all the words in the middle.

5. Then add a border to the whole table.

6. Add the formula "Amount = Quantity * Unit Price" to the amount. After the form is completed, save it.