1. Inventory method: combination of dynamic inventory and static inventory; combination of regular inventory and irregular inventory; combination of self-inventory, review and drawing.
2. Inventory method: a combination of comprehensive inventory and sampling inventory; a combination of counting and weighing.
3. Regular monthly inventory takes a dynamic inventory, with self-inventory as the main method and drawing as the supplement. The inventory method is determined by the warehouse based on actual conditions.
4. The quarterly inventory is carried out through a static inventory, which is a combination of self-inventory, review, and drawing.
5. Unscheduled inventory counting shall be carried out in the form of dynamic inventory counting and stock drawing, and the inventory counting method shall be determined by the Finance Department.
6. Inventory of outsourced processing parts and materials: The person in charge of the relevant department and the financial personnel shall jointly determine the inventory method and conduct an independent inventory.
1: Double-click to quickly apply functions
There is no need to type the same function one by one. When you have set the function for the cells in the first row, just move the cursor to the lower right corner of the cell, wait until it turns into a small plus sign, double-click, and the formula will be applied to all the remaining cells in the column.
Isn’t this much easier than dragging with the mouse?!
2: Quickly add or delete a column
For those of you who have to deal with Excel all day long, this trick may save you a little time. When you want to quickly insert a column, type Ctrl + Shift + '=' (Shift + '=' is actually the + sign) to insert a column to the left of the column you selected, and Ctrl + '-' (minus sign) to delete the column you selected.
3: Multi-region joint calculation
In some worksheets, we do not need to sum continuous areas, but may be summing several discontinuous areas.
For example, there is a table that calculates the totals from January to February, March and May to June.
Enter the formula in cell H2, press the Enter key to complete and fill downwards.
=SUM(B2:C2,E2,G2)
Warehouse regular inspection listIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Real estate consultant performance commission calculation form,Caller registration formDownload to get the source file, which you can edit, modify and replace. Download the warehouse regular inspection form and go to Huajun Software Park.
Useful
Useful
Useful