Introduction 1
What Makes This Book Different 2
Foolish Assumptions 3
Conventions Used in This Book 3
Icons Used in This Book 4
Beyond the Book 5
Book 1: Common Office Tasks 7
Chapter 1: Office Nuts and Bolts 9
Introducing Office 365 9
Finding Your Way around the Office Interface 13
Saving Your Files 20
Navigating the Save As and Open Windows 21
Opening and Closing Files 23
Reading and Recording File Properties 24
Locking a File with a Password 25
Trusting (or not Trusting) Microsoft with Your “Content” 26
Chapter 2: Wrestling with the Text 29
Manipulating the Text 29
Speaking, not Typing, the Words 32
Changing the Look of Text 34
Quick Ways to Handle Case, or Capitalization 41
Entering Symbols and Foreign Characters 42
Creating Hyperlinks 44
Chapter 3: Speed Techniques Worth Knowing About 49
Undoing and Repeating Commands 49
Zooming In, Zooming Out 51
Viewing a File through More than One Window 52
Correcting Typos on the Fly 53
Entering Text Quickly with the AutoCorrect Command 55
Book 2: Word 365 57
Chapter 1: Speed Techniques for Using Word 59
Introducing the Word Screen 59
Creating a New Document 61
Getting a Better Look at Your Documents 63
Selecting Text in Speedy Ways 68
Moving around Quickly in Documents 69
Inserting a Whole File into a Document 73
Getting Word to Read It 74
Entering Information Quickly in a Computerized Form 74
Chapter 2: Laying Out Text and Pages 79
Paragraphs and Formatting 79
Inserting a Section Break for Formatting Purposes 80
Breaking a Line 83
Starting a New Page 83
Setting Up and Changing the Margins 84
Indenting Paragraphs and First Lines 86
Numbering the Pages 88
Putting Headers and Footers on Pages 91
Adjusting the Space between Lines 95
Adjusting the Space between Paragraphs 96
Creating Numbered and Bulleted Lists 97
Working with Tabs 100
Hyphenating Text 102
Chapter 3: Word Styles 105
All about Styles 105
Applying Styles to Text and Paragraphs 107
Creating a New Style 112
Modifying a Style 115
Creating and Managing Templates 116
Chapter 4: Constructing the Perfect Table 123
Talking Table Jargon 124
Creating a Table 124
Entering the Text and Numbers 127
Selecting Different Parts of a Table 128
Laying Out Your Table 128
Aligning Text in Columns and Rows 133
Merging and Splitting Cells 134
Repeating Header Rows on Subsequent Pages 135
Formatting Your Table 137
Using Math Formulas in Tables 140
Neat Table Tricks 141
Chapter 5: Taking Advantage of the Proofing Tools 147
Correcting Your Spelling Errors 148
Correcting Grammatical Errors 151
Finding and Replacing Text 153
Finding the Right Word with the Thesaurus 161
Proofing Text Written in a Foreign Language 162
Translating Foreign Language Text 164
Chapter 6: Desktop Publishing with Word 167
Experimenting with Themes 167
Sprucing Up Your Pages 168
Making Use of Charts, Diagrams, Shapes, and Photos 171
Working with the Drawing Canvas 172
Positioning and Wrapping Objects Relative to the Page and Text 173
Working with Text Boxes 177
Dropping in a Drop Cap 179
Watermarking for the Elegant Effect 179
Putting Newspaper-Style Columns in a Document 181
Landscape Documents 183
Printing on Different Size Paper 184
Showing Online Video in a Document 184
Chapter 7: Getting Word’s Help with Office Chores 187
Highlighting Parts of a Document 187
Commenting on a Document 188
Tracking Changes to Documents 192
Printing an Address on an Envelope 197
Printing a Single Address Label (or a Page of the Same Label) 198
Churning Out Letters, Envelopes, and Labels for Mass Mailings 200
Chapter 8: Tools for Reports and Scholarly Papers 207
Alphabetizing a List 207
Outlines for Organizing Your Work 208
Collapsing and Expanding Parts of a Document 210
Generating a Table of Contents 211
Indexing a Document 215
Putting Cross-References in a Document 220
Putting Footnotes and Endnotes in Documents 222
Compiling a Bibliography 225
Book 3: Excel 365 229
Chapter 1: Up and Running with Excel 231
Creating a New Excel Workbook 231
Getting Acquainted with Excel 233
Entering Data in a Worksheet 235
Quickly Entering Lists and Serial Data with the AutoFill Command 241
Formatting Numbers, Dates, and Time Values 244
Establishing Data-Validation Rules 245
Chapter 2: Refining Your Worksheet 249
Editing Worksheet Data 249
Moving around in a Worksheet 250
Getting a Better Look at the Worksheet 251
Notes for Documenting Your Worksheet 254
Comments for Collaborating with Others on a Workbook 256
Selecting Cells in a Worksheet 257
Deleting, Copying, and Moving Data 258
Handling the Worksheets in a Workbook 259
Keeping Others from Tampering with Worksheets 261
Chapter 3: Formulas and Functions for Crunching Numbers 263
How Formulas Work 263
The Basics of Entering a Formula 269
Speed Techniques for Entering Formulas 269
Copying Formulas from Cell to Cell 275
Detecting and Correcting Errors in Formulas 276
Working with Functions 280
A Look at Some Very Useful Functions 284
Chapter 4: Making a Worksheet Easier to Read and Understand 295
Laying Out a Worksheet 295
Decorating a Worksheet with Borders and Colors 301
Getting Ready to Print a Worksheet 306
Chapter 5: Advanced Techniques for Analyzing Data 313
Seeing What the Sparklines Say 313
Conditional Formats for Calling Attention to Data 314
Managing Information in Lists 316
Forecasting with the Goal Seek Command 319
Performing What-If Analyses with Data Tables 321
Analyzing Data with PivotTables 325
Book 4: Powerpoint 365 329
Chapter 1: Getting Started in PowerPoint 331
Getting Acquainted with PowerPoint 332
A Brief Geography Lesson 333
A Whirlwind Tour of PowerPoint 334
Creating a New Presentation 335
Advice for Building Persuasive Presentations 338
Creating New Slides for Your Presentation 340
Getting a Better View of Your Work 343
Hiding and Displaying the Slides Pane and Notes Pane 345
Selecting, Moving, and Deleting Slides 346
Putting Together a Photo Album 347
Hidden Slides for All Contingencies 350
Chapter 2: Fashioning a Look for Your Presentation 353
Looking at Themes and Slide Backgrounds 353
Choosing a Theme for Your Presentation 355
Creating Slide Backgrounds on Your Own 356
Changing the Background of a Single or Handful of Slides 362
Choosing the Slide Size 363
Using Master Slides and Master Styles for a Consistent Design 363
Chapter 3: Entering the Text 367
Entering Text 367
Fun with Text Boxes and Text Box Shapes 371
Controlling How Text Fits in Text Frames and Text Boxes 372
Positioning Text in Frames and Text Boxes 375
Handling Bulleted and Numbered Lists 376
Putting Footers (and Headers) on Slides 379
Chapter 4: Making Your Presentations Livelier 383
Suggestions for Enlivening Your Presentation 383
Presenting Information in a Table 384
Exploring Transitions and Animations 387
Making Audio Part of Your Presentation 390
Playing Video on Slides 393
Recording a Voice Narration for Slides 396
Chapter 5: Delivering a Presentation 399
All about Notes 399
Rehearsing and Timing Your Presentation 400
Showing Your Presentation 402
Tricks for Making Presentations a Little Livelier 405
Delivering a Presentation When You Can’t Be There in Person 408
Book 5: Outlook 365 419
Chapter 1: Outlook Basics 421
What is Outlook, Anyway? 421
Navigating the Outlook Folders 422
Categorizing Items 423
Searching for Stray Folder Items 425
Deleting Email Messages, Contacts, Tasks, and Other Items 428
Cleaning Out Your Folders 429
Chapter 2: Maintaining the Contacts Folder 433
Maintaining a Happy and Healthy Contacts Folder 434
Contact Groups for Sending Messages to Groups 437
Finding a Contact in the Contacts Folder 440
Linking Duplicate Contacts 440
Sharing Contacts with Coworkers 441
Printing the Contacts Folder 443
Chapter 3: Handling Your Email 447
Setting Up an Email Account 447
Addressing and Sending Email Messages 448
Sending Files and Photos 454
Receiving Email Messages 456
Reading Your Email in the Inbox Window 457
Handling Files That Were Sent to You 459
Techniques for Organizing Email Messages 460
All about Email Folders 464
Yes, You Can Prevent Junk Mail (Sort of) 466
Chapter 4: Managing Your Time and Schedule 469
Introducing the Calendar 469
The Different Kinds of Activities 470
Seeing Your Schedule 472
Scheduling Appointments and Events 473
Canceling, Rescheduling, and Altering Activities 476
Managing Meetings with the Calendar 476
Chapter 5: Tasks, Reminders, and Notes 481
Tasks: Seeing What Needs to Get Done 481
Reminders for Being Alerted to Activities and Tasks 484
Making Notes to Yourself 487
Book 6: Access 365 489
Chapter 1: Introducing Access 491
What is a Database, Anyway? 491
Tables, Queries, Forms, and Other Objects 492
Creating a Database File 497
Finding Your Way around the Navigation Pane 499
Designing a Database 500
Chapter 2: Building Your Database Tables 505
Creating a Database Table 505
Opening and Viewing Tables 509
Entering and Altering Table Fields 510
Field Properties for Making Sure That Data Entries are Accurate 516
Indexing for Faster Sorts, Searches, and Queries 524
Establishing Relationships among Database Tables 526
Chapter 3: Entering the Data 533
The Two Ways to Enter Data 533
Entering the Data in Datasheet View 534
Entering the Data in a Form 538
Finding a Missing Record 540
Finding and Replacing Data 541
Chapter 4: Sorting, Querying, and Filtering for Data 543
Sorting Records in a Database Table 543
Filtering to Find Information 544
Querying: The Basics 550
Six Kinds of Queries 559
Select query 559
Top-value query 559
Summary query 559
Calculation query 560
Delete query 561
Update query 563
Chapter 5: Presenting Data in a Report 565
Creating a Report 565
Opening and Viewing Reports 567
Tweaking a Report 567
Book 7: Publisher 365 571
Chapter 1: Introducing Publisher 573
“A Print Shop in a Can” 573
Introducing Frames 574
Creating a Publication 575
Redesigning a Publication 576
Getting a Better View of Your Work 578
Understanding and Using the Layout Guides 579
Chapter 2: Refining a Publication 585
Entering Text on the Pages 585
Making Text Fit in Text Frames 586
Formatting Text 589
Making Text Wrap around a Frame or Graphic 590
Replacing the Placeholder Pictures 591
Inserting Frames on the Pages 591
Making Frames Overlap 593
Inserting, Removing, and Moving Pages 594
Chapter 3: Putting on the Finishing Touches 597
Decorating the Text 597
Techniques for Decorating Pages 600
Master Pages for Handling Page Backgrounds 603
Running the Design Checker 605
Commercially Printing a Publication 606
Book 8: Working with Charts and Graphics 607
Chapter 1: Creating a Chart 609
The Basics: Creating a Chart 609
Choosing the Right Chart 611
Providing the Raw Data for Your Chart 613
Positioning Your Chart in a Workbook, Page, or Slide 615
Changing a Chart’s Appearance 616
Saving a Chart as a Template So That You Can Use It Again 622
Chart Tricks for the Daring and Heroic 623
Troubleshooting a Chart 626
Chapter 2: Making a SmartArt Diagram 629
The Basics: Creating SmartArt Diagrams 629
Creating the Initial Diagram 632
Changing the Size and Position of a Diagram 634
Laying Out the Diagram Shapes 634
Handling the Text on Diagram Shapes 640
Changing a Diagram’s Direction 642
Choosing a Look for Your Diagram 643
Changing the Appearance of Diagram Shapes 644
Creating a Diagram from Scratch 647
Chapter 3: Handling Graphics and Photos 649
All about Picture File Formats 649
Inserting a Picture in an Office File 653
Touching Up a Picture 656
Compressing Pictures to Save Disk Space 663
Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 665
The Basics: Making Lines, Arrows, and Shapes 666
Handling Lines, Arrows, and Connectors 668
Handling Rectangles, Ovals, Stars, and Other Shapes 672
Drawing by Freehand 676
Decorating Your Work with Icons 679
Inserting a 3-D Model 680
WordArt for Embellishing Letters and Words 680
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects 682
Changing an Object’s Size and Shape 685
Changing an Object’s Color, Outline Color, and Transparency 686
Moving and Positioning Objects 691
Book 9: Office 365: One Step Beyond 699
Chapter 1: Customizing an Office Program 701
Customizing the Ribbon 701
Customizing the Quick Access Toolbar 707
Customizing the Status Bar 710
Changing the Screen Background and Office Theme 711
Customizing Keyboard Shortcuts in Word 712
Chapter 2: Ways of Distributing Your Work 715
Printing — the Old Standby 715
Distributing a File in PDF Format 717
Sending Your File in an Email Message 719
Saving an Office File as a Web Page 720
Book 10: File Sharing and Collaborating 723
Chapter 1: Up and Running on OneDrive 725
Signing in to OneDrive 725
Exploring the OneDrive Window 726
Managing Your OneDrive Folders 727
Uploading Files to a Folder on OneDrive 732
Saving a File from Office 365 to OneDrive 732
Opening a File from OneDrive 734
Downloading Files from OneDrive to Your Computer 735
Chapter 2: File Sharing and Collaborating 737
Sharing Files: The Big Picture 737
Sharing Your Files and Folders with Others 739
Seeing Files and Folders Others Shared with You 742
Investigating and Managing How Files and Folders are Shared 743
Chapter 3: Collaborating in SharePoint 745
Introducing Team Sites 745
Working with Document Libraries 747
Delving Deeper into Office 365 755
Chapter 4: Working Together in Teams 757
Introducing Microsoft Teams and Channels 758
Setting Your Status 761
All about Conversations 762
Chatting Privately with a Colleague 764
Filtering and Searching 765
Choosing Notification Settings 767
Sharing and Editing Files with Coworkers 768
Holding Meetings with Coworkers 770
Index 773
Peter Weverka is a veteran technology author with dozens of books to his credit. In addition to previous editions of Office All-in-One For Dummies, he has written books on PowerPoint, OneNote, Word, and Quicken, as well as the bestselling Windows 10 For Seniors For Dummies. Timothy L. Warner is a Microsoft MVP and co-author of CompTIA A+ Certification All-in-One For Dummies.
|
Ask a Question About this Product More... |
|
