You can use the computer comes with the EXCEL file to enter the relevant table header, and then enter the actual situation of the inventory data details can be, the specific production methods are as follows:
1, in the blank space on the computer desktop, right-click, select the new EXCEL file.
2, open the new EXCEL file, in the first cell, enter the company's inventory details.
3, and then in accordance with the chart below the labeling of the relevant details entered one after another, such as the name of the goods, model number, last balance, date, in and out of the number of figures, such as the date has been entered to October 5th.
4, the form will be pulled to the far right in the October 5 of the back of the current balance, you can enter the formula in the cell = (C5 + D5 + F5 + H5 + J5 + L5) - (E5 + G5 + I5 + K5 + M5), the purpose of the calculation is used to automatically calculate (with the balance of the previous period + the daily number of incoming inventory) - (the daily number of outgoing inventory and the sum of the cumulative).
5, at this point you can enter the product name, the balance of the previous period, as well as other date-related information. You can see the current balance is with the daily in and out of the figures automatically account for the current balance of inventory.
6, in the selected need to show all the cells, click on the top of the field grid logo, select all the box line can be clearly seen in the location of the cells.
7, the final design and production of the inventory schedule is shown below.
Note:
The EXCEL table in the design process can be continued until the end of the date, and then need to be in the current balance in advance to enter a good inventory balance formula can be calculated automatically.