Javatpoint Logo
Javatpoint Logo

HOW TO SUMMARIZE DATA IN EXCEL

Introduction

Summarizing data and presenting it briefly is a crucial skill in today's data-driven world. Assuming that you really want to sum up information in Excel and don't have the foggiest idea how to achieve it, you have come to the perfect locations. In this tutorial, we will cover eight effective and simple techniques to summarize data in Excel.

Summarizing data in Excel is important for extracting valuable information from large datasets. Microsoft Excel provides different tool to facilitate this process. One normal technique is to utilize capabilities like Aggregate, Normal, MIN, and MAX to compute essential insights like sums, midpoints, and limits. Turn tables are another strong element that permits you to bunch and sum up information powerfully, empowering you to make synopses in view of various rules.

Also, Excel's implicit graphing abilities permit you to imagine summed up information for more straightforward understanding. Whether you're dissecting marketing projections, overview reactions, or some other sort of information, dominating Excel's rundown strategies can assist you with uncovering patterns and examples productively.

Valuable Strategies to Sum up Information in Excel

Succeed gives fundamental instruments to summing up information, including capabilities like Aggregate, Normal, MIN, and MAX for essential measurements, as well as turn tables for dynamic gathering and outline in light of various models. Excel's diagramming capacities further consider imagining summed up information, helping with pattern distinguishing proof and example acknowledgment across different datasets. Proficiently using these highlights empowers clients to remove significant experiences from huge datasets, for example, marketing projections or study reactions.

In this segment, we will demonstrate 8 compelling techniques to sum up information in Excel. To show how those techniques work, we have made a situation. Here, we have a few deals information for an inexpensive food organization on a specific day. This organization has 5 shops in better places, each with two salespersons. Their selling things are burgers, pizza, and Franks. The sheet beneath gives us the data about the selling of the things, their value, the salesman who sold them, and the shop number from where the things were sold.

1. Apply AutoSum Choice to Sum up Information

We should initially work out the aggregate sum of deals.

HOW TO SUMMARIZE DATA IN EXCEL

We can do that by utilizing AutoSum capabilities. Follow the means underneath.

Steps:

  • Click on the cell where you need to show the aggregate. Here we have chosen H4. Presently go to the Altering lace and select this symbol displayed in the screen capture underneath.
    HOW TO SUMMARIZE DATA IN EXCEL
  • Presently select the cells which contain the selling cost.
  • Click Enter. You'll see the amount of all the sell costs.
    HOW TO SUMMARIZE DATA IN EXCEL
  • Now, if you click on the down arrow next to the AutoSum symbol, you will see the following 4 additional choices:
    HOW TO SUMMARIZE DATA IN EXCEL
  • Apply AutoSum Choice to Sum up Information
  • Like the Average choice, you can utilize these capabilities to your information.
    HOW TO SUMMARIZE DATA IN EXCEL
  • The Typical capability will provide you with the typical worth of the information.

What's more, here you get the typical information.

HOW TO SUMMARIZE DATA IN EXCEL
  • Also, you can compute the no of passage, greatest, and least worth by utilizing the Count Numbers, Max, and Min choices separately.
  • Consequence of Count Numbers.
    HOW TO SUMMARIZE DATA IN EXCEL
  • Apply AutoSum Choice to Sum up Information.
  • The aftereffect of MAX is here.
    HOW TO SUMMARIZE DATA IN EXCEL

2.5 SUMIF Capability

Steps:

To aggregate information restrictively, we can utilize the SUMIF capability. Assume, we need to perceive how much deals were from Burger as it were. We can apply the accompanying equation:

=SUMIF(k4:k14,"Burger",l4:l14)

Here,

  • k4:k14 is the Thing Information range.
  • "Burger" is the thing for which we need to aggregate.
  • L4:L14 is the scope of the Sell cost.
HOW TO SUMMARIZE DATA IN EXCEL

We can likewise work out the complete deals in shop 1 just and all out deals made by Cathy by applying the accompanying recipe:

  • The recipe for working out all out deals in shop 1:
  • =SUMIF(i4:i14,1,L4:L14)
  • Here is the outcome.
    HOW TO SUMMARIZE DATA IN EXCEL
  • The equation for working out the complete seals made by Cathy.
  • =SUMIF(j4:j14,"Cathy",l4:l19)
  • Furthermore, the outcome ought to be this way:
HOW TO SUMMARIZE DATA IN EXCEL

2.6 SUMIFS Capability

If we have any desire to aggregate information by giving more than 1 standards, we need to utilize the SUMIFS capability.

Steps:

Assume we need to know the quantity of deals for Burger from Shop 1. Consequently, we record the accompanying recipe.

=SUMIFS(l4:l14,k4:k14,"Burger",i4:i14)

Where,

  • L4:L14 is the Selling Cost range which should be the aggregate.
  • k4:k14 is the Thing range where the first models will be looked.
  • "Burger" is the first standards that are to be fulfilled in the reach k4:k19.
  • i4:i14 is the Shop ID range where the second rules will be looked.
  • 1 is the second measures that are to be fulfilled in range i4:i19.
  • Click Enter and you will come by the accompanying outcome :
HOW TO SUMMARIZE DATA IN EXCEL

3. Apply Sort and Channel Choice to Sum up Information

By applying Sort and Channel choice, we can rapidly make the information more coordinated and simple to peruse. To utilize the choice initially select the cells and go to the Sort and Channel choice in the Altering strip, simply on the right half of the AutoSum choice.

HOW TO SUMMARIZE DATA IN EXCEL

Steps:

Here, you will see that you have numerous choices to figure out the information. You can make the request from a to z, Z to A, and obviously, you can likewise do the Custom Sort. The Initial 2 choices sort the information in light of the principal section. To do arranging in view of different segments you need to pick the Custom Sort choice. We will attempt the Custom Sort. We'll sort the information in light of the Thing segment.

HOW TO SUMMARIZE DATA IN EXCEL

We should tap on the Custom Sort and we will see a window springing up this way.

HOW TO SUMMARIZE DATA IN EXCEL
  • From the Section drop-down list, select Thing.
  • From Sort On the drop-down list, select Cell Values.
  • From the Request drop-down list, select beginning to end.

Also, presently you will consider the rundown to be arranged underneath founded on Thing:

Presently we can perform numerous computations effectively as we have the information arranged by our craving. For instance, we will figure out the absolute burger, pizza and sausage sells like underneath.

  • You can likewise play with other custom channel choices and see which one is the most fitting for you.
  • Presently there is likewise a Channel choice. By picking the Channel choice, you can channel information as indicated by your decision. We should perceive how it functions.

In the event that you pick the Channel, you will see a symbol on every section header like underneath:

HOW TO SUMMARIZE DATA IN EXCEL

By tapping on any of the symbols, you can figure out information in like manner. Here we have figured out information in light of Offer costs from little to enormous numbers.

HOW TO SUMMARIZE DATA IN EXCEL

Here is the outcome.

You can likewise actually look at the other astounding highlights of the Channel choice from our site.

Conclusion:

Excel's hearty set-up of devices enables clients to quickly sum up information. Its representation choices, including outlines and charts, improve information translation. The stage's adaptability obliges different information arrangements and examination necessities. Joint effort highlights work with collaboration, while robotization smoothes out dull undertakings, supporting efficiency. Utilizing these capacities empowers clients to remove significant experiences, helping with informed direction and at last encouraging business development. Excel remains as a flexible tool for data summarization, offering a mix of effectiveness, flexibility, cooperation, and computerization to drive progress in different settings.







Youtube For Videos Join Our Youtube Channel: Join Now

Feedback


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA




news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news
news