Home Page Icon
Home Page
Table of Contents for
Index
Close
Index
by Marianne Moon, Jerry Joyce
2007 Microsoft® Office System Plain & Simple
2007 Microsoft® Office System Plain & Simple
SPECIAL OFFER: Upgrade this ebook with O’Reilly
Acknowledgments
1. About This Book
No Computerspeak!
Useful Tasks...
...And the Easiest Way to Do Them
A Quick Overview
What’s New in Office 2007?
A Few Assumptions
A Final Word (or Two)
2. Working in Office
What’s What in Office?
Microsoft Office 2007 Programs
Dialog Box Decisions
Using the Ribbon
Explore the Ribbon
Set the Ribbon Display
Using Menus and Toolbars
Explore the Menus
Use the Toolbars
Use the Shortcut Menus
Using Only the Keyboard
Browse the Ribbon with Your Keyboard
Use Keyboard Shortcuts
Common Keyboard Shortcuts
Moving and Copying Content
Cut or Copy Text
Paste the Cut or Copied Text
Copy and Paste Multiple Items
Getting Help
Browse for Help
Search for Help
Saving Your Work
Save the File
Office’s File Formats
Other File Formats for Office Programs
And There’s More
3. Common Tasks in Office
Working with Old Documents
Convert the Document
Inserting Special Characters
Insert a Character
Inserting Pictures
Insert a Picture
Changing the Size of a Picture
Trim It
Size It
Editing a Picture
Change Its Appearance
Rotate It
Add an Effect
Adding Shapes
Draw a Shape
Adding Clip Art
Find and Insert Clip Art
Formatting a Shape
Format the Shape
Inserting the Date and Time
Insert the Date and/or Time
Creating Stylized Text
Create Some WordArt
Fine-Tune the Result
Inserting a Relational Diagram
Create a Diagram
Modify the Diagram
Researching a Subject
Do Some Research
4. Viewing and Editing Text in Word
What’s Where in Word 2007?
Creating a New Document
Start Word and Enter Some Text
Composing Different Types of Documents
Start the Document
Word’s Views
Print Layout View
Full Screen Reading View
Web Layout View
Outline View
Draft View
Print Preview
Reading a Document
Read
Editing Text
Select and Modify Text
Finding Text
Find Text One Instance at a Time
Find All Instances of Text
Replacing Text
Replace Text
Correcting Your Spelling and Grammar
Correct a Spelling Error
Correct a Contextual Spelling Error
Correct the Grammar
Automatically Correct Your Misspellings
Correcting Text Automatically
Add Entries
Adding Page Numbers
Insert Page Numbers
So Many Ways to Do It
Text-Selection Methods
Copying and Moving Methods
Marking and Reviewing Changes in a Document
Review a Document
Review a Review
Comparing Documents Side by Side
View the Documents
5. Formatting in Word
Controlling the Look: Themes, Styles, and Fonts
Setting the Overall Look
Choose a Theme
Formatting Text
Apply a Quick Paragraph Style
Apply Character Formatting
Using Any Style
Access Your Styles
Changing Character Fonts
Change the Font
Change the Font Size
Setting Paragraph Alignment
Set the Alignment
Adjusting Paragraph Line Spacing
Set the Line Spacing Within a Paragraph
Set the Line Spacing Between Paragraphs
Indenting a Paragraph
Indent the Paragraph
Formatting with Tabs
Set Your Tabs
Adding Emphasis and Special Formatting
Format the Text
Copying Your Formatting
Copy the Formatting
Creating a Bulleted or Numbered List
Create the List
Formatting a List
Change the Format
Creating a Table from Scratch
Create the Table
Using a Predesigned Table
Choose a Table
Creating a Table from Text
Convert the Text
Adding or Deleting Rows and Columns
Add to the Table
Delete from the Table
Formatting a Table
Format the Table
Improving the Layout with Hyphenation
Set Automatic Hyphenation
Laying Out the Page
Set Up a Standard Page
Set Up a Two-Sided Document
Set Up a Bound Document
Changing Page Orientation Within a Document
Change the Page Orientation
Flowing Text into Columns
Change the Number of Columns
Creating Chapters
Start a New Chapter
Change the Running Heads
Wrapping Text Around a Graphic
Set the Text Wrapping
Creating a Running Head
Create a Header and a Footer
Sorting Your Information
Sort a Table
Sort a List
Reorganizing a Document
View a Document’s Outline
6. Working with Special Content in Word
Inserting a Cover Page
Insert the Cover Page
Numbering Headings
Number the Headings
Adding Line Numbers
Number the Lines
Inserting Information with Smart Tags
Insert a Character
Inserting an Equation
Insert the Equation
Adding a Sidebar or a Pull Quote
Insert a Predesigned Text Box
Inserting a Watermark
Create the Watermark
Creating Footnotes and Endnotes
Insert the Footnote or Endnote
Change the Reference Mark
Inserting a Citation
Add Existing Citations
Insert a Citation
Creating a Table of Contents
Set the Outline Text
Printing an Envelope
Add the Address
Printing a Mailing Label
Print the Label
Mail Merge: The Power and the Pain
Setting Conditional Content
It’s More than Letters
Creating a Form Letter
Set Up Your Letter
Specify the Data to Be Merged
Finalizing Your Document
Prepare Your Document
7. Working in Excel
What’s Where in Excel?
Entering the Data
Enter Your Data
Editing the Data
Replace the Data
Edit the Existing Data
Excel’s Eccentricities
Using a Predefined Workbook
Open and Use a Template
Formatting Cells
Format Some Cells
Changing the Overall Look
Choose a Theme
Formatting Numbers
Format Some Numbers
Moving and Copying Data
Move Some Content
Copy or Cut Some Content
Copy Content to Adjacent Cells
Adding and Deleting Columns and Rows
Add a Column
Add a Row
Delete a Column or a Row
Delete Some or All Content of Cells
Creating a Series
Create a Series
Hiding Columns and Rows
Hide Columns or Rows
Reveal Hidden Columns or Rows
Formatting Cell Dimensions
Set the Column Width
Set the Row Height
Adjust the Height or Width to Fit the Content
Organizing Your Worksheets
Name the Worksheets
Change Their Order
Insert a Worksheet
Delete a Worksheet
Setting Up the Page
Set the Dimensions
Set the Header and Footer
Printing a Worksheet
Specify What’s to be Printed
Check the Layout
Adding and Viewing Comments
Create a Comment
Review the Comments
8. Analyzing and Presenting Data in Excel
Creating a Table
Create a Table
Use the Table
Cell References, Formulas, and Functions
Doing the Arithmetic
Calculate a Value
Arithmetic Operators
Calculate the Value of Cells
Summing the Data
Sum the Numbers
Creating a Series of Calculations
Create the Series
Making Calculations with Functions
Find a Function
Add Your Arguments
Troubleshooting Formulas
Review the Errors
Evaluate a Formula
Sorting the Data
Conduct an Alphabetic or a Numeric Sort
Filtering the Data
Filter the Data
Separating Data into Columns
Separate the Data
Creating Subtotals
Create the Subtotals
Summarizing the Data with a PivotTable
Create the PivotTable
Use the PivotTable
Displaying Relative Values
Show the Relative Value
Automatically Highlighting Certain Data
Set the Conditional Formatting
Customizing Conditional Formatting
Create a Rule
The Anatomy of a Chart
Charting Your Data
Create a Chart
Complete the Layout
Formatting a Chart
Change the Chart Style
Change the Theme
Format an Element
Customizing a Chart
Change a Data-Series Chart
Add an Axis
Reviewing the Data
Freeze the Columns and/or Rows
View Multiple Sections
9. Creating a PowerPoint Presentation
What’s Where in PowerPoint?
Creating a Presentation
Set Up the Presentation
Add Your Content
Inserting a Table
Create the Table
Converting Text into a SmartArt Graphic
Create the Graphic
Converting Text into WordArt
Convert the Text
Including a Slide from Another Presentation
Include the Slide
Inserting Multimedia
Insert a Video
Insert a Sound
Formatting a Slide
Format the Content
Format the Background
Animating Items on a Slide
Animate the Text
Animate a SmartArt Graphic
Customizing Your Animation
Customize the Animation
Adding an Action to a Slide
Assign an Action
Editing a Presentation
Change the Content of the Slides
Change the Order of the Slides
Repeating Content on Every Slide
Add the Footer
Adding Transition Effects to Slides
Set the Transitions
Modifying the Default Layout
Modify the Layout
Create a New Layout
Creating a Photo Album
Create the Album
10. Presenting a PowerPoint Slide Show
Adding Speaker Notes
Create the Notes
Set Up and Print the Notes
Printing Handouts
Create the Handouts
The Perils of Presentation
Running a Slide Show
Run the Presentation
Modify the Presentation
Running a Slide Show with Dual Monitors
Control the Show
Customizing the Presentation
Set Up the Show
Recording a Narration
Narrate Your Presentation
Timing a Presentation
Time the Presentation
Creating Different Versions of a Slide Show
Create a Custom Slide Show
Creating a Show for Distribution
Save the Show
Taking Your Show on the Road
Package Your Presentation
Using Navigation Buttons
Add Navigation Buttons
Creating Pictures of Your Slides
Create the Pictures
Reviewing a Presentation
Review the Presentation
Changing Slide-Show Settings
Change the Settings
11. Working with Messages in Outlook
What’s Where in Outlook Messages?
Overview of New Message Window
Overview of the Message Window’s Insert Tab
Sending E-Mail
Address an E-Mail Message
Type Your Message Subject and Text
Receiving and Reading E-Mail
Locate New Messages
Open Message Items
Replying to and Forwarding a Message
Reply to an E-Mail Message
Forward an E-Mail Message
Sending or Receiving a File
Attach a File
Open an Attachment
Formatting E-Mail Messages
Use a Rich Text or HTML Message Format
Add Formatting to a Message
Managing Messages
Mark, Unmark, and Delete Messages
Move Messages Between Folders
Signing Your E-Mail
Using Your Signature
Setting Up RSS Subscriptions
Add an RSS Feed from a Quick Link
Reading RSS Items
Read RSS Feed
Setting Up E-Mail Accounts
Add an E-Mail Account
E-Mailing Your Schedule
Send Your Schedule via E-Mail
Understanding E-Mail Encryption
12. Organizing with Outlook
What’s Where in Outlook?
Calendar
Contacts
Keeping Track of Your Schedule
Use the Date Navigator
Use the Calendar View
Use the To-Do Bar
Sharing Calendars
Forward a Calendar Item
Forward an Item as an iCalendar
Viewing Your Group’s Schedule
Create a New Group
View a Group Schedule
Scheduling a Meeting
Create a Meeting in a Block of Time
Specify a Meeting Date and Time Manually
Managing Your Contacts
Use E-Mail Message Information
Use the Contact Window
Keeping Track of Your Tasks
Set the Task Name and Due Date
Open the Task Item Window
Use the Task List
Assigning Tasks
Assign a Task
Tacking Up Notes
Add a Note
Creating and E-Mailing Contact Business Cards
Create a Contact Business Card
E-Mail a Contact Business Card
Customizing Outlook
Add or Remove a Toolbar
13. Creating a Publication in Publisher
What’s Where in Publisher?
Creating a Publication from a Design
Use a Design
Creating a Publication from Scratch
Set Up Your Publication
Adding Text
Add Text
Flowing Text Among Text Boxes
AutoFlow the Text
Manually Flow the Text
Tweaking Your Text
Improve the Look of the Text
Adding a Table
Insert the Table
Repeating Objects on Every Page
Add the Repeating Objects
Modifying a Picture
Modify the Picture
Formatting an Object
Format the Object
Adding a Design Object
Insert the Design Object
Arranging Objects on the Page
Set Up Your Grid
Position an Object at an Exact Location
Stacking and Grouping Objects
Arrange the Objects
Flowing Text Around an Object
Set the Text Wrapping
Reusing Content
Use the Content Library
Inserting Your Business Information
Use Business Information
Creating a Web Site in Publisher
Create the Web Site
Publish It!
Double-Checking Your Publication
Check the Design
Sending a Publication as E-Mail
E-Mail Your Publication
Printing Your Publication
The Final Step: Print It!
14. Working in Access
What’s Where in Access?
Surveying the Access Window
Surveying the Object Window
What is a Relational Database?
Storing Data on Index Cards
Storing Data on the Computer
Storing Data in a Database
Using an Existing Database
Open a Database on Startup
Open a Recently Used Database
Creating a Database from a Template
Create a Database from a Template
Find Database Templates Online
Adding a Table to a Database
Create a New Table by Typing
Modifying a Table
Change a Table
Adding Data to a Table
Select Text
Delete Text
Undoing Operations
Copy and Paste Text
Access File Formats
Importing Data
Copy a Table from Another Database
Exporting Data
Exporting Data to Excel
Defining Relationships Among Tables
Define a Relationship
Creating a Form
Create a Simple Form
Step through the Form Wizard
Creating a Report from the Data
Step through the Report Wizard
Extracting Information from a Database (Queries)
Create a Detail Query
Analyzing Data with a PivotChart
Step through the PivotChart Wizard
Change a PivotChart Chart Type
Collecting Data Using E-Mail
Send a Data Collection E-Mail Message
Customizing Access
Create a Macro
15. Exchanging Information Among Programs
Inserting Excel Data into a Document, Publication, or Presentation
Copy the Data
Edit the Data
Inserting an Excel Chart into a Document, Publication, or Presentation
Insert the Chart
Analyzing a Word Table in Excel
Analyze the Table
Using Word to Prepare PowerPoint Text
Create the Presentation
Preparing PowerPoint Handouts in Word
Publish the Slides to Word
Inserting a PowerPoint Slide Show into a Document, Worksheet, or Publication
Insert the Presentation
Using Publisher to Present a Word Document
Publish Your Document
Using Word to Prepare Publisher Text
Create Your Story
Using Word to Present Access Data
Publish Your Data
Analyzing Access Data in Excel
Analyze Your Data
Adding Excel Data to an Access Database
Get the Excel Data
Using Access Data in a Mail Merge
Create a Mail Merge Using Access Data
Using Your Contacts List in a Mail Merge
Create a Mail Merge Using Your Contacts List
Creating PDF or XPS Documents
Create a Document in Access, Excel, PowerPoint, or Word
Create a Document in Publisher
Creating an Image of Your Work
Create the Image
Viewing and Annotating a Scanned Image or a Fax
View and Annotate an Image
Converting a Scanned Document into Text
Convert the Image
Scanning a Document
Scan a Text Document
Managing and Editing Your Pictures
Work with Your Pictures
Linking to a File or to a Web Page
Link to the File or to the Web Page
Managing Pictures, Videos, and Sound Files
Organize Your Clips
16. Customizing and Securing Office
Customizing the Quick Access Toolbar
Add or Remove Items Common to the Quick Access Toolbar
Control the Customization
Customizing the Window
Show or Hide Items on the Status Bar
Change the Window’s Color Scheme
Change What’s Shown
Customizing Your Editing
Adjust the Settings
Changing Your User Information
Change Your Name and Address
Customizing the Spelling and Grammar Checkers
Specify What’s to Be Checked
Customizing Your Spelling Dictionaries
Add a Dictionary
Changing the Location and Type of Saved Files
Change the File Locations and Formats
Safeguarding a Document
Set Up the Safeguards
Protecting a Document, Workbook, or Presentation with a Password
Encrypt the Document, Workbook, or Presentation
Protect the Document, Workbook, or Presentation from Modifications
Signing a Document or Workbook with a Visible Signature
Set Up the Signature
Sign the Document
Signing a Document, Workbook, or Presentation with a Digital Certificate
Attach a Digital Signature
Controlling Macros, Add-Ins, and ActiveX Controls
Modify the Settings
Downloading Add-Ins and Other Free Software
Download the Software
Adding or Removing Office Components
Add or Remove Components
Checking the Compatibility
Run the Check
Fixing Office
Run the Diagnostics
About the Authors
Choose the Right Book for You
Published and Upcoming Titles
Plain & Simple
Step by Step
Inside Out
Index
About the Authors
SPECIAL OFFER: Upgrade this ebook with O’Reilly
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Index
Next
Next Chapter
About the Authors
Z
Zoom Controls,
What’s Where in Word 2007?
,
Creating a New Document
,
What’s Where in Publisher?
zooming,
Creating a New Document
,
Adding Speaker Notes
,
Managing and Editing Your Pictures
magnifying text,
Creating a New Document
,
Adding Speaker Notes
picture views,
Managing and Editing Your Pictures
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset