

You got some data and want to gain a quick overview? Or conduct some easy evaluation? Maybe later on analyze the data more detailed? For all these purposes, a Pivot Table can be a good choice.
With Pivot Tables you can summarize your data. Each column of your data is represented by one “data field” having the name of the first row of your data table (the heading row). You can summarize each field by dragging and dropping them into your Pivot Table:
In our example, we want to know the average prices of each car type and color. We could as well display the sum of each value.
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Comments 2
ali from iran
hello every body
can you learn free about excel Dashboard in gift file
tank you if yes pleas send me g.mail
if not but ok tanks
Ambrose
Dear Prof
I am struggling to add the top 8 scores out of 11. I am using different columns to record the scores for 28 players. I have tried this…
=SUM(LARGE(C4;F4;I4;L4;O4;R4;U4;X4;AA4;AD4;AG4,{1,2,3,4,5,6,7,8}))
COLUMN Headings are as follows;
Score, Rank, Points per month. I wish to add the top 8 out of 11 for “Score” only