Introduction 1
I Introduction to the Office 2016 Application Suite
1 Getting Oriented to the Office 2016 Applications 5
Introducing Office 2016 5
New Features and Tools in Office 2016 8
Saving and Sharing Files in the Cloud 8
Editing Adobe Acrobat Files 9
Other Office 2016 Improvements and Updates 10
The Office 2016 Suite Applications 11
The Different Versions of the Office 2016 Suite 12
Hardware and Software Requirements for Office 2016 13
Installing Office 2016 14
Getting Help in the Office Applications 16
2 Navigating and Customizing the Office Interface 19
Getting Familiar with the Office Interface 19
Galleries 20
Contextual Tabs 21
Overview of the Office Application Window 22
Navigating the Office Applications 25
Working with the Ribbon 25
Working in the Backstage 28
Customizing an Application Interface 30
Customizing the Ribbon 31
Customizing the Quick Access Toolbar 33
Customizing the Status Bar 36
Configuring Application Options 37
Advanced Option Settings 39
Add-Ins 39
Using Office Add-ins 40
Using the Trust Center 41
Trusted Publishers 43
Trusted Locations 44
3 Managing and Sharing Office Files 47
Understanding Office File Formats 47
Saving Files as Different File Types 50
Converting Files to Different File Types 51
Configuring Save File Options 52
Creating and Managing Files 54
Managing Files 56
Creating a New Folder 57
Creating a New Library 58
Viewing File Versions in an Application 59
Searching for Office Files 60
Sharing Files Using Homegroup 61
Protecting an Office File 63
Prepare a File for Sharing 65
4 Using and Creating Graphics 67
The Office 2016 Options for Graphics and Pictures 67
Working with SmartArt Graphics 70
Inserting SmartArt Graphics 72
Modifying SmartArt Graphics 74
Working with Your Digital Pictures 77
Inserting Pictures 77
Adjusting Pictures 78
Cropping an Image 81
Using the Background Removal Tool 81
Inserting Online Pictures 83
Inserting Bing Image Search Results 84
Inserting Facebook Images 84
Inserting Flickr.com Images 85
Inserting Images from Your OneDrive 86
Using Shapes and the Office Drawing Tools 87
Adding and Combining Multiple Shapes 88
Formatting a Shape with the Drawing Tools 90
Using the Screenshot Feature 91
Using WordArt 93
5 Using the Office Apps 95
What the Online Apps Can Do 96
Where the Online Apps Live 97
Saving Office Application Files to the Cloud 99
Saving a File to OneDrive or OneDrive for Business 101
Sharing a File Saved to the Cloud 102
Using the Word Online app 104
The Word Online App's File Tab 105
The Word Online App's Home Tab 106
The Word Online App's Insert Tab 107
The Word Online App's Review Tab 108
The Word Online App's View Tab 108
Using Excel Online 109
The Excel Online App's File Tab 109
Working in the Excel Online App 110
Inserting Functions and Charts in the Excel Online App 110
Using PowerPoint Online 113
Working with Slides 114
Adding Pictures and SmartArt 115
The Windows 10 Mobile Office Apps 116
The Word Mobile App 117
The Excel Mobile App 120
II Word
6 Requisite Word: Essential Features 123
Introducing Word 2016 123
The Word 2016 Interface 123
New Features and Improvements 125
Options for Creating a New Word Document 126
Using Templates 128
Creating a Template 131
Attaching a Template 133
Navigating a Word Document 134
Moving Around a Document with the Mouse 134
Moving Around a Document with the Keyboard 135
Selecting Text 136
Understanding Document Formatting 137
Character Formatting Versus Paragraph Formatting 137
Manual Formatting Versus Styles and Themes 138
Working with Fonts and Text Formatting 138
Formatting Text 139
Working with Paragraph Formatting 142
Setting Paragraph Alignment 143
Changing Line Spacing 144
Setting Line and Page Breaks 145
Setting Indents 146
Working with Tabs 148
Page Layout: Margins and Page Options 150
Changing Margins 151
Changing Page Orientation and Paper Size 152
Inserting Page Breaks 152
Printing Documents 152
7 Enhancing Word Documents 155
Creating Better Documents 155
Creating Bulleted and Numbered Lists 156
Bulleted Lists 156
Numbered Lists 158
Multilevel Lists 159
Working with Borders and Shading 160
Formatting with Themes 162
Creating Headers and Footers 166
Inserting Headers and Footers 167
The Header and Footer Tools 168
Working with Page Numbering 170
Inserting Pictures, Clip Art, and Charts 171
Inserting Pictures 172
Inserting Online Pictures and Clip Art 173
Inserting a Chart 175
Integrating Text and Images 177
Changing the Document Display 178
Using the Navigation Pane 180
Using the Outline View 181
Splitting the Document Window 182
Using the Review Tools 183
Running Spelling and Grammar 183
Using the Thesaurus 184
Using the Insights Command 185
Working with Quick Parts 186
Creating and Inserting an AutoText Entry 186
Creating and Inserting Building Blocks 187
Configuring AutoCorrect 188
Understanding Styles 189
Using the Styles Gallery 190
Creating Styles 191
Editing Styles 192
Managing Styles 193
8 Working with Tables, Columns, and Sections 197
Options for Adding a Table 197
Inserting a Table 199
Drawing a Table 201
Converting Text to a Table 201
Entering and Deleting Text and Navigating a Table 202
Selecting and Positioning a Table 203
Formatting Tables 204
Adjusting Columns and Rows 206
Formatting Cells 207
Using Table Styles 209
Sorting Table Data 211
Using Formulas in Tables 212
Adding Columns to a Document 214
Understanding Sections 215
Adding and Removing Section Breaks 216
Formatting Page Attributes in a Section 217
9 Managing Mailings and Forms 219
Options for Mail-Related Documents 219
Creating an Envelope 220
Creating a Label or Labels 222
Understanding Mass Mailings 223
Performing a Mail Merge 223
Using the Mail Merge Commands 225
Understanding Recipient Lists 226
Creating a Recipient List 227
Editing and Manipulating a Recipient List 229
Using Merge Fields 231
Using Merge Rules 233
Previewing Merge Results 234
Completing the Merge 235
Creating Merged Envelopes and Labels 235
Understanding Word Fields 236
Building a Form with Form Controls 238
10 Creating Special Documents 241
Options for Large Documents 241
Creating a Table of Contents 242
Creating a Table of Contents with Built-in Styles 243
Creating a Table of Contents with Your Own Styles 244
Adding Entries and Updating the TOC 246
Building a TOC with Field Codes 247
Working with Captions and Tables of Figures 249
Inserting a Caption 249
Inserting a Table of Figures 250
Using Cross-References 251
Generating an Index 253
Marking Index Entries 254
Inserting the Index 255
Working with Citations and Bibliographies 256
Creating Citations 256
Managing Citations 257
Inserting the Bibliography 258
Inserting Footnotes and Endnotes 260
Tracking Document Changes 261
Options for Viewing Changes 264
Reviewing Changes 265
Comparing Documents 266
Building a Better Big Document 268
Creating Bookmarks 268
Inserting Comments 269
Creating a Master Document 270
Working in Outline View 271
Creating Subdocuments from Scratch 272
Inserting Existing Document Files into a Master Document Outline 273
Manipulating the Master Document 274
III Excel
11 Requisite Excel: Essential Features 275
Introducing Excel 2016 275
Navigating the Excel Workspace 277
The Excel Ribbon 278
Moving Around a Worksheet 280
Creating Workbooks and Worksheets 281
Using Office.com Templates 281
Inserting and Rearranging Worksheets 283
Managing Excel Workbooks 284
Protecting Workbooks and Worksheets 286
Locking Cells 286
Specifying Edit Ranges 288
Preparing a Workbook for Sharing 290
Managing Versions 291
Entering Data in a Worksheet 291
Entering Labels 292
Entering Values 292
Using AutoComplete 293
Filling and Entering Series 294
Using the Fill Handle 295
Creating Custom Fill Lists 297
Creating Custom Series 298
Using Flash Fill 299
Copying, Moving, and Deleting Cell Contents 299
Using the Paste Special Dialog Box 302
Moving Cells and Ranges 304
Clearing and Deleting Cells 304
Editing Cell Content 305
Viewing Worksheets 306
Printing Worksheets 308
Using the Page Layout Commands 308
Setting a Print Area 310
Inserting Page Breaks 310
Setting Print Titles 311
Working on the Print Page 311
Inserting Headers and Footers 313
12 Worksheet Formatting and Management 315
Formatting Text Entries 315
Accessing the Format Cells Dialog Box 316
Changing Text Orientation 317
Formatting Values 318
Using the Format Cells Dialog Box 320
Creating Custom Number Formats 321
Adding Comments to Cells 323
Formatting Comment Text 324
Deleting and Viewing Comments 324
Using Themes 325
Formatting Cells Using Borders and Color 326
Adding Cell Borders 326
Using Background Colors 328
Using Cell Styles and the Format Painter 328
Creating a Cell Style 329
Using the Format Painter 330
Using Conditional Formatting 330
Using Highlight Cell Rules 331
Using Top/Bottom Rules 332
Using Data Bars 333
Using Color Scales 334
Using Icon Sets 334
Creating Conditional Formatting Rules 334
Manipulating Cells and Cell Content 336
Inserting Cells 336
Merging Cells and Wrapping Text 337
Finding and Replacing Cell Items 337
Working with Columns and Rows 339
Changing Column Width and Row Height 339
Inserting Columns and Rows 340
Deleting Columns and Rows 340
Hiding Columns and Rows 341
Working with Worksheets 341
Freezing Rows and Columns 341
Splitting Worksheets 342
Hiding Worksheets 343
Naming Ranges 343
Creating Range Names from Selections 345
Managing Range Names 345
Adding Images and Graphics to Worksheets 346
13 Getting the Most from Formulas and Functions 349
Performing Calculations in Excel Worksheets 349
Relative Versus Absolute Referencing 351
Creating and Editing Formulas 354
Understanding Operator Precedence 355
Entering Formulas 356
Editing Formulas 356
Working with Excel Functions 357
Entering a Function in a Cell 358
Using AutoSum 358
Using the Status Bar Statistical Functions 360
Using the Insert Function Dialog Box 360
Using the Function Library 361
Using Range Names in Formulas and Functions 364
Inserting a Range Name into a Formula 364
Inserting a Range Name into a Function 365
Referencing Cells or Ranges on Other Worksheets 366
Copying and Moving Formulas and Functions 368
Choosing the Right Function 368
Financial Functions 369
Logical Functions 370
Statistical Functions 372
Lookup & Reference Functions 373
Date & Time Functions 374
Text Functions 375
Other Function Categories 376
Proofing Your Formulas and Functions 377
Common Error Messages 377
Using the Auditing Tools 379
Using the Watch Window 380
14 Enhancing Worksheets with Charts 383
Understanding Excel Charts 383
Chart Terminology 384
Using Different Chart Types 387
Creating Charts 393
Inserting a Chart from the Ribbon 394
Selecting a Recommended Chart 395
Inserting Charts with the Quick Analysis Gallery 395
Tools for Quickly Customizing a Chart 396
Moving, Copying, or Deleting a Chart 397
Modifying a Chart 398
Changing Chart Type or Chart Data 398
Selecting Chart Layouts and Styles 400
Working with Chart Elements 402
Modifying Titles and Data Labels 404
Working with the Legend and Data Points 404
Manipulating Axes and Gridlines 406
Adding Trendlines, Drop Lines, and Bars to a Chart 406
Creating a Combination Chart 410
Working with a Pie of Pie Chart 411
Creating a Custom Combination Chart 411
Using Sparklines 413
Creating Sparklines 413
Modifying Sparklines 414
15 Using Excel Tables and Pivottables 417
Excel and Databases 417
Defining a Table Range 418
Creating a Table Using Styles 419
Using the Table Tools 420
Sorting Table Data 421
How Excel Sorts Data 422
Using the Sort Dialog Box 422
Filtering Table Data 424
Using the AutoFilter Search Box 425
Creating Custom AutoFilters 425
Filtering Tables with Slicers 428
Creating Advanced Filters 429
Using the Data Form 431
Creating Outlines and Subtotals 432
Working with External Data 435
Importing Data from Access 436
Importing a Web Table 437
Importing Text Files 438
Connecting to Other Data Sources 439
Using Microsoft Query 441
Viewing and Refreshing Connections 444
Working with PivotTables 445
Using the Recommended PivotTables Command 447
Creating a PivotTable 447
Working with the PivotTable Tools 450
Using Slicers 452
16 Validating and Analyzing Worksheet Data 453
Taking Advantage of Data Validation 453
Specifying Validation Criteria 454
Configuring Input Messages and Error Alerts 456
Circling Invalid Data 458
Performing a What-If Analysis 459
Creating a Data Table 460
Creating Scenarios 462
Viewing Scenarios and Creating Reports 464
Using Goal Seek and Solver 466
Working with Goal Seek 466
Working with Solver 467
IV PowerPoint
17 Requisite Powerpoint: Essential Features 471
PowerPoint 2016 471
Options for Creating a New Presentation 472
Using Templates 473
Using a Theme to Create a New Presentation 476
Creating a Presentation from an Existing Presentation 477
Inserting Slides from the Reuse Slides Task Pane 478
Publishing Slides to a Library 479
Creating a Template 480
Inserting New Slides 481
Entering Text 482
Inserting Slides from a Word Outline 483
Inserting Other Object Content 483
Modifying a Slide's Layout 484
Working with Slides in Different Views 484
Zooming In and Out 486
Rulers, Gridlines, and Guides 487
Color/Grayscale Commands 488
Opening a New Presentation Window 489
Rearranging and Deleting Slides 490
Modifying Bulleted Lists 491
Using Numbered Lists 493
Viewing a Presentation During Editing 493
18 Advanced Presentation Formatting, Themes, and Masters 495
Working with Text Boxes and Formatting 495
Inserting a Text Box 496
Basic Text Formatting 497
Formatting a Text Box with the Drawing Tools 499
Selecting Quick Styles and Shape Attributes 499
Shape Fill, Outline, and Effects 500
Using WordArt Styles and Text Settings 503
Arranging Text in Tables 507
Inserting a Table on an Existing Slide 507
Formatting a Table 507
Table Layout Commands 508
Working with Themes 510
Applying Themes 511
Applying Theme Variants 512
Creating a Custom Theme 517
Using Headers and Footers 517
Understanding Masters 518
Altering and Creating Master Slides 520
Creating Layout Masters 522
Using Slide Sections 523
19 Better Slides with Clip Art, Pictures, and SmartArt 525
Using Graphics to Enhance Slides 525
Inserting a Picture 527
Adding Online Images to Slides 529
Creating a Photo Album 531
Adjusting Picture Settings 532
Configuring Album Layout Settings 533
Working with Shapes 534
Using SmartArt Graphics 535
Inserting a SmartArt Graphic 538
Converting Text to a SmartArt Graphic 539
Using the SmartArt Tools 540
Adding Charts to Slides 541
Inserting a Chart onto a Slide 542
Modifying and Formatting a Chart 544
Working with Slide Objects 546
Grouping Objects 546
Layering Objects 546
Adding Hyperlinks to Slides 547
20 Enhancing Slides with Animation, Transitions, and Multimedia 549
Animations versus Transitions 549
Assigning Animation to a Slide Object 551
Accessing Additional Animation Effects 553
Using Motion Paths 554
Advanced Animation Techniques 559
Changing Effect Options 560
Adding Additional Animations 561
Using the Animation Painter 562
Including Sound Effects with Animations 562
Setting Timings for Animations 564
Managing Slide Animations 565
Adding Transitions to Slides 566
Modifying Transitions 567
Adding Sound to a Slide 569
Editing Sound Options 569
Adding Video to a Slide 571
Inserting Online Video 571
Inserting a Video File 574
Modifying Your Video Clips 575
21 Delivering a Presentation and Creating Support Materials 577
Planning Your Presentation 578
Checking the Presentation for Spelling and Grammar Errors 579
Running Through a Completed Presentation 580
Using the Presenter View 581
Using Hidden Slides 583
Creating a Custom Slide Show 585
Creating a Self-Running Presentation 586
Setting Up a Slide Show 586
Rehearsing Timings 588
Recording a Slide Show 589
Creating an Interactive Presentation 590
Presenting a Slide Show Online 592
Presenting Online with Skype for Business 592
Presenting Online with the Office Presentation Service 593
Working with the Notes and Handout Masters 594
Setting Handout Master Options 595
Setting Notes Master Options 596
Printing Presentations, Notes, and Handouts 596
Exporting a Presentation 599
Sharing Your Presentation 600
V Outlook
22 Requisite Outlook: Configuration and Essential Features 603
Introducing Outlook 2016 603
Outlook and Email Accounts 604
Exchange ActiveSync 605
Outlook.com Email 606
Internet Email 606
Configuring Outlook at First Start 607
Understanding Outlook Profiles 610
Creating a New Profile 610
Managing Profiles 611
Loading Profiles 613
Understanding Outlook Data Files 614
Configuring Outlook for Microsoft Exchange Server 614
Creating Personal Folders Files 616
Repairing Outlook Data Files 617
Importing and Exporting Data 619
Importing Data 619
Exporting Data 621
Navigating the Outlook Workspace 621
Accessing Outlook Items Using the Navigation Bar 623
Working with Views in Outlook 624
Categorizing Outlook Items 627
Searching for Outlook Items 628
Using Advanced Find 629
Using Search Folders 629
Printing Outlook Items 631
23 Managing Email in Outlook 633
Working in the Mail Folder 633
Creating an Email Message 635
Using the Outlook Address Book 637
Setting Message Options 639
Specifying Email Format 640
Setting Message Flags, Importance, and Sensitivity 640
Configuring Voting Buttons, Receipts, and Delivery Options 642
The Message Options/Properties Dialog Box 645
Attaching Files and Items to a Message 647
Attaching a Business Card 648
Attaching a Calendar 648
Using Themes and Email Stationery 650
Adding a Signature 652
Sending Mail 653
Recalling a Message 653
Working with Received Email 654
Organizing Messages in the Inbox 655
Showing Messages as Conversations 655
Filtering Email 656
Managing Email 657
Using Quick Steps 658
Answering a Message 660
Forwarding a Message 660
Saving an Attachment 660
Deleting Messages 662
Printing Mail 663
Moving Email 663
Managing Email Accounts 664
Editing Email Account Settings 666
Adding an Email Account 667
Adding an Outlook.com Mail Account 669
Setting Outlook Mail Options 669
24 Using the Calendar for Appointments and Tasks 673
Navigating the Calendar 673
Changing the Calendar View 675
Change the Time Scale and Time Zone 677
Scheduling an Appointment 678
Scheduling a Recurring Appointment 680
Scheduling an Event 681
Editing and Managing Appointments 682
Searching the Calendar 683
Sharing Calendars 684
Creating a Calendar Share Invitation 685
Opening a Shared Calendar 686
Viewing Multiple Calendars 686
Emailing a Calendar 688
Publishing a Calendar Online 689
Setting Calendar Options 690
Working with Tasks 692
Using the Task Folder 693
Creating a New Task from the Task Folder 694
Creating a Recurring Task 694
Assigning and Accepting Tasks 695
Viewing and Managing Tasks 696
Managing Tasks 699
Setting Tasks Options 700
25 Working with Contacts and Planning Meetings 703
Navigating the Contacts List 703
Creating a New Contact 705
Entering Contact Details 708
Adding Fields for a Contact 709
Editing Contact Information 709
Editing a Business Card 711
Tagging Contacts with Flags and Categories 712
Mapping a Contact's Address 713
Searching the Contacts Folder 714
Organizing Contacts with Groups 715
Forwarding and Sharing Contacts 716
Forwarding Contacts 717
Sharing Contacts 718
Accessing Contacts on Social Networks 720
Communicating with Contacts 722
Contact Actions 724
Printing Contact Information 725
Setting Contact Options 726
Scheduling Meetings 726
Selecting the Meeting Location 728
Using the Scheduling Assistant 728
Viewing and Editing Meeting Information 729
Responding to Meeting Requests 730
26 Using the Journal and Notes 733
Using the Outlook Journal 733
Creating a New Journal Entry 734
Using the Journal Timer 735
Adding Tags and Names to a Journal Entry 736
Adding Outlook Items and Inserting Files 737
Journal Actions 739
Viewing the Journal 740
Manipulating the Journal View 741
Using Search to Filter Journal Entries 742
Working with Notes 742
Viewing and Managing Notes 743
Creating Appointments and Tasks from Notes 744
27 Securing and Maintaining Outlook 747
Security Overview 747
Malware and Antivirus Software 748
Strong Password Protection 749
Configuring Outlook Security Settings 751
Encrypting Email and Using Digital Signatures 753
Options for Encrypting Email 754
Digitally Signing Emails 755
The Perils of HTML Email 755
Dealing with Message Attachments 756
Coping with Junk Email 758
Working with the Junk Email Commands 759
Setting Junk Email Options 760
Creating Email Rules 762
Creating a Quick Rule for a Specific Sender 762
Creating Complex Rules 763
The Rule Wizard 764
Managing Rules 767
Archiving Outlook Items 768
Configuring AutoArchive Settings 769
Setting AutoArchive Options for a Folder 770
Archiving Manually 771
Configuring an Autoreply Message 772
VI Publisher
28 Requisite Publisher: Essential Features 775
Introducing Publisher 2016 775
Planning Your Publication 776
Working with Publication Templates 777
Creating a New Publication 779
Using a Template 779
Using Blank Sizes 780
Creating a New Template 781
Navigating the Publisher Workspace 782
Using the Rulers and Guides 783
Options for Viewing the Publication 785
Creating a Business Information Set 787
Creating a New Business Information Set 787
Creating Additional Business Information Sets 788
Working with Text 789
Editing Text in a Text Box 789
Creating Your Own Text Boxes 790
Formatting Text Boxes 791
Linking Text Boxes 796
Inserting a Text File 797
Inserting Illustrations 798
Options for Inserting Pictures 798
Formatting a Picture 801
Inserting Clip Art 802
Inserting Shapes 802
Using Building Blocks 802
Printing Publications 803
29 Advanced Publisher Features 805
Adding Pages to a Publication 805
Configuring Page Settings 807
Changing the Current Template 810
Working with Master Pages 812
Placing Objects on the Master Page 813
Inserting Headers and Footers 814
Creating Master Pages 815
Using Tables in Publications 816
Table Design Commands 816
Table Layout Commands 817
Manipulating Publication Objects 818
Grouping Objects 818
Layering Objects 819
Swapping Images 820
Merging Data into a Publication 820
Performing a Mail Merge 821
Performing a Catalog Merge 823
Fine-tuning Your Publications 825
The Spelling Feature 825
Hyphenation 825
Design Checker 825
VII OneNote
30 Requisite OneNote: Essential Features 827
Introducing OneNote 827
How OneNote Notebooks Are Organized 828
Navigating the OneNote Workspace 829
The OneNote Ribbon 830
The Notebook Pane 832
Creating a Notebook 832
Modifying Notebook Properties 834
Sharing a Notebook 836
Viewing the Sync Status 839
Working with Sections 840
Creating or Deleting a Section 840
Modifying Sections 841
Merging a Section 843
Creating a Section Group 844
Working with Pages 845
Creating Pages Using Templates 845
Creating Subpages 846
Restoring Sections and Pages from the Notebook Recycle Bin 847
Inserting and Formatting Notes 848
Using Tags 849
Finding Tagged Notes 851
Using Tables to Store Information 852
31 Working with Notebook Pages 855
Managing Pages 855
Using the Move or Copy Pages Dialog Box 856
Making More Space Available on a Page 857
Modifying the Page Setup and View 858
Viewing Page Versions 860
Viewing Recent Edits 861
Viewing Changes by Author 862
Adding Objects to Notebook Pages 864
Adding Pictures 866
Recording Audio 867
Recording Video 868
Adding Drawings to OneNote Pages 868
Printing Notebook Pages 870
32 Integrating OneNote with Other Office Applications 873
Taking Linked Notes 873
Using File Printout 876
Adding Links 878
Attaching Files 879
Inserting Screen Clips 880
Integrating OneNote and Outlook 882
Adding Outlook Tasks 882
Emailing a Notebook Page 884
Inserting Meeting Details 885
VIII Appendix
A Office Application Integration 889
B Office Macros 905
TOC, 9780789755674, 9/23/2015
