Page 659 - Excel 2013 All-in-One For Dummies

External Data Query 641
Figure 2-22:
Worksheet after importing the data using the external database query.
After you perform an external query using Microsoft Query that extracts the data as a table, you can use the following command buttons on the Design tab of the Table Tools contextual tab:
✦ Table Name text box to change the name of the data table containing the external data.
✦ Resize the Table command button to select a new data range for the data retrieved by the external query.
✦ Summarize with PivotTable command button to open the Create PivotTable dialog box that enables you to create a new pivot table using the data retrieved by the external query. (See Book VII, Chapter 2.)
✦ Remove Duplicates command button to remove all duplicate entries from the data table.
✦ Convert to Range command button to convert the data table contain- ing the external data into a regular range of data (which removes the AutoFilter buttons and table formatting).
Book VI Chapter 2
Filtering and Querying a Data List