Page 106 - Excel Data Analysis

06 537547 Ch05.qxd 3/4/03 12:11 PM Page 92

EXCEL DATA ANALYSIS

CREATE A WEB QUERY

f you want to place text from a Web site in a worksheet, Web page, you must do so using the copy and paste
you can create a Web Query. With a Web Query, you commands. See the section "Link Data to Other Windows
I can copy any text into your worksheet for analysis. For Documents" for more information on copying graphics.
example, you can copy the latest stock quote information You must indicate the location for importing the data from
from a financial Web site.
the Web page. By default, Excel selects the active cell as the
The New Web Query dialog box works similar to any Web location for the imported data. If the existing worksheet
browser. You type the address of any Web site and view the contains data, Excel adds enough columns to contain the
associated Web pages. The dialog box analyzes each Web imported data. Any existing worksheet data moves to the
page and breaks it into individual tables of data. Little right into new columns. Alternatively, you can select the
yellow arrow buttons display next to each section of the New Worksheet option to create a new worksheet for the
Web page. You use the buttons to identify the portion of data. If you create a new worksheet, Excel inserts the
the Web page that you want to import. The icon changes to worksheet in the current workbook.
a green check button to identify your selections.
Keep in mind that Excel only imports the text portion of the
Web page. If you want to capture any of the graphics on the

CREATE A WEB QUERY

⁄ Click Data ➪ Import ■ The New Web Query ¤ Type the URL of the ■ Select the button in the
External Data ➪ New Web dialog box displays. desired Web site. upper-left corner if you want
Query. to import the entire Web page.
‹ Click Go.
■ Excel highlights the data,
› Click the yellow arrow and the yellow button
button to select data for changes to a green
import.
check mark.
ˇ Click Import.
92