Traditional Culture Encyclopedia - Hotel reservation - How to make the management table of hotel wine warehouse with EXCEL

How to make the management table of hotel wine warehouse with EXCEL

The operation steps are as follows:

1. First, open the Excel table and type your own data in the table.

2. Then select the right button of the cell and click the format cell option to enter.

3. Then enter a new interface, click the number and click the time to set it.

4. Then click the number and currency.

5. Click "FX", select "SUM" function to calculate profit, enter "G3-F3", and click "OK" to drop down and fill in.

6. Hold down the CTRL key, click the category to be counted, select the Insert option in the taskbar, click all charts and insert a column chart.

7. Then you can finish the operation.