Excel 2016 Data and List Management

Creating Slicers .......................................................................................................55 Filtering with Slicers ...............................................................................................57 Editing a Slicer ........................................................................................................59 Using Multi-Select Slicers .......................................................................................61 Creating a PivotChart Report..................................................................................62 Exercise...................................................................................................................65 WORKING WITH OUTLINES...........................................................67 Applying an Outline ................................................................................................68 Collapsing/Expanding an Outline ...........................................................................70 Modifying Outline Settings.....................................................................................72 Using Auto Outline .................................................................................................74 Clearing an Outline .................................................................................................76 Creating Subtotals in a List .....................................................................................78 Removing Subtotals from a List..............................................................................82 Exercise...................................................................................................................83

LESSON 3 -

Page iv

OFFICEPRO, Inc.