Sams Teach Yourself Microsoft Office 2003 in 24 Hours

By Greg Perry

• Table of Contents
  • Copyright
  • About the Author
  • Acknowledgments
  • We Want to Hear from You!
  • Introduction
  • Who Should Read This Book?
  • What This Book Does for You
  • Can This Book Really Teach Office 2003 in 24 Hours?
  • Conventions Used in This Book
  • Part I. Working with Office 2003
  • Hour 1. Getting Acquainted with Office 2003
  • Part II. Processing with Word 2003
  • Hour 2. Welcome to Word 2003
  • Hour 3. Formatting with Word 2003
  • Hour 4. Managing Documents and Customizing Word 2003
  • Hour 5. Advanced Word 2003
  • Part III. Computing with Excel 2003
  • Hour 6. Understanding Excel 2003 Workbooks
  • Hour 7. Restructuring and Editing Excel 2003 Worksheets
  • Hour 8. Using Excel 2003
  • Hour 9. Formatting Worksheets to Look Great
  • Hour 10. Charting with Excel 2003
  • Part IV. Presenting with Flair
  • Hour 11. PowerPoint 2003 Presentations
  • Hour 12. Editing and Arranging Your Presentations
  • Hour 13. PowerPoint 2003 Advanced Features
  • Hour 14. Animating Your Presentations
  • Part V. Organizing with Outlook 2003
  • Hour 15. Communicating with Outlook 2003
  • Hour 16. Planning and Scheduling with Outlook 2003
  • Part VI. Tracking with Access 2003
  • Hour 17. Access 2003 Basics
  • Hour 18. Entering and Displaying Access 2003 Data
  • Hour 19. Retrieving Your Data
  • Hour 20. Reporting with Access 2003
  • Part VII. Combining Office 2003 and the Internet
  • Hour 21. Office 2003 and the Internet
    • How Office Products Combine with the Web
    • Keeping Current
    • Word Sends Email
    • To Do: Send Office Documents as Email
    • Summary
    • Q&A
  • Hour 22. Creating Web Content with Word, Excel, Access, and PowerPoint
  • Part VIII. Publishing Eye-Catching Documents
  • Hour 23. Publishing with Flair Using Publisher 2003
  • Hour 24. Adding Art to Your Publications
  • Part IX. Appendixes
  • Appendix B. Business Contact Manager and Office Extras
  • Part X. Bonus Hours
  • Hour 25. Using FrontPage 2003 for Web Page Design and Creation
  • Hour 26. Managing Your Web with FrontPage

How Office Products Combine with the Web

Office offers a complete set of tools that integrate the Office products and the Internet. From any Office product, you can access files and Web pages on the Internet. The following sections describe how you can access the Web from Office.

To Do: View Web Pages from Within Office Programs

You don't have to start Internet Explorer to view a Web page from within an Office program. All you need to do is display the Web toolbar and type the address you want to see. While creating an Excel worksheet, for example, you might need to locate financial information from your company's Web site. Follow these steps to surf the Web from Excel:

1. Select View, Toolbars, Web to add a new Web-browsing toolbar to Excel. Figure 21.1 shows what the Web toolbar looks like.
   

   Figure 21.1 Use the Web toolbar to access Internet information from any Office program.

2. Click the Address text box on the Web toolbar.
3. Enter the Web address that you want to see. (Alternatively, you can click the Favorites list on the Web toolbar to view and select the Web page that you want to view.) If you access the Internet from a modem, Excel dials your Internet service provider (ISP) to get Internet access. If you're already connected to the Internet, Excel immediately goes to the Web page.
4. Excel's menus and toolbars change to match that of Internet Explorer, the Microsoft Web browser, and Excel displays the Web site that you want to view. You can switch between the Web and Excel by pressing Alt+Tab. In addition, you can copy and paste information from Web pages to your Excel worksheet.

Figure 21.2 shows what you see when you view a Web page from Excel. Notice that the program doesn't look much like Excel anymore! Actually, Excel triggered the start of Internet Explorer and your Excel worksheet is still in another window that you can get to through Alt+Tab or by clicking the Excel window's button on your Windows taskbar.

Figure 21.2 You can go straight from any Office program, such as Excel, to a Web browser simply by typing a Web address in your program's Web toolbar's address text box.

Viewing Documents in Internet Explorer

In addition to launching Internet Explorer from an Office product, you can view Office documents directly from within Internet Explorer. Whenever you are browsing the Internet, select File, Open and type the full path and filename you want to view (or click Browse to locate the path and file) from within Internet Explorer.

Internet Explorer opens and displays the file within the browser window. Not only does Internet Explorer display the file, but all Internet Explorer menus change to enable full editing capabilities for that Office document. If you open a Word document, for example, Internet Explorer menus change to Word menus; you can then insert a table or format the text as if you were using Word. If you click the Internet Explorer Tools toolbar button while viewing the Office document, the Word toolbars appear beneath the Internet Explorer toolbar so that you have full Word toolbar capabilities within Internet Explorer.

Figure 21.3 shows an Excel worksheet viewed by starting Internet Explorer from the Windows Start menu and opening the worksheet from the Internet Explorer program. When Internet Explorer senses that the file is an Excel worksheet file, Internet Explorer triggers Excel's launch (just as Excel triggers Internet Explorer when you view a Web page from within a worksheet) and the worksheet loads. As you can see, the result is the full set of Excel buttons and menus.

Figure 21.3 You can view a worksheet within Internet Explorer.

Creating Links in Office

As you learned how to use Office programs throughout the previous hours, you learned that you can type a Web address in an Office document to create a link to that address. When you type a Web address in a PowerPoint presentation, for example, that address becomes a link to an active Web site address. If you click that address, the Office program starts Internet Explorer, logs you on to the Internet if needed, and displays the Web page located at that address.

Share This