The fast and easy way to get things done with OfficePerplexed by PowerPoint? Looking to excel at Excel? From Access to Wordand every application in betweenthis 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, PowerPoint, Outlook, Access, Publisher, Charts and Graphics, OneNote, and moreand 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 itlet 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 WordBuild a worksheet, create formulas, and perform basic data analysis in ExcelCreate a notebook and organize your thoughts in NotesManage 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.
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 Words 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 Functionsfor 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