Excel 2016 A For Mac how to create a PivotTable report

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.