Excel 2016 Tips and Tricks

Lesson – Creating/Revising PivotTables

Excel 2016

PivotTable report



P ROCEDURES

1. Select any cell in the database. 2. Select the Insert tab.

3. Select the PivotTable button in the Tables group. 4. Select where you want the PivotTable report to appear. 5. Select .



S TEP - BY -S TEP From the Student Data directory, open PIVOT1.XLSX . Creating a PivotTable report.

Steps

Practice Data

1. Select a cell containing data in the worksheet. The cell is selected.

Click anywhere in the table

2. Select the Insert tab.

Click Insert

The Insert tab is displayed.

Page 100

OFFICEPRO, Inc.