Learn how to use schedules
PlanningThings to note:
1. The study plan is not only about studying, but also about studying.
2. There is a time for study, a time for rest, and a time for entertainment. All of these must be taken into account in the plan.
3. The plan must take into account multiple aspects. Don’t forget to eat and sleep when studying. This is not good for your health. Such a plan is also unscientific.
General tips for learning timetable forms 1: Sum of multiple conditionsIt 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
Study time scheduleIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the study time schedule, please download it quickly. also,Credit card customer information summary table,Stock transaction accounting formIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works