How to Create a Pivot Table in Microsoft Excel (Complete+Pictures)
NESABAMEDIA.COM – What is a PivotTable? PivotTable is a table that summarizes data in another table that is performed by applying certain operations such as sort, average, or sum to the data in the first table, usually including grouping the data.
Pivot Table is an interactive table that in a short time can display a summary of large amounts of data in different forms and orientations and is able to perform calculations on each item needed by using the calculation method as needed.
PivotTable is a very powerful Excel feature for summarizing, analyzing,explore, as well as presenting your data in Microsoft Excel. Presentation of data with a pivot table is relatively very fast to be created with a few clicks without having to mess around with various excel formulas (Excel Formula).
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 create a pivot table in excel?
Well, this time I will share about how to create a pivot table in Microsoft Excel very easily. how do? Just follow the steps below.
How to Create a Pivot Table in Microsoft Excel
In this tutorial I’m using the 2021 version of Microsoft Excel, but if you use another version, that’s okay too. Because the steps taken will not be much different. Just take a look at the following steps.
1. First, prepare the data that you want to make a pivot table. As in the image below.
2. Then, please go to the menu “Insert”. As in the image below.
3. Then, please click “Pivot Tables”. As in the image below.
4. Then, please specify which table data you want. Then, please choose where you want to place the pivot table. You better choose “New worksheets” so that the original table data is not disturbed. Then, please click Ok. As in the image below.
5. Then, a pivot table menu will appear on your right and you will be in a new sheet. As in the image below.
6. Then, please select the field you want. Then, please drag your drop field to columns, rows, filters, or values. As in the image below.
7. Then, a pivot table will appear that corresponds to the field that you set earlier. As in the image below. So, it is easier for you to see the data from your table.
Well, how? The method is quite easy and very simple right? Now we can present or display data from a table 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 create 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 me. Thank you
The rain lover and coffee connoisseur who likes to sit in daydream while dreaming of his dreams that will come true.
){kind=link}
Post a Comment for "How to Create a Pivot Table in Microsoft Excel (Complete+Pictures)"