Geekers - – What is a Pivot Table? A PivotTable is a table that summarizes data in other tables which is done by applying certain operations such as sorting, averaging, or summing to data in the first table, usually including grouping data.
A Pivot Table is an interactive table that can display large sums of data in a short time in different formats and orientations and is able to perform calculations on each item needed by using a calculation method as needed.
PivotTables are a very powerful excel feature for summarizing, analyzing, exploring, and presenting your data in Microsoft Excel. Presentation of data with a pivot table is relatively very fast to make with a few clicks without having to mess around with various kinds of excel formulas (Excel Formulas).
Pivot Tables are very flexible and can be quickly adjusted depending on how you want to display the results. Using a pivot table is a great choice for users to summarize data from a table. Then, how do you make a pivot table in Excel?
Well, this time I will share about how to make a pivot table in Microsoft Excel very easily. how do? Just follow the steps below.
How to Make a Pivot Table in Microsoft Excel
In this tutorial I use Microsoft Excel version 2013, but if you use another version that's fine too. Because the steps taken will not be much different. Immediately, see the steps - the following steps.
1. First, prepare the data that you want to make a pivot table. As in the picture below.
How to Make a Pivot Table in Microsoft Excel How to Make a Pivot Table in Microsoft Excel
2. Then, please go to the "Insert" menu. As in the picture below.
insert inserts
3. Then, please click "Pivot Table". As in the picture below.
pivot tables pivot tables
4. Then, please specify which table data you want. Then, please choose where you want to place the pivot table. Better you choose “New worksheet� so that the original table data is not disturbed. Then, please click Ok. As in the picture below.
How to Make a Pivot Table in Microsoft Excel How to Make a Pivot Table in Microsoft Excel
5. Then, a pivot table menu will appear on your right and you will be in a new sheet. As in the picture below.
pivots pivots
6. Then, please select the field you want. Then, please drag your drop field to columns, rows, filters, or values. As in the picture below.
drag n drop drag n drop
7. Then, a pivot table will appear that matches the field you have set earlier. As in the picture below. So, it's easier for you to see data from your table.
How to Make a Pivot Table in Microsoft Excel How to Make a Pivot Table in Microsoft Excel
Well, how? The method is quite easy and very simple, right? Now we can present or display data from tables very quickly. So, if there is large enough data, we can easily and quickly display it. Because the pivot table is very flexible and very easy.
That's how to easily make a pivot table in Microsoft Excel that you can try. If this article can help you, please share it with your friends so they also know how to easily create a pivot table in Microsoft Excel. Hopefully this article can be useful for all of us. If there is a writing error please forgive. Thank you 🙂
RELATED TUTORIALS
* How to Filter Data in Range or Table
* How to Protect Cells and Range in Ms. Excel
* 8 Steps How to Open Excel Files on Android
* How to Make a List of Ordered Dates in Excel