Microsoft Office 2010

Part I: Getting to Know Microsoft Office 2010 - Page 25
Part I: Getting to Know Microsoft Office 2010 - Page 26
Chapter 1: Introducing Microsoft Office 2010 - Page 27
Starting an Office 2010 Program - Page 28
Starting an Office 2010 Program - Page 29
Starting an Office 2010 Program - Page 30
Starting an Office 2010 Program - Page 31
Starting an Office 2010 Program - Page 32
Starting an Office 2010 Program - Page 33
Starting an Office 2010 Program - Page 34
Starting an Office 2010 Program - Page 35
Starting an Office 2010 Program - Page 36
Using the Quick Access Toolbar - Page 37
Using the Quick Access Toolbar - Page 38
Using the Quick Access Toolbar - Page 39
Using the Ribbon - Page 40
Using the Ribbon - Page 41
Using the Ribbon - Page 42
Using the Ribbon - Page 43
Using the Ribbon - Page 44
Using the Ribbon - Page 45
Using the Ribbon - Page 46
Customizing an Office 2010 Program - Page 47
Customizing an Office 2010 Program - Page 48
Customizing an Office 2010 Program - Page 49
Exiting Office 2010 - Page 50
Chapter 2: Selecting and Editing Data - Page 51
Chapter 2: Selecting and Editing Data - Page 52
Selecting Data - Page 53
Selecting Data - Page 54
Selecting Data - Page 55
Editing Text with the Pop-up Toolbar - Page 56
Deleting Data - Page 57
Deleting Data - Page 58
Copying and Pasting Data - Page 59
Copying and Pasting Data - Page 60
Dragging with the Mouse to Cut, Copy, and Paste - Page 61
Dragging with the Mouse to Cut, Copy, and Paste - Page 62
Sharing Data with Other Office 2010 Programs - Page 63
Sharing Data with Other Office 2010 Programs - Page 64
Sharing Data with Other Office 2010 Programs - Page 65
Sharing Data with Other Office 2010 Programs - Page 66
Chapter 3: Modifying Pictures - Page 67
Manipulating Pictures - Page 68
Manipulating Pictures - Page 69
Enhancing Pictures - Page 70
Enhancing Pictures - Page 71
Enhancing Pictures - Page 72
Enhancing Pictures - Page 73
Enhancing Pictures - Page 74
Chapter 4: Getting Help from Office 2010 - Page 75
Browsing the Help Window - Page 76
Searching in the Help Window - Page 77
Making the Help Window Easier to Read - Page 78
Making the Help Window Easier to Read - Page 79
Making the Help Window Easier to Read - Page 80
Making the Help Window Easier to Read - Page 81
Making the Help Window Easier to Read - Page 82
Part II: Working with Word - Page 83
Part II: Working with Word - Page 84
Chapter 5: Typing Text in Word - Page 85
Chapter 5: Typing Text in Word - Page 86
Moving the Cursor with the Keyboard - Page 87
Moving the Cursor with the Keyboard - Page 88
Moving the Cursor with the Keyboard - Page 89
Moving the Cursor with the Keyboard - Page 90
Moving the Cursor with the Keyboard - Page 91
Moving the Cursor with the Keyboard - Page 92
Moving the Cursor with the Keyboard - Page 93
Navigating through a Document - Page 94
Navigating through a Document - Page 95
Finding and Replacing Text - Page 96
Finding and Replacing Text - Page 97
Finding and Replacing Text - Page 98
Finding and Replacing Text - Page 99
Finding and Replacing Text - Page 100
Finding and Replacing Text - Page 101
Finding and Replacing Text - Page 102
Checking Your Spelling - Page 103
Checking Your Spelling - Page 104
Checking Your Grammar - Page 105
Checking Your Grammar - Page 106
Chapter 6: Formatting Text - Page 107
Changing the Font - Page 108
Changing the Font Size - Page 109
Changing the Text Style - Page 110
Changing the Text Style - Page 111
Changing the Text Style - Page 112
Justifying Text Alignment - Page 113
Adjusting Line Spacing - Page 114
Making Lists - Page 115
Making Lists - Page 116
Making Lists - Page 117
Making Lists - Page 118
Using the Ruler - Page 119
Using the Ruler - Page 120
Using Format Painter - Page 121
Using Styles - Page 122
Using Templates - Page 123
Removing Formatting from Text - Page 124
Removing Formatting from Text - Page 125
Removing Formatting from Text - Page 126
Chapter 7: Designing Your Pages - Page 127
Adding (And Deleting) a Cover Page - Page 128
Inserting Page Breaks - Page 129
Inserting Page Breaks - Page 130
Inserting Page Breaks - Page 131
Organizing Text in Tables - Page 132
Organizing Text in Tables - Page 133
Organizing Text in Tables - Page 134
Organizing Text in Tables - Page 135
Organizing Text in Tables - Page 136
Organizing Text in Tables - Page 137
Organizing Text in Tables - Page 138
Formatting and Coloring a Table - Page 139
Formatting and Coloring a Table - Page 140
Formatting and Coloring a Table - Page 141
Formatting and Coloring a Table - Page 142
Sorting a Table - Page 143
Deleting Tables - Page 144
Deleting Tables - Page 145
Deleting Tables - Page 146
Making Text Look Artistic - Page 147
Making Text Look Artistic - Page 148
Making Text Look Artistic - Page 149
Dividing Text into Columns - Page 150
Dividing Text into Columns - Page 151
Previewing a Document before Printing - Page 152
Previewing a Document before Printing - Page 153
Previewing a Document before Printing - Page 154
Part III: Playing the Numbers with Excel - Page 155
Part III: Playing the Numbers with Excel - Page 156
Chapter 8: The Basics of Spreadsheets: Numbers, Labels, and Formulas - Page 157
Chapter 8: The Basics of Spreadsheets: Numbers, Labels, and Formulas - Page 158
Storing Stuff in a Spreadsheet - Page 159
Storing Stuff in a Spreadsheet - Page 160
Formatting Numbers and Labels - Page 161
Formatting Numbers and Labels - Page 162
Formatting Numbers and Labels - Page 163
Formatting Numbers and Labels - Page 164
Formatting Numbers and Labels - Page 165
Formatting Numbers and Labels - Page 166
Formatting Numbers and Labels - Page 167
Formatting Numbers and Labels - Page 168
Navigating a Spreadsheet - Page 169
Navigating a Spreadsheet - Page 170
Navigating a Spreadsheet - Page 171
Navigating a Spreadsheet - Page 172
Searching a Spreadsheet - Page 173
Searching a Spreadsheet - Page 174
Editing a Spreadsheet - Page 175
Editing a Spreadsheet - Page 176
Editing a Spreadsheet - Page 177
Editing a Spreadsheet - Page 178
Editing a Spreadsheet - Page 179
Clearing Data - Page 180
Printing Workbooks - Page 181
Printing Workbooks - Page 182
Printing Workbooks - Page 183
Printing Workbooks - Page 184
Printing Workbooks - Page 185
Printing Workbooks - Page 186
Printing Workbooks - Page 187
Printing Workbooks - Page 188
Chapter 9: Playing with Formulas - Page 189
Chapter 9: Playing with Formulas - Page 190
Chapter 9: Playing with Formulas - Page 191
Chapter 9: Playing with Formulas - Page 192
Chapter 9: Playing with Formulas - Page 193
Using Functions - Page 194
Using Functions - Page 195
Using Functions - Page 196
Using Functions - Page 197
Editing a Formula - Page 198
Conditional Formatting - Page 199
Conditional Formatting - Page 200
Conditional Formatting - Page 201
Data Validation - Page 202
Data Validation - Page 203
Data Validation - Page 204
Goal Seeking - Page 205
Goal Seeking - Page 206
Creating Multiple Scenarios - Page 207
Creating Multiple Scenarios - Page 208
Creating Multiple Scenarios - Page 209
Creating Multiple Scenarios - Page 210
Creating Multiple Scenarios - Page 211
Auditing Your Formulas - Page 212
Auditing Your Formulas - Page 213
Checking for Errors - Page 214
Checking for Errors - Page 215
Checking for Errors - Page 216
Chapter 10: Charting and Analyzing Data - Page 217
Chapter 10: Charting and Analyzing Data - Page 218
Chapter 10: Charting and Analyzing Data - Page 219
Creating a Chart - Page 220
Editing a Chart - Page 221
Editing a Chart - Page 222
Using the Chart Tools - Page 223
Using the Chart Tools - Page 224
Using the Chart Tools - Page 225
Using the Chart Tools - Page 226
Using the Chart Tools - Page 227
Using Sparklines - Page 228
Using Sparklines - Page 229
Using Sparklines - Page 230
Organizing Lists in Pivot Tables - Page 231
Organizing Lists in Pivot Tables - Page 232
Organizing Lists in Pivot Tables - Page 233
Organizing Lists in Pivot Tables - Page 234
Organizing Lists in Pivot Tables - Page 235
Organizing Lists in Pivot Tables - Page 236
Organizing Lists in Pivot Tables - Page 237
Organizing Lists in Pivot Tables - Page 238
Organizing Lists in Pivot Tables - Page 239
Organizing Lists in Pivot Tables - Page 240
Organizing Lists in Pivot Tables - Page 241
Organizing Lists in Pivot Tables - Page 242
Organizing Lists in Pivot Tables - Page 243
Organizing Lists in Pivot Tables - Page 244
Part IV: Making Presentations with PowerPoint - Page 245
Part IV: Making Presentations with PowerPoint - Page 246
Chapter 11: Creating a PowerPoint Presentation - Page 247
Creating a PowerPoint Presentation - Page 248
Creating a PowerPoint Presentation - Page 249
Creating a PowerPoint Presentation - Page 250
Creating a PowerPoint Presentation - Page 251
Creating a PowerPoint Presentation - Page 252
Creating a PowerPoint Presentation - Page 253
Creating a PowerPoint Presentation - Page 254
Working with Text - Page 255
Working with Text - Page 256
Working with Text - Page 257
Working with Text - Page 258
Working with Text - Page 259
Working with Text - Page 260
Working with Text - Page 261
Working with Text - Page 262
Working with Text - Page 263
Working with Text - Page 264
Chapter 12: Adding Color and Pictures to a Presentation - Page 265
Chapter 12: Adding Color and Pictures to a Presentation - Page 266
Chapter 12: Adding Color and Pictures to a Presentation - Page 267
Changing the Background - Page 268
Changing the Background - Page 269
Changing the Background - Page 270
Changing the Background - Page 271
Adding Graphics to a Slide - Page 272
Adding Graphics to a Slide - Page 273
Adding Graphics to a Slide - Page 274
Adding Graphics to a Slide - Page 275
Adding Graphics to a Slide - Page 276
Adding Graphics to a Slide - Page 277
Adding Movies to a Slide - Page 278
Adding Movies to a Slide - Page 279
Adding Movies to a Slide - Page 280
Adding Movies to a Slide - Page 281
Adding Movies to a Slide - Page 282
Adding Movies to a Slide - Page 283
Adding Sound to a Slide - Page 284
Adding Sound to a Slide - Page 285
Adding Sound to a Slide - Page 286
Chapter 13: Showing Off a Presentation - Page 287
Chapter 13: Showing Off a Presentation - Page 288
Organizing Slides in Sections - Page 289
Organizing Slides in Sections - Page 290
Organizing Slides in Sections - Page 291
Organizing Slides in Sections - Page 292
Adding Visual Transitions - Page 293
Adding Visual Transitions - Page 294
Adding Visual Transitions - Page 295
Adding Visual Transitions - Page 296
Adding Hyperlinks - Page 297
Adding Hyperlinks - Page 298
Viewing a Presentation - Page 299
Viewing a Presentation - Page 300
Viewing a Presentation - Page 301
Viewing a Presentation - Page 302
Creating Handouts - Page 303
Creating Handouts - Page 304
Creating Handouts - Page 305
Creating Handouts - Page 306
Part V: Getting Organized with Outlook - Page 307
Part V: Getting Organized with Outlook - Page 308
Chapter 14: Managing E-Mail with Outlook - Page 309
Creating E-Mail - Page 310
Creating E-Mail - Page 311
Creating E-Mail - Page 312
Creating E-Mail - Page 313
Creating E-Mail - Page 314
Attaching Files to Messages - Page 315
Attaching Files to Messages - Page 316
Reading and Organizing E-Mail - Page 317
Reading and Organizing E-Mail - Page 318
Reading and Organizing E-Mail - Page 319
Deleting E-Mail Messages - Page 320
Deleting E-Mail Messages - Page 321
Deleting E-Mail Messages - Page 322
Chapter 15: Calendars, Contacts, and Tasks - Page 323
Chapter 15: Calendars, Contacts, and Tasks - Page 324
Chapter 15: Calendars, Contacts, and Tasks - Page 325
Chapter 15: Calendars, Contacts, and Tasks - Page 326
Storing Names and Addresses - Page 327
Storing Names and Addresses - Page 328
Storing Names and Addresses - Page 329
Managing Tasks - Page 330
Managing Tasks - Page 331
Managing Tasks - Page 332
Managing Tasks - Page 333
Managing Tasks - Page 334
Part VI: Storing Stuff in Access - Page 335
Part VI: Storing Stuff in Access - Page 336
Chapter 16: Using a Database - Page 337
Understanding the Basics of a Database - Page 338
Designing a Database - Page 339
Designing a Database - Page 340
Editing and Modifying a Database - Page 341
Editing and Modifying a Database - Page 342
Editing and Modifying a Database - Page 343
Editing and Modifying a Database - Page 344
Typing Data into a Database - Page 345
Typing Data into a Database - Page 346
Typing Data into a Database - Page 347
Typing Data into a Database - Page 348
Typing Data into a Database - Page 349
Closing and Saving a Database - Page 350
Closing and Saving a Database - Page 351
Closing and Saving a Database - Page 352
Chapter 17: Searching, Sorting, and Querying a Database - Page 353
Searching a Database - Page 354
Searching a Database - Page 355
Searching a Database - Page 356
Searching a Database - Page 357
Searching a Database - Page 358
Searching a Database - Page 359
Searching a Database - Page 360
Sorting a Database - Page 361
Querying a Database - Page 362
Querying a Database - Page 363
Querying a Database - Page 364
Querying a Database - Page 365
Querying a Database - Page 366
Querying a Database - Page 367
Querying a Database - Page 368
Querying a Database - Page 369
Querying a Database - Page 370
Querying a Database - Page 371
Querying a Database - Page 372
Chapter 18: Creating a Database Report - Page 373
Chapter 18: Creating a Database Report - Page 374
Chapter 18: Creating a Database Report - Page 375
Chapter 18: Creating a Database Report - Page 376
Manipulating the Data in a Report - Page 377
Manipulating the Data in a Report - Page 378
Manipulating the Data in a Report - Page 379
Manipulating the Data in a Report - Page 380
Editing a Report - Page 381
Editing a Report - Page 382
Making Reports Look Pretty - Page 383
Making Reports Look Pretty - Page 384
Making Reports Look Pretty - Page 385
Deleting a Report - Page 386
Part VII: The Part of Tens - Page 387
Part VII: The Part of Tens - Page 388
Chapter 19: Ten Tips for Using Office 2010 - Page 389
Chapter 19: Ten Tips for Using Office 2010 - Page 390
Password-Protecting Your Files - Page 391
Guarding Against Macro Viruses - Page 392
Customize the Ribbon - Page 393
Customize the Ribbon - Page 394
Zooming In (And Out) to Avoid Eyestrain - Page 395
Displaying Slides Out of Order in PowerPoint - Page 396
Reduce Spam in Outlook - Page 397
Reduce Spam in Outlook - Page 398
Reduce Spam in Outlook - Page 399
Using Office Web - Page 400
Chapter 20: Ten Keystroke Shortcuts - Page 401
Cut (Ctrl+ X), Copy (Ctrl+ C), and Paste (Ctrl+ V) - Page 402
Saving a File (Ctrl+ S) - Page 403
Opening a File (Ctrl+ O) - Page 404
Closing a Window (Ctrl+ W) - Page 405
Closing a Window (Ctrl+ W) - Page 406
Chapter 21: Almost Ten Ways to Make Office 2010 Easier to Use - Page 407
Collaborating with the Review Tab - Page 408
Using Word’s References Tab - Page 409
Password-Protecting a File - Page 410
Checking File Compatibility - Page 411