Microsoft Office 2010

Part I: Office Features - Page 20
Part I: Office Features - Page 21
Chapter 1: Office Basics - Page 22
Chapter 1: Office Basics - Page 23
Navigate the Program Windows - Page 24
Navigate the Program Windows - Page 25
Work with the Ribbon - Page 26
Work with the Ribbon - Page 27
Customize the Quick Access Toolbar - Page 28
Customize the Quick Access Toolbar - Page 29
Find Help with Office - Page 30
Find Help with Office - Page 31
Chapter 2: Working with Files - Page 32
Chapter 2: Working with Files - Page 33
Save a File - Page 34
Save a File - Page 35
Open a File - Page 36
Open a File - Page 37
Print a File - Page 38
Print a File - Page 39
Check Your File for Hidden or Personal Data - Page 40
Check Your File for Hidden or Personal Data - Page 41
E-mail a File - Page 42
E-mail a File - Page 43
Select Data - Page 44
Select Data - Page 45
Cut, Copy, and Paste Data - Page 46
Cut, Copy, and Paste Data - Page 47
View Multiple Files - Page 48
View Multiple Files - Page 49
Chapter 3: Office Graphics Tools - Page 50
Chapter 3: Office Graphics Tools - Page 51
View Clip Art with the Clip Organizer - Page 52
View Clip Art with the Clip Organizer - Page 53
Insert a Picture - Page 54
Insert a Picture - Page 55
Resize and Move Objects - Page 56
Resize and Move Objects - Page 57
Rotate and Flip Objects - Page 58
Rotate and Flip Objects - Page 59
Crop a Picture - Page 60
Crop a Picture - Page 61
Add a Picture Border - Page 62
Add a Picture Border - Page 63
Add a Picture Effect - Page 64
Make Image Corrections - Page 65
Make Color Adjustments - Page 66
Apply Artistic Effects - Page 67
Create a WordArt Object - Page 68
Create a WordArt Object - Page 69
Add SmartArt - Page 70
Add SmartArt - Page 71
Chapter 4: Working with Office Files Online - Page 72
Chapter 4: Working with Office Files Online - Page 73
Upload a File to Office Live Workspace - Page 74
Upload a File to Office Live Workspace - Page 75
Create a New File in Office Live Workspace - Page 76
Create a New File in Office Live Workspace - Page 77
Edit a File in Office Live Workspace - Page 78
Edit a File in Office Live Workspace - Page 79
Share a Workspace - Page 80
Share a Workspace - Page 81
View Shared Workspaces - Page 82
Delete a File from Office Live Workspace - Page 83
Part II: Word - Page 84
Part II: Word - Page 85
Chapter 5: Adding Text - Page 86
Chapter 5: Adding Text - Page 87
Type and Edit Text - Page 88
Type and Edit Text - Page 89
Insert Quick Parts - Page 90
Insert Quick Parts - Page 91
Insert Symbols - Page 92
Insert Symbols - Page 93
Create a Blog Post - Page 94
Create a Blog Post - Page 95
Chapter 6: Formatting Text - Page 96
Chapter 6: Formatting Text - Page 97
Chapter 6: Formatting Text - Page 98
Chapter 6: Formatting Text - Page 99
Align Text - Page 100
Set Line Spacing - Page 101
Indent Text - Page 102
Indent Text - Page 103
Set Tabs - Page 104
Set Tabs - Page 105
Set Margins - Page 106
Set Margins - Page 107
Create Lists - Page 108
Create Lists - Page 109
Copy Formatting - Page 110
Clear Formatting - Page 111
Format with Styles - Page 112
Format with Styles - Page 113
Apply a Template - Page 114
Apply a Template - Page 115
Chapter 7: Adding Extra Touches - Page 116
Chapter 7: Adding Extra Touches - Page 117
Add Borders - Page 118
Add Borders - Page 119
Create Columns - Page 120
Create Columns - Page 121
Insert a Table - Page 122
Insert a Table - Page 123
Apply Table Styles - Page 124
Insert an Excel Spreadsheet - Page 125
Add Headers and Footers - Page 126
Add Headers and Footers - Page 127
Insert Footnotes and Endnotes - Page 128
Insert Footnotes and Endnotes - Page 129
Insert Page Numbers and Page Breaks - Page 130
Insert Page Numbers and Page Breaks - Page 131
Mark Index Entries - Page 132
Mark Index Entries - Page 133
Generate an Index - Page 134
Generate an Index - Page 135
Generate a Table of Contents - Page 136
Generate a Table of Contents - Page 137
Create a Bibliography - Page 138
Create a Bibliography - Page 139
Chapter 8: Reviewing Documents - Page 140
Chapter 8: Reviewing Documents - Page 141
Scan Document Content - Page 142
Scan Document Content - Page 143
Check Spelling and Grammar - Page 144
Check Spelling and Grammar - Page 145
Work with AutoCorrect - Page 146
Work with AutoCorrect - Page 147
Use Word’s Thesaurus and Dictionary - Page 148
Use Word’s Thesaurus and Dictionary - Page 149
Translate Text - Page 150
Translate Text - Page 151
Track and Review Document Changes - Page 152
Track and Review Document Changes - Page 153
Compare Documents - Page 154
Compare Documents - Page 155
Insert Comments - Page 156
Insert Comments - Page 157
Part III: Excel - Page 158
Part III: Excel - Page 159
Chapter 9: Building Spreadsheets - Page 160
Chapter 9: Building Spreadsheets - Page 161
Select Cells - Page 162
Select Cells - Page 163
Faster Data Entry with AutoFill - Page 164
Faster Data Entry with AutoFill - Page 165
Turn On Text Wrapping - Page 166
Center Data Across Columns - Page 167
Adjust Cell Alignment - Page 168
Adjust Cell Alignment - Page 169
Change the Font and Size - Page 170
Change the Font and Size - Page 171
Change Number Formats - Page 172
Increase or Decrease Decimals - Page 173
Add Borders - Page 174
Add Borders - Page 175
Format Data with Styles - Page 176
Format Data with Styles - Page 177
Apply Conditional Formatting - Page 178
Apply Conditional Formatting - Page 179
Add Columns and Rows - Page 180
Add Columns and Rows - Page 181
Resize Columns and Rows - Page 182
Freeze a Column or Row - Page 183
Name a Range - Page 184
Name a Range - Page 185
Delete Data or Cells - Page 186
Delete Data or Cells - Page 187
Chapter 10: Worksheet Basics - Page 188
Name a Worksheet - Page 189
Change Page Setup Options - Page 190
Change Page Setup Options - Page 191
Move and Copy Worksheets - Page 192
Delete a Worksheet - Page 193
Find and Replace Data - Page 194
Find and Replace Data - Page 195
Sort Data - Page 196
Sort Data - Page 197
Filter Data - Page 198
Filter Data - Page 199
Track and Review Worksheet Changes - Page 200
Track and Review Worksheet Changes - Page 201
Track and Review Worksheet Changes - Page 202
Track and Review Worksheet Changes - Page 203
Insert a Comment - Page 204
Insert a Comment - Page 205
Chapter 11: Working with Formulas and Functions - Page 206
Chapter 11: Working with Formulas and Functions - Page 207
Create a Formula - Page 208
Create a Formula - Page 209
Apply Absolute and Relative Cell References - Page 210
Apply Absolute and Relative Cell References - Page 211
Understanding Functions - Page 212
Understanding Functions - Page 213
Apply a Function - Page 214
Apply a Function - Page 215
Total Cells with AutoSum - Page 216
Total Cells with AutoSum - Page 217
Audit a Worksheet for Errors - Page 218
Audit a Worksheet for Errors - Page 219
Add a Watch Window - Page 220
Add a Watch Window - Page 221
Chapter 12: Working with Charts - Page 222
Chapter 12: Working with Charts - Page 223
Move and Resize Charts - Page 224
Move and Resize Charts - Page 225
Change the Chart Type - Page 226
Change the Chart Style - Page 227
Change the Chart Layout - Page 228
Add Axis Titles - Page 229
Format Chart Objects - Page 230
Format Chart Objects - Page 231
Add Gridlines - Page 232
Change the Chart Data - Page 233
Use Sparklines to View Data Trends - Page 234
Use Sparklines to View Data Trends - Page 235
Part IV: PowerPoint - Page 236
Part IV: PowerPoint - Page 237
Chapter 13: Creating a Presentation - Page 238
Chapter 13: Creating a Presentation - Page 239
Create a Presentation with a Template - Page 240
Create a Presentation with a Template - Page 241
Build a Blank Presentation - Page 242
Build a Blank Presentation - Page 243
Change PowerPoint Views - Page 244
Change PowerPoint Views - Page 245
Insert Slides - Page 246
Change the Slide Layout - Page 247
Create a Custom Layout - Page 248
Create a Custom Layout - Page 249
Chapter 14: Populating Presentation Slides - Page 250
Chapter 14: Populating Presentation Slides - Page 251
Change the Font, Size, and Color - Page 252
Change the Font, Size, and Color - Page 253
Change the Font, Size, and Color - Page 254
Change the Font, Size, and Color - Page 255
Apply a Theme - Page 256
Set Line Spacing - Page 257
Align Text - Page 258
Add a Text Box to a Slide - Page 259
Add a Table to a Slide - Page 260
Add a Table to a Slide - Page 261
Add a Chart to a Slide - Page 262
Add a Chart to a Slide - Page 263
Add a Picture to a Slide - Page 264
Add a Picture to a Slide - Page 265
Add a Video Clip to a Slide - Page 266
Add a Video Clip to a Slide - Page 267
Move a Slide Object - Page 268
Resize a Slide Object - Page 269
Chapter 15: Assembling and Presenting a Slide Show - Page 270
Chapter 15: Assembling and Presenting a Slide Show - Page 271
Reuse a Slide - Page 272
Reuse a Slide - Page 273
Organize Slides into Sections - Page 274
Organize Slides into Sections - Page 275
Define Slide Transitions - Page 276
Define Slide Transitions - Page 277
Add Animation Effects - Page 278
Add Animation Effects - Page 279
Create a Custom Animation - Page 280
Create a Custom Animation - Page 281
Record Narration - Page 282
Set Up a Slide Show - Page 283
Create Speaker Notes - Page 284
Create Speaker Notes - Page 285
Rehearse a Slide Show - Page 286
Rehearse a Slide Show - Page 287
Run a Slide Show - Page 288
Run a Slide Show - Page 289
Package Your Presentation on a CD - Page 290
Package Your Presentation on a CD - Page 291
Part V: Access - Page 292
Part V: Access - Page 293
Chapter 16: Database Basics - Page 294
Chapter 16: Database Basics - Page 295
Create a Database Based on a Template - Page 296
Create a Database Based on a Template - Page 297
Create a Blank Database - Page 298
Create a Blank Database - Page 299
Create a New Table - Page 300
Create a New Table - Page 301
Change Table Views - Page 302
Change Table Views - Page 303
Add a Field to a Table - Page 304
Delete a Field from a Table - Page 305
Hide a Field in a Table - Page 306
Move a Field in a Table - Page 307
Create a Form - Page 308
Create a Form - Page 309
Change Form Views - Page 310
Move a Field in a Form - Page 311
Delete a Field in a Form - Page 312
Apply a Database Theme - Page 313
Format Form Fields - Page 314
Add a Background Image - Page 315
Chapter 17: Adding, Finding, and Querying Data - Page 316
Chapter 17: Adding, Finding, and Querying Data - Page 317
Add a Record to a Form - Page 318
Add a Record to a Form - Page 319
Navigate Records in a Form - Page 320
Search for a Record in a Form - Page 321
Delete a Record from a Table - Page 322
Delete a Record from a Form - Page 323
Sort Records - Page 324
Sort Records - Page 325
Filter Records - Page 326
Filter Records - Page 327
Apply Conditional Formatting - Page 328
Apply Conditional Formatting - Page 329
Perform a Simple Query - Page 330
Perform a Simple Query - Page 331
Perform a Simple Query - Page 332
Perform a Simple Query - Page 333
Create a Report - Page 334
Create a Report - Page 335
Create a Report - Page 336
Create a Report - Page 337
Part VI: Outlook - Page 338
Part VI: Outlook - Page 339
Chapter 18: Organizing with Outlook - Page 340
Chapter 18: Organizing with Outlook - Page 341
Schedule an Appointment - Page 342
Schedule an Appointment - Page 343
Schedule a Recurring Appointment - Page 344
Schedule a Recurring Appointment - Page 345
Schedule an Event - Page 346
Schedule an Event - Page 347
Create a New Contact - Page 348
Create a New Contact - Page 349
Create a New Task - Page 350
Create a New Task - Page 351
Add a Note - Page 352
Add a Note - Page 353
Organize Outlook Items - Page 354
Organize Outlook Items - Page 355
Perform an Instant Search - Page 356
Customize the To-Do Bar - Page 357
Chapter 19: E-mailing with Outlook - Page 358
Chapter 19: E-mailing with Outlook - Page 359
Send a File Attachment - Page 360
Read an Incoming Message - Page 361
Reply To or Forward a Message - Page 362
Reply To or Forward a Message - Page 363
Add a Sender to Your Outlook Contacts - Page 364
Delete a Message - Page 365
View Conversations - Page 366
View Conversations - Page 367
Clean Up a Conversation - Page 368
Ignore a Conversation - Page 369
Screen Junk E-mail - Page 370
Screen Junk E-mail - Page 371
Create a Message Rule - Page 372
Create a Message Rule - Page 373
Part VII: Publisher - Page 374
Part VII: Publisher - Page 375
Chapter 20: Publisher Basics - Page 376
Chapter 20: Publisher Basics - Page 377
Create a Blank Publication - Page 378
Create a Blank Publication - Page 379
Zoom In and Out - Page 380
Zoom In and Out - Page 381
Add Text - Page 382
Add a New Text Box - Page 383
Add a Picture to a Publication - Page 384
Add a Picture to a Publication - Page 385
Chapter 21: Fine-Tuning a Publication - Page 386
Chapter 21: Fine-Tuning a Publication - Page 387
Chapter 21: Fine-Tuning a Publication - Page 388
Chapter 21: Fine-Tuning a Publication - Page 389
Apply a Text Effect - Page 390
Change Text Alignment - Page 391
Add a Border - Page 392
Control Text Wrap - Page 393
Link Text Boxes - Page 394
Link Text Boxes - Page 395
Move and Resize Publication Objects - Page 396
Move and Resize Publication Objects - Page 397
Edit the Background - Page 398
Edit the Background - Page 399
Add a Building Block Object - Page 400
Add a Building Block Object - Page 401
Create a Building Block Object - Page 402
Create a Building Block Object - Page 403
Part VIII: OneNote - Page 404
Part VIII: OneNote - Page 405
Chapter 22: Taking Notes with OneNote - Page 406
Chapter 22: Taking Notes with OneNote - Page 407
Type and Draw Notes - Page 408
Type and Draw Notes - Page 409
Paste a Picture into OneNote - Page 410
Attach Files to Notes - Page 411
Insert a Screen Clipping - Page 412
Insert a Screen Clipping - Page 413
Record an Audio Note - Page 414
Record an Audio Note - Page 415
Chapter 23: Organizing and Sharing Notes - Page 416
Create a New Section - Page 417
Create a New Page - Page 418
Create a New Page - Page 419
Rename Sections and Pages - Page 420
Rename Sections and Pages - Page 421
Group Sections - Page 422
Group Sections - Page 423
Search Notes - Page 424
Search Notes - Page 425
E-mail a Notes Page - Page 426
Convert Notes to PDF or XPS Format - Page 427