Shulou(Shulou.com)06/01 Report--

Today, the editor will take you to understand what the excel classification and summary function is. The knowledge points in the article are introduced in great detail. Friends who feel helpful can browse the content of the article together with the editor, hoping to help more friends who want to solve this problem to find the answer to the problem. Let's follow the editor to learn more about "what is the function of excel classification and summary".

What I want to share with you today is the classification and summary function of excel!

Classified summary is the basic function of dealing with table data with high frequency in excel, which can be competent for the basic statistical summary task!

We want to summarize the average performance indicators under the three dimensions (region, gender, department).

Mouse over any cell in the data area, and then select data-hierarchical display-classified summary.

Bring up the categorization menu and set the fields to be summarized and the summary method in the categorization menu. (remember to sort the target fields to be summarized before performing the classified summary (ascending order))

The first field: region, select the average value of the summary method, select the summary item, check Chinese, math, English, and then determine.

The result presents a summary output of three dimensions, the total average, the grouped average, and the schedule with the grouped average. (there is a three-level catalog label in the upper left corner, which can be expanded).

Of course, if we want to know about gender and departmental averages, we can continue to use categorized summaries.

Set the classification field to gender and department respectively, set the summary type to the mean, select the summary field and check Chinese, math and English.

Thank you for your reading. The above is the whole content of "what is the function of excel classification and summary". Friends who learn it, hurry up and operate it. I believe that the editor will certainly bring you better quality articles. Thank you for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.