Sams Teach Yourself Microsoft Office XP in 24 Hours

Greg Perry is a speaker and a writer on both the programming and the application sides of computing. He is known for his skills at bringing advanced computer topics to the novice's level. Perry has been a programmer and a trainer since the early 1980s. He received his first degree in computer science and a master's degree in corporate finance. Perry has sold more than 2 million computer books worldwide, including such titles as Sams Teach Yourself Windows Me in 24 Hours, Absolute Beginner's Guide to Programming, and Sams Teach Yourself Visual Basic 6 in 21 Days. He also writes about rental property management, creates and manages Web sites, and loves to travel.

Introduction.
I. WORKING WITH OFFICE XP.

Hour 1. Getting Acquainted with Office XP.


What's in Office XP? The Microsoft Office Shortcut Bar. Euro Support. Summary. Q&A.

Hour 2. Preparing for Introducing Office XP's Powerful Features.


The Office Assistant Type Your Question. The Office XP Self-Repair Feature. Installing On Demand. Parla Italian or Habla Spanish? Even Simpler: Just Say. Using Office to Share Information with Others. Making Office Easier to Use. Get Ready for the Internet and Office. Summary. Q&A.

II. PROCESSING WITH WORD 2002.

Hour 3. Welcome to Word 2002.


Beginning Words About Word. Documents and Disks. Entering and Editing Text. Correcting Mistakes. Initial Spelling and Grammar Correction. Summary. Q&A.

Hour 4. Formatting with Word 2002.


Simple Character Formatting. Inserting Numbers and Bullets. Paragraph Formatting. Formatting with Styles. Format Painter. Preview for Printing. Controlling View Size. A Word About Word's Wizards. Word Themes. Summary. Q&A.

Hour 5. Managing Documents and Customizing Word 2002.


Understanding Document Properties. Using Word's Advanced Proofreaders. Simple Translation. Customizing Word to Work for You. Summary. Q&A.

Hour 6. Advanced Word 2002.


Using Special Characters. Inserting Dates and Page Numbers. Inserting Pictures, Video Clips, and Sounds. Inserting Scanned and Digital Camera Images. Creating and Using AutoText Entries. Adding Tables to Your Documents. Creating Multiple Columns. Creating Headers and Footers. Adding Footnotes and Endnotes. Summary. Q&A.

III. COMPUTING WITH EXCEL 2002.

Hour 7. Excel 2002 Workbooks.


Starting Excel. Understanding Worksheets and Workbooks. Entering Worksheet Data. Navigating in Excel. A Quick Practice. Summary. Q&A.

Hour 8. Restructuring and Editing Excel 2002 Worksheets.


Worksheet Editing. Inserting and Deleting. Working with Worksheet Ranges. Using Formulas. Recalculating Worksheets. Working with Functions. Introduction to Worksheet Formatting. Making Format Changes. Summary. Q&A.

Hour 9. Using Excel 2002.


Spell Checking. Reviewing Cut, Copy, and Paste in Excel. Clearing Data. Speed Data Entry. Smarter Fills with AutoFill. Design Your Own Fills. A Word About Printing. Adding Comments. Summary. Q&A.

Hour 10. Formatting Worksheets to Look Great.


AutoFormatting Worksheets. Modifying Styles. Additional Formatting Options. Conditional Formatting. Tab Colors Help Separate Worksheets. Summary. Q&A.

Hour 11. Charting with Excel 2002.


Creating Custom Graphs. A Quick Chart. Making Your Chart Fancy. Summary. Q&A.

IV. PRESENTING WITH FLAIR.

Hour 12. PowerPoint 2002 Presentations.


Presenting PowerPoint. Understanding Presentations and Slides. Creating a New Presentation. Summary. Q&A.

Hour 13. Editing and Arranging Your Presentations.


Getting Acquainted with PowerPoint's Views. Using the Outline. Working on the Slide. Saving and Printing Your Work. Summary. Q&A.

Hour 14. PowerPoint 2002 Advanced Features.


Changing Your Entire Presentation's Design. Changing a Single Slide's Design. Editing Individual Slides. Adding Art. Summary. Q&A.

Hour 15. Animating Your Presentations.


Using PowerPoint's Slide Show. Voice Narration. Using Action Buttons. Introducing Animation Schemes. Customizing Your Own Animation. Summary. Q&A.

V. ORGANIZING WITH OUTLOOK 2002.

Hour 16. Communicating with Outlook 2002.


An Outlook Overview. Outlook and Outlook Express. The Outlook Screen. View Non-Outlook Data. Mastering Outlook Mail. Keeping Contacts. Summary. Q&A.

Hour 17. Planning and Scheduling with Outlook 2002.


Using the Calendar in Outlook. Writing Yourself Notes. Keeping a Journal. Smart Tags. Summary. Q&A.

VI. TRACKING WITH ACCESS 2002.

Hour 18. Access 2002 Basics.


Database Basics. Looking at Access. Creating a Database. Using Wizards to Create Databases. Summary. Q&A.

Hour 19. Entering and Displaying Access 2002 Data.


Entering Table Data. Summary. Q&A.

Hour 20. Retrieving Your Data.


Using Data Filters. Using Queries. Summary. Q&A.

Hour 21. Reporting with Access 2002.


Introducing Access Reports. Summary. Q&A.

VII. COMBINING THE OFFICE XP PRODUCTS AND THE INTERNET.

Hour 22. Sharing Information Between Programs.


Sharing Data Between Applications. Outlook Letters. Enhancing Your Office Documents. Summary. Q&A.

Hour 23. Office XP and the Internet.


Brief Internet Primer. Introducing the Web. Using Internet Explorer. How Office Products Combine with the Web. Keeping Current. Summary. Q&A.

Hour 24. Creating Web Pages with Office XP.


Preparing to Publish Web Pages. Office and the Web. Summary. Q&A.

Glossary.
Index.