Excel 2016 Tips and Tricks

Lesson 4 – Creating/Revising PivotTables

Excel 2016

R ECOMMENDED P IVOT T ABLES  D ISCUSSION

In Excel, PivotTables are very easy to use and provide an excellent way to manipulate your data. PivotTable options are easy to use so that you can create a clear layout based on your data and changing the layout of a PivotTable is just as easy.

If you want to quickly add a PivotTable, use the Recommended PivotTables option. After you insert the table, you can manipulate the table using the directions in this chapter.

Recommended PivotTables



P ROCEDURES 1. Select the table you want to use in the PivotTable.

2. On the Insert tab Tables group, select Recommended PivotTables

.

Page 98

OFFICEPRO, Inc.