The fast and easy way to get things done with Office
Perplexed by Power Point? Looking to excel at Excel? From Access to Word–and every application in between–this all-encompassing guide provides plain-English guidance on mastering the entire Microsoft Office suite. Through easy-to-follow instruction, you’ll quickly get up and running with Excel, Word, Power Point, Outlook, Access, Publisher, Charts and Graphics, One Note, and more–and make your work and home life easier, more productive, and more streamlined.
Microsoft Office is the leading productivity tool in the world. From word processing to business communication to data crunching, it requires a lot of knowledge to operate it–let alone master it. Luckily, Office 2016 All-in-One For Dummies is here to deliver the breadth of information you need to complete basic tasks and drill down into Office’s advanced features.
* Create customized documents and add graphic elements, proofing, and citations in Word
* Build a worksheet, create formulas, and perform basic data analysis in Excel
* Create a notebook and organize your thoughts in Notes
* Manage messages, tasks, contacts, and calendars in Outlook
Clocking in at over 800 pages, Office 2016 All-in-One For Dummies will be the singular Microsoft Office resource you’ll turn to again and again.
Table of Content
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: Power Point 2016 313
Chapter 1: Getting Started in Power Point 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: One Note 2016 405
Chapter 1: Up and Running with One Note 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 459
Chapter 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 Smart Art 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 One Drive 713
Chapter 2: File Sharing and Collaborating 723
Index 731
About the author
Peter Weverka is a veteran For Dummies author. In addition to previous books on Microsoft Office, Peter has written guides to Windows, the Internet, and Quicken.