Office 2019 for Dummies

Title Page......Page 3
Copyright Page......Page 4
Table of Contents......Page 7
Who Should Buy This Book......Page 17
Icons Used in This Book......Page 19
Getting Started......Page 20
Part I Getting Started with Office 2019......Page 21
Chapter 1 Introducing Microsoft Office 2019......Page 23
Starting an Office 2019 Program......Page 24
Introducing the Microsoft Office Ribbon......Page 25
Using the File Tab......Page 27
Creating a file......Page 28
Opening an existing file......Page 29
Saving a file......Page 30
Using the Ribbon......Page 33
Deciphering Ribbon icons......Page 34
Identifying Ribbon icons......Page 36
Displaying dialog boxes......Page 37
Minimizing the Ribbon......Page 38
Using the Quick Access icons......Page 40
Adding icons......Page 41
Removing icons......Page 42
Customizing the Ribbon for Touch......Page 43
Changing the file format and default location......Page 44
Customizing the Ribbon icons......Page 45
Exiting Office 2019......Page 46
Adding Data by Pointing......Page 47
Selecting Data......Page 49
Selecting data with the mouse......Page 50
Selecting multiple chunks of data with the mouse and keyboard......Page 51
Deleting Data......Page 52
Cutting and Pasting (Moving) Data......Page 53
Using Paste Options......Page 54
Undo and Redo......Page 56
Using the Office Clipboard......Page 57
Viewing and pasting items from the Office Clipboard......Page 58
Deleting items from the Office Clipboard......Page 59
Chapter 3 Modifying Pictures and Drawing on Documents......Page 61
Getting pictures from the Internet......Page 62
Capturing screenshots......Page 64
Moving a picture......Page 65
Rotating a picture......Page 66
Choosing visual effects......Page 67
Choosing a picture style......Page 70
Adding a border around a picture......Page 71
Drawing lines......Page 73
Moving lines......Page 74
Drawing Shapes......Page 75
Creating Math Equations......Page 76
Chapter 4 Getting Help from Office 2019......Page 79
Searching in the Help Window......Page 80
Moving the Help window......Page 82
Displaying Help text in a browser window......Page 83
Finding the Right Commands to Use......Page 84
Part 2 Working with Word......Page 87
Moving the Cursor with the Mouse......Page 89
Moving the Cursor with the Keyboard......Page 91
Navigating with the mouse......Page 92
Using the Go To command......Page 93
Using the Find command......Page 94
Customizing text searching......Page 96
Searching by headings......Page 98
Browsing through pages......Page 99
Using the Find and Replace command......Page 100
Checking Your Spelling......Page 101
Viewing a Document......Page 103
Switching between views......Page 104
Using Outline view......Page 105
Finding Formatting Tools on the Home Tab......Page 111
Changing the Font......Page 112
Changing the Font Size......Page 113
Changing the Text Style......Page 114
Changing the color of text......Page 115
Highlighting text with color......Page 116
Using Text Effects......Page 117
Justifying Text Alignment......Page 118
Adjusting Line Spacing......Page 119
Making Lists......Page 120
Customizing a list......Page 121
Renumbering numbered lists......Page 122
Using the Ruler......Page 123
Adjusting left and right paragraph margins......Page 124
Defining indentation with the Ruler......Page 125
Using Format Painter......Page 126
Using Styles......Page 127
Using Templates......Page 128
Removing Formatting from Text......Page 129
Chapter 7 Designing Your Pages......Page 131
Adding (and Deleting) a Cover Page......Page 132
Inserting Page Breaks......Page 133
Creating a header or footer......Page 134
Defining which pages display a header or footer......Page 135
Creating a table by highlighting rows and columns......Page 137
Creating a table with the Insert Table dialog box......Page 138
Creating a table with the mouse......Page 139
Creating a table from existing text......Page 140
Selecting all or part of a table......Page 142
Aligning text in a table cell......Page 143
Resizing columns and rows......Page 144
Sorting a Table......Page 146
Deleting an entire table......Page 147
Deleting cells......Page 148
Making Text Look Artistic......Page 149
Creating WordArt......Page 150
Dividing Text into Columns......Page 151
Editing columns......Page 152
Removing columns......Page 153
Defining page size and orientation......Page 154
Using Print Preview......Page 155
Part 3 Playing the Numbers with Excel......Page 157
Chapter 8 The Basics of Spreadsheets: Numbers, Labels, and Formulas......Page 159
Understanding Spreadsheets......Page 160
Typing data in multiple cells......Page 161
Typing in sequences with AutoFill......Page 162
Formatting numbers......Page 163
Formatting cells......Page 166
Using the mouse to move around in a spreadsheet......Page 170
Using the keyboard to move around a spreadsheet......Page 171
Naming cells......Page 172
Searching for text......Page 174
Searching for formulas......Page 176
Changing the size of rows and columns with the mouse......Page 177
Adding and deleting rows and columns......Page 178
Adding sheets......Page 179
Deleting a sheet......Page 180
Clearing Data......Page 181
Using Page Layout view......Page 182
Adding a header or footer......Page 183
Printing gridlines......Page 184
Defining a print area......Page 185
Inserting and removing page breaks......Page 186
Printing row and column headings......Page 187
Defining printing margins......Page 188
Defining paper orientation and size......Page 189
Printing in Excel......Page 190
Creating a Formula......Page 191
Organizing formulas with parentheses......Page 194
Copying formulas......Page 195
Using Functions......Page 196
Using the AutoSum command......Page 198
Using recently used functions......Page 199
Editing a Formula......Page 200
Comparing data values......Page 201
Creating conditional formatting rules......Page 202
Data Validation......Page 203
Goal Seeking......Page 206
Creating a scenario......Page 208
Viewing a scenario......Page 210
Viewing a scenario summary......Page 211
Finding where a formula gets its data......Page 213
Finding which formula(s) a cell can change......Page 214
Checking for Errors......Page 215
Understanding the Parts of a Chart......Page 217
Creating a Chart......Page 219
Moving a chart on a worksheet......Page 221
Moving a chart to a new sheet......Page 222
Changing the chart type......Page 223
Changing the data source......Page 224
Switching rows and columns......Page 225
Changing the parts of a chart......Page 226
Designing the layout of a chart......Page 227
Using Sparklines......Page 228
Customizing a Sparkline......Page 229
Deleting a Sparkline......Page 230
Creating a pivot table......Page 231
Rearranging labels in a pivot table......Page 233
Modifying a pivot table......Page 235
Filtering a pivot table......Page 236
Summing a pivot table......Page 237
Slicing up a pivot table......Page 238
Creating a pivot chart......Page 240
Part 4 Making Presentations with PowerPoint......Page 243
Defining the Purpose of Your Presentation......Page 245
Creating a PowerPoint Presentation......Page 246
Designing a presentation in Normal view......Page 247
Designing a presentation with Outline view......Page 250
Working with Text......Page 253
Creating a text box......Page 254
Aligning text......Page 255
Adjusting line spacing......Page 256
Making numbered and bulleted lists......Page 257
Making columns......Page 258
Moving and resizing a text box......Page 259
Rotating a text box......Page 260
Chapter 12 Adding Color and Pictures to a Presentation......Page 261
Applying a Theme......Page 262
Changing the Background......Page 263
Choosing a solid color background......Page 264
Choosing a gradient background......Page 265
Choosing a picture background......Page 267
Adding Graphics to a Slide......Page 268
Placing clip art on a slide......Page 269
Creating WordArt......Page 270
Capturing screenshots......Page 271
Resizing, moving, and deleting graphic images......Page 272
Layering objects......Page 273
Searching for a video on the Internet......Page 274
Searching for video on your computer......Page 275
Trimming a video......Page 276
Coloring a video......Page 277
Formatting the shape of a video......Page 278
Adding audio from a file......Page 280
Recording audio......Page 281
Spell-Checking Your Presentation......Page 283
Adding a section......Page 285
Expanding and collapsing a section......Page 286
Deleting a section......Page 287
Adding Visual Transitions......Page 288
Adding slide transitions......Page 289
Text and graphic transitions......Page 291
Adding Hyperlinks......Page 292
Creating web page hyperlinks......Page 293
Creating hyperlinks to external files......Page 294
Removing a hyperlink or action......Page 295
Viewing a Presentation......Page 296
Creating a custom slide show......Page 297
Organizing with Slide Sorter view......Page 299
Creating Handouts......Page 300
Part 5 Getting Organized with Outlook......Page 303
Configuring Email Settings......Page 305
Adding an email account......Page 306
Creating an email message......Page 307
Replying to an email message......Page 308
Using a stored email address to create a new email message......Page 309
Attaching Files to Messages......Page 311
Reading and Organizing Email......Page 313
Changing the appearance of the Reading Pane......Page 314
Retrieving a file attachment from a message......Page 315
Creating Quick Steps......Page 317
Making an appointment......Page 321
Viewing appointments......Page 324
Deleting an appointment......Page 325
Adding a name......Page 326
Viewing names......Page 327
Searching names......Page 328
Managing Tasks......Page 329
Storing a task......Page 331
Searching tasks......Page 332
Viewing tasks......Page 333
Part 6 Storing Stuff in Access......Page 335
Chapter 16 Using a Database......Page 337
Understanding the Basics of a Database......Page 338
Designing a Database......Page 339
Naming a field......Page 342
Adding and deleting a field......Page 343
Defining the type and size of a field......Page 344
Typing Data into a Database......Page 345
Using Form view......Page 346
Creating a form......Page 347
Editing a form......Page 348
Closing a database......Page 351
Exiting Access......Page 352
Chapter 17 Searching, Sorting, and Querying a Database......Page 353
Searching for a specific record......Page 354
Filtering a database......Page 355
Sorting a Database......Page 362
Creating a simple query......Page 363
Creating a crosstab query......Page 365
Creating a query that finds duplicate field data......Page 368
Creating an unmatched query......Page 370
Viewing, renaming, closing, and deleting queries......Page 371
Using the Report Wizard......Page 373
Counting records or values......Page 377
Filtering a field......Page 379
Editing a Report......Page 380
Resizing fields......Page 381
Making Reports Look Pretty......Page 382
Creating conditional formatting......Page 383
Deleting a Report......Page 385
Part 7 The Part of Tens......Page 387
Saving Office 2019 Files......Page 389
Password-Protecting Your Files......Page 391
Guarding Against Macro Viruses......Page 393
Customizing the Ribbon......Page 394
Changing the Size of the Office Window......Page 396
Freezing Row and Column Headings in Excel......Page 397
Setting up Outlook’s junk email filter......Page 398
Creating a Safe Senders list......Page 400
Using Office 365 and Office on Android and iOS......Page 401
Build (and Use) Your Own Office Add-Ins......Page 403
Collaborating with the Review Tab......Page 404
Using Excel’s Data Tab......Page 405
Encrypting a File......Page 406
Saving to the Cloud......Page 407
Find More Office Templates......Page 408
Use Microsoft Office Everywhere......Page 409
Index......Page 411
EULA......Page 435