Excel Pivot Table Report – Field Settings, Expand or Collapse Fields & Items, Refresh Data, Change Data Source & Show or Hide options As applicable to Excel 2007 Excel Pivot Tables Tutorial: 1. Create a Pivot Table report; Add, Copy, Rearrange & Remove Pivot Table Fields; ‘PivotTable Field List’ Pane. 2. ‘PivotTable Options’ dialog box...