2007 Microsoft® Office System Plain & Simple

Larger Cover

By Jerry Joyce, Marianne Moon

Publisher: Microsoft Press

Released: January 2007

Pages: 384

Chapter 1 About This Book
1. No Computerspeak!
2. A Quick Overview
3. What’s New in Office 2007?
4. A Few Assumptions
5. A Final Word (or Two)
Chapter 2 Working in Office
1. What’s What in Office?
2. Dialog Box Decisions
3. Using the Ribbon
4. Using Menus and Toolbars
5. Using Only the Keyboard
6. Moving and Copying Content
7. Getting Help
8. Saving Your Work
9. Office’s File Formats
Chapter 3 Common Tasks in Office
1. Working with Old Documents
2. Inserting Special Characters
3. Inserting Pictures
4. Changing the Size of a Picture
5. Editing a Picture
6. Adding Shapes
7. Adding Clip Art
8. Formatting a Shape
9. Inserting the Date and Time
10. Creating Stylized Text
11. Inserting a Relational Diagram
12. Researching a Subject
Chapter 4 Viewing and Editing Text in Word
1. What’s Where in Word 2007?
2. Creating a New Document
3. Composing Different Types of Documents
4. Word’s Views
5. Reading a Document
6. Editing Text
7. Finding Text
8. Replacing Text
9. Correcting Your Spelling and Grammar
10. Correcting Text Automatically
11. Adding Page Numbers
12. So Many Ways to Do It
13. Marking and Reviewing Changes in a Document
14. Comparing Documents Side by Side
Chapter 5 Formatting in Word
1. Controlling the Look: Themes, Styles, and Fonts
2. Setting the Overall Look
3. Formatting Text
4. Using Any Style
5. Changing Character Fonts
6. Setting Paragraph Alignment
7. Adjusting Paragraph Line Spacing
8. Indenting a Paragraph
9. Formatting with Tabs
10. Adding Emphasis and Special Formatting
11. Copying Your Formatting
12. Creating a Bulleted or Numbered List
13. Formatting a List
14. Creating a Table from Scratch
15. Using a Predesigned Table
16. Creating a Table from Text
17. Adding or Deleting Rows and Columns
18. Formatting a Table
19. Improving the Layout with Hyphenation
20. Laying Out the Page
21. Changing Page Orientation Within a Document
22. Flowing Text into Columns
23. Creating Chapters
24. Wrapping Text Around a Graphic
25. Creating a Running Head
26. Sorting Your Information
27. Reorganizing a Document
Chapter 6 Working with Special Content in Word
1. Inserting a Cover Page
2. Numbering Headings
3. Adding Line Numbers
4. Inserting Information with Smart Tags
5. Inserting an Equation
6. Adding a Sidebar or a Pull Quote
7. Inserting a Watermark
8. Creating Footnotes and Endnotes
9. Inserting a Citation
10. Creating a Table of Contents
11. Printing an Envelope
12. Printing a Mailing Label
13. Mail Merge: The Power and the Pain
14. Creating a Form Letter
15. Finalizing Your Document
Chapter 7 Working in Excel
1. What’s Where in Excel?
2. Entering the Data
3. Editing the Data
4. Excel’s Eccentricities
5. Using a Predefined Workbook
6. Formatting Cells
7. Changing the Overall Look
8. Formatting Numbers
9. Moving and Copying Data
10. Adding and Deleting Columns and Rows
11. Creating a Series
12. Hiding Columns and Rows
13. Formatting Cell Dimensions
14. Organizing Your Worksheets
15. Setting Up the Page
16. Printing a Worksheet
17. Adding and Viewing Comments
Chapter 8 Analyzing and Presenting Data in Excel
1. Creating a Table
2. Cell References, Formulas, and Functions
3. Doing the Arithmetic
4. Summing the Data
5. Creating a Series of Calculations
6. Making Calculations with Functions
7. Troubleshooting Formulas
8. Sorting the Data
9. Filtering the Data
10. Separating Data into Columns
11. Creating Subtotals
12. Summarizing the Data with a PivotTable
13. Displaying Relative Values
14. Automatically Highlighting Certain Data
15. Customizing Conditional Formatting
16. The Anatomy of a Chart
17. Charting Your Data
18. Formatting a Chart
19. Customizing a Chart
20. Reviewing the Data
Chapter 9 Creating a PowerPoint Presentation
1. What’s Where in PowerPoint?
2. Creating a Presentation
3. Inserting a Table
4. Converting Text into a SmartArt Graphic
5. Converting Text into WordArt
6. Including a Slide from Another Presentation
7. Inserting Multimedia
8. Formatting a Slide
9. Animating Items on a Slide
10. Customizing Your Animation
11. Adding an Action to a Slide
12. Editing a Presentation
13. Repeating Content on Every Slide
14. Adding Transition Effects to Slides
15. Modifying the Default Layout
16. Creating a Photo Album
Chapter 10 Presenting a PowerPoint Slide Show
1. Adding Speaker Notes
2. Printing Handouts
3. The Perils of Presentation
4. Running a Slide Show
5. Running a Slide Show with Dual Monitors
6. Customizing the Presentation
7. Recording a Narration
8. Timing a Presentation
9. Creating Different Versions of a Slide Show
10. Creating a Show for Distribution
11. Taking Your Show on the Road
12. Using Navigation Buttons
13. Creating Pictures of Your Slides
14. Reviewing a Presentation
15. Changing Slide-Show Settings
Chapter 11 Working with Messages in Outlook
1. What’s Where in Outlook Messages?
2. Sending E-Mail
3. Receiving and Reading E-Mail
4. Replying to and Forwarding a Message
5. Sending or Receiving a File
6. Formatting E-Mail Messages
7. Managing Messages
8. Signing Your E-Mail
9. Setting Up RSS Subscriptions
10. Reading RSS Items
11. Setting Up E-Mail Accounts
12. E-Mailing Your Schedule
13. Understanding E-Mail Encryption
Chapter 12 Organizing with Outlook
1. What’s Where in Outlook?
2. Keeping Track of Your Schedule
3. Sharing Calendars
4. Viewing Your Group’s Schedule
5. Scheduling a Meeting
6. Managing Your Contacts
7. Keeping Track of Your Tasks
8. Assigning Tasks
9. Tacking Up Notes
10. Creating and E-Mailing Contact Business Cards
11. Customizing Outlook
Chapter 13 Creating a Publication in Publisher
1. What’s Where in Publisher?
2. Creating a Publication from a Design
3. Creating a Publication from Scratch
4. Adding Text
5. Flowing Text Among Text Boxes
6. Tweaking Your Text
7. Adding a Table
8. Repeating Objects on Every Page
9. Modifying a Picture
10. Formatting an Object
11. Adding a Design Object
12. Arranging Objects on the Page
13. Stacking and Grouping Objects
14. Flowing Text Around an Object
15. Reusing Content
16. Inserting Your Business Information
17. Creating a Web Site in Publisher
18. Double-Checking Your Publication
19. Sending a Publication as E-Mail
20. Printing Your Publication
Chapter 14 Working in Access
1. What’s Where in Access?
2. What is a Relational Database?
3. Using an Existing Database
4. Creating a Database from a Template
5. Adding a Table to a Database
6. Modifying a Table
7. Adding Data to a Table
8. Access File Formats
9. Importing Data
10. Exporting Data
11. Defining Relationships Among Tables
12. Creating a Form
13. Creating a Report from the Data
14. Extracting Information from a Database (Queries)
15. Analyzing Data with a PivotChart
16. Collecting Data Using E-Mail
17. Customizing Access
Chapter 15 Exchanging Information Among Programs
1. Inserting Excel Data into a Document, Publication, or Presentation
2. Inserting an Excel Chart into a Document, Publication, or Presentation
3. Analyzing a Word Table in Excel
4. Using Word to Prepare PowerPoint Text
5. Preparing PowerPoint Handouts in Word
6. Inserting a PowerPoint Slide Show into a Document, Worksheet, or Publication
7. Using Publisher to Present a Word Document
8. Using Word to Prepare Publisher Text
9. Using Word to Present Access Data
10. Analyzing Access Data in Excel
11. Adding Excel Data to an Access Database
12. Using Access Data in a Mail Merge
13. Using Your Contacts List in a Mail Merge
14. Creating PDF or XPS Documents
15. Creating an Image of Your Work
16. Viewing and Annotating a Scanned Image or a Fax
17. Converting a Scanned Document into Text
18. Scanning a Document
19. Managing and Editing Your Pictures
20. Linking to a File or to a Web Page
21. Managing Pictures, Videos, and Sound Files
Chapter 16 Customizing and Securing Office
1. Customizing the Quick Access Toolbar
2. Customizing the Window
3. Customizing Your Editing
4. Changing Your User Information
5. Customizing the Spelling and Grammar Checkers
6. Customizing Your Spelling Dictionaries
7. Changing the Location and Type of Saved Files
8. Safeguarding a Document
9. Protecting a Document, Workbook, or Presentation with a Password
10. Signing a Document or Workbook with a Visible Signature
11. Signing a Document, Workbook, or Presentation with a Digital Certificate
12. Controlling Macros, Add-Ins, and ActiveX Controls
13. Downloading Add-Ins and Other Free Software
14. Adding or Removing Office Components
15. Checking the Compatibility
16. Fixing Office

Appendix About the Authors
Appendix Choose the Right Book for You
1. Published and Upcoming Titles

Title:

2007 Microsoft® Office System Plain & Simple

By:

Jerry Joyce, Marianne Moon

Publisher:

Microsoft Press

Formats:

Print
Ebook
Safari Books Online

Print:

January 2007

Ebook:

November 2009

Pages:

384

Print ISBN:

978-0-7356-2273-9

| ISBN 10:

0-7356-2273-6

Ebook ISBN:

978-0-7356-9024-0

| ISBN 10:

0-7356-9024-3

Description

Table of Contents

Product Details

About the Author

Recommended for You

Chapter 1 About This Book

No Computerspeak!

A Quick Overview

What’s New in Office 2007?

A Few Assumptions

A Final Word (or Two)

Chapter 2 Working in Office

What’s What in Office?

Dialog Box Decisions

Using the Ribbon

Using Menus and Toolbars

Using Only the Keyboard

Moving and Copying Content

Getting Help

Saving Your Work

Office’s File Formats

Chapter 3 Common Tasks in Office

Working with Old Documents

Inserting Special Characters

Inserting Pictures

Changing the Size of a Picture

Editing a Picture

Adding Shapes

Adding Clip Art

Formatting a Shape

Inserting the Date and Time

Creating Stylized Text

Inserting a Relational Diagram

Researching a Subject

Chapter 4 Viewing and Editing Text in Word

What’s Where in Word 2007?

Creating a New Document

Composing Different Types of Documents

Word’s Views

Reading a Document

Editing Text

Finding Text

Replacing Text

Correcting Your Spelling and Grammar

Correcting Text Automatically

Adding Page Numbers

So Many Ways to Do It

Marking and Reviewing Changes in a Document

Comparing Documents Side by Side

Chapter 5 Formatting in Word

Controlling the Look: Themes, Styles, and Fonts

Setting the Overall Look

Formatting Text

Using Any Style

Changing Character Fonts

Setting Paragraph Alignment

Adjusting Paragraph Line Spacing

Indenting a Paragraph

Formatting with Tabs

Adding Emphasis and Special Formatting

Copying Your Formatting

Creating a Bulleted or Numbered List

Formatting a List

Creating a Table from Scratch

Using a Predesigned Table

Creating a Table from Text

Adding or Deleting Rows and Columns

Formatting a Table

Improving the Layout with Hyphenation

Laying Out the Page

Changing Page Orientation Within a Document

Flowing Text into Columns

Creating Chapters

Wrapping Text Around a Graphic

Creating a Running Head

Sorting Your Information

Reorganizing a Document

Chapter 6 Working with Special Content in Word

Inserting a Cover Page

Numbering Headings

Adding Line Numbers

Inserting Information with Smart Tags

Inserting an Equation

Adding a Sidebar or a Pull Quote

Inserting a Watermark