Download Office 2007 All-in-One Desk Reference for Dummies (ISBN - 0471782793) PDF

TitleOffice 2007 All-in-One Desk Reference for Dummies (ISBN - 0471782793)
TagsFor Dummies
File Size16.2 MB
Total Pages818
Table of Contents
                            Office 2007 All-In-One Desk Reference For Dummies
	About the Author
	Author’s Acknowledgments
		What’s in This Book, Anyway?
		What Makes This Book Different
		Foolish Assumptions
		Conventions Used in This Book
		Icons Used in This Book
		Good Luck, Reader!
	Book I: Common Office Tools
		Contents at a Glance
		Chapter 1: Office Nuts and Bolts
			A Survey of Office Programs
			Starting an Office Program
			Finding Your Way around the New Office Interface
			Saving Your Files
			Opening and Closing Files
			Entering the Document Properties
			Understanding the New Office XML Format
			Locking a File with a Password
		Chapter 2: Wrestling with the Text
			Manipulating the Text
			Changing the Look of Text
			Quick Ways to Handle Case, or Capitalization
			Entering Symbols and Foreign Characters
			Finding and Replacing Text
			Creating Hyperlinks
		Chapter 3: Speed Techniques Worth Knowing About
			Undoing and Repeating Commands
			Zooming In, Zooming Out
			Viewing a File through More Than One Window
			Correcting Typos on the Fly
			Entering Text Quickly with the AutoCorrect Command
		Chapter 4: Taking Advantage of the Proofing Tools
			Correcting Your Spelling Errors
			Checking for Grammatical Errors in Word
			Researching a Topic inside an Office Program
			Finding the Right Word with the Thesaurus
			Proofing Text Written in a Foreign Language
			Translating Foreign Language Text
		Chapter 5: Creating a Table
			Talking Table Jargon
			Creating a Table
			Entering the Text and Numbers
			Selecting Different Parts of a Table
			Aligning Text in Columns and Rows
			Merging and Splitting Cells
			Laying Out Your Table
			Formatting Your Table
			Using Math Formulas in Word Tables
			Neat Table Tricks
		Chapter 6: Creating a Chart
			A Mercifully Brief Anatomy Lesson
			The Basics: Creating a Chart
			Choosing the Right Chart
			Providing the Raw Data for Your Chart
			Positioning Your Chart in a Workbook, Page, or Slide
			Changing a Chart’s Appearance
			Saving a Chart as a Template so You Can Use It Again
			Chart Tricks for the Daring and Heroic
			Troubleshooting a Chart
		Chapter 7: Making a SmartArt Diagram
			The Basics: Creating SmartArt Diagrams
			Creating the Initial Diagram
			Changing the Size and Position of a Diagram
			Laying Out the Diagram Shapes
			Handling the Text on Diagram Shapes
			Changing a Diagram’s Direction
			Choosing a Look for Your Diagram
			Changing the Appearance of Diagram Shapes
			Creating a Diagram from Scratch
		Chapter 8: Drawing and Manipulating Lines, Shapes, and Other Objects
			The Basics: Drawing Lines, Arrows, and Shapes
			Handling Lines, Arrows, and Connectors
			Handling Rectangles, Ovals, Stars, and Other Shapes
			WordArt for Bending, Spindling, and Mutilating Text
			Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects
			Changing an Object’s Color, Outline Color, and Transparency
	Book II: Word 2007
		Contents at a Glance
		Chapter 1: Speed Techniques for Using Word
			Introducing the Word Screen
			Creating a New Document
			Getting a Better Look at Your Documents
			Selecting Text in Speedy Ways
			Moving Around Quickly in Documents
			Inserting a Whole File into a Document
			Entering Information Quickly in a Computerized Form
		Chapter 2: Laying Out Text and Pages
			Paragraphs and Formatting
			Inserting a Section Break for Formatting Purposes
			Breaking a Line
			Starting a New Page
			Setting Up and Changing the Margins
			Indenting Paragraphs and First Lines
			Numbering the Pages
			Putting Headers and Footers on Pages
			Adjusting the Space between Lines
			Adjusting the Space between Paragraphs
			Creating Numbered and Bulleted Lists
			Working with Tabs
			Hyphenating a Document
		Chapter 3: Word Styles
			All about Styles
			Applying a Style to Text and Paragraphs
			Creating a New Style
			Modifying a Style
			Creating and Managing Templates
		Chapter 4: Desktop Publishing with Word
			Making Use of Charts, Diagrams, Shapes, Clip Art, and Photos
			Constructing the Perfect Table
			Positioning and Wrapping Objects Relative to the Page and Text
			Working with the Drawing Canvas
			Choosing a Theme for Your Document
			Putting Newspaper-Style Columns in a Document
			Working with Text Boxes
			Decorating a Page with a Border
			Dropping In a Drop Cap
			Watermarking for the Elegant Effect
			Landscape Documents
			Printing on Different Size Paper
		Chapter 5: Getting Word’s Help with Office Chores
			Highlighting Parts of a Document
			Commenting on a Document
			Tracking Revisions to Documents
			Printing an Address on an Envelope
			Printing a Single Address Label ( or a Page of the Same Label)
			Churning Out Letters, Labels, and Envelopes for Mass Mailings
		Chapter 6: Tools for Reports and Scholarly Papers
			Alphabetizing a List
			Outlines for Organizing Your Work
			Generating a Table of Contents
			Indexing a Document
			Putting Cross-References in a Document
			Putting Footnotes and Endnotes in Documents
			Compiling a Bibliography
	Book III: Outlook 2007
		Contents at a Glance
		Chapter 1: Getting Acquainted with Outlook
			What Is Outlook, Anyway?
			Navigating the Outlook Folders
			Wrestling with the Navigation Pane and To-Do Bar
			Getting a Better View of Items in a Folder
			Categorizing Items
			Finding Stray Folder Items
			Deleting E-Mail Messages, Contacts, Tasks, and Other Items
			Finding and Backing Up Your Outlook File
			Importing E-Mail and Addresses from Another Program
			Cleaning Out Your Folders
		Chapter 2: Maintaining the Contacts Folder
			Maintaining a Happy and Healthy Contacts Folder
			Finding a Contact in the Contacts Folder
			Printing the Contacts Folder
		Chapter 3: Handling Your E-Mail
			Addressing and Sending E-Mail Messages
			Being Advised When Someone Has Read Your E-Mail
			All about Message Formats
			Receiving E-Mail Messages
			Handling Files That Were Sent to You
			Techniques for Organizing E-Mail Messages
			All about E-Mail Folders
			Yes, You Can Prevent Junk Mail ( Sort of)
		Chapter 4: Managing Your Time and Schedule
			Introducing the Calendar
			The Different Kinds of Activities
			Going to a Different Day, Week, or Month
			Scheduling an Activity
			Canceling, Rescheduling, and Altering Activities
			Getting a Better View of Your Schedule
			Customizing the Outlook Calendar Window
		Chapter 5: Tasks, Reminders, and Notes
			Tasks: Seeing What Needs to Get Done
			Reminders for Being Alerted to Activities and Tasks
			Making Notes to Yourself
	Book IV: PowerPoint 2007
		Contents at a Glance
		Chapter 1: Getting Started in PowerPoint
			Getting Acquainted with PowerPoint
			A Brief Geography Lesson
			A Whirlwind Tour of PowerPoint
			Creating a New Presentation
			Advice for Building Persuasive Presentations
			Creating New Slides for Your Presentation
			Getting a Better View of Your Work
			Hiding and Displaying the Slides Pane and Notes Pane
			Selecting, Moving, and Deleting Slides
			Putting Together a Photo Album
			Hidden Slides for All Contingencies
		Chapter 2: Fashioning a Look for Your Presentation
			Looking at Themes and Background Styles
			Choosing a Theme for Your Presentation
			Creating Slide Backgrounds on Your Own
			Changing the Background of a Single or Handful of Slides
			Using Master Slides and Master Styles for a Consistent Design
		Chapter 3: Entering the Text
			Entering Text
			Fun with Text Boxes and Text Box Shapes
			Controlling How Text Fits in Text Frames and Text Boxes
			Positioning Text in Frames and Text Boxes
			Handling Bulleted and Numbered Lists
			Putting Footers ( and Headers) on Slides
		Chapter 4: Making Your Presentations Livelier
			Suggestions for Enlivening Your Presentation
			Transitions and Animations
			Sounding Off on Slides
			Playing Video on Slides
		Chapter 5: Delivering a Presentation
			All about Notes
			Rehearsing and Timing Your Presentation
			Showing Your Presentation
			Tricks for Making Presentations a Little Livelier
			Delivering a Presentation When You Can’t Be There in Person
	Book V: Excel 2007
		Contents at a Glance
		Chapter 1: Up and Running with Excel
			Creating a New Excel Workbook
			Getting Acquainted with Excel
			Entering Data in a Worksheet
			Quickly Entering Lists and Serial Data with the AutoFill Command
			Formatting Numbers, Dates, and Time Values
			Conditional Formats for Calling Attention to Data
			Establishing Data-Validation Rules
		Chapter 2: Refining Your Worksheet
			Editing Worksheet Data
			Moving Around in a Worksheet
			Getting a Better Look at the Worksheet
			Comments for Documenting Your Worksheet
			Selecting Cells in a Worksheet
			Deleting, Copying, and Moving Data
			Handling the Worksheets in a Workbook
			Keeping Others from Tampering with Worksheets
		Chapter 3: Formulas and Functions for Crunching Numbers
			How Formulas Work
			The Basics of Entering a Formula
			Speed Techniques for Entering Formulas
			Copying Formulas from Cell to Cell
			Detecting and Correcting Errors in Formulas
			Working with Functions
		Chapter 4: Making a Worksheet Easier to Read and Understand
			Laying Out a Worksheet
			Decorating a Worksheet with Borders and Colors
			Getting Ready to Print a Worksheet
		Chapter 5: Analyzing Data
			Managing Information in Lists
			Forecasting with the Goal Seek Command
			Performing What-If Analyses with Data Tables
	Book VI: Access 2007
		Contents at a Glance
		Chapter 1: Introducing Access
			What Is a Database, Anyway?
			Tables, Queries, Forms, and Other Objects
			Creating a Database File
			Finding Your Way around the Navigation Pane
			Designing a Database
		Chapter 2: Building Your Database Tables
			Creating a Database Table
			Opening and Viewing Tables
			Entering and Altering Table Fields
			Field Properties for Making Sure That Data Entries Are Accurate
			Indexing for Faster Sorts, Searches, and Queries
			Establishing Relationships between Database Tables
		Chapter 3: Entering the Data
			The Two Ways to Enter Data
			Entering the Data in Datasheet View
			Entering the Data in a Form
			Finding a Missing Record
			Finding and Replacing Data
		Chapter 4: Sorting, Querying, and Filtering for Data
			Sorting Records in a Database Table
			Filtering to Find Information
			Querying: The Basics
			Six Kinds of Queries
		Chapter 5: Presenting Data in a Report
			Creating a Report
			Opening and Viewing Reports
			Tweaking a Report
	Book VII: Publisher 2007
		Contents at a Glance
		Chapter 1: Introducing Publisher
			“A Print Shop in a Can”
			Introducing Frames
			Creating a Publication
			Redesigning a Publication
			Getting Around in Publisher
			Understanding and Using the Layout Guides
		Chapter 2: Refining a Publication
			Entering Text on the Pages
			Making Text Fit in Text Frames
			Making Text Wrap Around a Frame or Graphic
			Replacing the Placeholder Graphics
			Inserting Frames on the Pages
			Making Frames Overlap
			Inserting, Removing, and Moving Pages
		Chapter 3: Putting On the Finishing Touches
			Decorating the Text
			Techniques for Decorating Pages
			The Master Page for Handling Page Backgrounds
			Taking Advantage of the Design Gallery
			Running the Design Checker
			Commercially Printing a Publication
	Book VIII: Office 2007 — One Step Beyond
		Contents at a Glance
		Chapter 1: Customizing an Office Program
			Customizing the Quick Access Toolbar
			Customizing the Status Bar
			Changing Color Schemes
			Customizing Keyboard Shortcuts in Word
			Smart Tags, Smart Alecks
		Chapter 2: Ways of Distributing Your Work
			Printing — the Old Standby
			Distributing a File in PDF Format
			Sending Your File in an E-Mail Message
			Saving an Office File as a Web Page
			Blogging from inside Word
		Chapter 3: Handling Graphics
			All about Picture File Formats
			Inserting a Graphic in a File
			Touching Up a Graphic
			Compressing Graphics to Save Disk Space
			Using Microsoft Office Picture Manager
		Chapter 4: Decorating Files with Clip Art
			What Is Clip Art?
			Inserting a Clip-Art Image
			Tinkering with a Clip-Art Image’s Appearance
			Handling Media Files with the Clip Organizer
		Chapter 5: Note Taking with OneNote
			Running OneNote
			Introducing OneNote
			Creating Storage Units for Notes
			Writing Notes
			Getting from Place to Place in OneNote
			Finding and Keeping Track of Notes
			Some Housekeeping Chores
			OneNote and Other Office Programs
		Chapter 6: Collaborating with SharePoint Services
			Getting Equipped and Getting Started
			Visiting a SharePoint Services Web Site
			Getting from Place to Place in the Web Site
			Handling and Managing Files
			Other Ways to Collaborate at a SharePoint Services Web Site
		Chapter 7: Automating Tasks with Macros
			What Is a Macro?
			Displaying the Developer Tab
			Managing the Macro Security Problem
			Recording a Macro
			Running a Macro
			Editing a Macro
			Running a Macro from a Button on the Quick Access Toolbar
		Chapter 8: Linking and Embedding in Compound Files
			What Is OLE, Anyway?
			Linking to Data in another File
			Embedding Data from Other Programs
Document Text Contents
Page 1

by Peter Weverka

Office 2007
A L L - I N - O N E D E S K R E F E R E N C E



01_782793 ffirs.qxp 11/22/06 5:07 PM Page iii

File Attachment

Page 2

01_782793 ffirs.qxp 11/22/06 5:07 PM Page ii

Page 409

Book IV
Chapter 1

etting S

tarted in


Advice for Building Persuasive Presentations 377

✦ Tell a story: Include an anecdote in the presentation. Everybody loves a
pertinent and well-delivered story. This piece of advice is akin to the pre-
vious one about personalizing your presentation. Typically, a story illus-
trates a problem for people and how people solve the problem. Even if
your presentation concerns technology or an abstract subject, make it
about people. “The people in Shaker Heights needed faster Internet
access,” not, “the data switches in Shaker Heights just weren’t perform-
ing fast enough.”

Figure 1-4:
presented in
a table (top),
and diagram

27_782793 bk04ch01.qxp 11/27/06 9:13 AM Page 377

Page 410

Creating New Slides for Your Presentation378

✦ Rehearse and then rehearse some more: The better you know your
material, the less nervous you are. To keep from getting nervous,
rehearse your presentation until you know it backward and forward.
Rehearse it out loud. Rehearse it while imagining you’re in the presence
of an audience.

✦ Use visuals, not only words, to make your point: You really owe it to
your audience to take advantage of the table, chart, diagram, and pic-
ture capabilities of PowerPoint. People understand more from words
and pictures than they do from words alone. It’s up to you — not the
slides — as the speaker to describe topics in detail with words.

Want to see just how PowerPoint can suck the life and drama out of a dra-
matic presentation? Try visiting the Gettysburg PowerPoint Presentation, a
rendering of Lincoln’s Gettysburg Address in PowerPoint. Yikes! You can find
it here:

Creating New Slides for Your Presentation
After you create a presentation, your next step on the path to glory is to start
inserting the slides. As shown in Figures 1-5 and 1-6, you can choose among
several different slide layouts, the preformatted slide designs that help you
enter text, graphics, and other things. Some layouts have text placeholder
frames for entering titles and text; some come with content placeholder frames
designed especially for inserting a table, chart, diagram, picture, clip-art
image, or video. When you insert a new slide, select the layout that best
approximates the slide you have in mind for your presentation. These pages
explain how to insert slides and harvest them from Word document headings.

Inserting a new slide
Follow these steps to insert a new slide in your presentation:

1. Select the slide that you want the new slide to go after.

In Normal view, select the slide on the Slides pane. In Slide Sorter view,
select the slide in the main window.

2. Click the Home tab.

3. Click the bottom half of the New Slide button.

You see a drop-down list of slide layouts. (If you click the top half of the
Add Slide button, you insert a slide with the same layout as the one you
selected in Step 1.) Figures 1-5 and 1-6 show you what the slide layouts
look like (left), what a slide looks like right after you insert it (middle),
and finished slides (right).

27_782793 bk04ch01.qxp 11/27/06 9:13 AM Page 378

Page 817

Available wherever books are sold. For more information or to order direct: U.S. customers visit or call 1-877-762-2974.
U.K. customers visit or call 0800 243407. Canadian customers visit or call 1-800-567-4797.

Get smart @®
• Find a full list of Dummies titles

• Look into loads of FREE on-site articles

• Sign up for FREE eTips e-mailed to you weekly

• See what other products carry the Dummies name

• Shop directly from the Dummies bookstore

• Enter to win new prizes every month!

Also available:
Bipolar Disorder For Dummies
Chemotherapy and Radiation
For Dummies
Controlling Cholesterol For Dummies
Diabetes For Dummies
0-7645-6820-5* †
Divorce For Dummies
0-7645-8417-0 †

Fibromyalgia For Dummies
Low-Calorie Dieting For Dummies
Meditation For Dummies
Osteoporosis For Dummies
Overcoming Anxiety For Dummies
Reiki For Dummies
Stress Management For Dummies


0-7645-8450-2 0-7645-4149-8

Also available:
The ACT For Dummies
Algebra For Dummies
Algebra Workbook For Dummies
Astronomy For Dummies
Calculus For Dummies
Chemistry For Dummies
Forensics For Dummies

Freemasons For Dummies
French For Dummies
Geometry For Dummies
Organic Chemistry I For Dummies
The SAT I For Dummies
Spanish For Dummies
Statistics For Dummies


0-7645-8381-6 0-7645-9554-7

* Separate Canadian edition also available
† Separate U.K. edition also available

58_782793 bob.qxp 11/27/06 12:16 PM Page 785

Page 818

Check out the Dummies Specialty Shop at for more information!

Do More with Dum

Instructional DVDs • Music Compilations
Games & Novelties • Culinary Kits
Crafts & Sewing Patterns
Home Improvement/DIY Kits • and more!

58_782793 bob.qxp 11/27/06 12:16 PM Page 786

Similer Documents