Excel 2016 Tips and Tricks

Lesson – Creating/Revising PivotTables

Excel 2016

Steps

Practice Data

2. Click two or more Analyze in the dialog box. The slicer selections turn a different color indicating they are active. 3. Click the selected items to remove. The slicer selections are deselected.

Click Ernest Feldgus and Janice Faraco.

Click Gloves and Golf Balls .

4. Click Clear Filter .

Click the Clear Filter icon.

All filters are cleared.

C REATING A P IVOT C HART R EPORT  D ISCUSSION A PivotChart report allows you to manipulate large amounts of data in a graphical environment.

PivotChart reports can be created from an Excel table, or from an existing PivotTable report. Both methods yield the same result: a chart with a layout you can change in order to view different levels of detail and data. When you create a PivotChart report from a table, Excel automatically creates an accompanying PivotTable report on a separate worksheet.

Creating a PivotChart report is similar to creating a PivotTable report. The chart layout is created by dragging fields from the PivotTable Field List pane to the desired area of the PivotChart report. The chart layout, however, is slightly different than the report layout.

Page 128

OFFICEPRO, Inc.