Microsoft Excel Tips and TricksRecommended PivotTables in Excel is getting a great update. To use Recommended PivotTables, click the Insert Tab, and click Recommended PivotTables. The new update includes an easy method to change the data range. You also get a task pane on the right side of the screen and can add the PivotTable to the current worksheet or a new worksheet.
Credit Chris Menard