HomeApplicationOffice informationFamiliarize yourself with PivotTable reports in Excel

Familiarize yourself with PivotTable reports in Excel

The following article will help you familiarize yourself with PivotTable reports in Excel 2013 accurately and quickly.

To gain a thorough understanding of PivotTable reports, learn the following:

1. What are PivotTable reports?

- PivotTable reports are the most useful feature of Excel that helps you to statistic data according to many different criteria. From there, you save time and effort to produce a detailed report describing the above data.

- A PivotTable reports will turn all data into brief reports that help you determine the information and direction you need for the future.

2. Create a PivotTable reports

2.1 Review the source data.

Familiarize yourself with PivotTable reports in Excel Picture 1

Before creating a PivotTable report, you should review the source data to avoid unnecessary errors.

- The title in the PivotTable report will be taken from the title names of the columns in the data table.

- There should be no blank columns in the source data table to create a PivotTable report.

2.2 Create a PivotTable report dialog box.

Step 1: Select the data to create a report -> Insert -> Tables -> Pivot Table:

Familiarize yourself with PivotTable reports in Excel Picture 2

Step 2: After selecting the dialog box appears including the following options:

- Select a table or range: Select the data area to create a report.

- Choose where you want the PivotTable report to be placed: Choose where to save the report:

+ New Worksheet: Save in a new sheet.

+ Existing Worsheet: Save the report in the current sheet.

- After making your selection click OK:

Familiarize yourself with PivotTable reports in Excel Picture 3

Step 3: After selecting OK the report table appears but there is no data:

Familiarize yourself with PivotTable reports in Excel Picture 4

Step 4: Check the name of the fields to create a report -> be PivotTable report:

Familiarize yourself with PivotTable reports in Excel Picture 5

3. Basic PivotTable report.

- PivotTable report includes 2 main parts:

Familiarize yourself with PivotTable reports in Excel Picture 6

+ Layout area for the report: An area that displays all the information of the report.

+ PivotTable Field List : This is where the column headings of source data you want to display on the report and you can optionally select the fields to display on the report.

- In case you want the PivotTable Field List to disappear -> click on the outside of the report, want the report to appear again -> click on the area inside the report layout.

Above is a detailed guide on how to create PivotTable reports in Excel 2013.

Good luck!

4 ★ | 1 Vote

You should read it

May be interested

  • Filter PivotTable report data in ExcelPhoto of Filter PivotTable report data in Excel
    teach you how to filter pivottable reports data in excel 2013 accurately and quickly. the original pivottable report created on demand helps you see the entire information of the data. in case you want to statistically follow a field
  • Protect safety information in ExcelPhoto of Protect safety information in Excel
    protect safety information in excel. your information and all other computers are always in danger. there are many people trying to get into computers for personal gain or some other purpose.
  • Basic Office skills in ExcelPhoto of Basic Office skills in Excel
    basic office skills in excel. to quickly familiarize yourself with the office system, you need to understand the following issues: understand ribbon toolbar. - ribbon toolkit includes: home, insert, pagelayout, formulas, data, review, view, developer, add –ins. different from the exce version
  • The basics of Excel Services in ExcelPhoto of The basics of Excel Services in Excel
    the basics of excel services in excel. what is excel sercives? excel service is a sharepoint technology that extends excel by using server technology. it allows users to access the working window from the browser even if your computer does not have exce
  • Calculate data in a PivotTable in ExcelPhoto of Calculate data in a PivotTable in Excel
    calculate data in a pivottable in excel. creating statistical reports using pivottable mainly through numbers: summing up quantity, highest sales, lowest ... therefore, the calculation in pivottable is based on calculating numbers.
  • Practice practicing hotel expense index in ExcelPhoto of Practice practicing hotel expense index in Excel
    the following article provides detailed instructions for you to practice on how to calculate the values ​​in the hotel cost list in excel 2013. for example, the following data table: calculating the amount of tenants to pay according to the exchange rate current dollars.

Office information