:Human Resources Administration Skills: Create Pivot Tables and Statistical Employee Information-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Human Resources Administration Skills: Create Pivot Tables and Statistical Employee Information

Human Resources Administration Skills: Create Pivot Tables and Statistical Employee Information

Author: daogeziyuan • • Table skills • Views 712
  • Image and text skills


Personnel personnel often use pivot tables when conducting basic employee information statistics and performance appraisal summary.

So how to create a pivot table?


教程分界线.png

￭Take this employee information table as an example.

Select the area where you want to create a pivot table and click Insert - Pivot Table.

A new worksheet will pop up. In the pivot table pane on the right, you can check fields and pivot table areas.

Select the fields that need to be presented and we can filter the information table.

For example, screen for "marketing department" and "female employees".


1.gif


￭We can see that there is an employee’s birth date here, so how to filter the employee’s birth year separately?

The "grouping" function of the pivot table will be used here.

Place the cursor on the date, right-click - Group, and select the required grouping in the pop-up dialog box.

Check "Year" here and click OK to set the year into a group.

This allows you to filter employee birth years individually.


2.gif


WPS Academy has more related tutorials on "Pivot Tables".

What are you waiting for? Let’s learn quickly~



Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/ren-shi-xing-zheng-ji-qiao-chuang-jian-shu-ju-tou-shi-biao-tong-ji-yuan-gong-xin-xi.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu ♚ 泡沫 Columnist
48 196
single-end

Related Suggestion