Tips for using schedule
schedulePreparation of:
1. Get up early and go outside to breathe fresh air, which has many benefits for your body.
2. Proper nap is very beneficial to reduce physical and mental fatigue and improve study and work efficiency.
3. Overexertion can cause dysfunction of the body’s nervous system and cause imbalances in major organs and systems in the body, such as irregular heartbeat, endocrine disorders, etc.
General Tips for Schedules
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
The work and rest table is a very practical form, and most of the forms are for general purposes. If you happen to need to download the Excel form of the work and rest table, download it quickly.Sales appraisal form,Employee Appraisal Form Self-EvaluationIt is also a good form. Welcome to click to download and experience it!
it works
it works
it works