Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Transcript of Pivot table
What's a pivot table?
To pivot, in fact, means to turn the data in order to view it
from different perspectives
If the owner wanted to know which items sold better in a particular financial quarter, it would be very time-consuming for him to look through pages and pages of figures to find the information.
A pivot table is a data summarization tool found in all spreadsheet applications.
It can be used for sorting, counting or giving the average of the data stored in one table or spreadsheet.
The result is a new report.
A pivot table is especially useful with large amounts of data.
For example, a big company with different headquarters might list daily sales totals for a large number of merchandise items in a spreadsheet. For each sale, there is a row recording when it was sold, where it was sold, what was sold, how it was sold, the quantity sold, and the sales revenue.
A pivot table would allow the owner to quickly reorganize the data and create a summary for each item for the quarter in question.
You can also immediately obtain the average revenue for different headquarters, considering how products have been sold.
You can also carry out the same research considering what have been sold, in particular a product at a time. In this case we can find out the compass average revenue.
Or, once again, you can find out the daily maximum quantity of products monthly sold in a store.