Mastering Microsoft Office XP Premium Edition

Step Up to Office XP

Mastering Microsoft Office XP Premium Edition is the most effective way for you to reap all the benefits of Microsoft's latest, most powerful suite of integrated business tools. In addition to in-depth coverage of all seven applications with special emphasis on Word, Excel, and Outlook, easy-to-follow problem-solving advice, and the authors' valuable insights into putting Office XP to work in a business. It's everything you need to make the transition to Office XP and watch your productivity climb!

Coverage includes:

• Creating, editing, formatting, and printing documents and worksheets
• Streamlining your work using styles and templates
• Improving productivity with Task Panes and Smart Tags
• Generating Web pages from Word and Excel documents and PowerPoint presentations
• Using functions and references in worksheets
• Creating charts, graphs, and Pivot Tables
• Developing effective presentations and handouts
• Using Office's collaboration features
• Creating effective databases
• Securing your documents and data
• Managing your e-mail and schedules
• Adding data to your Web pages using Web Components
• Heading off problems with the new document recovery features
• Using Office XP's graphics tools
• Moving beyond the keyboard with voice- and handwriting-recognition
• Developing and managing Web sites with FrontPage

Table of Contents

PART I • HARNESSING THE POWER OF OFFICE XP

Chapter 1 - Presenting Office XP: What You Need to Know
Chapter 2 - Inputting Text with Speech and Handwriting Recognition Tools

PART II • CREATING QUALITY TEXT DOCUMENTS USING WORD

Chapter 3 - Working with Text and Formats in Word
Chapter 4 - Putting Text and Language Tools to Work for You
Chapter 5 - Designing Pages with Columns and Tables
Chapter 6 - Beyond Text: Making the Most of Graphics
Chapter 7 - Getting Creative with the Office XP Graphics Tools
Chapter 8 - Simplifying with Styles, Outlines, and Templates
Chapter 9 - Creating Merge Documents in Word
Chapter 10 - Creating and Distributing Word Forms
Chapter 11 - Making Large Documents Easy to Use
Chapter 12 - Working Collaboratively with Word

PART III • CRUNCHING DATA WITH EXCEL

Chapter 13 - Creating and Printing Excel Worksheets
Chapter 14 - Using References, Names, and Functions
Chapter 15 - Creating Easy-to-Understand Charts
Chapter 16 - Managing Information with Excel
Chapter 17 - Solving Business Problems with the Analysis Tools
Chapter 18 - Automating Excel with Macros
Chapter 19 - Using Excel to Present Information
Chapter 20 - Importing and Exporting Data in Excel
Chapter 21 - Using Excel's Workgroup Tools

PART IV • AND NOW, PRESENTING WITH POWERPOINT!

Chapter 22 - Creating a Presentation
Chapter 23 - Formatting and Designing a Presentation
Chapter 24 - Objects, Transitions, and Animation
Chapter 25 - Taking Your Show on the Road

PART V • INTEGRATION AND COLLABORATION FOR POWER USERS

Chapter 26 - Breaking the Application Barrier
Chapter 27 - Collaborating in Office XP

PART VI • MAKING THE WEB COME ALIVE WITH OFFICE XP

Chapter 28 - Exploring Office XP's Web Creation Tools
Chapter 29 - Creating Web Pages in Word and Excel
Chapter 30 - Creating Online Presentations with PowerPoint

PART VII • GETTING ORGANIZED WITH OUTLOOK

Chapter 31 - Understanding Outlook Basics
Chapter 32 - Using Outlook As a Communications Tool
Chapter 33 - Tracking and Documenting Contacts with Outlook
Chapter 34 - Managing Your Time and Tasks
Chapter 35 - Working behind the Scenes in Outlook

PART VIII • CREATING AND USING AN ACCESS DATABASE

Chapter 36 - Planning a Database
Chapter 37 - Creating the Database Structure
Chapter 38 - Creating and Using Forms
Chapter 39 - Creating Reports and Queries
Chapter 40 - Creating Web Pages with Access

APPENDICES

Customizing the Office Environment
Troubleshooting Office XP
Index