Info, Tutorials, Downloads, Audio Books, Videos, Ebooks and More

Tuesday, September 27, 2016

Pivot Table in Excel

A PivotTable report is an interactive way to quickly summarize large amounts of data. Use a PivotTable report to analyze numerical data in detail and to answer unanticipated questions about your data. A PivotTable report is especially designed for

  •  Querying large amounts of data in many user-friendly ways.
  •  Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.
  •  Expanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest to you.
  •  Moving rows to columns or columns to rows (or "pivoting") to see different summaries of the source data.
  •  Filtering, sorting, grouping, and conditionally formatting the most useful and interesting subset of data to enable you to focus on the information that you want.
  •  Presenting concise, attractive, and annotated online or printed reports.

Pivot Table in Excel
 
 In this example the source data contains information about food sales, in two regions.

Creating Pivot Table 

  1. Select any cell in the source data table.
  2. On the Ribbon, click the Insert tab.
  3. In the Tables group, click PivotTables.
  4. Create Pivot table dialog appear.
  5. Click on ok.
Pivot Table in Excel

You will find the pivot table Field List
Select appropriate Field to filter and summarize data


Pivot Table in Excel

Report Filter: Is area for filter data
Column Labels: is Area to see in column
Row labels : is Area for show data In rows
Values: is  area for calculation data or summarize detail

Pivot Table in Excel



You will change data filter as per Required

Check These Also


No comments:

Post a Comment

Dear Readers,

Great !! You've decided to leave comment for us. Let's make meaningful conversation by adding your name.

Please note that,

Comments deemed to be spam or questionable spam, including profanity and containing language or concepts that could be deemed offensive will be deleted.
Including a link to relevant content is permitted, but comments should be relevant to the post topic.