What is pivot table?


3 Answer(s)


You create the table by defining which fields to view and how the information should be displayed. Based on your field selections, Excel organizes the data so you see a different view of your data.

you can take the sales data with columns like salesmen,region,and product wise revenue and use pivot tables to quickly find out how products are performing in each regions...
it can be used to summarizing, analyze explore and present your data.

Pivot Tables are interactive tables that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. They can sort, count, and total the data, and are available in a variety of spreadsheet programs. One advantage of this feature in Excel is that it allows you to rearrange, hide, and display different category fields within the Pivot Table to provide alternate views of the data.