Home > Store

Office 2016 In Depth

Register your product to gain access to bonus material or receive a coupon.

Office 2016 In Depth


  • Sorry, this book is no longer in print.
Not for Sale



• Beyond-the-basics, beneath-the-surface Office 2016 reference and desk-side resource: comprehensive, expert, task-based solutions
• Organizes Office 2016's features and tools within the context of specific real-world tasks and documents
• Illuminates hot new features in Word, Excel, PowerPoint, Outlook, Access, Publisher, and beyond
• Written by renowned Microsoft Office expert and instructor Joe Habraken, who has taught thousands of users through best-selling
books and in person
• Updates will be delivered via a FREE Web Edition of this book, which can be accessed with any Internet connection


  • Copyright 2016
  • Dimensions: 7" x 9-1/8"
  • Pages: 1008
  • Edition: 1st
  • Book
  • ISBN-10: 0-7897-5567-X
  • ISBN-13: 978-0-7897-5567-4

Beyond the Basics…

Beneath the Surface…In Depth

Do more in less time!

Whatever your Microsoft Office experience, don’t let Office 2016 make you feel like a beginner! This book is packed with intensely useful knowledge, tips, and shortcuts you just won’t find anywhere else. It’s the fastest, best way to master Office 2016’s full power, and the great new features built into Word, Excel, PowerPoint, Outlook, Publisher, and OneNote. This friendly, expert guide will make you way more productive… whether you’re creating documents, analyzing data, delivering presentations, designing newsletters, taking quick notes, or managing your life!

  • Take full advantage of Office 2016’s cloud integration
  • Use Insights for Office to quickly access information
  • Easily create complex Word documents, from books to mail merges
  • Coauthor Word documents with collaborators in real time
  • Build flexible, reliable Excel workbooks with formulas and functions
  • Transform data into insight with Excel charts and PivotTables
  • Discover best practices for creating great PowerPoint slides, handouts, and notes
  • Take advantage of the new Tell Me Box, which provides access to contextual and traditional Office help features including the new Insights pane
  • Use Outlook 2016’s Clutter feature to clear away low-priority email
  • Create visually compelling documents of all kinds with Publisher 2016
  • Gather, organize, share, and use knowledge with OneNote 2016
  • Get more done faster by integrating OneNote with other Office 2016 components
  • Discover Microsoft’s new mobile Word, Excel, and PowerPoint apps for Windows 10

All In Depth books offer

  • Comprehensive coverage, with detailed solutions
  • Practical, real-world examples with nothing glossed over or left out
  • Troubleshooting help for tough problems you can’t fix on your own

This book is part of Que’s Content Update Program. As Microsoft updates features of Office, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details.

Sample Content

Online Sample Chapter

Managing and Sharing Office Files

Sample Pages

Download the sample pages (includes Chapter 3 and Index)

Table of Contents

    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


Updates & Corrections

This book is part of Que's Content Update Program. As Microsoft updates features of Office 2016, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a free Web Edition of this book, which can be accessed with any Internet connection from your account on quepublishing.com. For more information, visit quepublishing.com/CUP.

Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.


Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.


If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.


This site is not directed to children under the age of 13.


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020