Microsoft Office 2013

Part I: Common Office Features - Page 31
Part I: Common Office Features - Page 32
Chapter 1: Welcome to Microsoft Office 2013 - Page 33
Word - Page 34
Word - Page 35
Excel - Page 36
Excel - Page 37
Excel - Page 38
PowerPoint - Page 39
Outlook - Page 40
Taking Advantage of Other Office Applications - Page 41
Taking Advantage of Other Office Applications - Page 42
Access - Page 43
OneNote - Page 44
Previewing New Features - Page 45
Previewing New Features - Page 46
Starting an Application - Page 47
Starting an Application - Page 48
Closing an Application - Page 49
Finding Files - Page 50
Finding Files - Page 51
Getting Help - Page 52
Searching Office.com - Page 53
Searching Office.com - Page 54
Summary - Page 55
Summary - Page 56
Chapter 2: Navigating in Office - Page 57
Chapter 2: Navigating in Office - Page 58
Your Interface to Faster File Creation - Page 59
Your Interface to Faster File Creation - Page 60
Using an Application Start Screen - Page 61
Title bar - Page 62
Ribbon - Page 63
Ribbon - Page 64
Ribbon - Page 65
Ribbon - Page 66
Quick Access Toolbar - Page 67
Quick Access Toolbar - Page 68
Galleries and Live Preview - Page 69
Galleries and Live Preview - Page 70
The MiniBar or Mini Toolbar - Page 71
Shortcut menus and contextual command buttons - Page 72
Shortcut menus and contextual command buttons - Page 73
Enhanced ScreenTips - Page 74
Task panes or panes - Page 75
Task panes or panes - Page 76
Status bar - Page 77
Exploring the File Tab - Page 78
Exploring the File Tab - Page 79
Displaying and closing the tab - Page 80
Displaying and closing the tab - Page 81
Controlling the Ribbon Display - Page 82
Gestures and Touch Navigation - Page 83
Setting Application Options - Page 84
Finding the option you want - Page 85
Finding the option you want - Page 86
Working with Dialog Boxes - Page 87
Navigating dialog boxes - Page 88
Summary - Page 89
Summary - Page 90
Chapter 3: Mastering Fundamental Operations - Page 91
Understanding Office 2013 file formats - Page 92
Creating a new, blank file - Page 93
Creating a new, blank file - Page 94
Creating a file with a document template - Page 95
Creating a file with a document template - Page 96
Creating a file with a document template - Page 97
Saving and naming a file - Page 98
Saving and naming a file - Page 99
Saving and naming a file - Page 100
Opening a file - Page 101
Opening a file - Page 102
Closing a file - Page 103
Printing a File - Page 104
Performing a basic preview and print - Page 105
Performing a basic preview and print - Page 106
Understanding page design settings - Page 107
Understanding page design settings - Page 108
Choosing print settings and printing - Page 109
Choosing print settings and printing - Page 110
Choosing print settings and printing - Page 111
Working with Multiple Windows - Page 112
Arranging windows - Page 113
Moving and Copying Information - Page 114
Selecting information - Page 115
Copying - Page 116
Cutting - Page 117
Cutting - Page 118
Cutting - Page 119
Undoing and Redoing Actions - Page 120
Finding and Replacing - Page 121
Finding and Replacing - Page 122
Using Go To - Page 123
Using Go To - Page 124
Using Go To - Page 125
AutoCorrect, AutoFormat, and Actions - Page 126
AutoCorrect, AutoFormat, and Actions - Page 127
Styles and Live Preview - Page 128
Working with User Accounts - Page 129
Summary - Page 130
Part II: Creating Documents with Word 2013 - Page 131
Part II: Creating Documents with Word 2013 - Page 132
Chapter 4: Diving Into Document Creation - Page 133
Typing text - Page 134
Using word wrap - Page 135
Inserting versus overtyping - Page 136
Using default tabs - Page 137
Reviewing available document templates - Page 138
Reviewing available document templates - Page 139
Reviewing available document templates - Page 140
Creating the file from the template - Page 141
Working with template content - Page 142
Opening an Existing File - Page 143
Opening an Existing File - Page 144
Opening an Existing File - Page 145
Saving and File Formats - Page 146
Converting to another format - Page 147
Converting to another format - Page 148
Converting to another format - Page 149
Compatibility with Previous Versions of Word - Page 150
Understanding .docx - Page 151
Choosing between .doc and .docx - Page 152
Persistent Save As - Page 153
Microsoft Office Compatibility Pack - Page 154
Navigation and Selection Tips and Tricks - Page 155
Selecting text - Page 156
Using the Navigation pane - Page 157
Using the Navigation pane - Page 158
Keyboard shortcuts - Page 159
Keyboard shortcuts - Page 160
Choosing the Right Word View for the Task at Hand - Page 161
Draft view - Page 162
Read Mode and object zoom - Page 163
Read Mode and object zoom - Page 164
Web Layout - Page 165
Outline (Master Document tools) - Page 166
Resume Reading - Page 167
Summary - Page 168
Chapter 5: Font/Character Formatting - Page 169
Formatting Characters Directly or with Styles - Page 170
Formatting Characters Directly or with Styles - Page 171
Formatting Characters Directly or with Styles - Page 172
Applying Character Formatting - Page 173
Applying Character Formatting - Page 174
Applying Character Formatting - Page 175
Applying Character Formatting - Page 176
Using the Font group on the Home tab - Page 177
Using the Font group on the Home tab - Page 178
Using the Font group on the Home tab - Page 179
Using the Font group on the Home tab - Page 180
Using the Font group on the Home tab - Page 181
Using the Font group on the Home tab - Page 182
Using the Font group on the Home tab - Page 183
Using the Font group on the Home tab - Page 184
Using the Font group on the Home tab - Page 185
Using the Font group on the Home tab - Page 186
Formatting via the Font dialog box - Page 187
Formatting via the Font dialog box - Page 188
Formatting via the Font dialog box - Page 189
Formatting via the Font dialog box - Page 190
Text Effects and Typography - Page 191
Character formatting keyboard shortcuts - Page 192
Summary - Page 193
Summary - Page 194
Chapter 6: Paragraph Formatting - Page 195
Finding Paragraph Formatting Tools - Page 196
Finding Paragraph Formatting Tools - Page 197
Finding Paragraph Formatting Tools - Page 198
Paragraph formatting attributes - Page 199
Paragraph formatting attributes - Page 200
Paragraph formatting attributes - Page 201
Paragraph formatting techniques - Page 202
Paragraph formatting techniques - Page 203
Paragraph formatting techniques - Page 204
Changing text alignment - Page 205
Changing spacing - Page 206
Changing spacing - Page 207
Setting and using tabs - Page 208
Setting and using tabs - Page 209
Setting and using tabs - Page 210
Setting and using tabs - Page 211
Setting Off Text with Paragraph Decoration - Page 212
Setting Off Text with Paragraph Decoration - Page 213
Line and page break controls - Page 214
Line and page break controls - Page 215
Shading paragraphs - Page 216
Borders and boxes - Page 217
Borders and boxes - Page 218
Caveats for printing and viewing - Page 219
Summary - Page 220
Chapter 7: Using Styles to Create a Great Looking Document - Page 221
Chapter 7: Using Styles to Create a Great Looking Document - Page 222
Chapter 7: Using Styles to Create a Great Looking Document - Page 223
Applying styles from the Style gallery - Page 224
Applying styles from the Style gallery - Page 225
Applying styles using the Styles pane - Page 226
Applying styles using the Styles pane - Page 227
Applying styles using the Styles pane - Page 228
Reapplying or resetting a style - Page 229
Clearing all styles from selected text - Page 230
Clearing all styles from selected text - Page 231
Creating a style from scratch - Page 232
Creating a style from scratch - Page 233
Changing the Whole Document via Style Sets - Page 234
Changing the Whole Document via Style Sets - Page 235
Changing the Whole Document via Style Sets - Page 236
Changing the Whole Document via Style Sets - Page 237
Changing your mind - Page 238
Removing a style from the gallery - Page 239
Restricted styles - Page 240
Restricted styles - Page 241
Deleting a style - Page 242
Summary - Page 243
Summary - Page 244
Chapter 8: Controlling Document Appearance with Sections and More - Page 245
Changing Basic Page Setup - Page 246
Margins - Page 247
Orientation - Page 248
Size - Page 249
Size - Page 250
Section Formatting - Page 251
Section breaks overview - Page 252
Automatic section breaks - Page 253
Styles, section formatting, and paragraph formatting - Page 254
Styles, section formatting, and paragraph formatting - Page 255
Page layout within a section - Page 256
Page layout within a section - Page 257
Page layout within a section - Page 258
Page layout within a section - Page 259
Headers and Footers Overview - Page 260
Coordinating headers and footers and document sections - Page 261
Header and Footer Navigation and Design - Page 262
Editing in the header and footer areas - Page 263
Link to Previous - Page 264
Different Odd & Even Pages - Page 265
Show Document Text - Page 266
Page numbers - Page 267
Page numbers - Page 268
Adding document information - Page 269
Adding side margin material - Page 270
Adding header and footer graphics - Page 271
Adding header and footer graphics - Page 272
Adding header and footer graphics - Page 273
Adding a line between columns - Page 274
Changing columns using section breaks - Page 275
Balancing columns - Page 276
Adding and Removing Page Borders - Page 277
Adding and Removing Page Borders - Page 278
Working More Effectively with Themes - Page 279
Understanding and applying themes - Page 280
Understanding and applying themes - Page 281
Understanding and applying themes - Page 282
Theme elements or components - Page 283
Theme elements or components - Page 284
Theme elements or components - Page 285
Style sets and paragraph spacing - Page 286
Saving custom themes - Page 287
Setting the default theme - Page 288
Chapter 9: Adding Tables and Graphics to a Document - Page 289
Table Basics - Page 290
Inserting a table from scratch - Page 291
Inserting a table from scratch - Page 292
Managing AutoFit behavior - Page 293
Inserting a table based on existing content - Page 294
Inserting a table based on existing content - Page 295
Inserting a table based on existing content - Page 296
Selecting, copying, and moving in tables - Page 297
Selecting, copying, and moving in tables - Page 298
Selecting, copying, and moving in tables - Page 299
Changing table properties - Page 300
Changing table properties - Page 301
Changing table properties - Page 302
Changing table properties - Page 303
Working with Table Layout and Design - Page 304
Working with Table Layout and Design - Page 305
Working with Table Layout and Design - Page 306
Working with Table Layout and Design - Page 307
Working with Table Layout and Design - Page 308
Working with Table Layout and Design - Page 309
Working with Table Layout and Design - Page 310
Working with Table Layout and Design - Page 311
Working with Table Layout and Design - Page 312
Adding table calculations - Page 313
Adding table calculations - Page 314
Modifying table design - Page 315
Modifying table design - Page 316
Modifying table design - Page 317
Modifying table design - Page 318
Modifying table design - Page 319
Modifying table design - Page 320
Modifying table design - Page 321
Adding a Shape - Page 322
Inserting a Picture from a File - Page 323
Adding the picture - Page 324
Adding the picture - Page 325
Supported picture file formats - Page 326
Adding an Online Picture - Page 327
Adding an Online Picture - Page 328
Pasting or Snapping a Picture - Page 329
Taking a screen shot - Page 330
Manipulating Inserted Pictures (and Other Graphics) - Page 331
Manipulating Inserted Pictures (and Other Graphics) - Page 332
Manipulating Inserted Pictures (and Other Graphics) - Page 333
Manipulating Inserted Pictures (and Other Graphics) - Page 334
Manipulating Inserted Pictures (and Other Graphics) - Page 335
Moving a graphic - Page 336
Resizing, rotating, and cropping a picture - Page 337
Resizing, rotating, and cropping a picture - Page 338
Resizing, rotating, and cropping a picture - Page 339
Formatting a picture or shape - Page 340
Formatting a picture or shape - Page 341
Formatting a picture or shape - Page 342
Formatting a picture or shape - Page 343
Formatting a picture or shape - Page 344
Creating WordArt - Page 345
Creating WordArt from scratch - Page 346
Creating WordArt from selected text - Page 347
Creating WordArt from selected text - Page 348
Creating WordArt from selected text - Page 349
Inserting SmartArt - Page 350
Inserting SmartArt - Page 351
Changing layout, style, and colors - Page 352
Adding a shape - Page 353
Arranging Pictures and Other Objects - Page 354
Using the Selection Pane - Page 355
Summary - Page 356
Chapter 10: Data Documents and Mail Merge - Page 357
Data Considerations - Page 358
Reviewing Data File Formats - Page 359
Reviewing Data File Formats - Page 360
Typing a new list - Page 361
Typing a new list - Page 362
Typing a new list - Page 363
Word and text files - Page 364
Word and text files - Page 365
Word and text files - Page 366
Outlook - Page 367
Excel - Page 368
Access - Page 369
Choosing the Data Document Type - Page 370
Restoring a Word document to Normal - Page 371
Attaching a Data Source - Page 372
Selecting recipients - Page 373
Selecting recipients - Page 374
Selecting recipients - Page 375
Selecting recipients - Page 376
Assembling a Merge Document - Page 377
Adding merge fields - Page 378
Adding merge fields - Page 379
Adding merge fields - Page 380
Adding merge fields - Page 381
Rules - Page 382
Rules - Page 383
Update Labels - Page 384
Preview Results - Page 385
Find Recipient - Page 386
Highlight Merge Fields - Page 387
Check for Errors - Page 388
Finishing the merge - Page 389
Finishing the merge - Page 390
Mail Merge Pane/Wizard - Page 391
Step 1: Select document type - Page 392
Step 3: Select recipients - Page 393
Step 4: Write your letter - Page 394
Step 5: Preview your letters - Page 395
Summary - Page 396
Chapter 11: Managing Document Security, Comments, and Tracked Changes - Page 397
Chapter 11: Managing Document Security, Comments, and Tracked Changes - Page 398
Using digital signatures - Page 399
Using digital signatures - Page 400
Using digital signatures - Page 401
Using digital signatures - Page 402
Using digital signatures - Page 403
Using digital signatures - Page 404
Document Inspector (removing private/personal information) - Page 405
Document Inspector (removing private/personal information) - Page 406
Formatting and editing restrictions - Page 407
Formatting and editing restrictions - Page 408
Formatting and editing restrictions - Page 409
Formatting and editing restrictions - Page 410
Applying a password to open/modify a Word document - Page 411
Applying a password to open/modify a Word document - Page 412
Comments and Tracked Changes - Page 413
Comments and Tracked Changes - Page 414
Comments and Tracked Changes - Page 415
Tracking changes by various editors - Page 416
Tracking changes by various editors - Page 417
Show Markup - Page 418
Display for Review - Page 419
Combining Collaborative Documents - Page 420
Comparing Documents - Page 421
Comparing Documents - Page 422
Comparing Documents - Page 423
Protection - Page 424
Combining multiple documents containing changes - Page 425
Running the Combine Documents command - Page 426
Running the Combine Documents command - Page 427
Running the Combine Documents command - Page 428
Part III: Making the Numbers Work with Excel 2013 - Page 429
Part III: Making the Numbers Work with Excel 2013 - Page 430
Chapter 12: Using Excel Worksheets and Workbooks - Page 431
Seeing What’s New in Excel 2013 - Page 432
Understanding Workbooks and Worksheets - Page 433
Understanding Workbooks and Worksheets - Page 434
Understanding Workbooks and Worksheets - Page 435
Moving around a Worksheet - Page 436
Navigating with your keyboard - Page 437
Introducing Excel’s Ribbon Tabs - Page 438
Ribbon tabs - Page 439
Contextual tabs - Page 440
Creating Your First Excel Workbook - Page 441
Entering the sales data - Page 442
Formatting the numbers - Page 443
Summing the values - Page 444
Printing your worksheet - Page 445
Saving your workbook - Page 446
Summary - Page 447
Summary - Page 448
Cahapter 13: Entering and Editing Worksheet Data - Page 449
Understanding text entries - Page 450
Understanding formulas - Page 451
Understanding formulas - Page 452
Entering Dates and Times into Your Worksheets - Page 453
Entering time values - Page 454
Replacing the contents of a cell - Page 455
Replacing the contents of a cell - Page 456
Learning some handy data-entry techniques - Page 457
Learning some handy data-entry techniques - Page 458
Learning some handy data-entry techniques - Page 459
Learning some handy data-entry techniques - Page 460
Learning some handy data-entry techniques - Page 461
Learning some handy data-entry techniques - Page 462
Learning some handy data-entry techniques - Page 463
Learning some handy data-entry techniques - Page 464
Learning some handy data-entry techniques - Page 465
Learning some handy data-entry techniques - Page 466
Applying Number Formatting - Page 467
Using automatic number formatting - Page 468
Using keyboard shortcuts to format numbers - Page 469
Using keyboard shortcuts to format numbers - Page 470
Using keyboard shortcuts to format numbers - Page 471
Summary - Page 472
Chapter 14: Essential Worksheet and Cell Range Operations - Page 473
Working with Excel windows - Page 474
Working with Excel windows - Page 475
Activating a worksheet - Page 476
Adding a new worksheet to your workbook - Page 477
Changing the name of a worksheet - Page 478
Rearranging your worksheets - Page 479
Hiding and unhiding a worksheet - Page 480
Controlling the Worksheet View - Page 481
Viewing a worksheet in multiple windows - Page 482
Viewing a worksheet in multiple windows - Page 483
Comparing sheets side by side - Page 484
Keeping the titles in view by freezing panes - Page 485
Keeping the titles in view by freezing panes - Page 486
Monitoring cells with a Watch Window - Page 487
Working with Rows and Columns - Page 488
Deleting rows and columns - Page 489
Hiding rows and columns - Page 490
Hiding rows and columns - Page 491
Understanding Cells and Ranges - Page 492
Understanding Cells and Ranges - Page 493
Selecting complete rows and columns - Page 494
Selecting noncontiguous ranges - Page 495
Selecting multisheet ranges - Page 496
Selecting multisheet ranges - Page 497
Selecting special types of cells - Page 498
Selecting special types of cells - Page 499
Selecting cells by searching - Page 500
Selecting cells by searching - Page 501
Copying or Moving Ranges - Page 502
Copying by using Ribbon commands - Page 503
Copying by using Ribbon commands - Page 504
Copying or moving by using drag-and-drop - Page 505
Copying to adjacent cells - Page 506
Using the Office Clipboard to paste - Page 507
Using the Office Clipboard to paste - Page 508
Pasting in special ways - Page 509
Using the Paste Special dialog box - Page 510
Using the Paste Special dialog box - Page 511
Using the Paste Special dialog box - Page 512
Using Names to Work with Ranges - Page 513
Using Names to Work with Ranges - Page 514
Using Names to Work with Ranges - Page 515
Managing names - Page 516
Adding Comments to Cells - Page 517
Formatting comments - Page 518
Working further with comments - Page 519
Summary - Page 520
Chapter 15: Introducing Formulas and Functions - Page 521
Using operators in formulas - Page 522
Understanding operator precedence in formulas - Page 523
Understanding operator precedence in formulas - Page 524
Using functions in your formulas - Page 525
Using functions in your formulas - Page 526
Using functions in your formulas - Page 527
Entering Formulas into Your Worksheets - Page 528
Entering Formulas into Your Worksheets - Page 529
Entering formulas manually - Page 530
Pasting range names into formulas - Page 531
Inserting functions into formulas - Page 532
Inserting functions into formulas - Page 533
Function entry tips - Page 534
Using Cell References in Formulas - Page 535
Using Cell References in Formulas - Page 536
Using Cell References in Formulas - Page 537
Changing the types of your references - Page 538
Changing the types of your references - Page 539
Using Formulas in Tables - Page 540
Using Formulas in Tables - Page 541
Using formulas within a table - Page 542
Referencing data in a table - Page 543
Correcting Common Formula Errors - Page 544
Handling circular references - Page 545
Handling circular references - Page 546
Specifying when formulas are calculated - Page 547
Tips for Working with Formulas - Page 548
Making an exact copy of a formula - Page 549
Summary - Page 550
Chapter 16: Working with Dates and Times - Page 551
Entering dates - Page 552
Entering dates - Page 553
Understanding time serial numbers - Page 554
Entering times - Page 555
Formatting dates and times - Page 556
Problems with dates - Page 557
Problems with dates - Page 558
Date-Related Worksheet Functions - Page 559
Displaying the current date - Page 560
Displaying any date - Page 561
Displaying any date - Page 562
Converting a nondate string to a date - Page 563
Calculating the number of workdays between two dates - Page 564
Offsetting a date using only workdays - Page 565
Calculating the number of years between two dates - Page 566
Calculating a person’s age - Page 567
Determining the day of the year - Page 568
Determining the day of the week - Page 569
Determining the first day of the week after a date - Page 570
Determining the first day of the week after a date - Page 571
Determining the first day of the week after a date - Page 572
Determining the last day of a month - Page 573
Determining a date’s quarter - Page 574
Displaying any time - Page 575
Calculating the difference between two times - Page 576
Summing times that exceed 24 hours - Page 577
Summing times that exceed 24 hours - Page 578
Converting from military time - Page 579
Converting decimal hours, minutes, or seconds to a time - Page 580
Rounding time values - Page 581
Summary - Page 582
Summary - Page 583
Summary - Page 584
Chapter 17: Creating Formulas That Count and Sum - Page 585
Chapter 17: Creating Formulas That Count and Sum - Page 586
Basic Counting Formulas - Page 587
Counting the total number of cells - Page 588
Counting nonblank cells - Page 589
Counting nontext cells - Page 590
Counting cells by using the COUNTIF function - Page 591
Counting cells based on multiple criteria - Page 592
Counting cells based on multiple criteria - Page 593
Counting cells based on multiple criteria - Page 594
Counting the most frequently occurring entry - Page 595
Counting the occurrences of specific text - Page 596
Counting the number of unique values - Page 597
Creating a frequency distribution - Page 598
Creating a frequency distribution - Page 599
Creating a frequency distribution - Page 600
Creating a frequency distribution - Page 601
Creating a frequency distribution - Page 602
Summing Formulas - Page 603
Computing a cumulative sum - Page 604
Ignoring errors when summing - Page 605
Summing the “top n” values - Page 606
Conditional Sums Using a Single Criterion - Page 607
Summing values based on a different range - Page 608
Conditional Sums Using Multiple Criteria - Page 609
Using Or criteria - Page 610
Using Or criteria - Page 611
Using Or criteria - Page 612
Chapter 18: Getting Started Making Charts - Page 613
Understanding How Excel Handles Charts - Page 614
Embedded charts - Page 615
Chart sheets - Page 616
Chart sheets - Page 617
Creating a Chart - Page 618
Hands On: Creating and Customizing a Chart - Page 619
Choosing a chart type - Page 620
Experimenting with different styles - Page 621
Experimenting with different styles - Page 622
Trying another view of the data - Page 623
Trying another view of the data - Page 624
Working with Charts - Page 625
Resizing a chart - Page 626
Deleting a chart - Page 627
Deleting a chart - Page 628
Printing charts - Page 629
Understanding Chart Types - Page 630
Understanding Chart Types - Page 631
Summary - Page 632
Chapter 19: Communicating Data Visually - Page 633
Chapter 19: Communicating Data Visually - Page 634
Chapter 19: Communicating Data Visually - Page 635
Changing the Look of a Table - Page 636
Changing the Look of a Table - Page 637
Working with Tables - Page 638
Adding new rows or columns - Page 639
Deleting rows or columns - Page 640
Deleting rows or columns - Page 641
Removing duplicate rows from a table - Page 642
Sorting and filtering a table - Page 643
Sorting and filtering a table - Page 644
Sorting and filtering a table - Page 645
Converting a table back to a range - Page 646
Converting a table back to a range - Page 647
Specifying Conditional Formatting - Page 648
Making your own rules - Page 649
Conditional Formats That Use Graphics - Page 650
Conditional Formats That Use Graphics - Page 651
Using color scales - Page 652
Using color scales - Page 653
Using icon sets - Page 654
Using icon sets - Page 655
Using icon sets - Page 656
Creating Formula-Based Rules - Page 657
Understanding relative and absolute references - Page 658
Conditional formatting formula examples - Page 659
Conditional formatting formula examples - Page 660
Conditional formatting formula examples - Page 661
Working with Conditional Formats - Page 662
Copying cells that contain conditional formatting - Page 663
Locating cells that contain conditional formatting - Page 664
Sparkline Types - Page 665
Creating Sparklines - Page 666
Creating Sparklines - Page 667
Customizing Sparklines - Page 668
Handling hidden or missing data - Page 669
Highlighting certain data points - Page 670
Specifying a Date Axis - Page 671
Auto-Updating Sparklines - Page 672
Displaying a Sparkline for a Dynamic Range - Page 673
Summary - Page 674
Part IV: Persuading and Informing with PowerPoint 2013 - Page 675
Part IV: Persuading and Informing with PowerPoint 2013 - Page 676
Chapter 20: A First Look at PowerPoint 2013 - Page 677
Chapter 20: A First Look at PowerPoint 2013 - Page 678
Chapter 20: A First Look at PowerPoint 2013 - Page 679
What’s New in PowerPoint 2013? - Page 680
Improved shape merging - Page 681
Improved Smart Guides - Page 682
Improved comments - Page 683
Online pictures and videos - Page 684
. . . And other new features - Page 685
Starting and Exiting PowerPoint - Page 686
Changing the View - Page 687
Changing the View - Page 688
Normal and Outline views - Page 689
Slide Sorter view - Page 690
Slide Show view and Reading views - Page 691
Slide Show view and Reading views - Page 692
Notes Page view - Page 693
Zooming In and Out - Page 694
Enabling Optional Display Elements - Page 695
Gridlines - Page 696
Guides - Page 697
Color/Grayscale/Pure Black and White views - Page 698
Arranging windows - Page 699
Arranging windows - Page 700
Chapter 21: Creating a Presentation, Slides, and Text - Page 701
Starting a New Presentation - Page 702
Starting a presentation from a template - Page 703
Using a personal template - Page 704
Using a personal template - Page 705
Basing a new presentation on existing content - Page 706
Saving Your Work - Page 707
Saving for the first time - Page 708
Saving for the first time - Page 709
Saving subsequent times - Page 710
Saving subsequent times - Page 711
Saving in a different format - Page 712
Saving in a different format - Page 713
Saving in a different format - Page 714
Saving in a different format - Page 715
Saving in a different format - Page 716
Specifying save options - Page 717
Specifying save options - Page 718
Specifying save options - Page 719
Setting Passwords for File Access - Page 720
Closing and Reopening Presentations - Page 721
Opening a presentation - Page 722
Opening a presentation - Page 723
Opening a file from a different program - Page 724
Opening a file from a different program - Page 725
Finding a presentation file to open - Page 726
Setting File Properties - Page 727
Creating New Slides - Page 728
Creating new slides from Outline view - Page 729
Creating a slide from the Thumbnails pane - Page 730
Creating a slide from a layout - Page 731
Copying slides - Page 732
Inserting Content from External Sources - Page 733
Copying slides from other presentations - Page 734
Inserting new slides from an outline - Page 735
Inserting new slides from an outline - Page 736
Inserting new slides from an outline - Page 737
Opening a Word document as a new presentation - Page 738
Managing Slides - Page 739
Managing Slides - Page 740
Deleting slides - Page 741
Deleting slides - Page 742
Rearranging slides - Page 743
Using Content Placeholders - Page 744
Inserting content into a placeholder - Page 745
Inserting content into a placeholder - Page 746
When should you use a manual text box? - Page 747
Working with Text Boxes - Page 748
Sizing a text box - Page 749
Positioning a text box - Page 750
Changing a text box’s AutoFit behavior - Page 751
Changing a text box’s AutoFit behavior - Page 752
Summary - Page 753
Summary - Page 754
Chapter 22: Working with Layouts, Themes, and Masters - Page 755
Understanding Layouts and Themes - Page 756
Where themes are stored - Page 757
Themes, layouts, and Slide Master view - Page 758
Changing a Slide’s Layout - Page 759
Changing a Slide’s Layout - Page 760
Applying a Theme - Page 761
Applying a theme from the gallery - Page 762
Applying a theme from a theme or template file - Page 763
Applying a theme variant - Page 764
Managing Themes - Page 765
Renaming a theme - Page 766
Deleting a theme - Page 767
Copying a theme from another presentation - Page 768
Changing the color theme - Page 769
Changing the color theme - Page 770
Understanding font placeholders - Page 771
Changing the effect theme - Page 772
Changing the effect theme - Page 773
Creating a custom color theme - Page 774
Creating a custom color theme - Page 775
Creating a custom font theme - Page 776
Sharing a custom color or font theme with others - Page 777
Changing the Background - Page 778
Applying a background style - Page 779
Applying a custom background fill - Page 780
Working with background graphics - Page 781
Working with background graphics - Page 782
Working with Placeholders - Page 783
Formatting a placeholder - Page 784
Moving, deleting, or restoring placeholders - Page 785
Displaying the date, number, and footer on slides - Page 786
Displaying the date, number, and footer on slides - Page 787
Customizing and Creating Layouts - Page 788
Adding a custom placeholder - Page 789
Deleting and restoring a custom placeholder - Page 790
Creating a new layout - Page 791
Duplicating and deleting layouts - Page 792
Creating and deleting slide masters - Page 793
Preserving a slide master - Page 794
Summary - Page 795
Summary - Page 796
Chapter 23: Working with Tables and Charts - Page 797
Creating a New Table - Page 798
Creating a Table from the Table button - Page 799
Drawing a table - Page 800
Moving around in a Table - Page 801
Selecting Rows, Columns, and Cells - Page 802
Editing a Table’s Structure - Page 803
Editing a Table’s Structure - Page 804
Inserting or deleting rows and columns - Page 805
Merging and splitting cells - Page 806
Merging and splitting cells - Page 807
Formatting Table Cells - Page 808
Table margins and alignment - Page 809
Applying borders - Page 810
Applying fills - Page 811
Applying fills - Page 812
Applying fills - Page 813
Applying fills - Page 814
Applying a shadow to a table - Page 815
Applying a 3-D effect to a table - Page 816
Changing text alignment - Page 817
Changing text direction - Page 818
Understanding Charts - Page 819
Starting a New Chart - Page 820
Starting a New Chart - Page 821
Starting a New Chart - Page 822
Starting a New Chart - Page 823
Working with Chart Data - Page 824
Redefining the data range - Page 825
Redefining the data range - Page 826
Filtering the chart data - Page 827
Chart Types and Chart Layout Presets - Page 828
Working with Chart Elements - Page 829
Working with Chart Elements - Page 830
Working with Chart Elements - Page 831
Working with chart titles - Page 832
Working with axis titles - Page 833
Working with axis titles - Page 834
Working with legends - Page 835
Working with legends - Page 836
Adding data labels - Page 837
Adding data labels - Page 838
Adding data labels - Page 839
Adding a data table - Page 840
Controlling the Axes - Page 841
Setting axis scale options - Page 842
Setting axis scale options - Page 843
Setting axis scale options - Page 844
Setting axis scale options - Page 845
Setting a number format - Page 846
Formatting a Chart - Page 847
Formatting a Chart - Page 848
Formatting a Chart - Page 849
Formatting a Chart - Page 850
Applying chart styles - Page 851
Formatting the chart area and plot area - Page 852
Formatting the legend - Page 853
Formatting gridlines and walls - Page 854
Formatting the data series - Page 855
Rotating a 3-D Chart - Page 856
Rotating a 3-D Chart - Page 857
Summary - Page 858
Chapter 24: Using SmartArt Diagrams, Clip Art, and Pictures - Page 859
List - Page 860
Process - Page 861
Hierarchy - Page 862
Relationship - Page 863
Pyramid - Page 864
Picture - Page 865
Editing SmartArt Text - Page 866
Modifying SmartArt Structure - Page 867
Adding bullets - Page 868
Promoting and demoting text - Page 869
Resetting a SmartArt graphic - Page 870
Modifying a Hierarchy Graphic Structure - Page 871
Changing a person’s level in the organization - Page 872
Controlling subordinate layout options - Page 873
Formatting a SmartArt Graphic - Page 874
Changing SmartArt colors - Page 875
Manually applying colors and effects to individual shapes - Page 876
Making a shape larger or smaller - Page 877
Editing in 2-D - Page 878
Changing the shapes used - Page 879
Choosing Appropriate Artwork - Page 880
Choosing Appropriate Artwork - Page 881
Choosing Appropriate Artwork - Page 882
Browsing clips at Office.com - Page 883
Browsing clips at Office.com - Page 884
Browsing clips at Office.com - Page 885
Modifying clip art - Page 886
Modifying clip art - Page 887
Modifying clip art - Page 888
Understanding Raster Graphics - Page 889
Resolution - Page 890
Resolution - Page 891
Resolution - Page 892
Color depth - Page 893
File format - Page 894
File format - Page 895
Inserting Photos - Page 896
Inserting pictures from files - Page 897
Linking to a graphic file - Page 898
Capturing and inserting screenshots - Page 899
Capturing and inserting screenshots - Page 900
Sizing and Cropping Photos - Page 901
Cropping a photo - Page 902
Cropping a photo - Page 903
Cropping a photo - Page 904
Cropping a photo - Page 905
Resetting a photo - Page 906
Resetting a photo - Page 907
Recoloring a picture - Page 908
Recoloring a picture - Page 909
Setting a transparent color and removing a background - Page 910
Setting a transparent color and removing a background - Page 911
Applying artistic effects - Page 912
Applying picture styles and effects - Page 913
Compressing Images - Page 914
Reducing resolution and compressing images in PowerPoint - Page 915
Reducing resolution with a third-party utility - Page 916
Reducing resolution with a third-party utility - Page 917
Reducing resolution with a third-party utility - Page 918
Chapter 25: Building Animation Effects, Transitions, and Support Materials - Page 919
Assigning Transitions to Slides - Page 920
Assigning Transitions to Slides - Page 921
Assigning Transitions to Slides - Page 922
More about transition sounds - Page 923
More about transition sounds - Page 924
Rehearsing and recording transition timings - Page 925
Animating Slide Content - Page 926
Animating Slide Content - Page 927
Choosing an animation effect - Page 928
Choosing an animation effect - Page 929
Changing an effect’s options - Page 930
Animating parts of a chart - Page 931
Animating parts of a chart - Page 932
Animating parts of a chart - Page 933
Animating parts of a chart - Page 934
The When and How of Handouts - Page 935
Creating Handouts - Page 936
Printing handouts - Page 937
Printing handouts - Page 938
Printing handouts - Page 939
Setting printer-specific options - Page 940
Setting printer-specific options - Page 941
Setting printer-specific options - Page 942
Using the Handout Master - Page 943
Using the Handout Master - Page 944
Using the Handout Master - Page 945
Using the Handout Master - Page 946
Formatting handouts - Page 947
Creating Speaker Notes - Page 948
Typing speaker notes - Page 949
Changing the notes page layout - Page 950
Printing notes pages - Page 951
Printing Slides - Page 952
Chapter 26: Delivering a Live Presentation - Page 953
Starting and Ending a Show - Page 954
Starting and Ending a Show - Page 955
Moving from slide to slide - Page 956
Jumping to specific slides - Page 957
Blanking the screen - Page 958
Using the On-Screen Pen - Page 959
Using the On-Screen Pen - Page 960
Hiding Slides for Backup Use - Page 961
Hiding and unhiding slides - Page 962
Using Custom Shows - Page 963
Using Custom Shows - Page 964
Using Custom Shows - Page 965
Ideas for using custom shows - Page 966
Editing custom shows - Page 967
Copying custom shows - Page 968
Displaying a custom show - Page 969
Displaying a custom show - Page 970
Displaying a custom show - Page 971
Using a custom show as the main presentation - Page 972
Giving a Presentation on a Different Computer - Page 973
Copying a presentation to CD - Page 974
Copying a presentation to CD - Page 975
Creating a CD containing multiple presentation files - Page 976
Setting copy options - Page 977
Copying a presentation to other locations - Page 978
Copying a presentation to other locations - Page 979
Working with Audio-Visual Equipment - Page 980
Presenting with two screens - Page 981
Presenting with two screens - Page 982
Setting up a presentation for two screens - Page 983
Presenting with two screens using Presenter View - Page 984
Presenting with two screens using Presenter View - Page 985
Summary - Page 986
Part V: Organizing Messages, Contacts, and Time with Outlook - Page 987
Part V: Organizing Messages, Contacts, and Time with Outlook - Page 988
Chapter 27: Fundamentals of E-mail - Page 989
Setting Up Your E-mail Accounts - Page 990
Setting Up Your E-mail Accounts - Page 991
Manual e-mail account setup (POP and IMAP) - Page 992
Manual e-mail account setup (POP and IMAP) - Page 993
Manual e-mail account setup (POP and IMAP) - Page 994
Manual e-mail account setup (POP and IMAP) - Page 995
Manual e-mail account setup (POP and IMAP) - Page 996
Manual e-mail account setup (POP and IMAP) - Page 997
Manual e-mail account setup (Exchange Server) - Page 998
Manual e-mail account setup (Exchange Server) - Page 999
Manual e-mail account setup (web) - Page 1000
Modifying Account Settings - Page 1001
Using Outlook Profiles - Page 1002
Understanding profiles - Page 1003
Switching profiles - Page 1004
Switching profiles - Page 1005
Message addressing options - Page 1006
Entering recipients manually - Page 1007
Entering recipients manually - Page 1008
Sending attachments - Page 1009
Sending attachments - Page 1010
Reading and Replying to Messages - Page 1011
Reading a message - Page 1012
Reading a message - Page 1013
Reading a message - Page 1014
Replying to and forwarding messages - Page 1015
Working with received attachments - Page 1016
Working with received attachments - Page 1017
Working with received attachments - Page 1018
Understanding the Inbox Display - Page 1019
Understanding Files and Folders - Page 1020
Outlook Data Files - Page 1021
Outlook’s default folders - Page 1022
Outlook’s default folders - Page 1023
Outlook’s default folders - Page 1024
Creating a new non–e-mail folder - Page 1025
Creating a new non–e-mail folder - Page 1026
Organizing folders in groups - Page 1027
Working with folders, groups, and items - Page 1028
Working with folders, groups, and items - Page 1029
Deleting Items and Using the Deleted Items Folder - Page 1030
Setting Options for an Individual E-mail Message - Page 1031
Sending items with a message - Page 1032
Sending items with a message - Page 1033
Sending items with a message - Page 1034
Setting message importance and sensitivity - Page 1035
Requesting delivery and read receipts - Page 1036
Setting Global E-mail Options - Page 1037
Setting Global E-mail Options - Page 1038
Summary - Page 1039
Summary - Page 1040
Chapter 28: Processing and Securing E-mail - Page 1041
Understanding Junk E-mail Filtering - Page 1042
Understanding Junk E-mail Filtering - Page 1043
Blocking and Allowing Specific Addresses - Page 1044
Blocking and Allowing Specific Addresses - Page 1045
Blocking/allowing individual senders - Page 1046
International junk e-mail options - Page 1047
Understanding E-mail Rule Basics - Page 1048
Selecting a rule template - Page 1049
Editing a rule description - Page 1050
Creating a rule from a blank template - Page 1051
Creating a rule from a blank template - Page 1052
Creating a rule from a blank template - Page 1053
Some Rule Examples - Page 1054
Some Rule Examples - Page 1055
Rule example 2 - Page 1056
Rule example 3 - Page 1057
Managing Rules - Page 1058
Managing Rules - Page 1059
Protecting against Viruses - Page 1060
On-demand e-mail scan - Page 1061
On-demand e-mail scan - Page 1062
Other attachment types - Page 1063
Other attachment types - Page 1064
Using Certificates and Digital Signatures - Page 1065
Using Certificates and Digital Signatures - Page 1066
Importing/exporting digital IDs - Page 1067
Receiving digitally signed messages - Page 1068
Obtaining other people’s public keys - Page 1069
Encrypting messages - Page 1070
Encrypting messages - Page 1071
Digitally signing messages - Page 1072
Digitally signing messages - Page 1073
Summary - Page 1074
Chapter 29: Working with Contacts - Page 1075
The Contacts Window - Page 1076
The Contacts Window - Page 1077
Customizing a contacts view - Page 1078
Customizing a contacts view - Page 1079
Finding contacts - Page 1080
Finding contacts - Page 1081
Adding Contacts - Page 1082
Adding a contact manually - Page 1083
Adding a contact from an Outlook contact - Page 1084
Adding contacts from your social network - Page 1085
Sending an E-mail to a Contact or Group - Page 1086
More about Contacts - Page 1087
More about Contacts - Page 1088
More about Contacts - Page 1089
More about Contacts - Page 1090
Other contact displays - Page 1091
Other contact displays - Page 1092
Editing the Business Card - Page 1093
Editing the Business Card - Page 1094
Sending contact information by e-mail - Page 1095
Other contact actions - Page 1096
Other contact actions - Page 1097
Performing a Mail Merge from Your Contacts - Page 1098
Performing a Mail Merge from Your Contacts - Page 1099
Setting Contact Options - Page 1100
Summary - Page 1101
Summary - Page 1102
Chapter 30: Working with Appointments and Tasks - Page 1103
Understanding the Outlook Calendar - Page 1104
Understanding the Outlook Calendar - Page 1105
Working with Calendar views - Page 1106
Working with Calendar views - Page 1107
Working with Calendar views - Page 1108
Working with Calendar views - Page 1109
Using the To-Do Bar with appointments - Page 1110
Using the To-Do Bar with appointments - Page 1111
Getting a sneak peek - Page 1112
Viewing the Weather Bar - Page 1113
Viewing the Weather Bar - Page 1114
Viewing the Weather Bar - Page 1115
Editing and deleting appointments - Page 1116
Appointment options - Page 1117
Appointment options - Page 1118
Appointment options - Page 1119
Appointment options - Page 1120
Appointment options - Page 1121
Appointment options - Page 1122
Appointment options - Page 1123
Searching the Calendar - Page 1124
Searching the Calendar - Page 1125
Setting Calendar Options - Page 1126
Understanding Tasks - Page 1127
Using the Tasks Feature - Page 1128
Using the Tasks Feature - Page 1129
Creating a New Task - Page 1130
Entering task details - Page 1131
Marking a task as complete - Page 1132
Marking a task as complete - Page 1133
Specifying task recurrence - Page 1134
Working with Assigned Tasks - Page 1135
Task status reports - Page 1136
Other Ways of Viewing Tasks - Page 1137
Viewing tasks on the Calendar - Page 1138
Setting Task Options - Page 1139
Summary - Page 1140
Part VI: Designing Publications with Publisher - Page 1141
Part VI: Designing Publications with Publisher - Page 1142
Chapter 31: Introducing Publisher - Page 1143
Chapter 31: Introducing Publisher - Page 1144
Chapter 31: Introducing Publisher - Page 1145
Chapter 31: Introducing Publisher - Page 1146
Using a Template to Create a Publication - Page 1147
Using a Template to Create a Publication - Page 1148
Working with Text - Page 1149
Typing text in a placeholder - Page 1150
Creating a placeholder and adding text - Page 1151
Inserting a text file - Page 1152
Inserting a text file - Page 1153
Resizing, autoflow, and linked text boxes - Page 1154
Resizing, autoflow, and linked text boxes - Page 1155
Formatting text - Page 1156
Formatting text - Page 1157
Formatting text - Page 1158
The Measurement pane - Page 1159
Inserting a picture file - Page 1160
Inserting an online image - Page 1161
Inserting multiple pictures - Page 1162
Swapping pictures - Page 1163
Changing a placeholder picture or swapping pictures - Page 1164
Adding picture effects - Page 1165
Adding picture effects - Page 1166
Working with Tables - Page 1167
Entering and editing table data - Page 1168
Working with the table format - Page 1169
Summary - Page 1170
Chapter 32: Designing Dazzling Publications with Publisher - Page 1171
BorderArt - Page 1172
BorderArt - Page 1173
Drop caps - Page 1174
Drop caps - Page 1175
WordArt - Page 1176
WordArt - Page 1177
Text formatting and typography tools - Page 1178
Updating a Publication - Page 1179
Changing page settings - Page 1180
Changing colors - Page 1181
Fine-Tuning Objects - Page 1182
Grouping objects - Page 1183
Wrapping and hyphenating text - Page 1184
Working with Pages - Page 1185
Numbering pages - Page 1186
Checking and Printing - Page 1187
Printing - Page 1188
Preparing for Outside Printing - Page 1189
Saving a Publication for Online Photo Center Printing - Page 1190
Saving a Publication for Online Photo Center Printing - Page 1191
Summary - Page 1192
Part VII: Managing Information with Access and OneNote - Page 1193
Part VII: Managing Information with Access and OneNote - Page 1194
Chapter 33: An Introduction to Database Development - Page 1195
Chapter 33: An Introduction to Database Development - Page 1196
Tables - Page 1197
Values - Page 1198
Access Database Objects - Page 1199
Queries - Page 1200
Reports - Page 1201
Step 1: The overall design — from concept to reality - Page 1202
Step 2: Report design - Page 1203
Step 2: Report design - Page 1204
Step 4: Table design - Page 1205
Step 4: Table design - Page 1206
Step 4: Table design - Page 1207
Step 5: Form design - Page 1208
Summary - Page 1209
Summary - Page 1210
Chapter 34: Creating Access Tables - Page 1211
Chapter 34: Creating Access Tables - Page 1212
How to Create a Blank Desktop Database - Page 1213
The Access 2013 Environment - Page 1214
The Navigation pane - Page 1215
The Navigation pane - Page 1216
The Ribbon - Page 1217
Creating a new table - Page 1218
The importance of naming conventions - Page 1219
Designing tables - Page 1220
Adding a new table to the database - Page 1221
Adding a new table to the database - Page 1222
Adding a new table to the database - Page 1223
Adding a new table to the database - Page 1224
Using the Table Tools - Design tab - Page 1225
Working with fields - Page 1226
Working with fields - Page 1227
Working with fields - Page 1228
Working with fields - Page 1229
Working with fields - Page 1230
Working with fields - Page 1231
Working with fields - Page 1232
Working with fields - Page 1233
Creating an Example Table - Page 1234
Setting the Primary Key - Page 1235
Creating the primary key - Page 1236
Creating composite primary keys - Page 1237
Indexing Access Tables - Page 1238
The importance of indexes - Page 1239
Multiple-field indexes - Page 1240
Multiple-field indexes - Page 1241
When to index tables - Page 1242
Printing a Table Design - Page 1243
Saving the Completed Table - Page 1244
Manipulating Tables - Page 1245
Copying a table to another database - Page 1246
Adding Records to a Database Table - Page 1247
Opening a Datasheet - Page 1248
Using the Navigation buttons - Page 1249
Using the Navigation buttons - Page 1250
Saving the record - Page 1251
Understanding automatic data-type validation - Page 1252
Navigating Records in a Datasheet - Page 1253
Finding a specific value - Page 1254
Finding a specific value - Page 1255
Changing Values in a Datasheet - Page 1256
Manually replacing an existing value - Page 1257
Fields that you can’t edit - Page 1258
Understanding Attachment Fields - Page 1259
Summary - Page 1260
Chapter 35: Creating and Entering Data with Basic Access Forms - Page 1261
Formulating Forms - Page 1262
Creating a new form - Page 1263
Creating a new form - Page 1264
Creating a new form - Page 1265
Creating a new form - Page 1266
Looking at special types of forms - Page 1267
Looking at special types of forms - Page 1268
Looking at special types of forms - Page 1269
Looking at special types of forms - Page 1270
Looking at special types of forms - Page 1271
Resizing the form area - Page 1272
Working with Controls - Page 1273
Categorizing controls - Page 1274
Categorizing controls - Page 1275
Adding a control - Page 1276
Adding a control - Page 1277
Adding a control - Page 1278
Adding a control - Page 1279
Adding a control - Page 1280
Selecting and deselecting controls - Page 1281
Manipulating controls - Page 1282
Manipulating controls - Page 1283
Manipulating controls - Page 1284
Manipulating controls - Page 1285
Manipulating controls - Page 1286
Manipulating controls - Page 1287
Manipulating controls - Page 1288
Manipulating controls - Page 1289
Manipulating controls - Page 1290
Manipulating controls - Page 1291
Introducing Properties - Page 1292
Introducing Properties - Page 1293
Getting acquainted with the Property Sheet - Page 1294
Getting acquainted with the Property Sheet - Page 1295
Naming control labels and their captions - Page 1296
Using Form View - Page 1297
Using Form View - Page 1298
Looking at the Home tab of the Ribbon - Page 1299
Looking at the Home tab of the Ribbon - Page 1300
Navigating among fields - Page 1301
Moving among records in a form - Page 1302
Knowing which controls you can’t edit - Page 1303
Knowing which controls you can’t edit - Page 1304
Entering data in the Long Text field - Page 1305
Using option groups - Page 1306
Using combo boxes and list boxes - Page 1307
Switching to Datasheet view - Page 1308
Printing a Form - Page 1309
Summary - Page 1310
Chapter 36: Selecting Data with Queries - Page 1311
Introducing Queries - Page 1312
What queries return - Page 1313
Creating a Query - Page 1314
Creating a Query - Page 1315
Creating a Query - Page 1316
Adding fields to your queries - Page 1317
Adding fields to your queries - Page 1318
Adding fields to your queries - Page 1319
Running your query - Page 1320
Changing field order - Page 1321
Resizing columns in the QBE grid - Page 1322
Hiding a field - Page 1323
Hiding a field - Page 1324
Adding Criteria to Your Queries - Page 1325
Entering simple string criteria - Page 1326
Entering other simple criteria - Page 1327
Printing a Query’s Recordset - Page 1328
Saving a Query - Page 1329
Saving a Query - Page 1330
Viewing table names - Page 1331
Recognizing the limitations of multi-table queries - Page 1332
Overcoming query limitations - Page 1333
Working with the Table Pane - Page 1334
Moving a table - Page 1335
Understanding joins - Page 1336
Understanding joins - Page 1337
Leveraging ad hoc table joins - Page 1338
Specifying the type of join - Page 1339
Specifying the type of join - Page 1340
Deleting joins - Page 1341
Deleting joins - Page 1342
Chapter 37: Presenting Data with Access Reports - Page 1343
Chapter 37: Presenting Data with Access Reports - Page 1344
Chapter 37: Presenting Data with Access Reports - Page 1345
Chapter 37: Presenting Data with Access Reports - Page 1346
Distinguishing between reports and forms - Page 1347
Defining the report layout - Page 1348
Creating a report with the Report Wizard - Page 1349
Creating a report with the Report Wizard - Page 1350
Creating a report with the Report Wizard - Page 1351
Creating a report with the Report Wizard - Page 1352
Creating a report with the Report Wizard - Page 1353
Creating a report with the Report Wizard - Page 1354
Creating a report with the Report Wizard - Page 1355
Creating a report with the Report Wizard - Page 1356
Creating a report with the Report Wizard - Page 1357
Creating a report with the Report Wizard - Page 1358
Creating a report with the Report Wizard - Page 1359
Creating a report with the Report Wizard - Page 1360
Creating a report with the Report Wizard - Page 1361
Creating a report with the Report Wizard - Page 1362
Creating a report with the Report Wizard - Page 1363
Printing or viewing the report - Page 1364
Printing or viewing the report - Page 1365
Saving the report - Page 1366
Chapter 38: Keeping Information at Hand with OneNote - Page 1367
Touring OneNote - Page 1368
Touring OneNote - Page 1369
Creating a Notebook - Page 1370
Creating a Section - Page 1371
Creating a Page - Page 1372
Creating a Page - Page 1373
Inserting Notes - Page 1374
Tagged notes - Page 1375
Extra writing space - Page 1376
Extra writing space - Page 1377
Inserting a Picture or File - Page 1378
Inserting a Screen Clipping - Page 1379
Writing on a Page - Page 1380
Writing on a Page - Page 1381
Using Linked Note Taking - Page 1382
Using Send To OneNote - Page 1383
Organizing, Finding, and Sharing - Page 1384
Viewing tagged notes - Page 1385
Searching notes - Page 1386
Searching notes - Page 1387
Working with Notes in the Cloud - Page 1388
Summary - Page 1389
Summary - Page 1390
Part VIII: Sharing and Collaborating in the Cloud and Applications - Page 1391
Part VIII: Sharing and Collaborating in the Cloud and Applications - Page 1392
Chapter 39: Collaborating in the Cloud with SkyDrive - Page 1393
Saving to the Cloud with SkyDrive - Page 1394
Saving to the Cloud with SkyDrive - Page 1395
Saving and sharing - Page 1396
Saving and sharing - Page 1397
SkyDrive for Windows Application versus SkyDrive in Office - Page 1398
SkyDrive for Windows Application versus SkyDrive in Office - Page 1399
Saving and viewing your files - Page 1400
Saving and viewing your files - Page 1401
Syncing your files - Page 1402
Viewing and working with SkyDrive files online - Page 1403
Viewing and working with SkyDrive files online - Page 1404
Touching up a document in the Web App - Page 1405
Touching up a document in the Web App - Page 1406
Accessing Your SkyDrive Pro Library on Office 365 - Page 1407
Accessing Your SkyDrive Pro Library on Office 365 - Page 1408
Changing the sync folder, syncing files, and viewing local files - Page 1409
Summary - Page 1410
Chapter 40: Integrating Office Application Information - Page 1411
Using Excel content in Word - Page 1412
Using Excel content in Word - Page 1413
Using Excel content in Word - Page 1414
Using Excel content in Word - Page 1415
Using Excel content in Word - Page 1416
Using Excel content in Word - Page 1417
Using Excel content in Word - Page 1418
Using Excel content in Word - Page 1419
Using Excel content in Word - Page 1420
Using Word content in Excel - Page 1421
Using Word content in Excel - Page 1422
Using Word content in Excel - Page 1423
PowerPoint - Page 1424
Converting a PowerPoint presentation to a Word document - Page 1425
Using tables from Word - Page 1426
Integrating Excel cells into PowerPoint - Page 1427
Using the Outlook Address Book in Word - Page 1428
Access Imports and Exports - Page 1429
OneNote - Page 1430
Printing from Word to OneNote - Page 1431
Sending from OneNote to Word - Page 1432
Sending from OneNote to Word - Page 1433
Sending from OneNote to Word - Page 1434
Appendix A: Customizing Office - Page 1435
Navigating in the Dialog Box - Page 1436
Using Common Options - Page 1437
Top Word Options - Page 1438
Top Word Options - Page 1439
Top Excel Options - Page 1440
Top Excel Options - Page 1441
Top PowerPoint Options - Page 1442
Top PowerPoint Options - Page 1443
Top Outlook Options - Page 1444
Customizing the Quick Access Toolbar - Page 1445
Customizing the Ribbon - Page 1446
Customizing the Ribbon - Page 1447
Customizing the Ribbon - Page 1448
Appendix B: Optimizing Your Office Installation - Page 1449
Activating Microsoft Office - Page 1450
Getting Updates - Page 1451
Running Microsoft Office Diagnostics - Page 1452
Running Microsoft Office Diagnostics - Page 1453
Running Microsoft Office Diagnostics - Page 1454
Appendix C: International Support and Accessibility Features - Page 1455
Enabling Editing Languages for Office Programs - Page 1456
Enabling Editing Languages for Office Programs - Page 1457
Enabling Editing Languages for Office Programs - Page 1458
Enabling Editing Languages for Office Programs - Page 1459
Language Translation Features - Page 1460
Accessibility Features - Page 1461