Excel 2010 Bible

Part V: Analyzing Data with Excel

684

Using the Query Wizard

The Choose Data Source dialog box has a check box at the bottom that lets you specify whether to

use the Query Wizard to create your query. (Refer to Figure 33.4.) The Query Wizard walks you

through the steps used to create your query; if you use the Query Wizard, you don’t have to deal

directly with Query. I highly recommend using the Query Wizard, and the examples in this chap-

ter use this tool.

In the Choose Data Source dialog box, do the following:

1. Select your data source (Budget Database, for this example).


2. Make sure that the Query Wizard check box is selected.


3. Click OK to start the Query Wizard.

Query Wizard: Choosing the columns

In the first step of the Query Wizard, select the database columns that you want to appear in your

query. Select one or more columns and click the > button to add them (see Figure 33.6). To select

all fields, click the table name (budget) and then click the > button.

FIGURE 33.6

In the first step of Query Wizard, you select the columns to use in your query.

You may have noticed that one of the options in the Choose Data Source dialog box is Excel Files. If

you choose this option, you can use Query to bring in data stored in Excel workbooks. You can put any

number of data tables in a workbook, but each one must have a range name because that’s how Query

identifies the tables.

Using Query with Excel Files