1. Training needs
(1) Learning must be motivated to be efficient, so training needs must be assessed first;
(2) Training must take into account the needs of the company and employees;
(3) The training needs of employees can be known through surveys.
2. Promoter of training plan
(1) Employee education and training must be carried out from top to bottom to be effective;
(2) The training plan must not only obtain the participation and support of senior managers, but also require their vigorous promotion, otherwise it will be empty talk.
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 (%).
Annual employee training planIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Department expense statistics table,Taobao brush order record formDownload to get the source file, which you can edit, modify and replace. Download the employee annual training plan and go to Huajun Software Park.
it works
it works
it works