How to Use Excel – How to Develop a Pivot Table in Excel: It is important to know what the pivot table is and how it can be used? A pivot table is an interactive view of your data. Pivot Pivot tables allow you to look at the same data from different perspectives.
These steps below will lead you in creating a pivot table and how to use your pivot table.
How to Create a Pivot Table
- The following method describes how to create a pivot table:
- Open the Excel spreadsheet you wish to analyze.
- Make sure you data does not have any blank rows or columns and it only contains single row heading.
- Select the cells you want to create a Pivot Table from by highlighting your data.
- Click Insert from the menu provided.
- Select Pivot Table.
- In the pop-up window, check if the Table/Range is correct.
- Next select your location for the Pivot Table.
- Select New worksheet to place the Pivot Table in a new worksheet or Existing worksheet.
- If you select the Existing worksheet, select the location you want the Pivot Table to appear.
- Tap OK.
Also Read: News Update on Facebook – Facebook’s Wide Spread Of Fake News
How to Use Different Pivot Table Fields for Different Views
This is where it gets more interesting. Now you can begin to use the system like a pro and capture different perspectives.
Follow the steps to use pivot table filters on your own data.
- Click on the Pivot Table you built in the above steps.
- Under Choose Fields to add to report, check all of the boxes to capture a full Pivot Table view of your data.
- By selecting the + beside the Row Label in your Pivot Table, you can expand your data for a full view.
- To sort your breakdown differently, you can drag and drop Rows. If you move the color to the top of rows, you can see the data change.
- To see individual breakdowns of a specific row, drag and drop it from Rows to Filters.
- A drop-down option will appear above your Pivot Table, simply open the drop-down and select any specific filter option you wish to analyze.
- By selecting the + located to each Row Label item, you will see a detailed breakdown of your data.
How can I create a pivot table in Excel?
- Insert a Pivot Table
- Click any single cell inside the data set.
On the Insert tab, in the Tables group, click PivotTable. The following dialog box appears. Excel automatically selects the data for you. The default location for a new pivot table is New Worksheet. - Click OK.
How do you create a pivot table step by step?
How to Create a Pivot Table
- Enter your data into a range of rows and columns.
- Sort your data by a specific attribute.
- Highlight your cells to create your pivot table.
- Drag and drop a field into the “Row Labels” area.
- Drag and drop a field into the “Values” area.
- Fine-tune your calculations.
What is a pivot table used for?
A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail and answer unanticipated questions about your data.
A PivotTable is specially designed for: Querying large amounts of data in many user-friendly ways.
