1. Equipment name, model specifications, purchase date, service life, depreciation life, asset number, usage status of the using department, etc.
2. Make it in the form of a table, which needs to be updated and inventoried every year.
3. Arrange according to the order of asset numbers to facilitate the statistics of asset numbers and classification models of newly added equipment.
1: Quick sum and average
If you want to directly know the sum or average of certain numbers, just select those numbers to find out. After selection, the sum, average, and count will be displayed in the bottom status bar.
2: Format brush
The use of Format Painter is very simple. Just click on Format Painter, then select the format you want to copy, and finally select the cells you want to modify. You can modify it in batches.
3: Quick copy and paste
Select one or some data, and then move the cursor to the lower right corner of the selection box. When the cursor turns into a plus sign, drag it downwards, and it will intelligently fill in 1, 2, 3... for you.
4: Automatic line wrapping
After typing the text in the cell, find the "Automatically wrap" button on the toolbar and you can freely switch the text between wrapping and not wrapping.
Equipment statistics tableIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Student Leave of Absence Application Form,Company annual meeting sign-in formDownload to get the source file, which you can edit, modify, and replace. To download the device statistics table, go to the Huajun Software Park.
it works
it works
it works