Book description
This book is a reasonably priced, unintimidating guide to the essentials of Microsoft Office. Organized and presented specifically for busy professionals who need to use the applications immediately, it guides you right to the information you need. All the most important tasks in each program are covered, using clear, step-by-step instructions, and illustrated with hundreds of helpful screenshots. Office XP promises a wealth of exciting new features, and Microsoft Office XP for Windows: Visual QuickStart Guide lets you put them to work for you in a hurry.
Table of contents
- Copyright
- About the Authors
- Other Books by Steve Sagman
- Acknowledgments
-
I. Common Office Techniques
-
1. Basic Office Techniques
- Creating a New Document
- Opening an Office Document
- Choosing from Menus and Toolbars
- Selecting Toolbars to Display
- Making Selections in Dialog Boxes
- Using the Task Panes
- Getting Help from the Office Assistant
- Getting Help Using the Ask a Question Box
- Controlling Office XP with Voice Commands
- Dictating in Office XP
- Using Smart Tags
-
2. Working in Programs
- Undoing a Change
- Selecting Text Using the Mouse
- Selecting and Replacing Text Using the Keyboard
- Dragging and Dropping Text
- Selecting and Formatting Objects
- Copying Formatting Using the Format Painter
- Zooming In and Out
- Setting Up the Page
- Previewing Printing
- Printing
- Saving Your Work
- Reopening a Saved File
- Quitting an Office Program
- Using the Office XP Clipboard
-
1. Basic Office Techniques
-
II. Microsoft Word
- 3. Introducing Word 2002
- 4. Entering and Editing Text
-
5. Formatting Text
- Changing the Font and Font Size
- Boldfacing, Italicizing, and Underlining
- Expanding and Condensing Character Spacing
- Changing the Case of Text
- Using Special Font Effects
- Selecting Paragraphs
- Using the Ruler to Indent Paragraphs
- Setting a Different First Line Indent
- Indenting Using the Paragraph Dialog Box
- Double-Spacing Paragraphs
- Centering and Justifying Paragraphs
- Setting Tabs
- Adding Bullets to Paragraphs
- Numbering Paragraphs
- Finding and Replacing Formatting
- Using Styles
- Choosing a Text Style
- Creating a Paragraph Style
- Modifying a Paragraph Style
- Creating a Character Style
- 6. Formatting Pages
- 7. Creating Tables
- 8. Special Word Techniques
- 9. Word and theWeb
-
III. Microsoft Excel
- 10. Introducing Excel 2002
-
11. Entering Data and Formulas
- Starting with a Template
- Moving Within a Sheet
- Typing Data into a Cell
- Editing Cells
- Adding a Hyperlink
- Filling an Entry Range
- AutoFilling a Range
- Entering Simple Calculations
- Building a Simple Formula
- Summing Columns and Rows
- Totaling a Column Using the Sum Function
- Copying Formulas to Adjacent Cells
- Averaging Numbers Using the Average Function
- Calculating Numbers in Nonadjacent Cells
- Building Formulas by Inserting Functions
- 12. Structuring the Sheet
- 13. Formatting the Sheet
-
14. Using Excel Charts
- Creating a Default Chart
- Creating a Chart Using the Chart Wizard
- Modifying a Chart
- Modifying the Chart Type
- Modifying the Chart Area, Plot Area, and Gridlines
- Modifying the Title, Axes, and Legend
- Modifying a Data Series
- Adding Data to a Chart
- Adding Data Tables and Trendlines
- Creating a PivotTable Report
- Creating a PivotChart Report
- 15. Excel Database Techniques
- 16. Special Excel Techniques
- 17. Excel and theWeb
-
IV. Microsoft PowerPoint
- 18. Introducing PowerPoint 2002
- 19. Building a Presentation
- 20. Outlining the Presentation
- 21. Creating Text Slides
- 22. Creating Chart Slides
- 23. Formatting Charts
- 24. Creating Org Charts and Tables
-
25. Customizing a Presentation
- Selecting a New Design
- Changing the Color Scheme
- Switching to Master Views
- Changing the Background Color and Shading
- Changing the Text Fonts
- Changing Header and Footer Information
- Adding a Logo to the Background
- Saving a Custom Design
- Working in Slide Sorter View
- Reordering Slides
- Changing the Design in Slide Sorter View
- Duplicating and Deleting Slides
- 26. Drawing on Slides
- 27. Creating Slide Shows
- 28. PowerPoint and the Web
-
V. Microsoft Access
- 29. Introducing Access 2002
- 30. Creating a Database
- 31. Creating a Table
-
32. Creating a Form
- Entering Data in a Form
- Viewing and Editing Records Using a Form
- Creating and Saving a Form
- Creating a Form Using the Form Wizard
- Opening the Form in Design View
- Moving a Control
- Sizing a Control and Moving Labels Independently
- Adding Labels
- Formatting Labels
- Adding a Combo Box
- Setting the Form and Control Properties
- 33. Working with Records
-
34. Using Queries
- Creating and Running a Select Query
- Saving a Query and Printing the Results
- Starting a Query Using the Simple Query Wizard
- Adding Criteria to a Query
- Calculating Totals in a Query
- Finding Duplicate or Unmatched Records
- Updating Table Records Using an Update Query
- Deleting Table Records Using a Delete Query
- Appending Table Records Using an Append Query
- Creating a Table of Query Results Using a Make-Table Query
- Creating a Crosstab Query
- 35. Creating a Report
-
36. Access and the Web
- Creating and Saving a Data Access Page
- Starting a Data Access Page Using the Page Wizard
- Creating a Data Acces Page Using an AutoPage
- Revising the Page in Design View
- Changing the Theme in Design View
- Inserting a Chart in a Data Access Page
- Inserting a PivotTable in a Data Access Page
- Inserting a Spreadsheet in a Data access Page
- Adding a Hyperlink Field
- Adding a Hyperlink
-
VI. Microsoft Outlook
- 37. Introducing Outlook 2002
- 38. Reading Messages
-
39. Sending Messages
- Setting Mail Format Options
- Using Stationery
- Creating a Signature
- Starting and Addressing a Message
- Entering and Formatting the Text
- Starting a Message Using a Different Format or Program
- Setting Message Options
- Attaching a File or an Item to a Message
- Inserting an Object in a Message
- Saving and Sending the Message
- 40. Managing Your Mailbox
- 41. Keeping a Contacts List
- 42. Scheduling Tasks and Meetings
Product information
- Title: Microsoft Office XP for Windows: Visual QuickStart Guide
- Author(s):
- Release date: July 2001
- Publisher(s): Peachpit Press
- ISBN: 9780201741476
You might also like
book
What's New in Windows Vista?
Get ready for a quick blast through this significant change to Windows! This guide will give …
book
Excel 2003 for Starters: The Missing Manual
The dominant spreadsheet program and one of the most widely used software applications in the world, …
book
Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours
For readers who are new to Excel 11 and want to get up and running quickly, …
book
Adobe® Photoshop® CS2 Studio Techniques
If you're ready to go from blindly following step-by-step instructions to "Aha, I finally GET Photoshop!" …