Cantitate/Preț
Produs

Office 2016 in Depth (Includes Content Update Program): In Depth

Autor Joe Habraken
en Limba Engleză Paperback – 13 oct 2015

This book is packed with intensely useful knowledge, tips, and shortcuts students just won't find anywhere else. It's the fastest, best way to master Office 2016's full power, and the great new features built into Word, Excel, PowerPoint, Outlook, Publisher, and OneNote.

Citește tot Restrânge

Din seria In Depth

Preț: 22221 lei

Puncte Express: 333

Preț estimativ în valută:
4257 4611$ 3651£

Carte indisponibilă temporar

Doresc să fiu notificat când acest titlu va fi disponibil:

Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9780789755674
ISBN-10: 078975567X
Pagini: 1008
Dimensiuni: 178 x 229 x 56 mm
Greutate: 1.5 kg
Editura: Que
Seria In Depth


Notă biografică

Joe Habraken is a computer technology professional, educator, and best-selling author with more than 25 years of experience in the information technology and digital media production fields. His books include numerous titles on the Microsoft Office application suite, computer networking, and Microsoft's Windows Server network platform. Titles include Que's Microsoft Office 2013 In Depth and Sams Teach Yourself Windows Server 2008 in 24 Hours. Joe is an associate professor of Communication at the University of New England in Biddeford, Maine, where he teaches a variety of digital media and information technology courses.


Cuprins

Introduction 1

I Introduction to the Office 2016 Application Suite

1 Getting Oriented to the Office 2016 Applications 5

Introducing Office 2016 5

New Features and Tools in Office 2016 8

Saving and Sharing Files in the Cloud 8

Editing Adobe Acrobat Files 9

Other Office 2016 Improvements and Updates 10

The Office 2016 Suite Applications 11

The Different Versions of the Office 2016 Suite 12

Hardware and Software Requirements for Office 2016 13

Installing Office 2016 14

Getting Help in the Office Applications 16

2 Navigating and Customizing the Office Interface 19

Getting Familiar with the Office Interface 19

Galleries 20

Contextual Tabs 21

Overview of the Office Application Window 22

Navigating the Office Applications 25

Working with the Ribbon 25

Working in the Backstage 28

Customizing an Application Interface 30

Customizing the Ribbon 31

Customizing the Quick Access Toolbar 33

Customizing the Status Bar 36

Configuring Application Options 37

Advanced Option Settings 39

Add-Ins 39

Using Office Add-ins 40

Using the Trust Center 41

Trusted Publishers 43

Trusted Locations 44

3 Managing and Sharing Office Files 47

Understanding Office File Formats 47

Saving Files as Different File Types 50

Converting Files to Different File Types 51

Configuring Save File Options 52

Creating and Managing Files 54

Managing Files 56

Creating a New Folder 57

Creating a New Library 58

Viewing File Versions in an Application 59

Searching for Office Files 60

Sharing Files Using Homegroup 61

Protecting an Office File 63

Prepare a File for Sharing 65

4 Using and Creating Graphics 67

The Office 2016 Options for Graphics and Pictures 67

Working with SmartArt Graphics 70

Inserting SmartArt Graphics 72

Modifying SmartArt Graphics 74

Working with Your Digital Pictures 77

Inserting Pictures 77

Adjusting Pictures 78

Cropping an Image 81

Using the Background Removal Tool 81

Inserting Online Pictures 83

Inserting Bing Image Search Results 84

Inserting Facebook Images 84

Inserting Flickr.com Images 85

Inserting Images from Your OneDrive 86

Using Shapes and the Office Drawing Tools 87

Adding and Combining Multiple Shapes 88

Formatting a Shape with the Drawing Tools 90

Using the Screenshot Feature 91

Using WordArt 93

5 Using the Office Apps 95

What the Online Apps Can Do 96

Where the Online Apps Live 97

Saving Office Application Files to the Cloud 99

Saving a File to OneDrive or OneDrive for Business 101

Sharing a File Saved to the Cloud 102

Using the Word Online app 104

The Word Online App's File Tab 105

The Word Online App's Home Tab 106

The Word Online App's Insert Tab 107

The Word Online App's Review Tab 108

The Word Online App's View Tab 108

Using Excel Online 109

The Excel Online App's File Tab 109

Working in the Excel Online App 110

Inserting Functions and Charts in the Excel Online App 110

Using PowerPoint Online 113

Working with Slides 114

Adding Pictures and SmartArt 115

The Windows 10 Mobile Office Apps 116

The Word Mobile App 117

The Excel Mobile App 120

II Word

6 Requisite Word: Essential Features 123

Introducing Word 2016 123

The Word 2016 Interface 123

New Features and Improvements 125

Options for Creating a New Word Document 126

Using Templates 128

Creating a Template 131

Attaching a Template 133

Navigating a Word Document 134

Moving Around a Document with the Mouse 134

Moving Around a Document with the Keyboard 135

Selecting Text 136

Understanding Document Formatting 137

Character Formatting Versus Paragraph Formatting 137

Manual Formatting Versus Styles and Themes 138

Working with Fonts and Text Formatting 138

Formatting Text 139

Working with Paragraph Formatting 142

Setting Paragraph Alignment 143

Changing Line Spacing 144

Setting Line and Page Breaks 145

Setting Indents 146

Working with Tabs 148

Page Layout: Margins and Page Options 150

Changing Margins 151

Changing Page Orientation and Paper Size 152

Inserting Page Breaks 152

Printing Documents 152

7 Enhancing Word Documents 155

Creating Better Documents 155

Creating Bulleted and Numbered Lists 156

Bulleted Lists 156

Numbered Lists 158

Multilevel Lists 159

Working with Borders and Shading 160

Formatting with Themes 162

Creating Headers and Footers 166

Inserting Headers and Footers 167

The Header and Footer Tools 168

Working with Page Numbering 170

Inserting Pictures, Clip Art, and Charts 171

Inserting Pictures 172

Inserting Online Pictures and Clip Art 173

Inserting a Chart 175

Integrating Text and Images 177

Changing the Document Display 178

Using the Navigation Pane 180

Using the Outline View 181

Splitting the Document Window 182

Using the Review Tools 183

Running Spelling and Grammar 183

Using the Thesaurus 184

Using the Insights Command 185

Working with Quick Parts 186

Creating and Inserting an AutoText Entry 186

Creating and Inserting Building Blocks 187

Configuring AutoCorrect 188

Understanding Styles 189

Using the Styles Gallery 190

Creating Styles 191

Editing Styles 192

Managing Styles 193

8 Working with Tables, Columns, and Sections 197

Options for Adding a Table 197

Inserting a Table 199

Drawing a Table 201

Converting Text to a Table 201

Entering and Deleting Text and Navigating a Table 202

Selecting and Positioning a Table 203

Formatting Tables 204

Adjusting Columns and Rows 206

Formatting Cells 207

Using Table Styles 209

Sorting Table Data 211

Using Formulas in Tables 212

Adding Columns to a Document 214

Understanding Sections 215

Adding and Removing Section Breaks 216

Formatting Page Attributes in a Section 217

9 Managing Mailings and Forms 219

Options for Mail-Related Documents 219

Creating an Envelope 220

Creating a Label or Labels 222

Understanding Mass Mailings 223

Performing a Mail Merge 223

Using the Mail Merge Commands 225

Understanding Recipient Lists 226

Creating a Recipient List 227

Editing and Manipulating a Recipient List 229

Using Merge Fields 231

Using Merge Rules 233

Previewing Merge Results 234

Completing the Merge 235

Creating Merged Envelopes and Labels 235

Understanding Word Fields 236

Building a Form with Form Controls 238

10 Creating Special Documents 241

Options for Large Documents 241

Creating a Table of Contents 242

Creating a Table of Contents with Built-in Styles 243

Creating a Table of Contents with Your Own Styles 244

Adding Entries and Updating the TOC 246

Building a TOC with Field Codes 247

Working with Captions and Tables of Figures 249

Inserting a Caption 249

Inserting a Table of Figures 250

Using Cross-References 251

Generating an Index 253

Marking Index Entries 254

Inserting the Index 255

Working with Citations and Bibliographies 256

Creating Citations 256

Managing Citations 257

Inserting the Bibliography 258

Inserting Footnotes and Endnotes 260

Tracking Document Changes 261

Options for Viewing Changes 264

Reviewing Changes 265

Comparing Documents 266

Building a Better "Big" Document 268

Creating Bookmarks 268

Inserting Comments 269

Creating a Master Document 270

Working in Outline View 271

Creating Subdocuments from Scratch 272

Inserting Existing Document Files into a Master Document Outline 273

Manipulating the Master Document 274

III Excel

11 Requisite Excel: Essential Features 275

Introducing Excel 2016 275

Navigating the Excel Workspace 277

The Excel Ribbon 278

Moving Around a Worksheet 280

Creating Workbooks and Worksheets 281

Using Office.com Templates 281

Inserting and Rearranging Worksheets 283

Managing Excel Workbooks 284

Protecting Workbooks and Worksheets 286

Locking Cells 286

Specifying Edit Ranges 288

Preparing a Workbook for Sharing 290

Managing Versions 291

Entering Data in a Worksheet 291

Entering Labels 292

Entering Values 292

Using AutoComplete 293

Filling and Entering Series 294

Using the Fill Handle 295

Creating Custom Fill Lists 297

Creating Custom Series 298

Using Flash Fill 299

Copying, Moving, and Deleting Cell Contents 299

Using the Paste Special Dialog Box 302

Moving Cells and Ranges 304

Clearing and Deleting Cells 304

Editing Cell Content 305

Viewing Worksheets 306

Printing Worksheets 308

Using the Page Layout Commands 308

Setting a Print Area 310

Inserting Page Breaks 310

Setting Print Titles 311

Working on the Print Page 311

Inserting Headers and Footers 313

12 Worksheet Formatting and Management 315

Formatting Text Entries 315

Accessing the Format Cells Dialog Box 316

Changing Text Orientation 317

Formatting Values 318

Using the Format Cells Dialog Box 320

Creating Custom Number Formats 321

Adding Comments to Cells 323

Formatting Comment Text 324

Deleting and Viewing Comments 324

Using Themes 325

Formatting Cells Using Borders and Color 326

Adding Cell Borders 326

Using Background Colors 328

Using Cell Styles and the Format Painter 328

Creating a Cell Style 329

Using the Format Painter 330

Using Conditional Formatting 330

Using Highlight Cell Rules 331

Using Top/Bottom Rules 332

Using Data Bars 333

Using Color Scales 334

Using Icon Sets 334

Creating Conditional Formatting Rules 334

Manipulating Cells and Cell Content 336

Inserting Cells 336

Merging Cells and Wrapping Text 337

Finding and Replacing Cell Items 337

Working with Columns and Rows 339

Changing Column Width and Row Height 339

Inserting Columns and Rows 340

Deleting Columns and Rows 340

Hiding Columns and Rows 341

Working with Worksheets 341

Freezing Rows and Columns 341

Splitting Worksheets 342

Hiding Worksheets 343

Naming Ranges 343

Creating Range Names from Selections 345

Managing Range Names 345

Adding Images and Graphics to Worksheets 346

13 Getting the Most from Formulas and Functions 349

Performing Calculations in Excel Worksheets 349

Relative Versus Absolute Referencing 351

Creating and Editing Formulas 354

Understanding Operator Precedence 355

Entering Formulas 356

Editing Formulas 356

Working with Excel Functions 357

Entering a Function in a Cell 358

Using AutoSum 358

Using the Status Bar Statistical Functions 360

Using the Insert Function Dialog Box 360

Using the Function Library 361

Using Range Names in Formulas and Functions 364

Inserting a Range Name into a Formula 364

Inserting a Range Name into a Function 365

Referencing Cells or Ranges on Other Worksheets 366

Copying and Moving Formulas and Functions 368

Choosing the Right Function 368

Financial Functions 369

Logical Functions 370

Statistical Functions 372

Lookup & Reference Functions 373

Date & Time Functions 374

Text Functions 375

Other Function Categories 376

Proofing Your Formulas and Functions 377

Common Error Messages 377

Using the Auditing Tools 379

Using the Watch Window 380

14 Enhancing Worksheets with Charts 383

Understanding Excel Charts 383

Chart Terminology 384

Using Different Chart Types 387

Creating Charts 393

Inserting a Chart from the Ribbon 394

Selecting a Recommended Chart 395

Inserting Charts with the Quick Analysis Gallery 395

Tools for Quickly Customizing a Chart 396

Moving, Copying, or Deleting a Chart 397

Modifying a Chart 398

Changing Chart Type or Chart Data 398

Selecting Chart Layouts and Styles 400

Working with Chart Elements 402

Modifying Titles and Data Labels 404

Working with the Legend and Data Points 404

Manipulating Axes and Gridlines 406

Adding Trendlines, Drop Lines, and Bars to a Chart 406

Creating a Combination Chart 410

Working with a Pie of Pie Chart 411

Creating a Custom Combination Chart 411

Using Sparklines 413

Creating Sparklines 413

Modifying Sparklines 414

15 Using Excel Tables and Pivottables 417

Excel and Databases 417

Defining a Table Range 418

Creating a Table Using Styles 419

Using the Table Tools 420

Sorting Table Data 421

How Excel Sorts Data 422

Using the Sort Dialog Box 422

Filtering Table Data 424

Using the AutoFilter Search Box 425

Creating Custom AutoFilters 425

Filtering Tables with Slicers 428

Creating Advanced Filters 429

Using the Data Form 431

Creating Outlines and Subtotals 432

Working with External Data 435

Importing Data from Access 436

Importing a Web Table 437

Importing Text Files 438

Connecting to Other Data Sources 439

Using Microsoft Query 441

Viewing and Refreshing Connections 444

Working with PivotTables 445

Using the Recommended PivotTables Command 447

Creating a PivotTable 447

Working with the PivotTable Tools 450

Using Slicers 452

16 Validating and Analyzing Worksheet Data 453

Taking Advantage of Data Validation 453

Specifying Validation Criteria 454

Configuring Input Messages and Error Alerts 456

Circling Invalid Data 458

Performing a What-If Analysis 459

Creating a Data Table 460

Creating Scenarios 462

Viewing Scenarios and Creating Reports 464

Using Goal Seek and Solver 466

Working with Goal Seek 466

Working with Solver 467

IV PowerPoint

17 Requisite Powerpoint: Essential Features 471

PowerPoint 2016 471

Options for Creating a New Presentation 472

Using Templates 473

Using a Theme to Create a New Presentation 476

Creating a Presentation from an Existing Presentation 477

Inserting Slides from the Reuse Slides Task Pane 478

Publishing Slides to a Library 479

Creating a Template 480

Inserting New Slides 481

Entering Text 482

Inserting Slides from a Word Outline 483

Inserting Other Object Content 483

Modifying a Slide's Layout 484

Working with Slides in Different Views 484

Zooming In and Out 486

Rulers, Gridlines, and Guides 487

Color/Grayscale Commands 488

Opening a New Presentation Window 489

Rearranging and Deleting Slides 490

Modifying Bulleted Lists 491

Using Numbered Lists 493

Viewing a Presentation During Editing 493

18 Advanced Presentation Formatting, Themes, and Masters 495

Working with Text Boxes and Formatting 495

Inserting a Text Box 496

Basic Text Formatting 497

Formatting a Text Box with the Drawing Tools 499

Selecting Quick Styles and Shape Attributes 499

Shape Fill, Outline, and Effects 500

Using WordArt Styles and Text Settings 503

Arranging Text in Tables 507

Inserting a Table on an Existing Slide 507

Formatting a Table 507

Table Layout Commands 508

Working with Themes 510

Applying Themes 511

Applying Theme Variants 512

Creating a Custom Theme 517

Using Headers and Footers 517

Understanding Masters 518

Altering and Creating Master Slides 520

Creating Layout Masters 522

Using Slide Sections 523

19 Better Slides with Clip Art, Pictures, and SmartArt 525

Using Graphics to Enhance Slides 525

Inserting a Picture 527

Adding Online Images to Slides 529

Creating a Photo Album 531

Adjusting Picture Settings 532

Configuring Album Layout Settings 533

Working with Shapes 534

Using SmartArt Graphics 535

Inserting a SmartArt Graphic 538

Converting Text to a SmartArt Graphic 539

Using the SmartArt Tools 540

Adding Charts to Slides 541

Inserting a Chart onto a Slide 542

Modifying and Formatting a Chart 544

Working with Slide Objects 546

Grouping Objects 546

Layering Objects 546

Adding Hyperlinks to Slides 547

20 Enhancing Slides with Animation, Transitions, and Multimedia 549

Animations versus Transitions 549

Assigning Animation to a Slide Object 551

Accessing Additional Animation Effects 553

Using Motion Paths 554

Advanced Animation Techniques 559

Changing Effect Options 560

Adding Additional Animations 561

Using the Animation Painter 562

Including Sound Effects with Animations 562

Setting Timings for Animations 564

Managing Slide Animations 565

Adding Transitions to Slides 566

Modifying Transitions 567

Adding Sound to a Slide 569

Editing Sound Options 569

Adding Video to a Slide 571

Inserting Online Video 571

Inserting a Video File 574

Modifying Your Video Clips 575

21 Delivering a Presentation and Creating Support Materials 577

Planning Your Presentation 578

Checking the Presentation for Spelling and Grammar Errors 579

Running Through a Completed Presentation 580

Using the Presenter View 581

Using Hidden Slides 583

Creating a Custom Slide Show 585

Creating a Self-Running Presentation 586

Setting Up a Slide Show 586

Rehearsing Timings 588

Recording a Slide Show 589

Creating an Interactive Presentation 590

Presenting a Slide Show Online 592

Presenting Online with Skype for Business 592

Presenting Online with the Office Presentation Service 593

Working with the Notes and Handout Masters 594

Setting Handout Master Options 595

Setting Notes Master Options 596

Printing Presentations, Notes, and Handouts 596

Exporting a Presentation 599

Sharing Your Presentation 600

V Outlook

22 Requisite Outlook: Configuration and Essential Features 603

Introducing Outlook 2016 603

Outlook and Email Accounts 604

Exchange ActiveSync 605

Outlook.com Email 606

Internet Email 606

Configuring Outlook at First Start 607

Understanding Outlook Profiles 610

Creating a New Profile 610

Managing Profiles 611

Loading Profiles 613

Understanding Outlook Data Files 614

Configuring Outlook for Microsoft Exchange Server 614

Creating Personal Folders Files 616

Repairing Outlook Data Files 617

Importing and Exporting Data 619

Importing Data 619

Exporting Data 621

Navigating the Outlook Workspace 621

Accessing Outlook Items Using the Navigation Bar 623

Working with Views in Outlook 624

Categorizing Outlook Items 627

Searching for Outlook Items 628

Using Advanced Find 629

Using Search Folders 629

Printing Outlook Items 631

23 Managing Email in Outlook 633

Working in the Mail Folder 633

Creating an Email Message 635

Using the Outlook Address Book 637

Setting Message Options 639

Specifying Email Format 640

Setting Message Flags, Importance, and Sensitivity 640

Configuring Voting Buttons, Receipts, and Delivery Options 642

The Message Options/Properties Dialog Box 645

Attaching Files and Items to a Message 647

Attaching a Business Card 648

Attaching a Calendar 648

Using Themes and Email Stationery 650

Adding a Signature 652

Sending Mail 653

Recalling a Message 653

Working with Received Email 654

Organizing Messages in the Inbox 655

Showing Messages as Conversations 655

Filtering Email 656

Managing Email 657

Using Quick Steps 658

Answering a Message 660

Forwarding a Message 660

Saving an Attachment 660

Deleting Messages 662

Printing Mail 663

Moving Email 663

Managing Email Accounts 664

Editing Email Account Settings 666

Adding an Email Account 667

Adding an Outlook.com Mail Account 669

Setting Outlook Mail Options 669

24 Using the Calendar for Appointments and Tasks 673

Navigating the Calendar 673

Changing the Calendar View 675

Change the Time Scale and Time Zone 677

Scheduling an Appointment 678

Scheduling a Recurring Appointment 680

Scheduling an Event 681

Editing and Managing Appointments 682

Searching the Calendar 683

Sharing Calendars 684

Creating a Calendar Share Invitation 685

Opening a Shared Calendar 686

Viewing Multiple Calendars 686

Emailing a Calendar 688

Publishing a Calendar Online 689

Setting Calendar Options 690

Working with Tasks 692

Using the Task Folder 693

Creating a New Task from the Task Folder 694

Creating a Recurring Task 694

Assigning and Accepting Tasks 695

Viewing and Managing Tasks 696

Managing Tasks 699

Setting Tasks Options 700

25 Working with Contacts and Planning Meetings 703

Navigating the Contacts List 703

Creating a New Contact 705

Entering Contact Details 708

Adding Fields for a Contact 709

Editing Contact Information 709

Editing a Business Card 711

Tagging Contacts with Flags and Categories 712

Mapping a Contact's Address 713

Searching the Contacts Folder 714

Organizing Contacts with Groups 715

Forwarding and Sharing Contacts 716

Forwarding Contacts 717

Sharing Contacts 718

Accessing Contacts on Social Networks 720

Communicating with Contacts 722

Contact Actions 724

Printing Contact Information 725

Setting Contact Options 726

Scheduling Meetings 726

Selecting the Meeting Location 728

Using the Scheduling Assistant 728

Viewing and Editing Meeting Information 729

Responding to Meeting Requests 730

26 Using the Journal and Notes 733

Using the Outlook Journal 733

Creating a New Journal Entry 734

Using the Journal Timer 735

Adding Tags and Names to a Journal Entry 736

Adding Outlook Items and Inserting Files 737

Journal Actions 739

Viewing the Journal 740

Manipulating the Journal View 741

Using Search to Filter Journal Entries 742

Working with Notes 742

Viewing and Managing Notes 743

Creating Appointments and Tasks from Notes 744

27 Securing and Maintaining Outlook 747

Security Overview 747

Malware and Antivirus