Table of Contents
Introduction 1
About This Book 1
Foolish Assumptions 2
Icons Used in This Book 2
Beyond the Book 3
Where to Go from Here 4
Book I: Common Office Tasks 5
Chapter 1: Office Nuts and Bolts 7
Chapter 2: Wrestling with the Text 25
Chapter 3: Speed Techniques Worth Knowing About 43
Book II: Word 2016 51
Chapter 1: Speed Techniques for Using Word 53
Chapter 2: Laying Out Text and Pages 71
Chapter 3: Word Styles 95
Chapter 4: Constructing the Perfect Table 111
Chapter 5: Taking Advantage of the Proofing Tools 133
Chapter 6: Desktop Publishing with Word 153
Chapter 7: Getting Word’s Help with Office Chores 171
Chapter 8: Tools for Reports and Scholarly Papers 191
Book III: Excel 2016 213
Chapter 1: Up and Running with Excel 215
Chapter 2: Refining Your Worksheet 233
Chapter 3: Formulas and Functions for Crunching Numbers 247
Chapter 4: Making a Worksheet Easier to Read and Understand 279
Chapter 5: Advanced Techniques for Analyzing Data 297
Book IV: PowerPoint 2016 313
Chapter 1: Getting Started in PowerPoint 315
Chapter 2: Fashioning a Look for Your Presentation 337
Chapter 3: Entering the Text 351
Chapter 4: Making Your Presentations Livelier 367
Chapter 5: Delivering a Presentation 383
Book V: OneNote 2016 405
Chapter 1: Up and Running with OneNote 407
Chapter 2: Taking Notes 419
Chapter 3: Finding and Organizing Your Notes 435
Book VI: Outlook 2016 443
Chapter 1: Outlook Basics 445
Chapter 2: Maintaining the Contacts Folder 459Chapter 3: Handling Your Email 469
Chapter 4: Managing Your Time and Schedule 491
Chapter 5: Tasks, Reminders, and Notes 499
Book VII: Access 2016 507
Chapter 1: Introducing Access 509
Chapter 2: Building Your Database Tables 523
Chapter 3: Entering the Data 551
Chapter 4: Sorting, Querying, and Filtering for Data 561
Chapter 5: Presenting Data in a Report 581
Book VIII: Working with Charts and Graphics 587
Chapter 1: Creating a Chart 589
Chapter 2: Making a SmartArt Diagram 607
Chapter 3: Handling Graphics and Photos 625
Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 641
Book IX: Office 2016 — One Step Beyond 669
Chapter 1: Customizing an Office Program 671
Chapter 2: Ways of Distributing Your Work 685
Chapter 3: Working with Publisher 695
Book X: File Sharing and Collaborating 711
Chapter 1: Up and Running on OneDrive 713
Chapter 2: File Sharing and Collaborating 723
Index 731