Microsoft Office 2010

Part I: Getting Started - Page 16
Part I: Getting Started - Page 17
Chapter 1 Discovering Office Common Features - Page 18
Opening Office Programs - Page 19
Opening Office Programs - Page 20
Opening Office Programs - Page 21
Opening Office Programs - Page 22
Exploring the Backstage View - Page 23
Working with Files - Page 24
Working with Files - Page 25
Working with Files - Page 26
Working with Files - Page 27
Working with Files - Page 28
Working with Files - Page 29
Previewing with Live Preview - Page 30
Customizing Applications - Page 31
Customizing Applications - Page 32
Customizing Applications - Page 33
Part II: Word - Page 34
Part II: Word - Page 35
Chapter 2 Getting Started with Word - Page 36
Exploring the Word Window - Page 37
Moving Around the Screen - Page 38
Moving Around the Screen - Page 39
Editing Text - Page 40
Editing Text - Page 41
Editing Text - Page 42
Editing Text - Page 43
Editing Text - Page 44
Moving and Copying Text - Page 45
Moving and Copying Text - Page 46
Moving and Copying Text - Page 47
Moving and Copying Text - Page 48
Using Undo and Repeat - Page 49
Displaying Non-Printing Symbols - Page 50
Displaying Non-Printing Symbols - Page 51
Chapter 3 Making a Word Document Look Good - Page 52
Selecting Text Attributes - Page 53
Selecting Text Attributes - Page 54
Selecting Text Attributes - Page 55
Selecting Text Attributes - Page 56
Selecting Text Attributes - Page 57
Selecting Text Attributes - Page 58
Selecting Text Attributes - Page 59
Formatting Paragraphs - Page 60
Formatting Paragraphs - Page 61
Formatting Paragraphs - Page 62
Formatting Paragraphs - Page 63
Formatting Paragraphs - Page 64
Formatting Paragraphs - Page 65
Formatting Paragraphs - Page 66
Formatting Paragraphs - Page 67
Copying Formatting - Page 68
Working with Lists - Page 69
Working with Themes - Page 70
Using Quick Styles - Page 71
Using Quick Styles - Page 72
Using Quick Styles - Page 73
Chapter 4 Managing Word Pages - Page 74
Creating Page Breaks - Page 75
Using Section Breaks - Page 76
Managing Page Layouts - Page 77
Managing Page Layouts - Page 78
Managing Page Layouts - Page 79
Viewing a Document - Page 80
Viewing a Document - Page 81
Viewing a Document - Page 82
Viewing a Document - Page 83
Viewing a Document - Page 84
Viewing a Document - Page 85
Adding Headers and Footers - Page 86
Adding Headers and Footers - Page 87
Adding Headers and Footers - Page 88
Adding Headers and Footers - Page 89
Chapter 5 Working with Columns and Tables - Page 90
Using Columns - Page 91
Using Columns - Page 92
Working with Tables - Page 93
Working with Tables - Page 94
Working with Tables - Page 95
Working with Tables - Page 96
Working with Tables - Page 97
Working with Tables - Page 98
Working with Tables - Page 99
Working with Tables - Page 100
Working with Tables - Page 101
Working with Tables - Page 102
Working with Tables - Page 103
Working with Tables - Page 104
Adding an Excel Table to a Word Document - Page 105
Adding an Excel Table to a Word Document - Page 106
Adding an Excel Table to a Word Document - Page 107
Chapter 6 Using Word for Mail Merge - Page 108
Generating a Single Envelope - Page 109
Generating a Single Envelope - Page 110
Generating a Single Envelope - Page 111
Creating Labels - Page 112
Creating Labels - Page 113
Using Mail Merge - Page 114
Using Mail Merge - Page 115
Using Mail Merge - Page 116
Using Mail Merge - Page 117
Using Mail Merge - Page 118
Using Mail Merge - Page 119
Using Mail Merge - Page 120
Using Mail Merge - Page 121
Chapter 7 Discovering Word Tools - Page 122
Employing Tools for Quality - Page 123
Employing Tools for Quality - Page 124
Employing Tools for Quality - Page 125
Employing Tools for Quality - Page 126
Employing Tools for Quality - Page 127
Employing Tools for Quality - Page 128
Employing Tools for Quality - Page 129
Employing Tools for Quality - Page 130
Employing Tools for Quality - Page 131
Applying Tools for Speed - Page 132
Applying Tools for Speed - Page 133
Applying Tools for Speed - Page 134
Applying Tools for Speed - Page 135
Applying Tools for Speed - Page 136
Applying Tools for Speed - Page 137
Applying Tools for Speed - Page 138
Applying Tools for Speed - Page 139
Creating Footnotes and Endnotes - Page 140
Creating Footnotes and Endnotes - Page 141
Creating Footnotes and Endnotes - Page 142
Working with Outlines - Page 143
Working with Outlines - Page 144
Working with Outlines - Page 145
Keeping Documents Secure - Page 146
Keeping Documents Secure - Page 147
Keeping Documents Secure - Page 148
Keeping Documents Secure - Page 149
Keeping Documents Secure - Page 150
Printing and Publishing - Page 151
Printing and Publishing - Page 152
Printing and Publishing - Page 153
Part III: Excel - Page 154
Part III: Excel - Page 155
Chapter 8 Creating a Basic Worksheet - Page 156
Exploring the Excel Window - Page 157
Exploring the Excel Window - Page 158
Exploring the Excel Window - Page 159
Entering Excel Data - Page 160
Entering Excel Data - Page 161
Entering Excel Data - Page 162
Entering Excel Data - Page 163
Learning Selection Techniques - Page 164
Learning Selection Techniques - Page 165
Editing a Worksheet - Page 166
Editing a Worksheet - Page 167
Editing a Worksheet - Page 168
Editing a Worksheet - Page 169
Editing a Worksheet - Page 170
Working with Range Names - Page 171
Working with Range Names - Page 172
Working with Range Names - Page 173
Using Data Validation - Page 174
Using Data Validation - Page 175
Using Data Validation - Page 176
Using Data Validation - Page 177
Chapter 9 Working with Formulas and Functions - Page 178
Working with Formulas - Page 179
Working with Formulas - Page 180
Working with Formulas - Page 181
Working with Formulas - Page 182
Using Excel Functions - Page 183
Using Excel Functions - Page 184
Using Excel Functions - Page 185
Using Excel Functions - Page 186
Using Excel Functions - Page 187
Using Excel Functions - Page 188
Using Excel Functions - Page 189
Using Excel Functions - Page 190
Using Excel Functions - Page 191
Using Excel Functions - Page 192
Using Excel Functions - Page 193
Troubleshooting Errors - Page 194
Troubleshooting Errors - Page 195
Troubleshooting Errors - Page 196
Troubleshooting Errors - Page 197
Chapter 10 Making Your Worksheet Look Good - Page 198
Changing Cell Formats - Page 199
Changing Cell Formats - Page 200
Changing Cell Formats - Page 201
Changing Cell Formats - Page 202
Changing Cell Formats - Page 203
Working with Alignment and Spacing - Page 204
Working with Alignment and Spacing - Page 205
Working with Alignment and Spacing - Page 206
Working with Alignment and Spacing - Page 207
Working with Alignment and Spacing - Page 208
Working with Alignment and Spacing - Page 209
Working with Alignment and Spacing - Page 210
Adding Borders and Shading - Page 211
Adding Borders and Shading - Page 212
Discovering Formatting Shortcuts - Page 213
Discovering Formatting Shortcuts - Page 214
Discovering Formatting Shortcuts - Page 215
Conditional Formatting - Page 216
Conditional Formatting - Page 217
Conditional Formatting - Page 218
Conditional Formatting - Page 219
Chapter 11 Managing Large Amounts of Data - Page 220
Working with Multiple Worksheets - Page 221
Working with Multiple Worksheets - Page 222
Working with Multiple Worksheets - Page 223
Working with Multiple Worksheets - Page 224
Working with Multiple Worksheets - Page 225
Working with Multiple Worksheets - Page 226
Working with Multiple Worksheets - Page 227
Working with Multiple Worksheets - Page 228
Managing Worksheet Views - Page 229
Managing Worksheet Views - Page 230
Managing Worksheet Views - Page 231
Managing Worksheet Views - Page 232
Sorting Data - Page 233
Sorting Data - Page 234
Sorting Data - Page 235
Sorting Data - Page 236
Sorting Data - Page 237
Filtering Data - Page 238
Filtering Data - Page 239
Filtering Data - Page 240
Filtering Data - Page 241
Filtering Data - Page 242
Filtering Data - Page 243
Filtering Data - Page 244
Filtering Data - Page 245
Filtering Data - Page 246
Filtering Data - Page 247
Chapter 12 Setting Security and Printing Options - Page 248
Keeping Workbooks Secure - Page 249
Keeping Workbooks Secure - Page 250
Keeping Workbooks Secure - Page 251
Keeping Workbooks Secure - Page 252
Keeping Workbooks Secure - Page 253
Checking for Errors - Page 254
Checking for Errors - Page 255
Using Find and Replace - Page 256
Using Find and Replace - Page 257
Adjusting Page Layout - Page 258
Adjusting Page Layout - Page 259
Adjusting Page Layout - Page 260
Adjusting Page Layout - Page 261
Adjusting Page Layout - Page 262
Working with Headers and Footers - Page 263
Working with Headers and Footers - Page 264
Working with Headers and Footers - Page 265
Printing Your Worksheet - Page 266
Printing Your Worksheet - Page 267
Printing Your Worksheet - Page 268
Printing Your Worksheet - Page 269
Chapter 13 Generating Excel Charts - Page 270
Creating a Basic Chart - Page 271
Creating a Basic Chart - Page 272
Inserting a Chart - Page 273
Inserting a Chart - Page 274
Changing the Chart Options - Page 275
Changing the Chart Options - Page 276
Changing the Chart Options - Page 277
Changing the Chart Options - Page 278
Changing the Chart Options - Page 279
Changing the Chart Options - Page 280
Changing the Chart Options - Page 281
Changing the Chart Options - Page 282
Changing the Chart Options - Page 283
Changing the Chart Options - Page 284
Changing the Chart Options - Page 285
Changing the Chart Options - Page 286
Working with Sparklines - Page 287
Working with Sparklines - Page 288
Working with Sparklines - Page 289
Working with Sparklines - Page 290
Working with Sparklines - Page 291
Part IV: PowerPoint - Page 292
Part IV: PowerPoint - Page 293
Chapter 14 Creating a PowerPoint Presentation - Page 294
Starting with the PowerPoint Basics - Page 295
Starting with the PowerPoint Basics - Page 296
Starting with the PowerPoint Basics - Page 297
Adding New Slides - Page 298
Adding New Slides - Page 299
Adding New Slides - Page 300
Adding New Slides - Page 301
Adding Slide Objects - Page 302
Adding Slide Objects - Page 303
Adding Slide Objects - Page 304
Adding Slide Objects - Page 305
Adding Slide Objects - Page 306
Adding Slide Objects - Page 307
Adding Slide Objects - Page 308
Adding Slide Objects - Page 309
Adding Slide Objects - Page 310
Adding Slide Objects - Page 311
Adding Slide Objects - Page 312
Working with Outlines - Page 313
Working with Outlines - Page 314
Working with Outlines - Page 315
Chapter 15 Editing Your Presentation - Page 316
Changing Views - Page 317
Changing Views - Page 318
Changing Views - Page 319
Modifying Slide Layouts - Page 320
Adding Multimedia and WordArt to Your Presentation - Page 321
Adding Multimedia and WordArt to Your Presentation - Page 322
Adding Multimedia and WordArt to Your Presentation - Page 323
Adding Multimedia and WordArt to Your Presentation - Page 324
Adding Multimedia and WordArt to Your Presentation - Page 325
Adding Multimedia and WordArt to Your Presentation - Page 326
Managing Objects - Page 327
Managing Objects - Page 328
Managing Objects - Page 329
Managing Objects - Page 330
Managing Objects - Page 331
Managing Objects - Page 332
Managing Objects - Page 333
Managing Objects - Page 334
Managing Objects - Page 335
Chapter 16 Formatting Your Presentation - Page 336
Changing Views - Page 337
Changing Theme Options - Page 338
Changing Theme Options - Page 339
Changing Theme Options - Page 340
Working with Slide Masters - Page 341
Working with Slide Masters - Page 342
Working with Slide Masters - Page 343
Working with Slide Masters - Page 344
Working with Slide Masters - Page 345
Creating Speaker Notes - Page 346
Finishing Your Presentation - Page 347
Finishing Your Presentation - Page 348
Finishing Your Presentation - Page 349
Finishing Your Presentation - Page 350
Finishing Your Presentation - Page 351
Chapter 17 Presenting Your Presentation - Page 352
Adding Transitions and Animations - Page 353
Adding Transitions and Animations - Page 354
Adding Transitions and Animations - Page 355
Adding Transitions and Animations - Page 356
Adding Transitions and Animations - Page 357
Adding Transitions and Animations - Page 358
Running Your Presentation - Page 359
Running Your Presentation - Page 360
Running Your Presentation - Page 361
Running Your Presentation - Page 362
Running Your Presentation - Page 363
Part V: Access - Page 364
Part V: Access - Page 365
Chapter 18 Creating an Access Database - Page 366
Understanding Database Terms - Page 367
Exploring Access - Page 368
Exploring Access - Page 369
Exploring Access - Page 370
Creating a New Database - Page 371
Creating a New Database - Page 372
Creating a New Database - Page 373
Creating a New Database - Page 374
Creating a New Database - Page 375
Working with Records - Page 376
Working with Records - Page 377
Working with Records - Page 378
Working with Records - Page 379
Working with Records - Page 380
Working with Records - Page 381
Working with Records - Page 382
Working with Records - Page 383
Working with Records - Page 384
Working with Records - Page 385
Chapter 19 Modifying an Access Database - Page 386
Designing Table Appearance - Page 387
Designing Table Appearance - Page 388
Designing Table Appearance - Page 389
Designing Table Appearance - Page 390
Modifying Table Structure - Page 391
Modifying Table Structure - Page 392
Modifying Table Structure - Page 393
Modifying Table Structure - Page 394
Modifying Table Structure - Page 395
Modifying Table Structure - Page 396
Modifying Table Structure - Page 397
Modifying a Form - Page 398
Modifying a Form - Page 399
Modifying a Form - Page 400
Modifying a Form - Page 401
Modifying a Form - Page 402
Modifying a Form - Page 403
Part VI: Outlook - Page 404
Part VI: Outlook - Page 405
Chapter 20 Communicating with Outllook E-Mail - Page 406
Looking at the Outlook Window - Page 407
Working with E-Mail - Page 408
Working with E-Mail - Page 409
Working with E-Mail - Page 410
Working with E-Mail - Page 411
Working with E-Mail - Page 412
Working with E-Mail - Page 413
Working with E-Mail - Page 414
Working with E-Mail - Page 415
Working with E-Mail Attachments - Page 416
Working with E-Mail Attachments - Page 417
Working with E-Mail Attachments - Page 418
Working with E-Mail Attachments - Page 419
Working with E-Mail Attachments - Page 420
Working with E-Mail Attachments - Page 421
Chapter 21 Working with Outlook Contacts - Page 422
Exploring Your Contacts Folder - Page 423
Exploring Your Contacts Folder - Page 424
Exploring Your Contacts Folder - Page 425
Exploring Your Contacts Folder - Page 426
Exploring Your Contacts Folder - Page 427
Exploring Your Contacts Folder - Page 428
Exploring Your Contacts Folder - Page 429
Exploring Your Contacts Folder - Page 430
Exploring Your Contacts Folder - Page 431
Exploring Your Contacts Folder - Page 432
Printing Contact Information - Page 433
Printing Contact Information - Page 434
Printing Contact Information - Page 435
Chapter 22 Using the Outlook Calendar - Page 436
Exploring the Calendar - Page 437
Exploring the Calendar - Page 438
Exploring the Calendar - Page 439
Working in the Calendar Folder - Page 440
Working in the Calendar Folder - Page 441
Working in the Calendar Folder - Page 442
Working in the Calendar Folder - Page 443
Working in the Calendar Folder - Page 444
Working in the Calendar Folder - Page 445
Working in the Calendar Folder - Page 446
Working in the Calendar Folder - Page 447
Chapter 23 Tracking Tasks with Outlook - Page 448
Working with Tasks - Page 449
Working with Tasks - Page 450
Working with Tasks - Page 451
Working with Tasks - Page 452
Working with Tasks - Page 453
Working with Tasks - Page 454
Exploring To-Do’s - Page 455
Exploring To-Do’s - Page 456
Creating Notes - Page 457
Using the To-Do Bar - Page 458
Using the To-Do Bar - Page 459
Part VII: Publisher - Page 460
Part VII: Publisher - Page 461
Chapter 24 Creating a Predesigned Publisher Publication - Page 462
Selecting a Publication Template - Page 463
Viewing the Publisher Window - Page 464
Viewing the Publisher Window - Page 465
Viewing the Publisher Window - Page 466
Customizing Your Publication - Page 467
Customizing Your Publication - Page 468
Presenting View Options - Page 469
Presenting View Options - Page 470
Presenting View Options - Page 471
Working with Text - Page 472
Working with Text - Page 473
Working with Text - Page 474
Working with Text - Page 475
Working with Text - Page 476
Working with Text - Page 477
Working with Graphics - Page 478
Working with Graphics - Page 479
Chapter 25 Designing Your Own Publication - Page 480
Starting Your Publication - Page 481
Starting Your Publication - Page 482
Working with Frames - Page 483
Working with Frames - Page 484
Working with Frames - Page 485
Working with Frames - Page 486
Working with Frames - Page 487
Working with Frames - Page 488
Working with Frames - Page 489
Working with Text - Page 490
Working with Text - Page 491
Working with Text - Page 492
Working with Text - Page 493
Working with Pages - Page 494
Working with Pages - Page 495
Working with Pages - Page 496
Preparing for Printing - Page 497
Preparing for Printing - Page 498
Preparing for Printing - Page 499
Preparing for Printing - Page 500
Preparing for Printing - Page 501