Office 2016 All-in-One For Dummies
Description
Perplexed by PowerPoint? 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, PowerPoint, Outlook, Access, Publisher, Charts and Graphics, OneNote, 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.
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 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 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
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.
10 BOOKS IN 1
- Common Office Tasks
- Word
- Excel®
- PowerPoint®
- OneNote®
- Outlook®
- Access®
- Charts and Graphics
- Advanced Office
- Office on the Web
Get everything you need from Office, the #1 productivity suite
Why buy a whole library of books to figure out Microsoft Office 2016 when you can find answers to your Office questions in just one book? Whether you're writing a masterpiece in Word, crunching numbers in Excel, organizing contacts in Outlook, wrangling data in Access, or using any Office application, this All-in-One has you covered!
- Understand the essentials navigate the tools that are common to all Office application
- All about Word use styles, format text and documents, use proofing tools, index documents, and discover shortcuts
- Crunch your numbers navigate Excel worksheets, use formulas and functions, and produce graphics that tell the story
- Make your point create a PowerPoint presentation that captures attention and shares a message
- A great Outlook manage your email, contacts, schedule, and tasks with one application
- Doing data set up Access database tables and store, search, query, and filter your data
- Charts and graphs take advantage of Office tools to display data in dynamic charts and diagrams
- Work together use OneDrive to set up file sharing and collaboration
Open the book and find:
- How to protect a file with a password
- Ways to design professional-looking documents
- What you can do with pivot tables
- How to add video to a slide show
- The best ways to enter data in a database
- Steps for creating a chart
- Tips for customizing Office
- All about using OneDrive
PUBLISHER:
Wiley
ISBN-13:
9781119083122
BINDING:
Paperback
BISAC:
COMPUTERS
BOOK DIMENSIONS:
Dimensions: 185.40(W) x Dimensions: 228.60(H) x Dimensions: 43.20(D)
AUDIENCE TYPE:
General/Adult
LANGUAGE:
English