Microsoft Office 2007 for Windows: Visual QuickStart Guide

Table of Contents

Introduction     xi
How This Book Is Organized     xii
Which Suites Are Covered?     xii
The Office Applications     xiii
Introducing Microsoft Office 2007     1
What's New in Office 2007?     3
The New User Interface     4
New File Formats     7
New Features and Changes     8
Office Basics     11
Creating a New Document     13
Opening Documents     14
Saving Documents     15
Closing Documents     16
Working with Windows     17
Setting the Magnification     19
Using the Office Clipboard     20
Printing     22
Getting Help     24
Quitting an Office Program     26
Microsoft Word     27
Getting Started with Word 2007     29
The Word Interface     30
Working in Different Views     33
Managing Windows     35
Setting Show/Hide Options     37
Entering Text     38
Basic Text Editing     39
Using the Proofing Tools     41
Finding and Replacing Text     45
Entering Symbolsand Special Characters     48
Formatting Documents     49
Specifying Page Settings     50
Modifying the Background     52
Inserting Breaks     55
Adding a Cover Page or Blank Page     57
Adding Headers or Footers     59
Paragraph Formatting     62
Setting Alignment     63
Setting Indents     64
Creating Lists     66
Between-Paragraph and Line Spacing     70
Character Formatting     72
Working with Styles     75
Merge Formatting     78
Creating Outlines     85
About Outline View     86
Starting an Outline     87
Reorganizing an Outline     88
Changing Display Settings     90
Tables, Charts, and Art     91
Inserting Tables     92
Entering Data into a Table     94
Modifying the Table Grid     95
Formatting Table Data     98
Calculations in Tables     99
Creating Charts     101
About Adding Graphics and Objects     102
Adding Pictures     103
Adding Clip Art     104
Adding Shapes     105
Using a Drawing Canvas     106
Adding SmartArt     107
Creating WordArt     108
Adding a Text Box     109
Setting Text Wrap     110
Resizing, Moving, and Rotating Objects     111
Sharing Word Documents     113
Choosing a File Format     114
Emailing Word Documents     115
Publishing Blog Entries     116
Change Tracking     118
Comparing Documents     120
Combining Documents     121
The Document Inspector     122
Protecting a Document     123
Microsoft Excel     125
Getting Started with Excel 2007     127
The Excel Interface     128
Workbooks and Worksheets     130
Cell and Range Selection     132
Entering Data     134
Editing Data     136
Reorganizing a Worksheet     137
Filling Cells     142
Importing Data     144
Finding/Replacing Data     149
Sorting Data     152
Naming Cells and Ranges     154
Password-Protecting Workbooks     156
Formatting Worksheets and Data     159
Setting Column Width and Row Height     160
About Data and Cell Formatting     162
Character and Paragraph Formatting     163
Fitting Text Within a Cell     164
Number Formatting     165
Conditional Formatting     166
Adding Cell Borders and Backgrounds     168
Removing, Replacing, and Reusing Formats     170
Formulas and Functions     173
About Cell References     174
Formula Essentials     176
Creating Formulas     180
Editing Formulas     182
Troubleshooting Tips     183
Working with Tables     185
Creating a Table     186
Formatting a Table     187
Creating Calculated Columns     188
Adding a Total Row     189
Sorting and Filtering     190
Changing a Table's Size     192
Creating Charts     195
Chart Elements     196
Creating a Chart     197
Changing the Background     198
Adding and Formatting Text     199
Rows vs. Columns     201
Changing the Layout and Style     202
Displaying the Data Set     203
Working with Gridlines     204
Working with the Legend     205
Adding Trendlines     206
Modifying the Axes     207
Changing the Chart Data     208
Microsoft PowerPoint     209
Getting Started with PowerPoint 2007     211
The PowerPoint Interface     212
Working in Different Views     214
Creating a Presentation     215
Creating a Presentation     217
Beginning a Presentation     218
Setting the Theme     220
Adding and Deleting Slides     221
Replacing Placeholders     222
Inserting Other Items     225
Creating a Photo Album     229
Previewing the Slide Show     231
Completing a Presentation     233
Animating Objects and Text     234
Organizing the Slides     236
Adding Transitions     237
Rehearsing a Presentation     239
Printing Notes and Handouts     240
Saving a Presentation in Other Formats     242
Microsoft Outlook     245
Getting Started with Outlook 2007     247
Types of Email Accounts      248
About Email Addresses     250
Adding Email Accounts     251
Changing Account Settings     254
Working with Profiles     256
Working with Send/Receive Groups     258
Subscribing to RSS Feeds     261
The Outlook 2007 Window     262
Working Online and Offline     264
Setting Preferences     265
Getting Help     266
Using the Address Book     267
The Contacts Window     268
Viewing Contact Records     269
Creating Contact Records     270
Searching for a Contact     274
Using Business Cards     276
Creating Distribution Lists     278
Composing and Sending Mail     281
The Message Window     282
Creating Messages     283
About Message Formats     288
Adding Attachments     292
Inserting Items     293
Correcting Spelling Errors     296
Using Signatures     298
Other Message Options     300
Receiving Mail     303
Checking for New Mail     304
Reading Messages     306
Changing the View      308
Searching for Messages     309
Working with Attachments     310
Printing Messages     311
Managing the Mail     313
Marking Messages as Read     314
Deleting Messages     316
Copying and Moving Messages     318
Creating Message Folders     319
Categorizing Messages     320
Flagging Messages     323
Handling Junk Mail and Phishing     325
Creating Message Rules     327
Tasks and Appointments     329
Calendar Basics     330
Recording an Appointment or Event     331
Creating Recurring Events     332
Responding to Reminders     333
Modifying Events and Appointments     334
Searching for an Event or Appointment     335
Emailing a Calendar     336
Task Basics     338
Creating a Task     339
Modifying Tasks     340
Microsoft OneNote     341
Getting Started with OneNote 2007     343
The OneNote Interface     344
Notebooks, Sections, and Pages     346
Opening and Closing Notebooks     349
OneNote Integration     350
Getting Help     352
Creating Notes     353
Typing a Note     354
Recording an Audio Note     355
Recording a Video Note     356
Creating Handwritten Notes     357
Copy-and-Paste and Drag-and-Drop     358
Creating Notes from Outlook Items     360
Notes without OneNote     361
Embellishing and Editing Notes     363
Using Page Templates     364
Inserting Images from Disk     365
Inserting and Working with Tables     366
Inserting Hyperlinks     369
Editing and Formatting Notes     372
Correcting Spelling Errors     374
Managing Notes     375
Rearranging Notebooks, Sections, Pages     376
Moving Pages and Sections     377
Creating Section Groups     379
Creating Page Groups     380
Deleting Notes and Objects     381
Adding Section Passwords     382
Searching for Notes     384
Printing Notes     386
Microsoft Publisher     387
Getting Started with Publisher 2007     389
The Publisher Interface      390
Creating a Publication     392
Creating a Business Information Set     394
Replacing Text Placeholders     395
Replacing and Inserting Artwork     397
Previewing the Publication     398
Making Minor Changes     399
Storing and Reusing Items     404
Changing the Font or Color Scheme     406
Changing Templates     407
Addressing the Postcards     408
Distributing and Printing Publications     409
Running a Prepress Check     410
Creating PDFs     411
Emailing a Publication     414
Publishing to the Web     417
Printing a Publication     419
Index     423