May 2001
Intermediate to advanced
1184 pages
33h 57m
English
Do you regularly check several Web pages during the day to gather information? Excel's capability to create live links to Web data might let you combine parts of each Web page into a single worksheet. You can then save the resulting worksheet as a Web page and put all those bits and pieces of data into a single easy-to-update location.
The page shown in Figure 25.26, for example, consists of tables drawn from Yahoo!'s Finance page and the home pages of MSN Investor and Thestreet.com. We added headings to identify each block, hid several columns that contained nonessential information, and formatted the top two blocks as Full HTML.
By saving the resulting worksheet ...
Read now
Unlock full access