1. The catering industry can make some tableware and consumables inventory tables by using excel, and respectively count the daily consumption of articles and the monthly material inventory table, and respectively count the inventory quantity of articles last month and this month, the purchase quantity this month and the monthly loss.
2. You can also make a salary accounting table to list the attendance days, basic salary, various subsidies and individual taxes of each employee, calculate the actual salary, and automatically calculate the subsidies or individual taxes by using the function to generate a salary slip.
3. naturally, the catering industry is indispensable for ordering food. you can make a ordering table by using the tool table, and write down the date, name, number of people, time, mobile phone number, remarks and other important information.
conceive the structure of the worksheet before making it. Practice more, make good use of the formulas and functions in the tool list, be familiar with related operations, and improve work efficiency.