After entering data in Excel, it is often necessary to use the function of classification and summary to assist data statistics. Maybe some friends don't know how to make a classified summary table. If you are interested, you might as well study it. The following is a tutorial that I shared to make a classification summary table with excel20 10 for everyone to read and learn.

Excel20 10 classification summary table making tutorial;

Make a classification summary table Step 1: Prepare a worksheet with complete data.

Step 2: Click any cell with data in the worksheet with the mouse, that is, the active cell is within the valid data.

Make a classification summary table Step 3: In? Ribbon? Choice? Data? Tab，in？ Data? Tab, click? Sort? .

Making Classification Summary Table Step 4: Pop up the sorting tab.

Make a classification summary table Step 5: Select? Key words? , which is the keyword of classification, where do I choose? Gender? .

Step 6: Make a classification summary table. You can see that the data in the worksheet is classified by gender.

Make a classification summary table. Step 7: Then? Ribbon? what's up Data? Tab, click? Classified summary? .

Make Classification Summary Table Step 8: Pop up the Classification Summary Table tab.

Make a classification summary table. Step 9: Here? Classification field? Set to? Gender? , consistent with the above. And choose? Summary method? , I choose here? Maximum value? . Choose next? Selected summary items? , I choose here? China? ,? Math? ,? English? Three projects.