Microsoft Excel Tutorial for Beginners: Lesson 3

[soybean]

• Enter “ja” and click on “OK” button
• You should be able to see only the results for Jane and James.

 

[soybean]

Group and Ungroup​

Groups allow us to view easily and hide unnecessary details from either columns or rows. In addition to that, we can also use groups to analyse data that belongs to a common category. Let’s illustrate this with an example. We will use the student scores example above.

 

[soybean]

• Right click on the score and select insert column. Name the name column gender.
• Change James to Juanita. Put female for Janet and Juanita. Put male for the rest of the students. Your sheet should look as follows.

 

[soybean]

We will now group the females together and display their average score and do the same for the males.

• Click on DATA tab on the ribbon
• Select all the columns and rows with data
• Click on Group drop down button as shown in the image below

 

[soybean]

You will get the following window

 

[soybean]

• Make sure Rows options is selected
• Click on OK button
• You will get the following preview

 

[soybean]

• We will now calculate the average scores for females and males
• Select the whole data as shown below

 

[soybean]

Click on Subtotal drop down button under DATA tab

 

[soybean]

You will get the following window

 

[soybean]

• Set “At each change” into gender
• Set “Use function” to average
• Select “Add subtotal” to Score
• Click on “OK” button

Download the above Excel Code