An example of how to calculate the percentage of a large amount of data in Excel

We will introduce an example below. This example is very simple. As long as you operate it step by step based on the small series, you can complete what we want.

1. Open the worksheet and select cell B4.

2. Calculate the number of students in the first grade and the percentage of students in the whole school, as shown in the figure. The formula is "= B4/MM", and press enter.

3. The data displayed is not a percentage. It doesn't matter. Pull to the right. After filling, each cell corresponds to the ratio of the number of students in the class to MM.

4. Select this line

5. Press Ctrl + f, replace "MM" with "Q3", and replace cell Q3 with 715 of the total students in the worksheet.

6. As shown in the figure, right-click this line and choose "set cell format"

7. Change the value to percentage.

Well, the above is a small part of the article for you on Excel to find the percentage of a large amount of data, this is actually very simple, I hope this article will help you.