How can pivot tales help to present data clearly?

Asked By ave broers 70 points N/A Posted on - 11/24/2014

Pivot tables help us to summarize data. How is this achieved? What is a flat table? How is the data presented in a pivot table better than the one presented in a flat table? How can I create a Pivot Table from a flat table? What is a Report Filter? What is it used for?

 

• Status: Open
• Question Views: 618
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Neil Auso 0 points N/A #151801

How can pivot tales help to present data clearly?

You  very well know that there is a huge amount of data we saved in an excel file so it is hard to find the any common trends and it's also to difficult to understand the relation between your data elements. So to solve this problem we use pivot table that allows you to analyze your data in a effective way.

To generate a pivot table you need to fulfill the following criteria like at least one column must has duplicate values and must be numeric values.

About Neil Auso

Questions
0

Answers
117

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 01/13/2015
• Question Category: MS Excel