How to use pivot table in excel sheet

One of Excel's most useful features are pivot tables. You can draw the significance from a sizable, comprehensive data set using a pivot table. There are 6 fields and 213 records in our data set. Product, Category, Amount, Date, and Country for the Order.

How to use a pivot table in excel online, 2016 and 2019:

Select a data set cell by clicking on it.Click Pivot Table under the Tables group on the Insert tab.

The dialogue window shown below appears. Excel chooses the data for you automatically. New Worksheet is the default location for a new pivot table.Click on ok.

How to drag fields in excel:A pane called Pivot Table Fields displays. Drag the following fields to the various places to obtain the total amount of each commodity exported.Field for products to the Rows areaField to the Values section.To the Filters section: a country field

Find the pivot table in the section below. Our primary export is bananas. Such is the simplicity of pivot tables!

How to sort in excel:Sort the pivot table to put Banana at the top of the list.In the Sum of Amount column, click any cell.Place a right-click on Sort, Largest to Smallest.

Result:

How to add filter in excel:We can filter this pivot table by Country because we added the Country field to the Filters section. For instance, what goods do we send to France the most of?Select France from the filter drop-down menu.Result. Our primary export to France is apples.

Note that you may limit the display to just the quantities of particular products by using the usual filter (triangle next to Row Labels).Change summary calculation in excel:By default, Excel counts or adds up the items to create a summary of your data. Follow the procedures below to alter the calculation type you want to employ.In the Sum of Amount column, click any cell.Click Value Field Settings using the right mouse button.

Select the calculation type you want to employ. For instance, select Count.

Click on ok.Result. A total of 16 of the 28 orders going to France were from Apple.

Two dimensional pivot table in excel:A two-dimensional pivot table can be made by dragging a field to the Rows and Columns areas. Insert a pivot table first. Drag the following fields to the various places to obtain the total quantity of each product's exports to each country.Country field to the neighbourhood of RowsColumns area with a Product field.Field to the Values section.To the Filters section, the Category field.

The two-dimensional pivot table is located below.

Make a pivot chart, then add a filter to make it simple to compare these statistics. This may be a step too far for you at this point, but it demonstrates one of Excel's many other potent pivot table functions.

Note: This above written article is an attempt to show you how to use pivot table in excel online, 2016 and 2019 in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.