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 carrier 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. Simply edit a warehousing data table to make the table look concise and beautiful, with unified rules. Setting the format of the table is a good choice.
2. You can see many ready-made formats in [Table Style]. You can directly click on any style you like.
3. Then select the area range, which is the data source. Select the default to only apply the table style.
4. You can also set conditional formatting for specific data in the table. For example, if you want to mark data with an amount greater than 2,000 yuan, you can select [Data]--[Conditional Formatting]--select greater than 2000 as the condition and mark it in red. Result. Select OK to see the effect.
5. If the amount of highlighted data is relatively large, you can use the [data bar] of conditional formatting to display it. In this way, you can see who has more and who has less by looking at the color in the cell.
6. Which cell is selected with the mouse, the color of the cell will become different from other cells. You can choose it at the bottom of the table, and the color can also be adjusted according to your own preferences. There is a sun mark to protect your eyes. The mode can also be changed at any time.
7. When a lot of content is entered in the cell, the text on the edit bar will display multiple lines, which will block the cell content below the edit bar. You can see a small triangle in the middle below the edit bar. It is the "edit box collapse" function. It allows the content of the edit bar to be folded to facilitate cell reading and editing.
Annual sales performance statistics tableIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Registration form for recruiting college graduates,investment income budget tableDownload to get the source file, which you can edit, modify and replace. Download the annual sales performance statistics table and go to Huajun Software Park.
it works
it works
it works