Office 2007 for dummies

Microsoft Office 2007 for Dummies\r......Page 1
About the Author......Page 4
Dedication......Page 6
Author’s Acknowledgments......Page 8
Contents at a Glance......Page 10
Table of Contents......Page 12
How This Book Is Organized......Page 22
Part IV: Making Presentations with PowerPoint......Page 23
How to Use This Book......Page 24
Icons Used in This Book......Page 25
Getting Started......Page 26
Part I......Page 28
Getting to Know Microsoft Office 2007......Page 30
Loading an Office 2007 Program......Page 31
Getting to Know the New User Interface......Page 32
Creating a new file......Page 33
Creating a new file from a template......Page 34
Opening an existing file......Page 36
Saving files......Page 37
Using the Quick Access toolbar......Page 40
Using the Quick Access icons......Page 41
Adding icons......Page 42
Minimizing the Ribbon......Page 43
Deciphering Ribbon icons......Page 44
Using Live Preview......Page 45
Giving commands to Office 2007......Page 46
Customizing an Office 2007 Program......Page 47
Exiting Office 2007......Page 48
Adding Data by Pointing......Page 50
Selecting data with the mouse......Page 52
Selecting data with the keyboard......Page 54
Editing Data with the Pop-up Toolbar......Page 55
Deleting Data......Page 56
Cutting and Pasting (Moving) Data......Page 57
Dragging with the Mouse to Cut, Copy, and Paste......Page 58
Undo and Redo......Page 59
Sharing Data with Other Office 2007 Programs......Page 60
Viewing and pasting items off the Office Clipboard......Page 61
Deleting items from the Office Clipboard......Page 62
Browsing the Help Window......Page 64
Searching in the Help Window......Page 66
Resizing the Help window......Page 67
Enlarging the text in the Help window......Page 68
Viewing the Table of Contents......Page 69
Part II......Page 72
Moving the Cursor with the Mouse......Page 74
Moving the Cursor with the Keyboard......Page 75
Viewing a Document......Page 76
Switching between views......Page 77
Using Full Screen Reading view......Page 78
Using Outline view......Page 79
Defining a heading......Page 80
Moving headings......Page 81
Collapsing and expanding headings and subheadings......Page 82
Using the scroll bar......Page 83
Using the Go To command......Page 84
Using the Find command......Page 85
Checking Your Spelling......Page 87
Proofreading Your Document......Page 89
Formatting Text......Page 92
Changing the Font......Page 93
Changing the Font Size......Page 94
Changing the Text Style......Page 95
Changing the color of text......Page 96
Justifying Text Alignment......Page 97
Adjusting Line Spacing......Page 98
Making Lists......Page 99
Converting list items back into text......Page 100
Renumbering numbered lists......Page 101
Using the Ruler......Page 103
Adjusting left and right paragraph margins......Page 104
Showing Formatting Marks......Page 105
Using Format Painter......Page 107
Creating a new document from a template......Page 109
Removing Formatting from Text......Page 110
Inserting New Pages......Page 112
Adding (And Deleting) a Cover Page......Page 113
Creating a header (or footer)......Page 114
Creating a unique header or footer for your first page......Page 115
Deleting a header (or footer)......Page 116
Creating a table by highlighting rows and columns......Page 117
Creating a table with the Insert Table dialog box......Page 118
Creating a table with the mouse......Page 119
Creating a table from existing text......Page 120
Selecting all or part of a table......Page 123
Aligning text in a table cell......Page 124
Adding borders......Page 125
Picking a table style......Page 127
Resizing columns and rows......Page 128
Defining cell margins......Page 129
Defining cell spacing......Page 130
Splitting (and merging) cells......Page 131
Sorting a Table......Page 132
Deleting an entire table......Page 133
Deleting rows and columns......Page 134
Deleting cells......Page 135
Creating drop caps......Page 136
Creating WordArt......Page 137
Editing columns......Page 139
Defining page size and orientation......Page 141
Using Print Preview......Page 143
Printing......Page 144
Part III......Page 146
Understanding Spreadsheets......Page 148
Typing data into a single cell......Page 149
Typing data in multiple cells......Page 150
Typing in sequences with AutoFill......Page 151
Formatting numbers......Page 152
Displaying negative numbers......Page 153
Formatting cells......Page 155
Formatting fonts and text styles......Page 156
Formatting with color......Page 157
Adding borders......Page 158
Using the keyboard to move around a spreadsheet......Page 159
Naming cells......Page 161
Searching for text......Page 163
Searching for formulas......Page 164
Changing the size of rows and columns with the mouse......Page 165
Typing the size of rows and columns......Page 166
Renaming sheets......Page 167
Clearing Data......Page 169
Printing Workbooks......Page 170
Using Page Layout view......Page 171
Adding a header (or footer)......Page 172
Defining a print area......Page 173
Inserting (and removing) page breaks......Page 174
Printing row and column headings......Page 176
Defining paper orientation and size......Page 177
Printing in Excel......Page 179
Creating a Formula......Page 180
Organizing formulas with parentheses......Page 183
Copying formulas......Page 184
Using Functions......Page 185
Using the AutoSum command......Page 187
Using recently used functions......Page 188
Goal Seeking......Page 189
Creating a scenario......Page 191
Viewing a scenario......Page 193
Editing a scenario......Page 194
Viewing a scenario summary......Page 195
Auditing Your Formulas......Page 196
Finding which formula(s) a cell can change......Page 197
Data Validation......Page 198
Understanding the Parts of a Chart......Page 202
Creating a Chart......Page 205
Moving a chart on a worksheet......Page 206
Moving a chart to a new sheet......Page 207
Using the Chart Tools......Page 208
Changing the chart type......Page 209
Switching rows and columns......Page 210
Changing the parts of a chart......Page 211
Designing the layout of a chart......Page 212
Organizing Lists in Pivot Tables......Page 213
Creating a pivot table......Page 214
Rearranging labels in a pivot table......Page 217
Modifying a pivot table......Page 218
Filtering a pivot table......Page 220
Summing a pivot table......Page 222
Part IV......Page 224
Defining the Purpose of Your Presentation......Page 226
Creating a PowerPoint Presentation......Page 227
Creating a new slide......Page 229
Hiding and deleting a slide......Page 230
Designing a presentation with Outline view......Page 231
Collapsing and expanding subtitles......Page 232
Deleting a slide......Page 233
Typing text in a text box......Page 234
Formatting text......Page 235
Aligning text......Page 236
Adjusting line spacing......Page 237
Making numbered and bullet lists......Page 238
Making columns......Page 239
Moving and resizing a text box......Page 240
Rotating a text box......Page 241
Applying a Theme......Page 242
Choosing a solid color background......Page 245
Choosing a gradient background......Page 247
Choosing a picture background......Page 249
Adding Graphics to a Slide......Page 250
Placing clip art on a slide......Page 251
Resizing, moving, and deleting graphic images......Page 253
Rotating graphics......Page 254
Layering objects......Page 255
Adding a movie to a slide......Page 256
Adding Sound to a Slide......Page 258
Adding an audio file to a presentation......Page 259
Adding a CD audio track to a presentation......Page 260
Spell-Checking Your Presentation......Page 262
Adding Visual Transitions......Page 263
Adding slide transitions......Page 264
Text transitions......Page 266
Creating Web page hyperlinks......Page 267
Creating hyperlinks to different slides......Page 268
Running a program through a hyperlink......Page 270
Viewing a Presentation......Page 271
Creating a custom slide show......Page 272
Hiding a slide......Page 273
Organizing with Slide Sorter view......Page 274
Timing yourself......Page 275
Creating Handouts......Page 277
Packing Presentations to Go......Page 278
Part V......Page 280
Configuring E-Mail Settings......Page 282
Adding an e-mail account......Page 286
Editing an e-mail account......Page 287
Creating a new e-mail message......Page 288
Replying to an e-mail message......Page 290
Using a stored e-mail address to create a new e-mail message......Page 291
Forwarding an e-mail message......Page 292
Attaching a file to a message......Page 293
Attaching Outlook information to another message......Page 294
Formatting text......Page 295
Adding signatures to your messages......Page 296
Creating and using multiple signatures......Page 298
Editing and deleting a signature file......Page 299
Categorizing messages......Page 300
Color categorizing a message......Page 301
Retrieving a file attachment from a message......Page 303
Deleting E-Mail Messages......Page 305
Storing Contact Information......Page 308
Viewing and Printing Contact Information......Page 311
Categorizing Contact Information......Page 312
Creating categories......Page 313
Storing names in categories......Page 314
Sharing Contact Information......Page 315
Defining Tasks......Page 316
Creating a task......Page 317
Editing a task......Page 318
Organizing and viewing your tasks......Page 319
Deleting a task......Page 320
Making a new appointment......Page 322
Editing an appointment......Page 325
Defining a recurring appointment......Page 326
Editing a recurring appointment......Page 327
Printing Your Schedule......Page 328
Part VI......Page 330
Using a Database......Page 332
Understanding the Basics of a Database......Page 333
Designing a Database......Page 334
Creating a database from scratch......Page 335
Creating a database from a template......Page 337
Adding and deleting a field......Page 338
Defining the type and size of a field......Page 339
Using Datasheet view......Page 342
Creating a form......Page 343
Viewing and editing data in a form......Page 344
Deleting a field......Page 345
Adding a field......Page 346
Closing a database table......Page 349
Closing a database file......Page 350
Searching, Sorting, and Querying a Database......Page 352
Searching for a specific record......Page 353
Filtering a database......Page 354
Using an exact match for a filter......Page 355
Filtering by form......Page 356
Using a filter criteria......Page 357
Sorting a Database......Page 360
Creating a simple query......Page 361
Creating a crosstab query......Page 364
Creating a query that finds duplicate field data......Page 367
Creating an unmatched query......Page 369
Viewing and deleting queries......Page 371
Using the Report Wizard......Page 374
Viewing and Printing a Report......Page 378
Manipulating the Data in a Report......Page 380
Counting records or values......Page 381
Sorting a field......Page 382
Filtering a field......Page 383
Editing a Report......Page 384
Resizing fields......Page 385
Deleting fields......Page 386
Deleting a Report......Page 387
Part VII......Page 388
Saving Office 2007 Files......Page 390
Password-Protecting Your Files......Page 391
Guarding Against Macro Viruses and Worms......Page 392
Create Your Own Word Keystroke Shortcuts......Page 393
Zooming In (And Out) to Avoid Eyestrain......Page 394
Freezing Row and Column Headings in Excel......Page 395
Setting up Outlook’s junk e-mail filter......Page 396
Creating a Safe Senders list......Page 398
Using Pocket Office......Page 399
Protecting Yourself with Undo (Ctrl+Z) and Redo (Ctrl+Y)......Page 400
Using the Cut and Paste commands......Page 401
Using the Paste command with the Office Clipboard......Page 402
Checking Your Spelling (F7)......Page 403
Opening a File (Ctrl+O)......Page 404
Finding Text (Ctrl+F)......Page 405
Finding and Replacing Text (Ctrl+H)......Page 406
Closing a Window (Ctrl+W)......Page 407
A\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 408
C\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 409
D\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 411
E\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 412
F\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 415
G\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 416
I\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 417
M\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 418
O\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 419
P\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 421
Q\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 423
S\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 424
T\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 426
U\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 427
W\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 428
Y\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0......Page 430