What is a PivotTable? How to use PivotTable in Excel

Excel's PivotTable is a great tool that Microsoft equips into Excel so users can summarize, analyze, learn and present data more easily.

What is a PivotTable? How to use PivotTable in Excel Picture 1

Suppose you have a data spreadsheet with lots of information below:

What is a PivotTable? How to use PivotTable in Excel Picture 2

Now you want to aggregate the data by:

+ Revenue of each store,

+ Revenue of each product,

+ Sales by store by quarter,

+ Quarterly revenue for each item,

+ Draw a chart, .

=> The steps are as follows:

Create a PivotTable table

Highlight the entire data area to be processed.

Then select the Insert tab (1) => PivotTable (2) .

What is a PivotTable? How to use PivotTable in Excel Picture 3

The Create PivotTable window appears.

Select (1) Select a table or range.

(2) You can selectNew WorksheetorExisting Worksheet.

(3) ClickOK.

What is a PivotTable? How to use PivotTable in Excel Picture 4

The PivotTable Fields window appears in the left corner of the screen.

What is a PivotTable? How to use PivotTable in Excel Picture 5

Now our job is drag and drop.

Simple data processing

For example, you want to sum the revenue of each store:

1. Select the Store Name line to drag it into the Rows box .
2. You select the Total money (VND) line and drag it into the Values box .

What is a PivotTable? How to use PivotTable in Excel Picture 6

Data processing under many different conditions / information

For example, you want to calculate the revenue of each store by quarter :

1. Select the Store Name line and drag it into the Filters box .
2. You select the line Qui dragged into the Rows box .
3. You select the Total money (VND) line and drag it into the Values box .

What is a PivotTable? How to use PivotTable in Excel Picture 7

You want to see data of a specific store, select cell B1, click the store you want to see, for example, you select Hanoi Branch (1) => click OK (2) .

What is a PivotTable? How to use PivotTable in Excel Picture 8

For example, if you want to compare sales between stores by quarter, you can do the following:

1. Select the Store Name line to drag it into the Rows box .
2. You choose the line You pull into the box Columns.
3. You select the Total money (VND) line and drag it into the Values box .

What is a PivotTable? How to use PivotTable in Excel Picture 9

Report format

You can design and reformat the report according to your actual needs by selecting the Design tab and selecting until you like.

What is a PivotTable? How to use PivotTable in Excel Picture 10

Create PivotChart from PivotTables

Place the cursor in the data area of ​​the PivotTable table, select the Insert tab (1) => Chart (2) .

What is a PivotTable? How to use PivotTable in Excel Picture 11

The Insert Chart window appears, select the chart template you intend to use, and this is the result:

What is a PivotTable? How to use PivotTable in Excel Picture 12

Above are some of the operations to use the basic Pivot table tool to analyze data in Excel, so you can easily synthesize the necessary data, draw charts simply and quickly. The fastest service for your work. Good luck!