Microsoft Office 2013

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