用excel做进销存（Do Invoicing with Excel）.docVIP

用excel做进销存（Do Invoicing with Excel） The operation described in this paper runs under Excel 97 and Excel 2000 and passes the test. In addition to Chinese characters, all characters in the Excel formula must be entered in the English (En) state. Methods and steps (I) new workbook 1. click the start menu, and then click the new office document in the pop-up start menu item, and the new office document dialog window appears. 2. in the new office document dialog box, in the commonly used binder folder, double click the empty workbook, and empty workbook named Book1 appears. 3., the Book1 as Invoicing automatic statistical system.Xls. (two) define the worksheet name and data 1. double click the Sheet1 worksheet tab, enter stock, press [Enter] key. 2. double click the Sheet2 worksheet tab, enter sell and press [Enter] key. 3. double click the Sheet3 worksheet tab, enter the Invoicing automatic statistics, press [Enter] key. 4. select the purchase worksheet, enter the title (date of purchase, commodity name, quantity of purchase) and the corresponding data. For limited space, and for illustration purposes only, here are only a list of commodities such as a, B and C (Table 1, table three). 5. select the sales worksheet, enter the title (sales date, sales whereabouts, commodity name, sales volume) and the corresponding data (Table 2). 6. select the Invoicing automatic statistics worksheet, in the first row, respectively, enter the title: commodity name, the current total purchase volume, the current total sales volume, the current inventory (Table 3). (three) definition formula 1. in the Invoicing automatic statistics worksheet, select the B2 cell, enter =SUMIF (purchase)! B:B, a purchase! C:C) press [Enter] key. 2. drag down the black dots at the bottom right of the B2 cell to the B4 cell for the operation of formula copying. 3. select the B3 cell, press the F2 key, modify the formula of a as B, the same, modify the B4 cell formula in a as C. If there are more goods, and so