The Internet is a global network of computers that communicate using a common language.
|
The demand for document and information sharing across the Internet makes it important that applications, like Microsoft Excel, offer this facility.
|
One of the innovations of Excel 97 is that it allows you to browse or open workbooks on the Internet or your company's intranet without leaving the application.
|
If you have a connection to the Internet, you can also open workbooks on Internet sites such as FTP (File Transfer Protocol) and HTTP (Hypertext Transfer Protocol) servers.
|
HTML (^RH^ryper^Rt^rext ^RM^rarkup ^RL^ranguage) is a set of conventions for marking portions of a document.
|
When accessed by a Web browser, each portion appears with a distinctive format.
|
HTML is the mark-up language behind the appearance of documents on the World Wide Web (WWW).
|
You can use Excel to read Web files stored in HTML format, and to create your own HTML files.
|
You can even use Excel 97 to query a database on the Internet, and to retrieve selected data to your workbook.
|
For information on running Web Queries, see the CBT Systems course ^RMicrosoft^r ^ROffice^r ^R97:^r ^RExcel^r ^Rfor^r ^RPower^r ^RUsers^r.
|
Excel's Web toolbar makes it easy to access Web sites without having to use a separate browser application.
|
The Web toolbar also contains a ^USearch the Web^u button that enables you to run a Web search.
|
When you click it, Microsoft's Internet Explorer takes you to a standard search page.
|
You can use the search page to locate information on your intranet or the Internet just as you would from Explorer.
|
Excel has useful shortcuts that allow you to open recently visited Web pages, rather than having to search for them again.
|
Let's say you want to open a page that you visited previously.
|
You click ^UBack^u on the Web toolbar.
|
Excel takes you back to the document you last visited.
|
Once you have returned to previously visited pages, you can click ^UForward^u on the Web toolbar to open the pages again in the order originally viewed.
|
When you use Microsoft Excel to open a workbook or another file on the World Wide Web, your intranet, your network, or your local system, you can add the file to the Favorites folder so that you can open it quickly again.
|
To do this you click ^UFavorites^u.
|
Then you click ^UAdd to Favorites^u.
|
Excel adds the file to your Favorites folder.
|
You can use the ^UFavorites - Open Favorites^u option to manage the folders in your Favorites folder.
|
You may want to get the latest update on the information in the Web page you are currently viewing.
|
To refresh or update the information which may have changed since you opened it, you simply click ^URefresh Current Page^u.
@@
The ^RW^rorld ^RW^ride ^RW^reb (WWW) gives you a graphical, easy-to-navigate interface for looking at documents on the Internet.
|
The documents, known as "pages", on the Web are interconnected.
|
You connect to other pages by clicking special text or graphics, which are called ^Rhyperlinks^r.
|
Web pages can contain text, images, movies, or sounds.
|
These pages can be located on computers all over the world.
|
Using Microsoft Excel, you can make your worksheets available to users on your intranet or the Web so that anyone who has a browser can view them.
|
You can create a complete HTML-based Web page from worksheet or chart data, without having to learn HTML code.
|
You can also insert data from worksheets and chart sheets into existing Web pages.
|
Suppose you want to create a Web page from your current worksheet data.
|
You click a cell in the data range that you want to convert to a Web page.
|
You click ^UFile - Save as HTML^u.
|
The Internet Assistant Wizard helps you publish your worksheet data or charts on a Web page.
|
It converts your data to HTML source format.
|
In the Internet Assistant Wizard Step 1 dialog box, you can specify the ranges and charts to put on the Web page.
|
To exclude items, you select each one and click ^URemove^u.
|
Suppose you want to change the order in which the items appear on the Web page.
|
You click the range you want to change.
|
Then you click the ^UMove^u button.
|
The Wizard reorganizes the ranges accordingly, and you click ^UNext^u.
|
In the Step 2 dialog box, you can choose to create an independent HTML document or to insert the data into an existing HTML file.
|
Here you choose the first option, and then you click ^UNext^u.
|
During Step 3, you lay out your Web page.
|
You enter the information you want to appear above and below your Excel data.
|
Then you click ^UNext^u.
|
In the Step 4 dialog box, you specify a code page, name, and location for the completed page.
|
Then you click the ^USave the result^u as an HTML file radio button.
|
You enter the path name for the file you want to save, for example, ^R\\NTSERVER1\Delivery\Regional budgets.htm^r.
|
When you click ^UFinish^u, Excel saves the file in HTML format.
@@
You may want to add information to an existing worksheet or chart on a Web page.
|
You first ensure that the HTML file has been saved and closed.
|
You use your text editor, for example Notepad, to edit the source code of your existing HTML Web page.
|
In the location where you want the additional worksheet data to appear, you insert a blank line.
|
On the new line you type <!--##Table##-->. This tells Excel where you want the new data inserted.
|
You save the changes you've made.
|
In your Excel worksheet, you click a cell in the range you want to add, and choose ^UFile - Save as HTML^u.
|
In the Step 1 dialog box, you select the data range you want to add.
|
Then you click ^UNext^u.
|
You click the ^UInsert the converted data into an existing HTML file^u radio button, and then click ^UNext^u.
|
You should check that the pathname is correct, and if it is, you click ^UNext^u.
|
In the Step 4 dialog box, you again check the file pathname, and click ^UFinish^u to close the Internet Assistant Wizard dialog box.
|
When prompted, you click ^UYes^u to overwrite the existing file.
|
Excel returns you to the Excel worksheet.
|
To see the HTML file with the new data, you choose ^UFile - Open^u.
|
You specify ^UAll Files^u rather than Microsoft Excel Workbook in the Open dialog box.
|
Excel opens the HTML file with its new data.
@@
@@
Hyperlinks are shortcuts that provide a quick way to jump to other workbooks and files.
|
You can use hyperlinks to open workbooks or files without needing to remember their locations.
|
Hyperlinks are words and graphics that have Web addresses embedded in them.
|
These hyperlinks can appear underlined, in a different colour than surrounding text, or in frames that make them clearly visible to the user.
|
By clicking a hyperlink, you can jump to a hyperlink address on
ò your own computer
|
ò your network or intranet
|
ò the Internet
|
Each Web page, including a Web siteÆs home page, has a unique address called a Uniform Resource Locator (URL), such as http://www.Microsoft.com/sales97.htm.
|
Suppose you want to jump to another workbook.
|
First you point to a hyperlink, in this case, ^UNational Budgets^u.
|
When the mouse is positioned over the hyperlinked object, it takes the shape of a hand.
|
The destination address for the hyperlink appears below the hand symbol.
|
You click the hyperlink text.
|
Excel jumps to the destination file.
|
Suppose you want to abort the jump before it is complete and return to the workbook that contains the hyperlink.
|
You click ^UStop Current Jump^u on the Web toolbar.
|
To return to your workbook after you have viewed the destination file, you click ^UBack^u on the Web toolbar.
|
When you return to the workbook after visiting another file by clicking a hyperlink, you'll notice that the hyperlink color has changed to purple.
@@
Let's suppose you want to create a hyperlink from your document, Sales Budget, to another document, Regional Budget, on your company's intranet.
|
You select the cell or cells containing the text.
|
When you use a range of cells for a hyperlink, the entire selected or merged area becomes the hyperlink.
|
You click the ^UInsert Hyperlink^u button to create a hyperlink.
|
^UInsert - Hyperlink^u also has the same result.
|
An easy way to enter the address of the destination file for the hyperlink is to click ^UBrowse^u to search for the path.
|
You click the file to which you want to create the link.
|
Excel automatically inserts the path to the destination file.
|
Suppose you want the hyperlink to jump to a specific location within the destination file.
|
If the destination file is a Microsoft Excel workbook, you click ^UBrowse^u to select a sheet name, cell or range reference, or defined name.
|
Here, you type the location in the Named location in file field.
|
Microsoft Excel uses the hyperlink base property to determine the destination address of the hyperlink you create.
|
If you don't set this property, the path is determined from where the workbook that contains the hyperlink is currently saved.
|
The hyperlink base address applies to all hyperlinks in the current workbook.
|
You select the ^UUse relative path for hyperlink^u checkbox.
|
Then you click ^UOK^u.
|
Excel returns you to your worksheet where you'll notice the hyperlink text is blue.
@@
At times you may want to change the hyperlink base property.
|
To do this you choose ^UFile - Properties^u.
|
Then you click the ^USummary^u tab.
|
Excel will use whatever address you type here, for example \\NTSERVER1, as its base address for hyperlinks.
|
Then you click ^UOK^u, to apply the hyperlink base property.
|
Suppose you want to change the destination for the hyperlink.
|
You right-click the hyperlink, then on the shortcut menu you select ^UHyperlink - Edit Hyperlink^u.
|
In the Edit Hyperlink dialog box you can edit the text.
|
If you want to remove a hyperlink, you select Remove link in the Edit Hyperlink dialog box.
|
Excel deletes the hyperlink.
|
When you make changes to the Hyperlink and Followed Hyperlink styles, your changes apply to all hyperlinks in the current workbook.
|
To change a hyperlink style you choose ^UFormat - Style^u.
|
The Hyperlink style appears in the Style name box only if you have previously created a text hyperlink in the workbook.
|
You click the ^UModify^u button.
|
Let's say you want to format the border of the selected cells.
|
In the Format Cells dialog box, you click the ^UBorder^u tab and select ^UOutline^u.
|
You click ^UOK^u to return to the Style dialog box.
|
Then you click the ^UBorder^u checkbox, and you click ^UOK^u.
|
Excel draws the border around the cells.
|
At times you might want to use the same hyperlink in different documents.
|
You right-click and select ^UHyperlink^u.
|
Then you click ^UCopy Hyperlink^u.
|
You can paste the hyperlink at its destination cell by right-clicking and selecting ^UPaste^u.
|
Excel copies the hyperlink to the destination cell.
