Office 2016 All-In-One for Dummies

ISBN-13: 9781119083122 / Angielski / Miękka / 2015 / 800 str.

Peter Weverka

Opis

The fast and easy way to get things done with Office 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.

The fast and easy way to get things done with OfficePerplexed 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.

Spis treści

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

A Survey of Office Applications 7

All about Office 365 9

Finding Your Way Around the Office Interface 10

The File tab and Backstage 10

The Quick Access toolbar 12

The Ribbon and its tabs 12

Context–sensitive tabs 13

The anatomy of a tab 13

Mini–toolbars and shortcut menus 14

Office 2016 for keyboard lovers 15

Saving Your Files 16

Saving a file 17

Saving a file for the first time 17

Saving AutoRecovery information 18

Navigating the Save As and Open Windows 19

Opening and Closing Files 20

Opening a file 20

Closing a file 21

Reading and Recording File Properties 21

Locking a File with a Password 22

Password–protecting a file 23

Removing a password from a file 24

Chapter 2: Wrestling with the Text 25

Manipulating the Text 25

Selecting text 25

Moving and copying text 27

Taking advantage of the Clipboard task pane 27

Deleting text 27

Changing the Look of Text 28

Choosing fonts for text 29

Changing the font size of text 30

Applying font styles to text 32

Applying text effects to text 32

Underlining text 34

Changing the color of text 34

Quick Ways to Handle Case, or Capitalization 35

Entering Symbols and Foreign Characters 36

Creating Hyperlinks 38

Linking a hyperlink to a web page 38

Creating a hyperlink to another place in your file 40

Creating an email hyperlink 41

Repairing and removing hyperlinks 41

Chapter 3: Speed Techniques Worth Knowing About 43

Undoing and Repeating Commands 43

Undoing a mistake 43

Repeating an action and quicker this time 44

Zooming In, Zooming Out 45

Viewing a File Through More Than One Window 46

Correcting Typos on the Fly 47

Entering Text Quickly with the AutoCorrect Command 48

Book II: Word 2016 51

Chapter 1: Speed Techniques for Using Word 53

Introducing the Word Screen 53

Creating a New Document 55

Getting a Better Look at Your Documents 57

Viewing documents in different ways 57

Splitting the screen 60

Selecting Text in Speedy Ways 61

Moving Around Quickly in Documents 63

Keys for getting around quickly 63

Navigating from page to page or heading to heading 63

Going there fast with the Go To command 65

Bookmarks for hopping around 65

Inserting a Whole File into a Document 66

Entering Information Quickly in a Computerized Form 67

Creating a computerized form 68

Entering data in the form 70

Chapter 2: Laying Out Text and Pages 71

Paragraphs and Formatting 71

Inserting a Section Break for Formatting Purposes 72

Breaking a Line 74

Starting a New Page 74

Setting Up and Changing the Margins 75

Indenting Paragraphs and First Lines 77

Clicking an Indent button (for left–indents) 77

Eye–balling it with the ruler 77

Indenting in the Paragraph dialog box 79

Numbering the Pages 79

Numbering with page numbers only 79

Including a page number in a header or footer 80

Changing page number formats 81

Putting Headers and Footers on Pages 82

Creating, editing, and removing headers and footers 83

Fine–tuning a header or footer 85

Adjusting the Space between Lines 86

Adjusting the Space Between Paragraphs 87

Creating Numbered and Bulleted Lists 88

Simple numbered and bulleted lists 88

Constructing lists of your own 89

Managing a multilevel list 90

Working with Tabs 91

Hyphenating Text 92

Automatically and manually hyphenating a document 93

Unhyphenating and other hyphenation tasks 94

Chapter 3: Word Styles 95

All About Styles 95

Styles and templates 95

Types of styles 96

Applying Styles to Text and Paragraphs 97

Applying a style 97

Experimenting with style sets 98

Choosing which style names appear on the Style menus 99

Creating a New Style 101

Creating a style from a paragraph 101

Creating a style from the ground up 102

Modifying a Style 103

Creating and Managing Templates 105

Creating a new template 105

Opening a template so that you can modify it 109

Modifying, deleting, and renaming styles in templates 110

Chapter 4: Constructing the Perfect Table 111

Talking Table Jargon 111

Creating a Table 112

Entering the Text and Numbers 114

Selecting Different Parts of a Table 115

Laying Out Your Table 116

Changing the size of a table, columns, and rows 116

Adjusting column and row size 116

Inserting columns and rows 117

Deleting columns and rows 118

Moving columns and rows 119

Aligning Text in Columns and Rows 120

Merging and Splitting Cells 121

Repeating Header Rows on Subsequent Pages 122

Formatting Your Table 123

Designing a table with a table style 123

Calling attention to different rows and columns 124

Decorating your table with borders and colors 124

Using Math Formulas in Tables 127

Neat Table Tricks 128

Changing the direction of header row text 128

Wrapping text around a table 129

Using a picture as the table background 130

Drawing diagonal lines on tables 131

Drawing on a table 132

Chapter 5: Taking Advantage of the Proofing Tools 133

Correcting Your Spelling Errors 133

Correcting misspellings one at a time 134

Running a spell–check 135

Preventing text from being spell checked 136

Checking for Grammatical Errors in Word 137

Getting a Word Definition 138

Finding and Replacing Text 138

The basics: Finding stray words and phrases 138

Narrowing your search 139

Conducting a find–and–replace operation 145

Researching a Topic Inside Word 146

Finding the Right Word with the Thesaurus 148

Proofing Text Written in a Foreign Language 149

Telling Office which languages you will use 150

Marking text as foreign language text 150

Translating Foreign Language Text 151

Chapter 6: Desktop Publishing with Word 153

Experimenting with Themes 153

Sprucing Up Your Pages 155

Decorating a page with a border 155

Putting a background color on pages 156

Getting Word s help with cover letters 157

Making Use of Charts, Diagrams, Shapes, and Photos 157

Working with the Drawing Canvas 158

Positioning and Wrapping Objects Relative to the Page and Text 159

Wrapping text around an object 159

Positioning an object on a page 161

Working with Text Boxes 163

Inserting a text box 163

Making text flow from text box to text box 164

Dropping In a Drop Cap 164

Watermarking for the Elegant Effect 165

Putting Newspaper–Style Columns in a Document 166

Doing the preliminary work 167

Running text into columns 167

Landscape Documents 168

Printing on Different Size Paper 169

Showing Online Video in a Document 169

Chapter 7: Getting Word s Help with Office Chores 171

Highlighting Parts of a Document 171

Commenting on a Document 172

Entering a comment 172

Viewing and displaying comments 174

Caring for and feeding comments 174

Tracking Changes to Documents 175

Telling Word to start marking changes 176

Reading and reviewing a document with change marks 176

Marking changes when you forgot to turn on change marks 178

Accepting and rejecting changes to a document 179

Printing an Address on an Envelope 180

Printing a Single Address Label (Or a Page of the Same Label) 182

Churning Out Letters, Envelopes, and Labels for Mass Mailings 183

Preparing the source file 184

Merging the document with the source file 185

Printing form letters, envelopes, and labels 189

Chapter 8: Tools for Reports and Scholarly Papers 191

Alphabetizing a List 191

Outlines for Organizing Your Work 192

Viewing the outline in different ways 193

Rearranging document sections in Outline view 193

Collapsing and Expanding Parts of a Document 194

Generating a Table of Contents 195

Creating a TOC 195

Updating and removing a TOC 196

Customizing a TOC 196

Changing the structure of a TOC 197

Indexing a Document 199

Marking index items in the document 199

Generating the index 201

Editing an index 203

Putting Cross References in a Document 203

Putting Footnotes and Endnotes in Documents 205

Entering a footnote or endnote 206

Choosing the numbering scheme and position of notes 207

Deleting, moving, and editing notes 208

Compiling a Bibliography 208

Inserting a citation for your bibliography 208

Editing a citation 210

Changing how citations appear in text 210

Generating the bibliography 211

Book III: Excel 2016 213

Chapter 1: Up and Running with Excel 215

Creating a New Excel Workbook 215

Getting Acquainted with Excel 217

Rows, columns, and cell addresses 219

Workbooks and worksheets 219

Entering Data in a Worksheet 219

The basics of entering data 219

Entering text labels 221

Entering numeric values 221

Entering date and time values 222

Quickly Entering Lists and Serial Data with the AutoFill Command 225

Formatting Numbers, Dates, and Time Values 227

Establishing Data–Validation Rules 228

Chapter 2: Refining Your Worksheet 233

Editing Worksheet Data 233

Moving Around in a Worksheet 234

Getting a Better Look at the Worksheet 235

Freezing and splitting columns and rows 235

Hiding columns and rows 237

Comments for Documenting Your Worksheet 238

Selecting Cells in a Worksheet 240

Deleting, Copying, and Moving Data 240

Handling the Worksheets in a Workbook 241

Keeping Others from Tampering with Worksheets 243

Hiding a worksheet 244

Protecting a worksheet 244

Chapter 3: Formulas and Functions for Crunching Numbers 247

How Formulas Work 247

Referring to cells in formulas 248

Referring to formula results in formulas 250

Operators in formulas 250

The Basics of Entering a Formula 253

Speed Techniques for Entering Formulas 254

Clicking cells to enter cell references 254

Entering a cell range 254

Naming cell ranges so that you can use them in formulas 256

Referring to cells in different worksheets 258

Copying Formulas from Cell to Cell 259

Detecting and Correcting Errors in Formulas 261

Correcting errors one at a time 261

Running the error checker 261

Tracing cell references 263

Working with Functions 264

Using arguments in functions 265

Entering a function in a formula 265

A Look at Some Very Useful Functions 269

AVERAGE for Averaging Data 269

COUNT and COUNTIF for Tabulating Data Items 270

CONCATENATE for Combining Values 270

PMT for Calculating How Much You Can Borrow 272

IF for Identifying Data 274

LEFT, MID, and RIGHT for Cleaning Up Data 275

PROPER for Capitalizing Words 275

LARGE and SMALL for Comparing Values 275

NETWORKDAY and TODAY for Measuring Time in Days 277

LEN for Counting Characters in Cells 278

Chapter 4: Making a Worksheet Easier to Read and Understand 279

Laying Out a Worksheet 279

Aligning numbers and text in columns and rows 279

Inserting and deleting rows and columns 282

Changing the size of columns and rows 282

Decorating a Worksheet with Borders and Colors 284

Cell styles for quickly formatting a worksheet 284

Formatting cells with table styles 286

Slapping borders on worksheet cells 287

Decorating worksheets with colors 288

Getting Ready to Print a Worksheet 289

Making a worksheet fit on a page 289

Making a worksheet more presentable 293

Repeating row and column headings on each page 294

Chapter 5: Advanced Techniques for Analyzing Data 297

Seeing What the Sparklines Say 297

Conditional Formats for Calling Attention to Data 298

Managing Information in Lists 300

Sorting a list 300

Filtering a list 301

Forecasting with the Goal Seek Command 303

Performing What If Analyses with Data Tables 305

Using a one input table for analysis 305

Using a two input table for analysis 307

Analyzing Data with PivotTables 308

Getting a PivotTable recommendation from Excel 310

Creating a PivotTable from scratch 310

Putting the finishing touches on a PivotTable 312

Book IV: PowerPoint 2016 313

Chapter 1: Getting Started in PowerPoint 315

Getting Acquainted with PowerPoint 316

A Brief Geography Lesson 317

A Whirlwind Tour of PowerPoint 318

Creating a New Presentation 319

Advice for Building Persuasive Presentations 322

Creating New Slides for Your Presentation 324

Inserting a new slide 324

Speed techniques for inserting slides 326

Conjuring slides from Word document headings 326

Selecting a different layout for a slide 328

Getting a Better View of Your Work 328

Changing views 328

Looking at the different views 328

Hiding and Displaying the Slides Pane and Notes Pane 330

Selecting, Moving, and Deleting Slides 330

Selecting slides 331

Moving slides 331

Deleting slides 331

Putting Together a Photo Album 332

Creating your photo album 332

Putting on the final touches 334

Editing a photo album 335

Hidden Slides for All Contingencies 335

Hiding a slide 335

Showing a hidden slide during a presentation 336

Chapter 2: Fashioning a Look for Your Presentation 337

Looking at Themes and Slide Backgrounds 337

Choosing a Theme for Your Presentation 339

Creating Slide Backgrounds on Your Own 340

Using a solid (or transparent) color for the slide background 340

Creating a gradient color blend for slide backgrounds 341

Placing a picture in the slide background 343

Using a photo of your own for a slide background 344

Using a texture for a slide background 345

Changing the Background of a Single or Handful of Slides 346

Choosing the Slide Size 347

Using Master Slides and Master Styles for a Consistent Design 347

Switching to Slide Master view 348

Understanding master slides and master styles 348

Editing a master slide 350

Changing a master slide layout 350

Chapter 3: Entering the Text 351

Entering Text 351

Choosing fonts for text 352

Changing the font size of text 352

Changing the look of text 353

Fun with Text Boxes and Text Box Shapes 355

Controlling How Text Fits in Text Frames and Text Boxes 356

Choosing how AutoFit works in text frames 357

Choosing how AutoFits works in text boxes 359

Positioning Text in Frames and Text Boxes 359

Handling Bulleted and Numbered Lists 360

Creating a standard bulleted or numbered list 360

Choosing a different bullet character, size, and color 361

Choosing a different list–numbering style, size, and color 362

Putting Footers (and Headers) on Slides 363

Some background on footers and headers 363

Putting a standard footer on all your slides 364

Creating a nonstandard footer 365

Removing a footer from a single slide 366

Chapter 4: Making Your Presentations Livelier 367

Suggestions for Enlivening Your Presentation 367

Presenting Information in a Table 368

Exploring Transitions and Animations 370

Showing transitions between slides 370

Animating parts of a slide 372

Making Audio Part of Your Presentation 374

Inserting an audio file on a slide 375

Telling PowerPoint when and how to play an audio file 375

Playing audio during a presentation 376

Playing Video on Slides 377

Inserting a video on a slide 377

Fine–tuning a video presentation 378

Experimenting with the look of the video 379

Recording a Voice Narration for Slides 380

Chapter 5: Delivering a Presentation 383

All about Notes 383

Rehearsing and Timing Your Presentation 384

Showing Your Presentation 385

Starting and ending a presentation 386

Going from slide to slide 387

Tricks for Making Presentations a Little Livelier 389

Wielding a pen or highlighter in a presentation 389

Blanking the screen 391

Zooming In 391

Delivering a Presentation When You Can t Be There in Person 391

Providing handouts for your audience 392

Creating a self–running, kiosk–style presentation 393

Creating a user–run presentation 394

Presenting a Presentation Online 397

Packaging your presentation on a CD 398

Creating a presentation video 401

Book V: OneNote 2016 405

Chapter 1: Up and Running with OneNote 407

Introducing OneNote 407

Finding Your Way Around the OneNote Screen 408

Notebook pane 408

Section (and section group) tabs 408

Page window 408

Page pane 409

Units for Organizing Notes 409

Creating a Notebook 410

Creating Sections and Section Groups 412

Creating a new section 412

Creating a section group 413

Creating Pages and Subpages 414

Creating a new page 414

Creating a new subpage 415

Renaming and Deleting Groups and Pages 415

Getting from Place to Place in OneNote 415

Changing Your View of OneNote 416

Chapter 2: Taking Notes 419

Entering a Typewritten Note 419

Notes: The Basics 420

Moving and resizing note containers 420

Formatting the Text in Notes 420

Selecting notes 422

Deleting notes 422

Getting more space for notes on a page 422

Drawing on the Page 423

Drawing with a pen or highlighter 423

Drawing a shape 424

Changing the size and appearance of drawings and shapes 425

Converting a Handwritten Note to Text 426

Writing a Math Expression in a Note 427

Taking a Screen–Clipping Note 428

Recording and Playing Audio Notes 429

Recording an audio note 429

Playing an audio note 431

Attaching, Copying, and Linking Files to Notes 431

Attaching an Office file to a note 431

Copying an Office file into OneNote 432

Linking a Word or PowerPoint file to OneNote 432

Copying a note into another Office program 434

Chapter 3: Finding and Organizing Your Notes 435

Finding a Stray Note 435

Searching by word or phrase 435

Searching by author 436

Tagging Notes for Follow Up 437

Tagging a note 438

Arranging tagged notes in the task pane 439

Creating and modifying tags 439

Color–Coding Notebooks, Sections, and Pages 440

Merging and Moving Sections, Pages, and Notes 441

Book VI: Outlook 2016 443

Chapter 1: Outlook Basics 445

What Is Outlook, Anyway? 445

Navigating the Outlook Folders 446

Categorizing Items 448

Creating a category 448

Assigning items to categories 449

Arranging items by category in folders 449

Searching for Stray Folder Items 449

Conducting an instant search 450

Refining a search 451

Conducting an advanced search 452

Deleting Email Messages, Contacts, Tasks, and Other Items 452

Finding and Backing Up Your Outlook File 453

Cleaning Out Your Folders 454

Archiving the old stuff 454

Running the Mailbox Cleanup command 457

Chapter 2: Maintaining the Contacts Folder 459

Maintaining a Happy and Healthy Contacts Folder 459

Entering a new contact in the Contacts folder 460

Changing a contact s information 462

Contact Groups for Sending Messages to Groups 463

Creating a contact group 463

Addressing email to a contact group 465

Editing a contact group 466

Finding a Contact in the Contacts Folder 466

Printing the Contacts Folder 466

Different ways to print contact information 466

Changing the look of printed pages 467

Chapter 3: Handling Your Email 469

Setting Up an Email Account 469

Addressing and Sending Email Messages 470

The basics: Sending an email message 470

Addressing an email message 472

Sending copies and blind copies of messages 474

Replying to and forwarding email messages 475

Sending Files and Photos 476

Sending a file along with a message 476

Including a photo in an email message 477

Receiving Email Messages 478

Getting your email 478

Being notified that email has arrived 479

Reading Your Email in the Inbox Window 479

Handling Files That Were Sent to You 481

Opening a file you received 482

Saving a file you received 482

Techniques for Organizing Email Messages 482

Flagging email messages 484

Being reminded to take care of email messages 485

Rules for earmarking messages as they arrive 486

All about Email Folders 487

Moving email messages to different folders 487

Creating a new folder for storing email 488

Yes, You Can Prevent Junk Mail (Sort of) 489

Defining what constitutes junk email 489

Preventative medicine for junk email 490

Chapter 4: Managing Your Time and Schedule 491

Introducing the Calendar 491

The Different Kinds of Activities 492

Seeing Your Schedule 493

Going to a different day, week, or month 493

Rearranging the Calendar window 494

Scheduling Appointments and Events 494

Scheduling an activity: The basics 494

Scheduling a recurring appointment or event 496

Scheduling an event 497

Canceling, Rescheduling, and Altering Activities 497

Chapter 5: Tasks, Reminders, and Notes 499

Tasks: Seeing What Needs to Get Done 499

Entering a task in the Tasks window 499

Examining tasks in the Tasks window 501

Handling and managing tasks 502

Reminders for Being Alerted to Activities and Tasks 502

Handling reminder messages 503

Scheduling a reminder message 503

Making reminders work your way 504

Making Notes to Yourself 504

Book VII: Access 2016 507

Chapter 1: Introducing Access 509

What Is a Database, Anyway? 509

Tables, Queries, Forms, and Other Objects 510

Database tables for storing information 510

Forms for entering data 512

Queries for getting the data out 512

Reports for presenting and examining data 514

Macros and modules 514

Creating a Database File 515

Creating a blank database file 516

Getting the help of a template 516

Finding Your Way Around the Navigation Pane 517

Designing a Database 518

Deciding what information you need 518

Separating information into different database tables 519

Choosing fields for database tables 521

Deciding on a primary key field for each database table 521

Mapping the relationships between tables 522

Chapter 2: Building Your Database Tables 523

Creating a Database Table 523

Creating a database table from scratch 524

Creating a database table from a template 524

Importing a table from another database 525

Opening and Viewing Tables 527

Entering and Altering Table Fields 528

Creating a field 528

All about data types 530

Designating the primary key field 532

Moving, renaming, and deleting fields 533

Field Properties for Making Sure That Data Entries Are Accurate 533

A look at the Field Properties settings 534

Creating a lookup data–entry list 539

Indexing for Faster Sorts, Searches, and Queries 541

Indexing a field 542

Indexing based on more than one field 542

Establishing Relationships Between Database Tables 544

Types of relationships 545

Handling tables in the Relationships window 546

Forging relationships between tables 547

Editing table relationships 549

Chapter 3: Entering the Data 551

The Two Ways to Enter Data 551

Entering the Data in Datasheet View 552

Entering data 553

Two tricks for entering data quicker 554

Changing the appearance of the datasheet 555

Entering the Data in a Form 556

Creating a form 556

Entering the data 557

Finding a Missing Record 557

Finding and Replacing Data 559

Chapter 4: Sorting, Querying, and Filtering for Data 561

Sorting Records in a Database Table 561

Ascending vs. descending sorts 561

Sorting records 562

Filtering to Find Information 562

Different ways to filter a database table 564

Unfiltering a database table 564

Filtering by selection 565

Filtering for input 565

Filtering by form 566

Querying: The Basics 568

Creating a new query 568

Viewing queries in Datasheet and Design view 569

Finding your way around the Query Design window 570

Choosing which database tables to query 570

Choosing which fields to query 571

Sorting the query results 572

Choosing which fields appear in query results 572

Entering criteria for a query 573

At last saving and running a query 576

Six Kinds of Queries 576

Select query 576

Top–value query 576

Summary query 577

Calculation query 578

Delete query 579

Update query 580

Chapter 5: Presenting Data in a Report 581

Creating a Report 581

Opening and Viewing Reports 583

Tweaking a Report 583

Book VIII: Working with Charts and Graphics 587

Chapter 1: Creating a Chart 589

The Basics: Creating a Chart 589

Choosing the Right Chart 591

Providing the Raw Data for Your Chart 593

Positioning Your Chart in a Workbook, Page, or Slide 595

Changing a Chart s Appearance 595

Changing the chart type 596

Changing the size and shape of a chart 597

Choosing a new look for your chart 597

Changing the layout of a chart 598

Handling the gridlines 599

Changing a chart element s color, font, or other particular 600

Saving a Chart as a Template So That You Can Use It Again 601

Saving a chart as a template 601

Creating a chart from a template 602

Chart Tricks for the Daring and Heroic 602

Decorating a chart with a picture 602

Annotating a chart 603

Displaying the raw data alongside the chart 604

Placing a trendline on a chart 605

Troubleshooting a Chart 606

Chapter 2: Making a SmartArt Diagram 607

The Basics: Creating SmartArt Diagrams 607

Choosing a diagram 607

Making the diagram your own 609

Creating the Initial Diagram 609

Creating a diagram 610

Swapping one diagram for another 611

Changing the Size and Position of a Diagram 611

Laying Out the Diagram Shapes 612

Selecting a diagram shape 612

Removing a shape from a diagram 612

Moving diagram shapes to different positions 612

Adding shapes to diagrams apart from hierarchy diagrams 613

Adding shapes to hierarchy diagrams 614

Adding shapes to Organization charts 615

Promoting and demoting shapes in hierarchy diagrams 617

Handling the Text on Diagram Shapes 617

Entering text on a diagram shape 617

Entering bulleted lists on diagram shapes 618

Changing a Diagram s Direction 619

Choosing a Look for Your Diagram 620

Changing the Appearance of Diagram Shapes 621

Changing the size of a diagram shape 621

Exchanging one shape for another 622

Changing a shape s color, fill, or outline 622

Changing fonts and font sizes on shapes 623

Creating a Diagram from Scratch 624

Chapter 3: Handling Graphics and Photos 625

All about Picture File Formats 625

Bitmap and vector graphics 625

Resolution 627

Compression 627

Color depth 628

Choosing file formats for graphics 628

Inserting a Picture in an Office File 629

Inserting a picture of your own 629

Obtaining a picture online 630

Touching Up a Picture 632

Softening and sharpening pictures 632

Correcting a picture s brightness and contrast 633

Recoloring a picture 633

Choosing an artistic effect 634

Selecting a picture style 635

Cropping off part of a picture 636

Removing the background 637

Compressing Pictures to Save Disk Space 639

Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 641

The Basics: Drawing Lines, Arrows, and Shapes 642

Handling Lines, Arrows, and Connectors 643

Changing the length and position of a line or arrow 643

Changing the appearance of a line, arrow, or connector 644

Attaching and handling arrowheads on lines and connectors 645

Connecting shapes by using connectors 646

Handling Rectangles, Ovals, Stars, and Other Shapes 648

Drawing a shape 648

Changing a shape s symmetry 650

Using a shape as a text box 650

WordArt for Embellishing Letters and Words 651

Creating WordArt 652

Editing WordArt 652

Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects 652

Selecting objects so that you can manipulate them 654

Hiding and displaying the rulers and grid 655

Changing an Object s Size and Shape 656

Changing an Object s Color, Outline Color, and Transparency 657

Filling an object with color, a picture, or a texture 657

Making a color transparent 660

Putting the outline around an object 660

Moving and Positioning Objects 661

Tricks for aligning and distributing objects 662

When objects overlap: Choosing which appears above the other 664

Rotating and flipping objects 666

Grouping objects to make working with them easier 667

Book IX: Office 2016 One Step Beyond 669

Chapter 1: Customizing an Office Program 671

Customizing the Ribbon 671

Displaying and selecting tab, group, and command names 673

Moving tabs and groups on the Ribbon 673

Adding, removing, and renaming tabs, groups, and commands 674

Creating new tabs and groups 675

Resetting your Ribbon customizations 676

Customizing the Quick Access Toolbar 676

Adding buttons to the Quick Access toolbar 677

Changing the order of buttons on the Quick Access toolbar 678

Removing buttons from the Quick Access toolbar 678

Placing the Quick Access toolbar above or below the Ribbon 679

Customizing the Status Bar 679

Changing the Screen Background and Office Theme 680

Customizing Keyboard Shortcuts in Word 681

Chapter 2: Ways of Distributing Your Work 685

Printing the Old Standby 685

Distributing a File in PDF Format 686

About PDF files 687

Saving an Office file as a PDF 687

Sending Your File in an Email Message 687

Saving an Office File as a Web Page 688

Choosing how to save the component parts 689

Turning a file into a web page 690

Opening a web page in your browser 691

Blogging from inside Word 691

Describing a blog account to Word 691

Posting an entry to your blog 692

Taking advantage of the Blog Post tab 693

Chapter 3: Working with Publisher 695

A Print Shop in a Can 695

Introducing Frames 696

Creating a Publication 697

Redesigning a Publication 697

Choosing a different template 698

Choosing a color scheme 699

Setting up your pages 699

Getting a Better View of Your Work 699

Zooming in and out 699

Viewing single pages and two–page spreads 700

Going from page to page 700

Entering Text on the Pages 701

Making Text Fit in Text Frames 702

Fitting overflow text in a single frame 703

Making text flow from frame to frame 703

Making Text Wrap around a Frame or Graphic 704

Replacing the Placeholder Pictures 705

Inserting, Removing, and Moving Pages 706

Master Pages for Handling Page Backgrounds 707

Switching to Master Page view 707

Changing the look of a master page 708

Applying (or unapplying) a master page to publication pages 708

Running the Design Checker 709

Commercially Printing a Publication 710

Book X: File Sharing and Collaborating 711

Chapter 1: Up and Running on OneDrive 713

Signing In to OneDrive 713

Exploring the OneDrive Window 715

Managing Your OneDrive Folders 715

Creating a folder 715

Viewing and locating folders in the OneDrive window 716

Going from folder to folder in OneDrive 716

Deleting, moving, and renaming folders 718

Uploading Files to a Folder on OneDrive 719

Saving a File from Office 2016 to OneDrive 720

Opening a File from OneDrive 722

Starting in an Office 2016 application 722

Starting in OneDrive 722

Downloading Files from OneDrive to Your Computer 722

Chapter 2: File Sharing and Collaborating 723

Sharing Files: The Big Picture 723

Sharing Your Files and Folders with Others 724

Inviting people by email 724

Generating a link to shared files 725

Generating HTML code 727

Seeing Files and Folders Others Shared with You 728

Investigating and Changing How Files and Folders Are Shared 729

Index 731

O autorze

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.

Blurb

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