First, for products that adopt a delivery system, the sales volume will be calculated after completing the consignment procedures with the transportation department. The date stamp of the shipping unit shall be used as the basis for statistics.
Second, for products that adopt the pick-up system, the sales volume will be calculated after the payment settlement procedures are completed with the buyer and the delivery note is issued. The date on the delivery note shall be used for statistics.
Third, for products that use buyer classification, count the number of products sold according to their different classifications.
1. Modify the font
First, let’s start with input and adjust the font. You can find the font tool box at the beginning of the toolbar, where you can quickly change the font type, size, color, etc.
2. Insert and delete cells
In the cell tool box, you can quickly insert or delete cells with one click. For example, sometimes when typing, a row of data is missed. Here, click "Insert Row" in "Insert Cell" under "Rows and Columns" and it will be OK.
3. Fill merged cells
As long as the data range is selected, unmerge the cells first. Then press Ctrl+G to locate the null value. Then enter the equal sign, press the up arrow of the direction key, and finally press Ctrl+Enter.
Sales data statistics tableIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Fund Statement,Monetary Assets and Inventory QuestionnaireDownload to get the source file, which you can edit, modify and replace. To download the sales data statistics table, go to Huajun Software Park.
it works
it works
it works