Tips for using department work plan template
Department work plan templateHow to fill it out?
According to different perspectives, plans can be divided into many categories:
According to the length of time, it can be divided into: long-term work plan, medium-term work plan and short-term work plan; annual work plan, quarterly work plan, monthly work plan and weekly work plan.
According to the degree of urgency, it can be divided into: normal, emergency and very urgent work plans;
According to the subject of making plans, it can be divided into: work plans made by oneself and issued by superiors, and work plans requested for assistance by equivalent positions.
According to the type of tasks, they can be divided into: daily planned and temporary work plans.
There is no need to type the same function one by one. When you have set the function for the cells in the first row, just move the cursor to the lower right corner of the cell, wait until it turns into a small plus sign, double-click, and the formula will be applied to all the remaining cells in the column. Gerry.
Isn’t this much easier than dragging with the mouse?!
2: Quickly add or delete a column
For those of you who have to deal with Excel all day long, this trick may save you a little time. When you want to quickly insert a column, type Ctrl + Shift + '=' (Shift + '=' is actually the + sign) to insert a column to the left of the selected column, and Ctrl + '-' (minus sign) ) will delete the column you selected.
3: Sum of cells with subtotals
How to sum cells with subtotals? In cell C9, enter the formula: =SUM(C2:C8)/2 and press Enter to complete.
The process of subtotaling and summing are used here to repeatedly calculate the above data, so dividing by 2 can get a non-repeating result, which is exactly the desired result.
Recommended by the editor of Huajun Software Park
Department work plan templateIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download a department work plan template, please download it quickly. also,Supplier file management form,Employee file summary tableIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works