Current location - Recipe Complete Network - Catering training - How to use excel as a ledger
How to use excel as a ledger
1. First, open excel software on the computer, open a spreadsheet software interface, and set the title name.

2. Fill in the name of the computer ledger in the first line, and then set the number of the computer ledger.

3. Fill in the serial number of the computer ledger in the first column, and add the department using the computer ledger.

4. After the computer ledger is filled in by the user department, fill in the brand column. Easy to classify and find computers.

5. After filling in the brand of the computer, fill in the factory code of the computer as the identification code of the computer.

6, fill in the factory code, fill in the computer model, you can find the computer model parameters.

7. After filling in the computer model, fill in the purchase date, which is convenient for the financial department to reconcile.

8. Fill in the purchase date first, and then fill in the purchase amount. It is convenient for the asset management department to enter and process.

9, fill in the purchase amount, and then fill in the user column, to record the use of computer assets.

10. Fill in the asset management department for the convenience of employing people and physical inventory.

1 1. After filling in the general title of the whole form, input the usage content and improve the computer information, and complete the computer ledger management table.