Annual leave statistics table

Annual leave statistics tableRefers to the annual holiday given to employees. The unit should ensure that employees enjoy annual leave. The free download of Excel template for annual leave statistics table is provided by Huajun Software Park. The source file is in xlsx format. You can edit and modify the content style by downloading the source file. For more free downloads of annual leave statistics table, please pay attention to Huajun Software Park.

Tips for using annual leave statistics table

Annual leave statistics tableHow to fill it out?
(1) Employees enjoy winter and summer vacations in accordance with the law, and the number of vacation days is more than the number of annual vacation days;
(2) Employees take personal leave for more than 20 days in total and the unit does not deduct wages in accordance with regulations;
(3) Employees who have worked for more than 1 year but less than 10 years in total have taken sick leave for more than 2 months in total;
(4) Employees who have worked for a total of 10 years but less than 20 years have taken sick leave for more than 3 months in total;
(5) Employees who have worked for more than 20 years in total have taken sick leave for more than 4 months in total.

General tips for annual leave statistics forms ​ ​ 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, summation, 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.
Recommended by the editor of Huajun Software Park

Annual leave statistics tableIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need the annual leave statistics form, please download it quickly. In addition,Special operations personnel training and education ledger,Resignation change record formIt is also a good software. Welcome to click to download and experience it!