1, the first in the same workbook:? Inventory summary, receipt and delivery? Three forms.

2. Enter data in the inventory summary table, then select the model column and set the model column as the uniqueness of model input (to avoid repeated statistics):?

Data Validity-Setting: Custom-Formula: =COUNTIF(B:B, B 1)= 1.

Error warning-Stop.

3. Set the formula in the inventory summary table:

Enter this formula in cell A3:? =IF(B3= ""，" "， 1)

Enter this formula in cell A4: =IF(B4= "","",A3+ 1).

Enter this formula in E3 cell:? =IF(B3= ""，" "，SUM(D3+F3-G3))

Enter this formula in the F3 cell:? =IF(B3= "","",SUMIF (warehousing! C:C, B3, storage! E:E))

Enter this formula in G3 cell:? =IF(B3= "","",SUMIF (outbound! C:C, B3, out of the station! E:E))

Then copy the formula in the previous line to the next line.

4. Enter data in the warehouse table and set the formula:

Enter this formula in cell A3:? =IF(B3= ""，" "， 1)

Enter this formula in cell A4: =IF(B4= "","",A3+ 1).

Enter this formula in cell D3: =IF(C3= "","",VLOOKUP(C3, inventory summary! B:C，2，0))

Then copy the formula in the previous line to the next line.

5. Enter data in the issue table and set the formula, which is the same as the receipt table. Then the column with formula is protected by formula, and then we only need to input the data we need to input in the cell without formula.

Microsoft Excel is one of the components of Microsoft office. It is a spreadsheet software written and run by Microsoft for computers with Windows and Apple Macintosh operating systems. Excel can process all kinds of data, make statistical analysis and assist decision-making. It is an important part of Microsoft office suite software, which is widely used in management, statistical finance, finance and many other fields.

Introduction to Microsoft Office Excel:

1982, Microsoft launched its first spreadsheet software ──Multiplan, which achieved great success on CP/M system, but lost to Lotus 1-2-3 on MS-DOS system. This incident prompted the birth of Excel, just as the research code of Excel is Doug Klunder: Do what Lotus 1-2-3 can do, and do it better.

1985, the first Excel was born, which was only used for Mac systems. In June, 1987, 1 1, the first Windows Excel (directly bundled with Windows environment, version number 2.0 in Mac) was released. Lotus 1-2-3 is not suitable for Windows system.

By 1988, the sales volume of Excel surpassed that of Lotus, which made Microsoft stand in the leading position of PC software manufacturers. This incident led to the replacement of the overlord of the software kingdom. Microsoft consolidated its strong competitor position and found the direction of developing graphics software. After that, every two years or so, Microsoft will launch a new version to expand its advantages. At present, the latest version of Excel is 16, which is Microsoft Office Excel 20 16.

In the early days, Excel became the target of trademark law because it had the same name as the software sold by another company. After trial, Microsoft was asked to name the software after Microsoft Excel in its official documents and legal documents. However, over time, this practice has gradually disappeared.

Although Excel provides a lot of user interface functions, it still retains the functions of the first spreadsheet software VisiCalc: rows and columns form cells, and data, formulas related to data or absolute references to other cells are stored in cells.

Excel is the first spreadsheet software that allows users to customize the interface, including fonts, text attributes and cell formats. The function of "intelligent recalculation" is also introduced. When the cell data changes, only the relevant data will be updated, while the original tabulation software can only recalculate all the data or wait for the next instruction. At the same time, Excel also has powerful graphic functions.

When Excel was first bundled into Microsoft Office in 1993, Microsoft redesigned the interface between Microsoft Word and PowerPoint to adapt to this extremely popular application program at that time.

Excel has supported Visual Basic for Applications (VBA) since 1993. VBA is a powerful tool, which makes Excel form an independent programming environment. With VBA and macros, you can automate manual steps. VBA also allows you to create forms to obtain information entered by users. However, the automation function of VBA also makes Excel the target of macro virus.