Preparation of the company's health duty schedule:
(1) Floor: No paper scraps, no oil stains, no stains, clean and transparent.
(2) Desktop: There is no obvious dust, no oil stains, and the objects on the table are neatly arranged and their true colors are visible.
(3) Chairs and sofas: no obvious dust or dirt, and placed neatly.
(4) Glass windows and window sills: smooth and shiny, without water stains, stains and dust, so that the windows are bright and clean.
(5) Printers and other fixed equipment and facilities: no dust or dirt.
(6) The company's bonsais, flowers and trees are managed by the administrative department, and on-duty personnel clean them up and remove debris. General tips for company health duty schedule form 1: Sum of multiple conditions
It is necessary to count the total amount of subsidies provided by the department for production and the position is for the main operator.
The formula is:
=SUMIFS(D2:D9,B2:B9,F2,C2:C9,G2)
2: Conditional counting
It is necessary to count the number of business transactions of the designated store. That is, count how many specified store names there are in column B.
=COUNTIF(B2:B12,E3)
3. Change number format
Excel’s shortcut keys are not chaotic, but follow a certain logic.
For example, if you want to quickly change the format of a number, you can immediately add a dollar sign to the number, because the $ symbol and the number 4 share the same key.
In the same way, "Ctrl+shift+5" can quickly change the number into the form of percentage (%).Recommended by the editor of Huajun Software Park
Company health duty scheduleIt is a very practical form, and most of the forms are for general purposes. If you happen to need to download the company health duty schedule, please download it quickly. In addition,Asset impairment provision details,Summary table of asset evaluation resultsIt is also a good form template. Welcome to click to download and experience it!
Useful
Useful
Useful