Microsoft Office 2013

Book I: Common Office Tasks - Page 39
Book I: Common Office Tasks - Page 40
Chapter 1: Office Nuts and Bolts - Page 41
Chapter 1: Office Nuts and Bolts - Page 42
Starting an Office Program - Page 43
Starting an Office Program - Page 44
Starting an Office Program - Page 45
Finding Your Way Around the Office Interface - Page 46
Finding Your Way Around the Office Interface - Page 47
Finding Your Way Around the Office Interface - Page 48
Finding Your Way Around the Office Interface - Page 49
Finding Your Way Around the Office Interface - Page 50
Finding Your Way Around the Office Interface - Page 51
Saving Your Files - Page 52
Saving Your Files - Page 53
Saving Your Files - Page 54
Navigating the Save As and Open Windows - Page 55
Navigating the Save As and Open Windows - Page 56
Opening and Closing Files - Page 57
Reading and Recording File Properties - Page 58
Locking a File with a Password - Page 59
Locking a File with a Password - Page 60
Chapter 2: Wrestling with the Text - Page 61
Chapter 2: Wrestling with the Text - Page 62
Chapter 2: Wrestling with the Text - Page 63
Changing the Look of Text - Page 64
Changing the Look of Text - Page 65
Changing the Look of Text - Page 66
Changing the Look of Text - Page 67
Changing the Look of Text - Page 68
Changing the Look of Text - Page 69
Quick Ways to Handle Case, or Capitalization - Page 70
Quick Ways to Handle Case, or Capitalization - Page 71
Entering Symbols and Foreign Characters - Page 72
Creating Hyperlinks - Page 73
Creating Hyperlinks - Page 74
Creating Hyperlinks - Page 75
Creating Hyperlinks - Page 76
Creating Hyperlinks - Page 77
Creating Hyperlinks - Page 78
Chapter 3: Speed Techniques Worth Knowing About - Page 79
Zooming In, Zooming Out - Page 80
Zooming In, Zooming Out - Page 81
Viewing a File Through More Than One Window - Page 82
Viewing a File Through More Than One Window - Page 83
Entering Text Quickly with the AutoCorrect Command - Page 84
Entering Text Quickly with the AutoCorrect Command - Page 85
Entering Text Quickly with the AutoCorrect Command - Page 86
Book II: Word 2013 - Page 87
Book II: Word 2013 - Page 88
Chapter 1: Speed Techniques for Using Word - Page 89
Chapter 1: Speed Techniques for Using Word - Page 90
Creating a New Document - Page 91
Creating a New Document - Page 92
Getting a Better Look at Your Documents - Page 93
Getting a Better Look at Your Documents - Page 94
Getting a Better Look at Your Documents - Page 95
Getting a Better Look at Your Documents - Page 96
Selecting Text in Speedy Ways - Page 97
Moving Around Quickly in Documents - Page 98
Moving Around Quickly in Documents - Page 99
Moving Around Quickly in Documents - Page 100
Inserting a Whole File into a Document - Page 101
Entering Information Quickly in a Computerized Form - Page 102
Entering Information Quickly in a Computerized Form - Page 103
Entering Information Quickly in a Computerized Form - Page 104
Entering Information Quickly in a Computerized Form - Page 105
Entering Information Quickly in a Computerized Form - Page 106
Chapter 2: Laying Out Text and Pages - Page 107
Inserting a Section Break for Formatting Purposes - Page 108
Inserting a Section Break for Formatting Purposes - Page 109
Breaking a Line - Page 110
Setting Up and Changing the Margins - Page 111
Setting Up and Changing the Margins - Page 112
Indenting Paragraphs and First Lines - Page 113
Indenting Paragraphs and First Lines - Page 114
Numbering the Pages - Page 115
Numbering the Pages - Page 116
Numbering the Pages - Page 117
Putting Headers and Footers on Pages - Page 118
Putting Headers and Footers on Pages - Page 119
Putting Headers and Footers on Pages - Page 120
Putting Headers and Footers on Pages - Page 121
Adjusting the Space Between Lines - Page 122
Adjusting the Space Between Paragraphs - Page 123
Creating Numbered and Bulleted Lists - Page 124
Creating Numbered and Bulleted Lists - Page 125
Creating Numbered and Bulleted Lists - Page 126
Working with Tabs - Page 127
Hyphenating Text - Page 128
Hyphenating Text - Page 129
Hyphenating Text - Page 130
Chapter 3: Word Styles - Page 131
Chapter 3: Word Styles - Page 132
Applying Styles to Text and Paragraphs - Page 133
Applying Styles to Text and Paragraphs - Page 134
Applying Styles to Text and Paragraphs - Page 135
Applying Styles to Text and Paragraphs - Page 136
Creating a New Style - Page 137
Creating a New Style - Page 138
Creating a New Style - Page 139
Modifying a Style - Page 140
Creating and Managing Templates - Page 141
Creating and Managing Templates - Page 142
Creating and Managing Templates - Page 143
Creating and Managing Templates - Page 144
Creating and Managing Templates - Page 145
Creating and Managing Templates - Page 146
Chapter 4: Constructing the Perfect Table - Page 147
Creating a Table - Page 148
Creating a Table - Page 149
Entering the Text and Numbers - Page 150
Selecting Different Parts of a Table - Page 151
Laying Out Your Table - Page 152
Laying Out Your Table - Page 153
Laying Out Your Table - Page 154
Laying Out Your Table - Page 155
Aligning Text in Columns and Rows - Page 156
Merging and Splitting Cells - Page 157
Repeating Header Rows on Subsequent Pages - Page 158
Formatting Your Table - Page 159
Formatting Your Table - Page 160
Formatting Your Table - Page 161
Formatting Your Table - Page 162
Formatting Your Table - Page 163
Using Math Formulas in Tables - Page 164
Neat Table Tricks - Page 165
Neat Table Tricks - Page 166
Neat Table Tricks - Page 167
Neat Table Tricks - Page 168
Neat Table Tricks - Page 169
Neat Table Tricks - Page 170
Chapter 5: Taking Advantage of the Proofing Tools - Page 171
Correcting Your Spelling Errors - Page 172
Correcting Your Spelling Errors - Page 173
Correcting Your Spelling Errors - Page 174
Checking for Grammatical Errors in Word - Page 175
Getting a Word Definition - Page 176
Finding and Replacing Text - Page 177
Finding and Replacing Text - Page 178
Finding and Replacing Text - Page 179
Finding and Replacing Text - Page 180
Finding and Replacing Text - Page 181
Finding and Replacing Text - Page 182
Finding and Replacing Text - Page 183
Finding and Replacing Text - Page 184
Researching a Topic Inside Word - Page 185
Researching a Topic Inside Word - Page 186
Finding the Right Word with the Thesaurus - Page 187
Proofing Text Written in a Foreign Language - Page 188
Translating Foreign Language Text - Page 189
Translating Foreign Language Text - Page 190
Chapter 6: Desktop Publishing with Word - Page 191
Chapter 6: Desktop Publishing with Word - Page 192
Sprucing Up Your Pages - Page 193
Sprucing Up Your Pages - Page 194
Making Use of Charts, Diagrams, Shapes, Clip Art, and Photos - Page 195
Working with the Drawing Canvas - Page 196
Positioning and Wrapping Objects Relative to the Page and Text - Page 197
Positioning and Wrapping Objects Relative to the Page and Text - Page 198
Positioning and Wrapping Objects Relative to the Page and Text - Page 199
Positioning and Wrapping Objects Relative to the Page and Text - Page 200
Working with Text Boxes - Page 201
Working with Text Boxes - Page 202
Dropping In a Drop Cap - Page 203
Dropping In a Drop Cap - Page 204
Putting Newspaper-Style Columns in a Document - Page 205
Landscape Documents - Page 206
Printing on Different Size Paper - Page 207
Showing Online Video in a Document - Page 208
Chapter 7: Getting Word’s Help with Office Chores - Page 209
Commenting on a Document - Page 210
Commenting on a Document - Page 211
Commenting on a Document - Page 212
Tracking Changes to Documents - Page 213
Tracking Changes to Documents - Page 214
Tracking Changes to Documents - Page 215
Tracking Changes to Documents - Page 216
Tracking Changes to Documents - Page 217
Printing an Address on an Envelope - Page 218
Printing an Address on an Envelope - Page 219
Printing a Single Address Label (or a Page of the Same Label) - Page 220
Churning Out Letters, Envelopes, and Labels for Mass Mailings - Page 221
Churning Out Letters, Envelopes, and Labels for Mass Mailings - Page 222
Churning Out Letters, Envelopes, and Labels for Mass Mailings - Page 223
Churning Out Letters, Envelopes, and Labels for Mass Mailings - Page 224
Churning Out Letters, Envelopes, and Labels for Mass Mailings - Page 225
Churning Out Letters, Envelopes, and Labels for Mass Mailings - Page 226
Churning Out Letters, Envelopes, and Labels for Mass Mailings - Page 227
Churning Out Letters, Envelopes, and Labels for Mass Mailings - Page 228
Chapter 8: Tools for Reports and Scholarly Papers - Page 229
Outlines for Organizing Your Work - Page 230
Outlines for Organizing Your Work - Page 231
Collapsing and Expanding Parts of a Document - Page 232
Collapsing and Expanding Parts of a Document - Page 233
Collapsing and Expanding Parts of a Document - Page 234
Collapsing and Expanding Parts of a Document - Page 235
Collapsing and Expanding Parts of a Document - Page 236
Indexing a Document - Page 237
Indexing a Document - Page 238
Indexing a Document - Page 239
Indexing a Document - Page 240
Putting Cross-References in a Document - Page 241
Putting Cross-References in a Document - Page 242
Putting Footnotes and Endnotes in Documents - Page 243
Putting Footnotes and Endnotes in Documents - Page 244
Putting Footnotes and Endnotes in Documents - Page 245
Compiling a Bibliography - Page 246
Compiling a Bibliography - Page 247
Compiling a Bibliography - Page 248
Compiling a Bibliography - Page 249
Compiling a Bibliography - Page 250
Book III: Excel 2013 - Page 251
Book III: Excel 2013 - Page 252
Chapter 1: Up and Running with Excel - Page 253
Chapter 1: Up and Running with Excel - Page 254
Getting Acquainted with Excel - Page 255
Getting Acquainted with Excel - Page 256
Entering Data in a Worksheet - Page 257
Entering Data in a Worksheet - Page 258
Entering Data in a Worksheet - Page 259
Entering Data in a Worksheet - Page 260
Entering Data in a Worksheet - Page 261
Entering Data in a Worksheet - Page 262
Quickly Entering Lists and Serial Data with the AutoFill Command - Page 263
Formatting Numbers, Dates, and Time Values - Page 264
Formatting Numbers, Dates, and Time Values - Page 265
Formatting Numbers, Dates, and Time Values - Page 266
Conditional Formats for Calling Attention to Data - Page 267
Establishing Data-Validation Rules - Page 268
Establishing Data-Validation Rules - Page 269
Establishing Data-Validation Rules - Page 270
Chapter 2: Refining Your Worksheet - Page 271
Moving Around in a Worksheet - Page 272
Getting a Better Look at the Worksheet - Page 273
Getting a Better Look at the Worksheet - Page 274
Getting a Better Look at the Worksheet - Page 275
Comments for Documenting Your Worksheet - Page 276
Comments for Documenting Your Worksheet - Page 277
Selecting Cells in a Worksheet - Page 278
Deleting, Copying, and Moving Data - Page 279
Deleting, Copying, and Moving Data - Page 280
Keeping Others from Tampering with Worksheets - Page 281
Keeping Others from Tampering with Worksheets - Page 282
Keeping Others from Tampering with Worksheets - Page 283
Keeping Others from Tampering with Worksheets - Page 284
Chapter 3: Formulas and Functions for Crunching Numbers - Page 285
Chapter 3: Formulas and Functions for Crunching Numbers - Page 286
Chapter 3: Formulas and Functions for Crunching Numbers - Page 287
Chapter 3: Formulas and Functions for Crunching Numbers - Page 288
Chapter 3: Formulas and Functions for Crunching Numbers - Page 289
The Basics of Entering a Formula - Page 290
Speed Techniques for Entering Formulas - Page 291
Speed Techniques for Entering Formulas - Page 292
Speed Techniques for Entering Formulas - Page 293
Speed Techniques for Entering Formulas - Page 294
Speed Techniques for Entering Formulas - Page 295
Copying Formulas from Cell to Cell - Page 296
Copying Formulas from Cell to Cell - Page 297
Detecting and Correcting Errors in Formulas - Page 298
Detecting and Correcting Errors in Formulas - Page 299
Detecting and Correcting Errors in Formulas - Page 300
Working with Functions - Page 301
Working with Functions - Page 302
Working with Functions - Page 303
Working with Functions - Page 304
Working with Functions - Page 305
Working with Functions - Page 306
Chapter 4: Making a Worksheet Easier to Read and Understand - Page 307
Chapter 4: Making a Worksheet Easier to Read and Understand - Page 308
Chapter 4: Making a Worksheet Easier to Read and Understand - Page 309
Chapter 4: Making a Worksheet Easier to Read and Understand - Page 310
Chapter 4: Making a Worksheet Easier to Read and Understand - Page 311
Decorating a Worksheet with Borders and Colors - Page 312
Decorating a Worksheet with Borders and Colors - Page 313
Decorating a Worksheet with Borders and Colors - Page 314
Decorating a Worksheet with Borders and Colors - Page 315
Decorating a Worksheet with Borders and Colors - Page 316
Getting Ready to Print a Worksheet - Page 317
Getting Ready to Print a Worksheet - Page 318
Getting Ready to Print a Worksheet - Page 319
Getting Ready to Print a Worksheet - Page 320
Getting Ready to Print a Worksheet - Page 321
Getting Ready to Print a Worksheet - Page 322
Getting Ready to Print a Worksheet - Page 323
Getting Ready to Print a Worksheet - Page 324
Chapter 5: Advanced Techniques for Analyzing Data - Page 325
Managing Information in Lists - Page 326
Managing Information in Lists - Page 327
Managing Information in Lists - Page 328
Managing Information in Lists - Page 329
Forecasting with the Goal Seek Command - Page 330
Performing What-If Analyses with Data Tables - Page 331
Performing What-If Analyses with Data Tables - Page 332
Performing What-If Analyses with Data Tables - Page 333
Performing What-If Analyses with Data Tables - Page 334
Analyzing Data with Pivot Tables - Page 335
Analyzing Data with Pivot Tables - Page 336
Analyzing Data with Pivot Tables - Page 337
Analyzing Data with Pivot Tables - Page 338
Book IV: PowerPoint 2013 - Page 339
Book IV: PowerPoint 2013 - Page 340
Chapter 1: Getting Started in PowerPoint - Page 341
Getting Acquainted with PowerPoint - Page 342
A Brief Geography Lesson - Page 343
A Whirlwind Tour of PowerPoint - Page 344
Creating a New Presentation - Page 345
Creating a New Presentation - Page 346
Creating a New Presentation - Page 347
Advice for Building Persuasive Presentations - Page 348
Advice for Building Persuasive Presentations - Page 349
Creating New Slides for Your Presentation - Page 350
Creating New Slides for Your Presentation - Page 351
Creating New Slides for Your Presentation - Page 352
Creating New Slides for Your Presentation - Page 353
Creating New Slides for Your Presentation - Page 354
Getting a Better View of Your Work - Page 355
Hiding and Displaying the Slides Pane and Notes Pane - Page 356
Selecting, Moving, and Deleting Slides - Page 357
Putting Together a Photo Album - Page 358
Putting Together a Photo Album - Page 359
Putting Together a Photo Album - Page 360
Hidden Slides for All Contingencies - Page 361
Hidden Slides for All Contingencies - Page 362
Chapter 2: Fashioning a Look for Your Presentation - Page 363
Chapter 2: Fashioning a Look for Your Presentation - Page 364
Chapter 2: Fashioning a Look for Your Presentation - Page 365
Choosing a Theme for Your Presentation - Page 366
Choosing a Theme for Your Presentation - Page 367
Choosing a Theme for Your Presentation - Page 368
Choosing a Theme for Your Presentation - Page 369
Choosing a Theme for Your Presentation - Page 370
Choosing a Theme for Your Presentation - Page 371
Choosing a Theme for Your Presentation - Page 372
Changing the Background of a Single or Handful of Slides - Page 373
Choosing the Slide Size - Page 374
Choosing the Slide Size - Page 375
Choosing the Slide Size - Page 376
Choosing the Slide Size - Page 377
Choosing the Slide Size - Page 378
Chapter 3: Entering the Text - Page 379
Chapter 3: Entering the Text - Page 380
Chapter 3: Entering the Text - Page 381
Fun with Text Boxes and Text Box Shapes - Page 382
Fun with Text Boxes and Text Box Shapes - Page 383
Controlling How Text Fits in Text Frames and Text Boxes - Page 384
Controlling How Text Fits in Text Frames and Text Boxes - Page 385
Controlling How Text Fits in Text Frames and Text Boxes - Page 386
Controlling How Text Fits in Text Frames and Text Boxes - Page 387
Positioning Text in Frames and Text Boxes - Page 388
Handling Bulleted and Numbered Lists - Page 389
Handling Bulleted and Numbered Lists - Page 390
Putting Footers (and Headers) on Slides - Page 391
Putting Footers (and Headers) on Slides - Page 392
Putting Footers (and Headers) on Slides - Page 393
Putting Footers (and Headers) on Slides - Page 394
Chapter 4: Making Your Presentations Livelier - Page 395
Presenting Information in a Table - Page 396
Exploring Transitions and Animations - Page 397
Exploring Transitions and Animations - Page 398
Exploring Transitions and Animations - Page 399
Exploring Transitions and Animations - Page 400
Exploring Transitions and Animations - Page 401
Making Audio Part of Your Presentation - Page 402
Making Audio Part of Your Presentation - Page 403
Making Audio Part of Your Presentation - Page 404
Making Audio Part of Your Presentation - Page 405
Playing Video on Slides - Page 406
Playing Video on Slides - Page 407
Playing Video on Slides - Page 408
Recording a Voice Narration for Slides - Page 409
Recording a Voice Narration for Slides - Page 410
Chapter 5: Delivering a Presentation - Page 411
Rehearsing and Timing Your Presentation - Page 412
Showing Your Presentation - Page 413
Showing Your Presentation - Page 414
Showing Your Presentation - Page 415
Showing Your Presentation - Page 416
Tricks for Making Presentations a Little Livelier - Page 417
Tricks for Making Presentations a Little Livelier - Page 418
Tricks for Making Presentations a Little Livelier - Page 419
Delivering a Presentation When You Can’t Be There in Person - Page 420
Delivering a Presentation When You Can’t Be There in Person - Page 421
Delivering a Presentation When You Can’t Be There in Person - Page 422
Delivering a Presentation When You Can’t Be There in Person - Page 423
Delivering a Presentation When You Can’t Be There in Person - Page 424
Delivering a Presentation When You Can’t Be There in Person - Page 425
Delivering a Presentation When You Can’t Be There in Person - Page 426
Delivering a Presentation When You Can’t Be There in Person - Page 427
Delivering a Presentation When You Can’t Be There in Person - Page 428
Delivering a Presentation When You Can’t Be There in Person - Page 429
Delivering a Presentation When You Can’t Be There in Person - Page 430
Delivering a Presentation When You Can’t Be There in Person - Page 431
Delivering a Presentation When You Can’t Be There in Person - Page 432
Book V: OneNote 2013 - Page 433
Book V: OneNote 2013 - Page 434
Chapter 1: Up and Running with OneNote - Page 435
Finding Your Way Around the OneNote Screen - Page 436
Units for Organizing Notes - Page 437
Units for Organizing Notes - Page 438
Creating a Notebook - Page 439
Creating Sections and Section Groups - Page 440
Creating Sections and Section Groups - Page 441
Creating Pages and Subpages - Page 442
Renaming and Deleting Groups and Pages - Page 443
Changing Your View of OneNote - Page 444
Changing Your View of OneNote - Page 445
Changing Your View of OneNote - Page 446
Chapter 2: Taking Notes - Page 447
Chapter 2: Taking Notes - Page 448
Chapter 2: Taking Notes - Page 449
Drawing on the Page - Page 450
Drawing on the Page - Page 451
Drawing on the Page - Page 452
Drawing on the Page - Page 453
Converting a Handwritten Note to Text - Page 454
Writing a Math Expression in a Note - Page 455
Taking a Screen-Clipping Note - Page 456
Recording and Playing Audio Notes - Page 457
Recording and Playing Audio Notes - Page 458
Attaching, Copying, and Linking Files to Notes - Page 459
Attaching, Copying, and Linking Files to Notes - Page 460
Attaching, Copying, and Linking Files to Notes - Page 461
Attaching, Copying, and Linking Files to Notes - Page 462
Chapter 3: Finding and Organizing Your Notes - Page 463
Chapter 3: Finding and Organizing Your Notes - Page 464
Tagging Notes for Follow Up - Page 465
Tagging Notes for Follow Up - Page 466
Tagging Notes for Follow Up - Page 467
Tagging Notes for Follow Up - Page 468
Color-Coding Notebooks, Sections, and Pages - Page 469
Color-Coding Notebooks, Sections, and Pages - Page 470
Book VI: Outlook 2013 - Page 471
Book VI: Outlook 2013 - Page 472
Chapter 1: Outlook Basics - Page 473
Navigating the Outlook Folders - Page 474
Categorizing Items - Page 475
Categorizing Items - Page 476
Searching for Stray Folder Items - Page 477
Searching for Stray Folder Items - Page 478
Searching for Stray Folder Items - Page 479
Deleting E-Mail Messages, Contacts, Tasks, and Other Items - Page 480
Finding and Backing Up Your Outlook File - Page 481
Cleaning Out Your Folders - Page 482
Cleaning Out Your Folders - Page 483
Cleaning Out Your Folders - Page 484
Cleaning Out Your Folders - Page 485
Cleaning Out Your Folders - Page 486
Chapter 2: Maintaining the Contacts Folder - Page 487
Chapter 2: Maintaining the Contacts Folder - Page 488
Chapter 2: Maintaining the Contacts Folder - Page 489
Chapter 2: Maintaining the Contacts Folder - Page 490
Contact Groups for Sending Messages to Groups - Page 491
Contact Groups for Sending Messages to Groups - Page 492
Finding a Contact in the Contacts Folder - Page 493
Printing the Contacts Folder - Page 494
Printing the Contacts Folder - Page 495
Printing the Contacts Folder - Page 496
Chapter 3: Handling Your E-Mail - Page 497
Addressing and Sending E-Mail Messages - Page 498
Addressing and Sending E-Mail Messages - Page 499
Addressing and Sending E-Mail Messages - Page 500
Addressing and Sending E-Mail Messages - Page 501
Addressing and Sending E-Mail Messages - Page 502
Sending Files and Photos - Page 503
Sending Files and Photos - Page 504
Being Advised When Someone Has Read Your E-Mail - Page 505
Receiving E-Mail Messages - Page 506
Reading Your E-Mail in the Inbox Window - Page 507
Reading Your E-Mail in the Inbox Window - Page 508
Reading Your E-Mail in the Inbox Window - Page 509
Handling Files That Were Sent to You - Page 510
Techniques for Organizing E-Mail Messages - Page 511
Techniques for Organizing E-Mail Messages - Page 512
Techniques for Organizing E-Mail Messages - Page 513
Techniques for Organizing E-Mail Messages - Page 514
Techniques for Organizing E-Mail Messages - Page 515
All about E-Mail Folders - Page 516
Yes, You Can Prevent Junk Mail (Sort of) - Page 517
Yes, You Can Prevent Junk Mail (Sort of) - Page 518
Yes, You Can Prevent Junk Mail (Sort of) - Page 519
Yes, You Can Prevent Junk Mail (Sort of) - Page 520
Chapter 4: Managing Your Time and Schedule - Page 521
The Different Kinds of Activities - Page 522
Seeing Your Schedule - Page 523
Scheduling Appointments and Events - Page 524
Scheduling Appointments and Events - Page 525
Scheduling Appointments and Events - Page 526
Canceling, Rescheduling, and Altering Activities - Page 527
Canceling, Rescheduling, and Altering Activities - Page 528
Chapter 5: Tasks, Reminders, and Notes - Page 529
Chapter 5: Tasks, Reminders, and Notes - Page 530
Chapter 5: Tasks, Reminders, and Notes - Page 531
Reminders for Being Alerted to Activities and Tasks - Page 532
Reminders for Being Alerted to Activities and Tasks - Page 533
Making Notes to Yourself - Page 534
Making Notes to Yourself - Page 535
Making Notes to Yourself - Page 536
Book VII: Access 2013 - Page 537
Book VII: Access 2013 - Page 538
Chapter 1: Introducing Access - Page 539
Chapter 1: Introducing Access - Page 540
Tables, Queries, Forms, and Other Objects - Page 541
Tables, Queries, Forms, and Other Objects - Page 542
Tables, Queries, Forms, and Other Objects - Page 543
Tables, Queries, Forms, and Other Objects - Page 544
Creating a Database File - Page 545
Finding Your Way Around the Navigation Pane - Page 546
Finding Your Way Around the Navigation Pane - Page 547
Designing a Database - Page 548
Designing a Database - Page 549
Designing a Database - Page 550
Designing a Database - Page 551
Designing a Database - Page 552
Chapter 2: Building Your Database Tables - Page 553
Chapter 2: Building Your Database Tables - Page 554
Chapter 2: Building Your Database Tables - Page 555
Chapter 2: Building Your Database Tables - Page 556
Opening and Viewing Tables - Page 557
Entering and Altering Table Fields - Page 558
Entering and Altering Table Fields - Page 559
Entering and Altering Table Fields - Page 560
Entering and Altering Table Fields - Page 561
Entering and Altering Table Fields - Page 562
Entering and Altering Table Fields - Page 563
Field Properties for Making Sure That Data Entries Are Accurate - Page 564
Field Properties for Making Sure That Data Entries Are Accurate - Page 565
Field Properties for Making Sure That Data Entries Are Accurate - Page 566
Field Properties for Making Sure That Data Entries Are Accurate - Page 567
Field Properties for Making Sure That Data Entries Are Accurate - Page 568
Field Properties for Making Sure That Data Entries Are Accurate - Page 569
Field Properties for Making Sure That Data Entries Are Accurate - Page 570
Field Properties for Making Sure That Data Entries Are Accurate - Page 571
Indexing for Faster Sorts, Searches, and Queries - Page 572
Indexing for Faster Sorts, Searches, and Queries - Page 573
Establishing Relationships Between Database Tables - Page 574
Establishing Relationships Between Database Tables - Page 575
Establishing Relationships Between Database Tables - Page 576
Establishing Relationships Between Database Tables - Page 577
Establishing Relationships Between Database Tables - Page 578
Establishing Relationships Between Database Tables - Page 579
Establishing Relationships Between Database Tables - Page 580
Chapter 3: Entering the Data - Page 581
Entering the Data in Datasheet View - Page 582
Entering the Data in Datasheet View - Page 583
Entering the Data in Datasheet View - Page 584
Entering the Data in Datasheet View - Page 585
Entering the Data in a Form - Page 586
Entering the Data in a Form - Page 587
Finding a Missing Record - Page 588
Finding and Replacing Data - Page 589
Finding and Replacing Data - Page 590
Chapter 4: Sorting, Querying, and Filtering for Data - Page 591
Filtering to Find Information - Page 592
Filtering to Find Information - Page 593
Filtering to Find Information - Page 594
Filtering to Find Information - Page 595
Filtering to Find Information - Page 596
Filtering to Find Information - Page 597
Querying: The Basics - Page 598
Querying: The Basics - Page 599
Querying: The Basics - Page 600
Querying: The Basics - Page 601
Querying: The Basics - Page 602
Querying: The Basics - Page 603
Querying: The Basics - Page 604
Querying: The Basics - Page 605
Six Kinds of Queries - Page 606
Six Kinds of Queries - Page 607
Six Kinds of Queries - Page 608
Six Kinds of Queries - Page 609
Six Kinds of Queries - Page 610
Chapter 5: Presenting Data in a Report - Page 611
Chapter 5: Presenting Data in a Report - Page 612
Opening and Viewing Reports - Page 613
Opening and Viewing Reports - Page 614
Book VIII: Working with Charts and Graphics - Page 615
Book VIII: Working with Charts and Graphics - Page 616
Chapter 1: Creating a Chart - Page 617
Chapter 1: Creating a Chart - Page 618
Choosing the Right Chart - Page 619
Providing the Raw Data for Your Chart - Page 620
Providing the Raw Data for Your Chart - Page 621
Positioning Your Chart in a Workbook, Page, or Slide - Page 622
Changing a Chart’s Appearance - Page 623
Changing a Chart’s Appearance - Page 624
Changing a Chart’s Appearance - Page 625
Changing a Chart’s Appearance - Page 626
Changing a Chart’s Appearance - Page 627
Changing a Chart’s Appearance - Page 628
Saving a Chart as a Template So That You Can Use It Again - Page 629
Chart Tricks for the Daring and Heroic - Page 630
Chart Tricks for the Daring and Heroic - Page 631
Chart Tricks for the Daring and Heroic - Page 632
Troubleshooting a Chart - Page 633
Troubleshooting a Chart - Page 634
Chapter 2: Making a SmartArt Diagram - Page 635
Chapter 2: Making a SmartArt Diagram - Page 636
Creating the Initial Diagram - Page 637
Creating the Initial Diagram - Page 638
Changing the Size and Position of a Diagram - Page 639
Laying Out the Diagram Shapes - Page 640
Laying Out the Diagram Shapes - Page 641
Laying Out the Diagram Shapes - Page 642
Laying Out the Diagram Shapes - Page 643
Laying Out the Diagram Shapes - Page 644
Laying Out the Diagram Shapes - Page 645
Handling the Text on Diagram Shapes - Page 646
Changing a Diagram’s Direction - Page 647
Choosing a Look for Your Diagram - Page 648
Changing the Appearance of Diagram Shapes - Page 649
Changing the Appearance of Diagram Shapes - Page 650
Changing the Appearance of Diagram Shapes - Page 651
Creating a Diagram from Scratch - Page 652
Creating a Diagram from Scratch - Page 653
Creating a Diagram from Scratch - Page 654
Chapter 3: Handling Graphics, Photos, and Clip Art - Page 655
Chapter 3: Handling Graphics, Photos, and Clip Art - Page 656
Chapter 3: Handling Graphics, Photos, and Clip Art - Page 657
Chapter 3: Handling Graphics, Photos, and Clip Art - Page 658
Inserting a Picture in an Office File - Page 659
Inserting a Picture in an Office File - Page 660
Inserting a Picture in an Office File - Page 661
Inserting a Picture in an Office File - Page 662
Touching Up a Picture - Page 663
Touching Up a Picture - Page 664
Touching Up a Picture - Page 665
Touching Up a Picture - Page 666
Touching Up a Picture - Page 667
Touching Up a Picture - Page 668
Touching Up a Picture - Page 669
Touching Up a Picture - Page 670
Compressing Pictures to Save Disk Space - Page 671
Compressing Pictures to Save Disk Space - Page 672
Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects - Page 673
The Basics: Drawing Lines, Arrows, and Shapes - Page 674
Handling Lines, Arrows, and Connectors - Page 675
Handling Lines, Arrows, and Connectors - Page 676
Handling Lines, Arrows, and Connectors - Page 677
Handling Lines, Arrows, and Connectors - Page 678
Handling Lines, Arrows, and Connectors - Page 679
Handling Rectangles, Ovals, Stars, and Other Shapes - Page 680
Handling Rectangles, Ovals, Stars, and Other Shapes - Page 681
Handling Rectangles, Ovals, Stars, and Other Shapes - Page 682
WordArt for Embellishing Letters and Words - Page 683
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects - Page 684
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects - Page 685
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects - Page 686
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects - Page 687
Changing an Object’s Size and Shape - Page 688
Changing an Object’s Color, Outline Color, and Transparency - Page 689
Changing an Object’s Color, Outline Color, and Transparency - Page 690
Changing an Object’s Color, Outline Color, and Transparency - Page 691
Changing an Object’s Color, Outline Color, and Transparency - Page 692
Changing an Object’s Color, Outline Color, and Transparency - Page 693
Moving and Positioning Objects - Page 694
Moving and Positioning Objects - Page 695
Moving and Positioning Objects - Page 696
Moving and Positioning Objects - Page 697
Moving and Positioning Objects - Page 698
Moving and Positioning Objects - Page 699
Moving and Positioning Objects - Page 700
Moving and Positioning Objects - Page 701
Moving and Positioning Objects - Page 702
Book IX: Office 2013: One Step Beyond - Page 703
Book IX: Office 2013: One Step Beyond - Page 704
Chapter 1: Customizing an Office Program - Page 705
Chapter 1: Customizing an Office Program - Page 706
Chapter 1: Customizing an Office Program - Page 707
Chapter 1: Customizing an Office Program - Page 708
Chapter 1: Customizing an Office Program - Page 709
Chapter 1: Customizing an Office Program - Page 710
Customizing the Quick Access Toolbar - Page 711
Customizing the Quick Access Toolbar - Page 712
Customizing the Quick Access Toolbar - Page 713
Customizing the Status Bar - Page 714
Customizing the Status Bar - Page 715
Customizing Keyboard Shortcuts in Word - Page 716
Customizing Keyboard Shortcuts in Word - Page 717
Customizing Keyboard Shortcuts in Word - Page 718
Chapter 2: Ways of Distributing Your Work - Page 719
Distributing a File in PDF Format - Page 720
Distributing a File in PDF Format - Page 721
Sending Your File in an E-Mail Message - Page 722
Saving an Office File as a Web Page - Page 723
Saving an Office File as a Web Page - Page 724
Blogging from inside Word - Page 725
Blogging from inside Word - Page 726
Blogging from inside Word - Page 727
Blogging from inside Word - Page 728
Chapter 3: Working with Publisher - Page 729
Introducing Frames - Page 730
Creating a Publication - Page 731
Redesigning a Publication - Page 732
Getting a Better View of Your Work - Page 733
Getting a Better View of Your Work - Page 734
Entering Text on the Pages - Page 735
Making Text Fit in Text Frames - Page 736
Making Text Fit in Text Frames - Page 737
Making Text Fit in Text Frames - Page 738
Making Text Wrap around a Frame or Graphic - Page 739
Making Text Wrap around a Frame or Graphic - Page 740
Inserting, Removing, and Moving Pages - Page 741
Master Pages for Handling Page Backgrounds - Page 742
Running the Design Checker - Page 743
Commercially Printing a Publication - Page 744
Book X: File Sharing and Collaborating - Page 745
Book X: File Sharing and Collaborating - Page 746
Chapter 1: Preparing to Use the Office Web Apps - Page 747
Storing and Sharing Files on the Internet - Page 748
Office Web Apps: The Big Picture - Page 749
Creating a Microsoft Account - Page 750
Navigating in a Microsoft Account - Page 751
Navigating in a Microsoft Account - Page 752
Navigating in a Microsoft Account - Page 753
Navigating in a Microsoft Account - Page 754
Navigating in a Microsoft Account - Page 755
Navigating in a Microsoft Account - Page 756
Chapter 2: Using the Office Web Apps - Page 757
Uploading Office Files to a Folder on SkyDrive - Page 758
Saving a File from Office 2013 to SkyDrive - Page 759
Saving a File from Office 2013 to SkyDrive - Page 760
Opening Office Files Stored on SkyDrive - Page 761
Opening Office Files Stored on SkyDrive - Page 762
Downloading Files from SkyDrive to Your Computer - Page 763
Downloading Files from SkyDrive to Your Computer - Page 764
Chapter 3: Sharing and Collaborating - Page 765
Chapter 3: Sharing and Collaborating - Page 766
Sharing Your Files and Folders with Others - Page 767
Sharing Your Files and Folders with Others - Page 768
Seeing Files and Folders Others Shared with You - Page 769
Seeing Files and Folders Others Shared with You - Page 770
Co-editing Shared Files on SkyDrive - Page 771
Co-editing Shared Files on SkyDrive - Page 772
Co-editing Shared Files on SkyDrive - Page 773