Insertion of Pivot Tables in Excel Sheet
For creating a pivot table, we will follow the following steps using the data shown below-
1. Click on any cell in the datasheet.
2. Go to the Insert tab then in the Tables group Pivot Table.
3. In most circumstances, the default parameters in the Create Pivot Table dialogue box are sufficient. Here are a few things to look for in it:
- Table/Range: This field is automatically filled in based on your data collection. Excel will automatically find the suitable range if your data contains no blank rows or columns. If necessary, you can modify this manually.
- Specify the area under the option 'Choose where you want the PivotTable to be placed’ if you're going to construct the Pivot Table in a specified location. Otherwise, the pivot table creates a new worksheet.
4. Now click on the ‘OK’ button, and then a new worksheet will open with the pivot table.
When the pivot table is being created, there is no data in it. The pivot table name and a single line instruction are on the left, and pivot table fields are on the right.
5. Now, when you drag and drop the number of working days in rows and salary in values, you will see the following pivot table-
Components of Pivot Tables
Pivot cache
Pivot Cache is created automatically when you build a Pivot Table. It is an object that contains a data source replica. It is a part of the workbook and is tied to the Pivot Table, even if you can't see it.
Values area
The calculations/values are stored in the Values Area.
Columns area
The Columns area is defined by the headings at the top of the Values area.
Rows area
The headers form the Rows area to the left of the Values area.
Filters area
The Filters section is an optional filter that you can use to delve further into the data set.
FAQs
1. What is excel?
Microsoft Excel is a spreadsheet or electronic worksheet tool for organizing, storing, manipulating, and analyzing data. Microsoft is the company that created it.
2. How is Excel useful in everyday life?
The capacity to perform mass arithmetic calculations is maybe the essential feature of MS Excel. It can add, multiply, subtract, and divide hundreds of integers with an extensive program full of formulae, and it can quickly re-do it if a value is modified or added.
3. What is meant by the Pivot Table?
A pivot table is a tool that allows you to summarise large datasets (with a few clicks) quickly. A pivot table is a visual representation of your data that summarises it to enable you to report on and examine patterns based on your data.
4. Is it possible to create a pivot table with data from different sources?
If the numerous sources are different worksheets from the same workbook, you can create a Pivot table using these many data sources.
5. Is there a unique address for each cell?
Yes, each cell has a unique address determined by the cell's row and column values.
Key Takeaways
In this article we have extensively discussed the introduction to pivot tables. Moreover, we saw how we can use them with examples.
We hope that this blog has helped you enhance your knowledge regarding encryption and if you would like to learn more, check out our articles on Pivot Charts , Group Pivot Table Items and Pie chart. Do upvote our blog to help other ninjas grow.
Refer to our guided paths on Coding Ninjas Studio to learn more about DSA, Competitive Programming, JavaScript, System Design, etc. Enroll in our courses and refer to the mock test and problems available. Take a look at the interview experiences and interview bundle for placement preparations.
Happy Learning!
24+ registered 
