Illustrated Microsoft Office 365 & Office 2019 Intermediate

Cover......Page 1
Contents......Page 6
Productivity Apps for School and Work......Page 12
Introduction to OneNote 2016......Page 13
Introduction to Sway......Page 17
Introduction to Office Mix......Page 21
Introduction to Microsoft Edge......Page 25
Module 5: Creating and Formatting Tables......Page 28
Insert a Table......Page 29
Converting Text To A Table And A Table To Text......Page 30
Insert and Delete Rows and Columns......Page 31
Copying And Moving Rows And Columns......Page 32
Modify Rows and Columns......Page 33
Setting Advanced Table Properties......Page 34
Sort Table Data......Page 35
Sorting Lists And Paragraphs......Page 36
Changing Cell Margins......Page 37
Using Tables To Lay Out A Page......Page 38
Perform Calculations in Tables......Page 39
Working With Formulas......Page 40
Apply a Table Style......Page 41
Customize a Table Format......Page 43
Drawing A Table......Page 44
Practice......Page 45
Module 6: Illustrating Documents with Graphics......Page 52
Insert a Graphic......Page 53
Correcting Pictures, Changing Colors, And Applying Artistic Effects......Page 54
Size and Scale a Graphic......Page 55
Cropping Graphics......Page 56
Position a Graphic......Page 57
Removing The Background From A Picture......Page 58
Create a Text Box......Page 59
Linking Text Boxes......Page 60
Create WordArt......Page 61
Enhancing Graphic Objects With Styles And Effects......Page 62
Draw Shapes......Page 63
Creating An Illustration In A Drawing Canvas......Page 64
Create a Chart......Page 65
Creating Smartart Graphics......Page 66
Finalize Page Layout......Page 67
Inserting Online Videos And Online Pictures In A Document......Page 68
Practice......Page 69
Module 7: Working with Themes and Building Blocks......Page 76
Apply Styles to Text......Page 77
Saving A Document As A Webpage......Page 78
Changing The Style Set......Page 79
Changing The Default Theme......Page 80
Customize a Theme......Page 81
Insert a Sidebar......Page 83
Insert Quick Parts......Page 85
Add a Cover Page......Page 87
Create Building Blocks......Page 89
Renaming A Building Block And Editing Other Properties......Page 90
Insert Building Blocks......Page 91
Practice......Page 93
Module 8: Merging Word Documents......Page 100
Understand Mail Merge......Page 101
Using A Mail Merge Template......Page 103
Design a Data Source......Page 105
Merging With An Outlook Data Source......Page 106
Enter and Edit Records......Page 107
Add Merge Fields......Page 109
Matching Fields......Page 110
Merge Data......Page 111
Create Labels......Page 113
Printing Individual Envelopes And Labels......Page 114
Sort and Filter Records......Page 115
Inserting Individual Merge Fields......Page 116
Practice......Page 117
Module 5: Analyzing Data Using Formulas......Page 124
Format Data Using Text Functions......Page 125
Working With Text In Other Ways......Page 126
Sum a Data Range Based on Conditions......Page 127
Entering Date And Time Functions......Page 128
Consolidate Data Using a Formula......Page 129
Linking Data Between Workbooks......Page 130
Check Formulas for Errors......Page 131
Correcting Circular References......Page 132
Consolidating Data Using Named Ranges......Page 133
Managing Workbook Names......Page 134
Build a Logical Formula with the IF Function......Page 135
Using The Or And Not Logical Functions......Page 137
Calculate Payments with the PMT Function......Page 139
Calculating Future Value With The FV Function......Page 140
Practice......Page 141
Module 6: Managing Workbook Data......Page 148
View and Arrange Worksheets......Page 149
Splitting The Worksheet Into Multiple Panes......Page 150
Protect Worksheets and Workbooks......Page 151
Freezing Rows And Columns......Page 152
Save Custom Views of a Worksheet......Page 153
Using Page Break Preview......Page 154
Add a Worksheet Background......Page 155
Working With Screenshots In Excel......Page 156
Prepare a Workbook for Distribution......Page 157
Sharing A Workbook Using Onedrive......Page 158
Working With Headers And Footers......Page 159
Using Research Tools......Page 160
Saving A Workbook In Other Formats......Page 161
Group Worksheets......Page 163
Practice......Page 165
Module 7: Managing Data Using Tables......Page 172
Plan a Table......Page 173
Create and Format a Table......Page 175
Changing Table Style Options......Page 176
Add Table Data......Page 177
Selecting Table Elements......Page 178
Find and Replace Table Data......Page 179
Using Find and Select Features......Page 180
Delete Table Data......Page 181
Sorting Conditionally Formatted Data......Page 183
Specifying A Custom Sort Order......Page 184
Use Formulas in a Table......Page 185
Print a Table......Page 187
Setting A Print Area......Page 188
Practice......Page 189
Module 8: Analyzing Table Data......Page 196
Filter a Table......Page 197
Create a Custom Filter......Page 199
Using More Than One Rule When Conditionally Formatting Data......Page 200
Filter a Table with the Advanced Filter......Page 201
Saving Time With Conditional Formatting......Page 202
Extract Table Data......Page 203
Understanding The Criteria Range And The Copy-to Location......Page 204
Look Up Values in a Table......Page 205
Using Other LOOKUP Functions......Page 206
Summarize Table Data......Page 207
Restricting Cell Values And Data Length......Page 209
Adding Input Messages And Error Alerts......Page 210
Create Subtotals......Page 211
Practice......Page 213
Module 4: Integrating Word and Excel......Page 220
Use Paste Special to Modify Formatting......Page 221
Create a Hyperlink Between Word and Excel......Page 223
Editing And Removing A Hyperlink......Page 224
Create an Excel Spreadsheet in Word......Page 225
Formatting Pasted, Embedded, And Linked Objects......Page 227
Change Link Sources......Page 229
Reestablishing Links......Page 230
Practice......Page 231
Module 5: Modifying the Database Structure......Page 236
Using Many-to-Many Relationships......Page 237
Enforcing Referential Integrity......Page 238
Specifying the Foreign Key Field Data Type......Page 239
Create One-to-Many Relationships......Page 241
More on Enforcing Referential Integrity......Page 242
Creating Multivalued Fields......Page 243
Modify Short Text Fields......Page 245
Working with the Input Mask Property......Page 246
Modify Number and Currency Fields......Page 247
Modifying Fields in Datasheet View......Page 248
Modify Date/Time Fields......Page 249
Using Smart Tags......Page 250
Modify Validation Properties......Page 251
Create Attachment Fields......Page 253
Working with Database File Types......Page 254
Practice......Page 255
Module 6: Improving Queries......Page 268
Create Multitable Queries......Page 269
Deleting A Field From The Query Grid......Page 270
Apply Sorts and View SQL......Page 271
Specifying A Sort Order Different From The Field Order In The Datasheet......Page 272
Develop AND Criteria......Page 273
Develop OR Criteria......Page 275
Using Wildcard Characters In Query Criteria......Page 276
Create Calculated Fields......Page 277
Function Sample Expression And Description......Page 278
Build Summary Queries......Page 279
Build Crosstab Queries......Page 281
Using Query Wizards......Page 282
Create a Report on a Query......Page 283
Practice......Page 285
Module 7: Enhancing Forms......Page 294
Use Form Design View......Page 295
Linking The Form And Subform......Page 297
Anchoring, Margins, And Padding......Page 299
Add a Combo Box for Data Entry......Page 301
Choosing Between A Combo Box And A List Box......Page 302
Add a Combo Box to Find Records......Page 303
Shape Effects......Page 305
Add Option Groups......Page 307
Protecting Data......Page 308
Add Tab Controls......Page 309
Practice......Page 311
Module 8: Analyzing Data with Reports......Page 320
Use Report Design View......Page 321
Create Parameter Reports......Page 323
Parameter Criteria......Page 324
Apply Conditional Formatting......Page 325
Conditional Formatting Using Data Bars......Page 326
Add Lines......Page 327
Line Troubles......Page 328
Use the Format Painter and Themes......Page 329
Add Subreports......Page 331
Modify Section Properties......Page 333
Create Summary Reports......Page 335
Practice......Page 337
Module 5: Integrating Word and Access......Page 348
Merge from Access to Word......Page 349
Export an Access Report to Word......Page 351
Practice......Page 353
Module 5: Working with Advanced Tools and Masters......Page 356
Draw and Format Connectors......Page 357
Changing Page Setup And Slide Orientation......Page 358
Use Advanced Formatting Tools......Page 359
Creating Columns In A Text Box......Page 360
Customize Animation Effects......Page 361
Understanding Animation Timings......Page 362
Create Custom Slide Layouts......Page 363
Restoring The Slide Master Layout......Page 364
Format Master Text......Page 365
Organizing Slides Into Sections......Page 366
Change Master Text Indents......Page 367
Adjust Text Objects......Page 369
Changing Text Direction......Page 370
Use Templates and Add Comments......Page 371
Understanding Powerpoint Templates And Themes......Page 372
Practice......Page 373
Module 6: Enhancing Charts......Page 380
Work with Charts in PowerPoint......Page 381
Using Paste Special......Page 382
Change Chart Design and Style......Page 383
Using AutoFit Options to Divide and Fit Body Text......Page 384
Customize a Chart......Page 385
Using the Insights Task Pane......Page 386
Format Chart Elements......Page 387
Changing PowerPoint Options......Page 388
Animate a Chart......Page 389
Inserting a Picture as a Slide Background......Page 390
Embed an Excel Chart......Page 391
Embedding a Worksheet......Page 392
Link an Excel Worksheet......Page 393
Update a Linked Excel Worksheet......Page 395
Editing Links......Page 396
Practice......Page 397
Module 7: Inserting Graphics, Media, and Objects......Page 404
Create a Custom Table......Page 405
Design a SmartArt Graphic......Page 407
Creating Mathematical Equations......Page 408
Enhance a SmartArt Graphic......Page 409
Saving A Presentation In PDF, XPS, Or Other Fixed File Formats......Page 410
Insert and Edit Digital Video......Page 411
Trimming A Video......Page 412
Insert and Trim Audio......Page 413
Recording A Narration On A Slide......Page 414
Edit and Adjust a Picture......Page 415
Compressing Pictures......Page 416
Add Action Buttons......Page 417
Changing The Transparency Of A Picture......Page 418
Insert Hyperlinks......Page 419
Inserting A Screenshot......Page 420
Practice......Page 421
Module 8: Using Advanced Features......Page 428
Customize Handout and Notes Masters......Page 429
Creating Handouts In Microsoft Word......Page 430
Send a Presentation for Review......Page 431
Packaging A Presentation......Page 432
Combine Reviewed Presentations......Page 433
Coauthoring A Presentation......Page 434
Set Up a Slide Show......Page 435
Installing And Using Office Add-ins......Page 436
Create a Custom Show......Page 437
Linking To A Custom Slide Show......Page 438
Prepare a Presentation for Distribution......Page 439
Recording A Slide Show......Page 440
Create a Photo Album......Page 441
Publishing Slides To A Slide Library......Page 442
Deliver a Presentation Online......Page 443
Mastering PowerPoint Features And Online Presentations......Page 444
Practice......Page 445
Module 6: Integrating Word, Excel, Access, and PowerPoint......Page 452
Insert an Access Table into PowerPoint......Page 453
Insert Word Objects into PowerPoint......Page 455
Link an Excel File into PowerPoint......Page 457
Create PowerPoint Handouts in Word......Page 459
Embed a PowerPoint Slide in Word......Page 461
Practice......Page 463
Glossary......Page 468
Index......Page 499