HomeApplicationOffice information

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

  • Guide to full Excel 2016 (Part 2): Learn about OneDriveGuide to full Excel 2016 (Part 2): Learn about OneDrive
    in the introduction in excel 2016, tipsmake.com helped you get acquainted with microsoft excel. today, we continue to share with you about things to know about onedrive. invite you to consult!
  • How to Automate Reports in ExcelHow to Automate Reports in Excel
    this wikihow teaches you how to automate the reporting of data in microsoft excel. for external data, this wikihow will teach you how to query and create reports from any external data source (mysql, postgres, oracle, etc) from within your...
  • Guide to full Excel 2016 (Part 8): Learn about Number FormatsGuide to full Excel 2016 (Part 8): Learn about Number Formats
    the data in the excel spreadsheet when you perform the import always have the default mode, general format, for excel formats to display and calculate in accordance with the actual data format, you need to set the format for it. join tipsmake.com to learn about number formats in excel 2016!
  • Summary of Shortcut Keys in Excel for Mac / WindowsSummary of Shortcut Keys in Excel for Mac / Windows
    many marketers use microsoft excel every day, whether it's to create charts, analyze data, or run reports to present at the next team meeting.
  • Complete guide to Excel 2016 (Part 11): Check spelling in the worksheetComplete guide to Excel 2016 (Part 11): Check spelling in the worksheet
    let's tipsmake.com refer to the spell check tutorial on excel 2016 worksheet in this article!
  • How to use the rounding function in Excel simply and effectivelyHow to use the rounding function in Excel simply and effectively
    when working with excel, you will need to round numbers to suit your calculations and reports. excel provides many rounding functions such as round(), roundup(), rounddown(), which help control rounding according to specific needs.
  • How to draw a pie chart in Excel 2016How to draw a pie chart in Excel 2016
    pie charts are the best way to show data, making your reports and summary sheets more scientific and logical, in today's article, tipsmake will help you write how to draw pie charts in excel. 2016 with quite simple steps.
  • How to compare data on 2 columns in an Excel fileHow to compare data on 2 columns in an Excel file
    to compare data on two columns in excel file we will use excel's conditional formating function. but for you to better understand its principle mechanism, tipsmake.com will guide you step by step. we will now familiarize ourselves with this issue with the following example.
  • How to update Excel PivotTable dataHow to update Excel PivotTable data
    in the process of using pivot table, updating data is a necessary operation so that the data in the pivot table is also updated.
  • How to Make a Shared SpreadsheetHow to Make a Shared Spreadsheet
    spreadsheets are a staple of an office. they are used to organize data and make reports. whether you use an internet-based spreadsheet program or the standard microsoft excel, you will need to share spreadsheet reports to your team or...

Office information