Excel 2016 Tips and Tricks

Excel 2016

Lesson – Creating/Revising PivotTables

3. Select the PivotTable you want to use.



S TEP - BY -S TEP Use Recommended PivotTables to quickly create a PivotTable.

Open the PIVOT.XLSX workbook.

Steps

Practice Data

1. Select the table you want to use in the PivotTable. Click in the table.

Click anywhere in the table

2. Click the Insert tab.

Click Insert

The Insert Analyze appear.

3. In the Tables group, click Recommended PivotTables.

Click

The Recommended PivotTables dialog box appears.

4. Select the type of PivotTable you want to use.

Select Sum of Profit by Purchaser

A preview appears on the right side of the screen.

5. Click OK .

Click

The table is inserted in a new worksheet.

Close the PIVOT.XLSX .

C REATING A P IVOT T ABLE R EPORT  D ISCUSSION

While Excel provides you with Recommended PivotTables, there may be times when you want to create and manipulate them from scratch. After you have created a PivotTable, you can take advantage of other new or improved features to summarize, analyze and format your PivotTable data. Quickly apply a predefined or custom style to a PivotTable and sort or filter your data easily. Filter data using date filters, label filters, value filters or manual filters and Slicers. For greater flexibility, you can also undo most actions that you carry out to create or rearrange a PivotTable.

OFFICEPRO, Inc.

Page 99