http://www.microsoft.com/office/using/tips/winners.htm

Office XP Tips and Tricks Center

CTRL+XP! Try these shortcuts and become an Office XP pro.   Tip of the Month: Web Queries Keep Excel Worksheets Up to Date Sent in by Brian Lema of Nepean, Ontario, Canada Web pages often contain information that is perfect for analysis in Microsoft Excel. For example, you can use Excel to analyze stock prices copied directly from a Web page. But what if you need to replace the information often to keep it current? The refreshable Web queries now available in Excel version 2002 make that task easy. Read the rest of this tip.

Web Queries Keep Excel Worksheets Up to Date
From Brian Lema, Nepean, Ontario, Canada

Web pages often contain information that is perfect for analysis in Microsoft Excel. For example, you can use Excel to analyze stock prices copied directly from a Web page. But what if you need to replace the information often to keep it current? The refreshable Web queries now available in Excel version 2002 make that task easy.

To create a new, refreshable Web query:

1. In your browser, browse to the Web page from which you want to query data (such as stock quotes on MSN MoneyCentral).
2. Copy the data and paste it into an Excel worksheet. A Paste Options smart tag will appear just below your pasted data.
3. Click the arrow on the right side of the Paste Options smart tag, and click Create Refreshable Web Query.
4. In the New Web Query dialog box, click the yellow arrow next to table of data you want in your Web query.
5. Click Import.

Refreshing this data can be done manually or automatically in Excel. To do a manual refresh:

1. On the View menu, point to Toolbars and click External Data.
2. Then click the Refresh button on the External Data toolbar.

To have your data refreshed automatically when the file is opened, at timed intervals, or in the background:

1. Click Data Range Properties on the External Data toolbar.
2. Then select the check boxes for the options you want under Refresh control.

Editor's Note: When you retrieve data from a Web site, you might lose some formatting or content, such as scripts, .gif images, or lists of data in a single cell.

Add a Map to Your Word Document Using MapPoint
Brian Lema, Nepean, Ontario

Did you know that by using smart tags you can insert a Microsoft MapPoint® map into your Word 2002 document?

In a Word 2002 document, when you type an address, a faint dotted line, the smart tag indicator, appears under the address. When you point your mouse at the line, a Smart Tag Actions button appears. Click the Smart Tag Actions button, and then select Insert MapPoint Map.

Editor's Note: If you don't have a copy of MapPoint—but you are connected to the Web—click Display Map to display a map of the address on Expedia.com.

Get to Know Your Visitors with FrontPage 2002
From Brian Lema, Nepean, Ontario

Knowing certain information about visitors to your Web site—their operating systems, browser versions, and connection speeds, for example—helps you decide which technologies and features to include on your site. A new feature in Microsoft FrontPage® version 2002 makes it easy to collect this important information. Here's how:

1. On the Insert menu, click Web Component.
2. In the Component type list, click Top 10 List.
3. In the Choose a usage list section on the right, click the type of user information you want to track.
4. Then, click Finish.
5. In the List settings box, enter a title for your list.
6. Choose a style.
7. Click OK.

Note: This will only work if your Web Presence Provider (WPP) supports FrontPage 2002 server extensions. To see a list of WPPs that support all features of FrontPage 2002, visit the Locate a Web Presence Provider page.