How to Create Pivot Table In Excel,Pivot Table,gcflearnfree,support.office,Easy Excel Tutorial,excel-easy,guru99,techinfo
Description:
A pivot table is a data visualization program that allows to reorganization and summary of selected columns and rows of data in an excel spreadsheet or database table to obtain the desired report. A pivot table is especially useful with large amounts of data operations such as sorting, averaging, or summing to data in the first table, typically including grouping of the data.
Pivot Table will save a lot of time by allowing to quickly summarize large amounts of data into a meaningful Before starting Pivot table: report.
Before starting the Pivot table :
> Data should be organized in a tabular format, and not have any blank rows or columns.
> Data types in columns should be the same.
> Tables are a great PivotTable data source because rows added to a table are automatically included in the PivotTable when you refresh the data when any new columns will be included in the PivotTable Fields List. Otherwise, need to either manually update the data source range, or use a dynamically named range formula.
Purpose of Pivot Table :
PivotTable report to summarize, analyze, explore, and present a summary of data.
Example :
PivotTables are highly flexible and can be quickly adjusted depending on how you need to display your data,
The first step in creating Pivot Table is to organize data in a list of rows and columns. Confirm that there is a heading in every column and no rows that are completely blank.
As the following image see that, the data are organized
Now keep cell any your data range like the red color of a middle cell showing following image then go Insert menu on Ribbon and see here two option 
1 ) Recommended PivotTable 2) Manually PivotTable.
Recommended PivotTable :
If you are lack experience with PivotTables, or not sure how to start, Recommended PivotTable is a good selection for you. If you use this feature, Excel determines a meaningful layout with matches the data that are most suitable areas in the PivotTable.
This feature was added in Excel 2013, so if you have an earlier version, follow the manually create a PivotTable instead.
The following image sees and evaluates this in your worksheet …
Manually PivotTable :
3) Excel will display the Create PivotTable dialog with your range or table name selected.
4) In the Choose where you want the PivotTable report to be placed section, select New Worksheet or Existing Worksheet. For Existing Worksheet, you'll need to select both the worksheet and the cell where you want the PivotTable placed.
5) If you want to include multiple tables or data sources in your PivotTable, click the Add this data to the Data Model checkbox.
6) Click OK, in the new worksheet, and Excel will create a blank PivotTable, and display the PivotTable Fields list.
Now see the following image for the Pivot Table field list manage from the data range heading name.
In the field, the list manages to select the checkbox for any field you want to add to your PivotTable. By default, non-numeric fields are added to the Row area, date and time fields are added to the Column area, and numeric fields are added to the Values area. You can also manually drag and drop any available item into any of the PivotTable fields, or if you no longer want an item in your PivotTable, simply drag it out of the Fields list.
You can also change your field table manage from setting Icon and manage it as per your own design. After all, is completed then see the following image your pivot table looks good with summarizing the report,
Noted that about two options:
Value Field Settings option you can change any like count, average, max, min, product.
Refresh option for the pivot table
If you add new data in the PivotTable data source, you need to refresh it. To refresh just one PivotTable you can right-click anywhere in the PivotTable range, then select Refresh. If you have multiple PivotTables, first select any cell in any PivotTable, then on the Ribbon go to PivotTable Tools > Analyze > Data > click the arrow under the Refresh button and select Refresh All.
You can download the workbook to practice this exercise.. click here
Subscribe to my YouTube Channel to see more.
COMMENTS