Data Assistants Menu

The following is the Data Assistants menu that appears when you click on the Data Assistants button. Any of the features can be added to Excel’s quick access toolbar for instant use any time.

One of the most useful features on the Data Assistants menu is often overlooked: the Expand the Pivot Table Range feature. When you add data to the bottom of a pivot table’s source worksheet, the data is not automatically added to the pivot table. Instead you must go to the pivot table, figure out how to change the data, and select the entire range manually. Painful.

With the Expand the Pivot Table Range feature, you just click in the pivot table and click this feature. Instantly you are presented with a dialog showing the top left and suggesting the new bottom right corner for your data.