Office 2019 All-in-One For Dummies

Title Page
......Page 3
Copyright Page......Page 4
Table of Contents......Page 7
Introduction......Page 27
What Makes This Book Different......Page 28
Conventions Used in This Book......Page 29
Beyond the Book......Page 30
Book
1 Common Office Tasks......Page 31
A Survey of Office Applications......Page 33
All about Office 365......Page 35
The File tab and Backstage......Page 37
The Ribbon and its tabs......Page 38
The anatomy of a tab......Page 40
Office 2019 for keyboard lovers......Page 42
Saving AutoRecovery information......Page 44
Navigating the Save As and Open Windows......Page 45
Closing a file......Page 47
Reading and Recording File Properties......Page 48
Password-protecting a file......Page 49
Trusting (or not Trusting) Microsoft with Your “Content”......Page 50
Manipulating the Text......Page 53
Moving and copying text......Page 54
Taking advantage of the Clipboard task pane......Page 55
Speaking, not Typing, the Words......Page 56
Choosing fonts for text......Page 58
Changing the font size of text......Page 60
Applying font styles to text......Page 62
Applying text effects to text......Page 63
Changing the color of text......Page 64
Quick Ways to Handle Case, or Capitalization......Page 65
Entering Symbols and Foreign Characters......Page 67
Linking a hyperlink to a web page......Page 68
Creating a hyperlink to another place in your file......Page 70
Creating an email hyperlink......Page 71
Repairing and removing hyperlinks......Page 72
Undoing and Repeating Commands......Page 73
Repeating an action — and quicker this time......Page 74
Zooming In, Zooming Out......Page 75
Viewing a File Through More Than One Window......Page 76
Correcting Typos on the Fly......Page 77
Entering Text Quickly with the AutoCorrect Command......Page 78
Book
2 Word 2019......Page 81
Introducing the Word Screen......Page 83
Creating a New Document......Page 85
Getting a Better Look at Your Documents......Page 87
Viewing documents in different ways......Page 88
Splitting the screen......Page 90
Selecting Text in Speedy Ways......Page 92
Keys for getting around quickly......Page 93
Navigating from page to page or heading to heading......Page 94
Going there fast with the Go To command......Page 95
Bookmarks for hopping around......Page 96
Inserting a Whole File into a Document......Page 97
Entering Information Quickly in a Computerized Form......Page 98
Creating a computerized form......Page 99
Entering data in the form......Page 101
Paragraphs and Formatting......Page 103
Inserting a Section Break for Formatting Purposes......Page 104
Starting a New Page......Page 107
Setting Up and Changing the Margins......Page 108
“Eyeballing” it with the ruler......Page 110
Numbering the Pages......Page 112
Numbering with page numbers only......Page 113
Changing page number formats......Page 114
Putting Headers and Footers on Pages......Page 115
Creating, editing, and removing headers and footers......Page 117
Fine-tuning a header or footer......Page 118
Adjusting the Space Between Lines......Page 119
Adjusting the Space Between Paragraphs......Page 121
Simple numbered and bulleted lists......Page 122
Constructing lists of your own......Page 123
Managing a multilevel list......Page 124
Working with Tabs......Page 125
Hyphenating Text......Page 127
Unhyphenating and other hyphenation tasks......Page 128
All About Styles......Page 131
Types of styles......Page 132
Applying a style......Page 133
Choosing which style names appear on the Style menus......Page 135
Creating a style from a paragraph......Page 138
Creating a style from the ground up......Page 139
Modifying a Style......Page 140
Creating a new template......Page 142
Opening a template so that you can modify it......Page 146
Modifying, deleting, and renaming styles in templates......Page 147
Chapter 4 Constructing the Perfect Table......Page 149
Creating a Table......Page 150
Entering the Text and Numbers......Page 153
Changing the size of a table, columns, and rows......Page 154
Adjusting column and row size......Page 155
Inserting columns and rows......Page 156
Deleting columns and rows......Page 157
Aligning Text in Columns and Rows......Page 159
Merging and Splitting Cells......Page 160
Repeating Header Rows on Subsequent Pages......Page 161
Designing a table with a table style......Page 163
Calling attention to different rows and columns......Page 164
Decorating your table with borders and colors......Page 165
Using Math Formulas in Tables......Page 166
Changing the direction of header row text......Page 167
Wrapping text around a table......Page 168
Using a picture as the table background......Page 169
Drawing on a table......Page 171
Chapter 5 Taking Advantage of the Proofing Tools......Page 173
Correcting misspellings one at a time......Page 174
Running a spell check......Page 175
Correcting Grammatical Errors......Page 177
The basics: Finding stray words and phrases......Page 179
Narrowing your search......Page 180
Conducting a find-and-replace operation......Page 185
Finding the Right Word with the Thesaurus......Page 187
Proofing Text Written in a Foreign Language......Page 188
Marking text as foreign language text......Page 189
Translating Foreign Language Text......Page 190
Experimenting with Themes......Page 193
Sprucing Up Your Pages......Page 194
Decorating a page with a border......Page 195
Getting Word’s help with cover letters......Page 196
Making Use of Charts, Diagrams, Shapes, and Photos......Page 197
Working with the Drawing Canvas......Page 198
Positioning and Wrapping Objects Relative to the Page and Text......Page 199
Wrapping text around an object......Page 200
Positioning an object on a page......Page 201
Working with Text Boxes......Page 203
Making text flow from text box to text box......Page 204
Dropping In a Drop Cap......Page 205
Watermarking for the Elegant Effect......Page 206
Doing the preliminary work......Page 207
Running text into columns......Page 208
Landscape Documents......Page 209
Showing Online Video in a Document......Page 210
Highlighting Parts of a Document......Page 213
Entering comments......Page 214
Caring for and feeding comments......Page 216
Tracking Changes to Documents......Page 218
Reading and reviewing a document with change marks......Page 219
Marking changes when you forgot to turn on change marks......Page 220
Accepting and rejecting changes to a document......Page 222
Printing an Address on an Envelope......Page 223
Printing a Single Address Label (Or a Page of the Same Label)......Page 225
Churning Out Letters, Envelopes, and Labels for Mass Mailings......Page 226
Preparing the source file......Page 227
Merging the document with the source file......Page 228
Printing form letters, envelopes, and labels......Page 232
Alphabetizing a List......Page 235
Viewing the outline in different ways......Page 236
Collapsing and Expanding Parts of a Document......Page 238
Generating a Table of Contents......Page 239
Customizing a TOC......Page 240
Changing the structure of a TOC......Page 242
Marking index items in the document......Page 244
Generating the index......Page 246
Putting Cross-References in a Document......Page 248
Entering a footnote or endnote......Page 251
Choosing the numbering scheme and position of notes......Page 252
Compiling a Bibliography......Page 253
Inserting a citation for your bibliography......Page 254
Generating the bibliography......Page 256
Book 3 Excel 2019......Page 259
Creating a New Excel Workbook......Page 261
Getting Acquainted with Excel......Page 263
The basics of entering data......Page 265
Entering numeric values......Page 267
Entering date and time values......Page 268
Quickly Entering Lists and Serial Data with the AutoFill Command......Page 271
Formatting Numbers, Dates, and Time Values......Page 274
Establishing Data-Validation Rules......Page 275
Editing Worksheet Data......Page 279
Moving Around in a Worksheet......Page 280
Freezing and splitting columns and rows......Page 281
Hiding columns and rows......Page 283
Comments for Documenting Your Worksheet......Page 284
Selecting Cells in a Worksheet......Page 286
Handling the Worksheets in a Workbook......Page 287
Protecting a worksheet......Page 290
How Formulas Work......Page 293
Referring to cells in formulas......Page 294
Referring to formula results in formulas......Page 296
Operators in formulas......Page 297
Clicking cells to enter cell references......Page 299
Entering a cell range......Page 300
Naming cell ranges so that you can use them in formulas......Page 301
Referring to cells in different worksheets......Page 304
Copying Formulas from Cell to Cell......Page 305
Correcting errors one at a time......Page 307
Running the error checker......Page 308
Tracing cell references......Page 309
Working with Functions......Page 310
Entering a function in a formula......Page 311
AVERAGE for averaging data......Page 315
COUNT and COUNTIF for tabulating data items......Page 316
CONCATENATE for combining values......Page 317
PMT for calculating how much you can borrow......Page 318
IF for identifying data......Page 320
LEFT, MID, and RIGHT for cleaning up data......Page 321
LARGE and SMALL for comparing values......Page 322
NETWORKDAY and TODAY for measuring time in days......Page 323
LEN for Counting Characters in Cells......Page 324
Laying Out a Worksheet......Page 325
Aligning numbers and text in columns and rows......Page 326
Inserting and deleting rows and columns......Page 328
Changing the size of columns and rows......Page 329
Cell styles for quickly formatting a worksheet......Page 331
Formatting cells with table styles......Page 333
Slapping borders on worksheet cells......Page 334
Making a worksheet fit on a page......Page 336
Making a worksheet more presentable......Page 340
Repeating row and column headings on each page......Page 341
Seeing What the Sparklines Say......Page 343
Conditional Formats for Calling Attention to Data......Page 345
Sorting a list......Page 346
Filtering a list......Page 347
Forecasting with the Goal Seek Command......Page 349
Using a one-input table for analysis......Page 351
Using a two-input table for analysis......Page 353
Analyzing Data with PivotTables......Page 355
Getting a PivotTable recommendation from Excel......Page 356
Creating a PivotTable from scratch......Page 357
Putting the finishing touches on a PivotTable......Page 359
Book 4 PowerPoint 2019......Page 361
Chapter 1 Getting Started in PowerPoint......Page 363
Getting Acquainted with PowerPoint......Page 364
A Brief Geography Lesson......Page 365
A Whirlwind Tour of PowerPoint......Page 366
Creating a New Presentation......Page 367
Advice for Building Persuasive Presentations......Page 370
Creating New Slides for Your Presentation......Page 372
Inserting a new slide......Page 373
Conjuring slides from Word document headings......Page 374
Looking at the different views......Page 376
Selecting, Moving, and Deleting Slides......Page 378
Deleting slides......Page 379
Creating your photo album......Page 380
Putting on the final touches......Page 382
Hiding a slide......Page 383
Showing a hidden slide during a presentation......Page 384
Chapter 2 Fashioning a Look for Your Presentation......Page 385
Looking at Themes and Slide Backgrounds......Page 386
Choosing a Theme for Your Presentation......Page 387
Using a solid (or transparent) color for the slide background......Page 388
Creating a gradient color blend for slide backgrounds......Page 389
Placing a picture in the slide background......Page 391
Using a photo of your own for a slide background......Page 392
Using a texture for a slide background......Page 393
Changing the Background of a Single or Handful of Slides......Page 394
Choosing the Slide Size......Page 395
Understanding master slides and master styles......Page 396
Changing a master slide layout......Page 398
Entering Text......Page 399
Choosing fonts for text......Page 400
Changing the look of text......Page 401
Fun with Text Boxes and Text Box Shapes......Page 403
Choosing how AutoFit works in text frames......Page 405
Choosing how AutoFits works in text boxes......Page 407
Handling Bulleted and Numbered Lists......Page 408
Choosing a different bullet character, size, and color......Page 409
Putting Footers (and Headers) on Slides......Page 411
Putting a standard footer on all your slides......Page 412
Creating a nonstandard footer......Page 413
Removing a footer from a single slide......Page 414
Suggestions for Enlivening Your Presentation......Page 415
Presenting Information in a Table......Page 416
Showing transitions between slides......Page 419
Animating parts of a slide......Page 420
Making Audio Part of Your Presentation......Page 422
Inserting an audio file on a slide......Page 423
Telling PowerPoint when and how to play an audio file......Page 424
Playing Video on Slides......Page 425
Fine-tuning a video presentation......Page 426
Experimenting with the look of the video......Page 428
Recording a Voice Narration for Slides......Page 429
All about Notes......Page 431
Rehearsing and Timing Your Presentation......Page 432
Going from slide to slide......Page 434
Tricks for Making Presentations a Little Livelier......Page 437
Wielding a pen or highlighter in a presentation......Page 438
Delivering a Presentation When You Can’t Be There in Person......Page 440
Providing handouts for your audience......Page 441
Creating a self-running, kiosk-style presentation......Page 442
Creating a user-run presentation......Page 444
Presenting a Presentation Online......Page 446
Packaging your presentation on a CD or DVD......Page 448
Creating a presentation video......Page 449
Book 5 Outlook 2019......Page 451
What Is Outlook, Anyway?......Page 453
Navigating the Outlook Folders......Page 455
Creating a category......Page 456
Assigning items to categories......Page 457
Searching for Stray Folder Items......Page 458
Refining a search......Page 459
Conducting an advanced search......Page 460
Deleting Email Messages, Contacts, Tasks, and Other Items......Page 461
Archiving the old stuff......Page 462
Running the Mailbox Cleanup command......Page 464
Chapter 2 Maintaining the Contacts Folder......Page 467
Entering a new contact in the Contacts folder......Page 468
Changing a contact’s information......Page 470
Creating a contact group......Page 471
Finding a Contact in the Contacts Folder......Page 473
Different ways to print contact information......Page 474
Changing the look of printed pages......Page 475
Setting Up an Email Account......Page 477
Addressing and Sending Email Messages......Page 478
The basics: Sending an email message......Page 479
Addressing an email message......Page 480
Replying to and forwarding email messages......Page 482
Sending a file along with a message......Page 484
Including a photo in an email message......Page 485
Getting your email......Page 486
Reading Your Email in the Inbox Window......Page 487
Handling Files That Were Sent to You......Page 489
Techniques for Organizing Email Messages......Page 490
Rules for earmarking messages as they arrive......Page 492
Moving email messages to different folders......Page 494
Creating a new folder for storing email......Page 495
Defining what constitutes junk email......Page 496
Preventative medicine for junk email......Page 497
Introducing the Calendar......Page 499
The Different Kinds of Activities......Page 500
Seeing Your Schedule......Page 501
Rearranging the Calendar window......Page 502
Scheduling an activity: The basics......Page 503
Scheduling a recurring appointment or event......Page 504
Scheduling an event......Page 505
Canceling, Rescheduling, and Altering Activities......Page 506
Tasks: Seeing What Needs to Get Done......Page 507
Entering a task in the Tasks window......Page 508
Reminders for Being Alerted to Activities and Tasks......Page 510
Handling reminder messages......Page 511
Making reminders work your way......Page 512
Making Notes to Yourself......Page 513
Book 6 Access 2019......Page 515
Chapter 1 Introducing Access......Page 517
Database tables for storing information......Page 518
Forms for entering data......Page 520
Queries for getting the data out......Page 521
Reports for presenting and examining data......Page 522
Creating a Database File......Page 523
Getting the help of a template......Page 524
Finding Your Way Around the Navigation Pane......Page 525
Deciding what information you need......Page 527
Separating information into different database tables......Page 528
Choosing fields for database tables......Page 529
Deciding on a primary key field for each database table......Page 530
Mapping the relationships between tables......Page 531
Creating a Database Table......Page 533
Creating a database table from scratch......Page 534
Creating a database table from a template......Page 535
Importing a table from another database......Page 536
Opening and Viewing Tables......Page 537
Creating a field......Page 538
All about data types......Page 540
Designating the primary key field......Page 541
Moving, renaming, and deleting fields......Page 543
A look at the Field Properties settings......Page 544
Creating a lookup data-entry list......Page 550
Indexing for Faster Sorts, Searches, and Queries......Page 552
Indexing based on more than one field......Page 553
Establishing Relationships Among Database Tables......Page 554
Handling tables in the Relationships window......Page 556
Forging relationships between tables......Page 558
Editing table relationships......Page 560
The Two Ways to Enter Data......Page 561
Entering the Data in Datasheet View......Page 562
Entering data......Page 563
Two tricks for entering data quicker......Page 564
Changing the appearance of the datasheet......Page 565
Creating a form......Page 566
Entering the data......Page 567
Finding a Missing Record......Page 568
Finding and Replacing Data......Page 569
Sorting Records in a Database Table......Page 571
Filtering to Find Information......Page 572
“Unfiltering” a database table......Page 574
Filtering for input......Page 575
Filtering by form......Page 576
Querying: The Basics......Page 578
Creating a new query......Page 579
Choosing which database tables to query......Page 580
Choosing which fields to query......Page 581
Choosing which fields appear in query results......Page 582
Entering criteria for a query......Page 584
Six Kinds of Queries......Page 586
Summary query......Page 587
Calculation query......Page 588
Update query......Page 590
Creating a Report......Page 593
Tweaking a Report......Page 595
Book 7 Publisher 2019......Page 599
“A Print Shop in a Can”......Page 601
Introducing Frames......Page 602
Creating a Publication......Page 603
Choosing a font scheme......Page 604
Setting up your pages......Page 605
Zooming in and out......Page 606
Going from page to page......Page 607
Making use of layout guides......Page 608
Snapping objects to ruler and grid lines......Page 611
Entering Text on the Pages......Page 613
Making Text Fit in Text Frames......Page 614
Fitting overflow text in a single frame......Page 615
Making text flow from frame to frame......Page 616
Filling out a text frame......Page 617
Making Text Wrap around a Frame or Graphic......Page 618
Replacing the Placeholder Pictures......Page 619
Inserting a new frame......Page 620
Changing the size and position of frames......Page 621
Inserting, Removing, and Moving Pages......Page 622
Chapter 3 Putting on the Finishing Touches......Page 625
Drawing a horizontal rule on a frame......Page 626
Dropping in a drop cap......Page 627
Plugging in a page part......Page 628
Taking advantage of attention getters......Page 630
Backgrounds for pages......Page 631
Switching to Master Page view......Page 632
Applying (or unapplying) a master page to publication pages......Page 633
Running the Design Checker......Page 634
Commercially Printing a Publication......Page 635
Book 8 Working with Charts and Graphics......Page 637
The Basics: Creating a Chart......Page 639
Choosing the Right Chart......Page 641
Providing the Raw Data for Your Chart......Page 643
Positioning Your Chart in a Workbook, Page, or Slide......Page 645
Changing the chart type......Page 646
Changing the size and shape of a chart......Page 647
Changing the layout of a chart......Page 648
Changing a chart element’s color, font, or other particular......Page 650
Creating a chart from a template......Page 652
Decorating a chart with a picture......Page 653
Annotating a chart......Page 654
Placing a trendline on a chart......Page 655
Troubleshooting a Chart......Page 656
The Basics: Creating SmartArt Diagrams......Page 659
Choosing a diagram......Page 660
Making the diagram your own......Page 661
Creating a diagram......Page 662
Swapping one diagram for another......Page 663
Selecting a diagram shape......Page 664
Adding shapes to diagrams apart from hierarchy diagrams......Page 665
Adding shapes to hierarchy diagrams......Page 666
Adding shapes to Organization charts......Page 668
Handling the Text on Diagram Shapes......Page 670
Entering bulleted lists on diagram shapes......Page 671
Choosing a Look for Your Diagram......Page 673
Changing the Appearance of Diagram Shapes......Page 674
Exchanging one shape for another......Page 675
Changing fonts and font sizes on shapes......Page 676
Creating a Diagram from Scratch......Page 677
All about Picture File Formats......Page 679
Bitmap and vector graphics......Page 680
Resolution......Page 681
Color depth......Page 682
Inserting a picture of your own......Page 683
Obtaining a picture online......Page 684
Touching Up a Picture......Page 686
Softening and sharpening pictures......Page 687
Recoloring a picture......Page 688
Choosing an artistic effect......Page 689
Cropping off part of a picture......Page 691
Removing the background......Page 693
Compressing Pictures to Save Disk Space......Page 694
Chapter 4 Drawing and Manipulating Lines, Shapes, and Other Objects......Page 697
The Basics: Making Lines, Arrows, and Shapes......Page 698
Changing the appearance of a line, arrow, or connector......Page 700
Attaching and handling arrowheads on lines and connectors......Page 701
Connecting shapes by using connectors......Page 702
Handling Rectangles, Ovals, Stars, and Other Shapes......Page 704
Drawing a shape......Page 705
Changing a shape’s symmetry......Page 706
Using a shape as a text box......Page 707
Freehand drawing with a pen or highlighter......Page 708
Changing the look of freehand drawings......Page 709
Drawing a math expression......Page 710
Decorating Your Work with Icons......Page 711
WordArt for Embellishing Letters and Words......Page 712
Editing WordArt......Page 713
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects......Page 714
Selecting objects so that you can manipulate them......Page 715
Hiding and displaying the rulers and grid......Page 716
Changing an Object’s Size and Shape......Page 717
Changing an Object’s Color, Outline Color, and Transparency......Page 718
Filling an object with color, a picture, or a texture......Page 719
Making a color transparent......Page 721
Putting the outline around an object......Page 722
Tricks for aligning and distributing objects......Page 723
When objects overlap: Choosing which appears above the other......Page 726
Rotating and flipping objects......Page 728
Grouping objects to make working with them easier......Page 729
Book 9 Office 2019: One Step Beyond......Page 731
Customizing the Ribbon......Page 733
Displaying and selecting tab, group, and command names......Page 735
Adding, removing, and renaming tabs, groups, and commands......Page 736
Resetting your Ribbon customizations......Page 738
Customizing the Quick Access Toolbar......Page 739
Adding buttons to the Quick Access toolbar......Page 740
Changing the order of buttons on the Quick Access toolbar......Page 741
Customizing the Status Bar......Page 742
Changing the Screen Background and Office Theme......Page 743
Customizing Keyboard Shortcuts in Word......Page 744
Printing — the Old Standby......Page 747
Distributing a File in PDF Format......Page 749
Saving an Office file as a PDF......Page 750
Sending Your File in an Email Message......Page 751
Turning a file into a web page......Page 752
Opening a web page in your browser......Page 753
Book 10 File Sharing and Collaborating......Page 755
Signing In to OneDrive......Page 757
Managing Your OneDrive Folders......Page 759
Viewing and locating folders in the OneDrive window......Page 760
Deleting, moving, and renaming folders......Page 762
Uploading Files to a Folder on OneDrive......Page 764
Saving a File from Office 2019 to OneDrive......Page 765
Starting in an Office 2019 application......Page 766
Downloading Files from OneDrive to Your Computer......Page 767
Sharing Files: The Big Picture......Page 769
Inviting people by email......Page 771
Generating a link to shared files......Page 772
Generating HTML code......Page 773
Seeing Files and Folders Others Shared with You......Page 774
Investigating and Managing How Files and Folders Are Shared......Page 775
Index......Page 777
EULA......Page 819