The production method is as follows:

1. First make three tables in the same workbook: inventory summary, storage in and out.

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

Data validity—— Settings: Custom - Formula: =COUNTIF(B:B,B1)=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 cell E3: ?=IF(B3="", "",SUM(D3+F3-G3))

Enter this formula in cell F3: ?=IF(B3="","",SUMIF(warehouse!C:C,B3, Inbound!E:E))

Enter this formula in cell G3: ?=IF(B3="","",SUMIF(Outbound!C:C,B3,Outbound!E :E))

Then copy the formula from the upper row to the lower row.

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

Enter this formula in cell A3: ?=IF(B3="","",1)< /p>

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 upper row to the lower row.

5. Enter data in the outbound table and set the formula the same as in the inbound table. Then formula-protect the columns with formulas, and then only need to enter the data we need to enter in the cells without formulas.

Microsoft Excel is one of the components of Microsoft Office software. It is a spreadsheet software written and run by Microsoft for computers with Windows and Apple Macintosh operating systems. Excel can perform various data processing, statistical analysis and auxiliary decision-making operations. It is an important part of Microsoft Office suite software and is widely used in many fields such as management, statistics and finance, and finance.

Introduction to Microsoft Office Excel:

In 1982, Microsoft launched its first electronic spreadsheet software, Multiplan, and was a great success in the CP/M system, but On MS-DOS systems, Multiplan lost to Lotus 1-2-3. This event prompted the birth of Excel, just like Excel development codename Doug Klunder: Do what Lotus 1-2-3 can do, and do it better.

In 1985, the first Excel was born, which was only used for Mac systems; in November 1987, the first Excel for Windows systems was also produced (directly bundled with the Windows environment, in Mac The version number is 2.0). Lotus1-2-3 has been unable to be applied to Windows systems for a long time.

By 1988, Excel sales surpassed Lotus, putting Microsoft in the leading position among PC software vendors. This incident contributed to the replacement of the dominant player in the software kingdom. Microsoft consolidated its position as a strong competitor and found the direction to develop graphics software. About every two years since then, Microsoft will launch a new version to expand its advantages. Currently, the latest version of Excel is 16, also known as Microsoft Office Excel 2016.

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

Although Excel provides a large number of user interface features, it still retains the features of VisiCalc, the first electronic spreadsheet software: rows and columns form cells, data, data-related formulas or other An absolute reference to the cell is saved in the cell.

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

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

Since 1993, Excel has supported Visual Basic for Applications (VBA). VBA is a powerful tool that enables Excel to form an independent programming environment. Using VBA and macros, you can automate manual steps, and VBA also allows you to create forms to obtain user-entered information. However, the automation function of VBA also makes Excel a target of macro viruses.