Excel 2016 A For Mac how to create a PivotTable report

Source: Internet
Author: User

Recently, Microsoft launched the Excel 2016 for MAC, many netizens do not know how to use. Therefore, today, Xiao-bian to share with you the Excel 2016 for Mac one of the most common features: the production method of the PivotTable report. So where does the Excel 2016 for Mac PivotTable report Open? Let's take a look at today's tutorial!

Recommended PivotTable reports

1. Create a recommended PivotTable report

The recommended PivotTable report is a good choice if you don't have any experience in using the PivotTable report or are unsure how to use it. When you use this feature, Excel determines a meaningful layout by matching the data with the most appropriate area in the PivotTable report. This can provide you with a starting point for other experiments. After you create the underlying PivotTable report and visualize its components, you should try different directions and rearrange the fields to achieve a specific result.

1 Open the workbook in which you want to create the PivotTable report.

2 Click the cell in the list or table that contains the data you want to use for the PivotTable report.

3 on the Insert option, click recommended PivotTable report.

2, to

1) Add fields

In the field name area, select the check box for the field. By default, non-numeric fields are added to the rows area, the date and time hierarchies are added to the columns area, and number fields are added to the values area.

2) Delete the field

In the field name area, clear the check box for the field.

3) Move the field

Drag the field of one area of the PivotTable builder to another area, for example, from columns to rows.

Refreshing a PivotTable report

Refreshing a PivotTable report

3. Create a manual PivotTable report

If you are an experienced PivotTable user, or you already know the sort of data you want, you can create a PivotTable report manually.

1 Open the workbook in which you want to create the PivotTable report.

2 Click the cell in the list or table that contains the data you want to use for the PivotTable report.

3 On the Insert tab, click Shapes.

Pivot table

4. This concludes the tutorial.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.