Material application:
1. Have a BOM: Make a production demand analysis sheet based on the BOM, check inventory, analyze material usage, and formulate a "purchase requisition sheet".
2. No BOM: analyze usage, check inventory, and formulate a "purchase application form".
3. Submit the purchase order to the purchasing department. The transfer (source) document number of the purchase order is the purchase requisition.
Product application:
1. There is a BOM: analyze the usage according to the BOM, check the inventory, and formulate a "purchase requisition".
2. No BOM: directly apply for the required products, submit to superiors for review and approval, and submit to the purchasing department to purchase products.
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. Gerry.
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 selected column, and Ctrl + '-' (minus sign) ) will 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)
The drug purchase application form is a very practical form, and most of the forms are for general purposes. If you happen to need to download the drug purchase application form, please download it quickly.resignation handover form,Land Value Added Tax ReturnIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works