1, open the excel form, write a title in a blank line first, and then fill in the daily consumption content (date, income, expenditure, etc.). ).

2. Organize the table, first set the place to merge, select the cell, and click the center merge at the top of the menu bar.

3. After setting the merge, set the font to bold and centered, and the font color can be selected according to your own requirements.

4. Fill in the date, right-click the selected cell, and then click Set Cell in the option box.

5. Select the date in the small window that appears, and select the desired date mode in the drop-down box at the back.

6. Fill in the date, select the cell, and hold down the mouse to drop it down.

7. Add a title to the table, select the cell merge center, and click bold, font size and color above the menu bar to increase the row height.

8. Select the cell you want to add, add the wireframe to the table, and then click all the wireframes above the menu bar.

9. To calculate the total expenditure, please enter "=C4+E4+G4+I4+K4" in the total cell to be calculated. Just press enter.

The second method:

Daily turnover report can be made by EXCEL software. After opening the software on the computer, enter the required header, goods, corresponding business hours and specific amount. The specific manufacturing method can be referred to as follows:

1, open a blank EXCEL file on the computer to enter.

2. After the page jumps, you can see that a blank EXCEL file has been created. At this time, you can enter the header as needed, and then enter the date and the theme of the turnover respectively. At the same time, you can list the specific product details included in the turnover of the day as needed.

3. Type the desired date in the date field.

4. At this point, you can enter the formula =SUM () in the cell of the total turnover of the day. In this cell, you can use the mouse to select the composition details of the total turnover of the day in brackets.

5. After the formula is entered, according to the actual situation, enter the specific turnover of the goods on that day, and you can see that the total turnover is automatically calculated and generated.

6. Click the lower right corner of the total business cell, drop it down to the required date, and apply the calculation formula.

7. At this time, after the daily commodity business details come out, you can input them one after another to complete the production of the daily total turnover table.

8. Click the Save button in the upper left corner after entering.

9. Select the storage location in the "Save" dialog box that appears, and then click the "Save" button to complete the production of the daily turnover report.