How to Install Pivot Table Wizard(2) PDF

Preview

Summary

Download How to Install Pivot Table Wizard(2) PDF

Description

How to Install Pivot Table Wizard 1. Microsoft Excel 2010/2013 hides the PivotChart Wizard, which is not shown in the Ribbon. Without Classic Menu for Excel 2010/2013 installed, it is not so intuitive to get this function. If you do need to use PivotChart Wizard, there still are several ways to configure it. Pivot Table Wizard allows the use to consolidate multiple ranges from the same worksheet or difference worksheet to create a pivot table. It is a very useful tool. 2. Click File Tab, and click “Options” item.

Click here

3. Click the Customize Ribbon in the Excel Options window, and then, you will see Customize the Ribbon in the right pane. Choose Commands Not in the Ribbon by clicking the arrow, and then use the scroll bar to search for the PivotTable and PivotChart Wizard.

4. Once you find out the Wizard, before you click Add to add it into the Ribbon, you need to create a Group for the Wizard. PivotTable and PivotChart

5. Click ‘Insert Tab’ and then Click ‘+’ of the Table Tab.

6. Click ‘New Group’ to add a group to the Table Tab.

7. Click ‘Add’ to add the Wizard to the group.

8. Click ‘New Group (custom)’ and right click your mouse button and select ‘Rename’ to rename the Tab as ‘Pivot Table Wizard’. Click ‘OK’.

9. Click the ‘Insert’ menu on the menu bar, the Pivot Table Wizard is located there and is ready to use....