Part I Microsoft 365 Features
Chapter 1 Microsoft 365 Basics
Start and Exit Microsoft 365 Apps 4
Explore the App Window 6
Work with Backstage View 7
Change the Color Scheme 8
Search for a Ribbon Command 10
Work with the Ribbon 12
Customize the Quick Access Toolbar 14
Using a Microsoft 365 App with a Touch Screen 16
Chapter 2 Working with Files
Create a New File 18
Save a File 20
Open a File 22
Print a File 24
Select Data 26
Chapter 3 Microsoft 365 Graphics Tools
Insert a Picture from Your PC 28
Insert an Online Picture 30
Resize and Move Graphic Objects 32
Understanding Graphics Modification Techniques 34
Chapter 4 Working with Microsoft 365 Files Online
Microsoft 365 and the Cloud 36
Sign In to Microsoft 365 38
Share a Document from Microsoft 365 40
Sign In to OneDrive 42
Using an Online App in OneDrive 44
Open a Document in a Desktop App from OneDrive 46
Upload a Document to OneDrive 48
Share a Document Using OneDrive 50
Part II Word
Chapter 5 Adding Text
Change Word’s Views 54
Type and Edit Text 56
Insert Quick Parts 58
Insert Symbols 60
Chapter 6 Formatting Text
Change the Font, Size, and Color 62
Align Text 66
Set Line Spacing 67
Indent Text 68
Set Tabs 70
Set Margins 72
Create Lists 74
Copy Formatting 76
Clear Formatting 77
Format with Styles 78
Using a Template 80
Chapter 7 Adding Extra Touches
Insert an Online Video 82
Assign a Theme 84
Add Borders 86
Create Columns 88
Insert a Table 90
Apply Table Styles 92
Insert Table Rows or Columns 93
Add Headers and Footers 94
Insert Footnotes and Endnotes 96
Chapter 8 Reviewing Documents
Work in Read Mode View 98
Find and Replace Text 102
Navigate Document Content 104
Check Spelling and Grammar 106
Customize AutoCorrect 108
Using Word’s Thesaurus and Dictionary 110
Translate Text 112
Track and Review Document Changes 114
Lock and Unlock Tracking 116
Combine Reviewers’ Changes 118
Work with Comments 120
Part III Excel
Chapter 9 Building Spreadsheets
Enter Cell Data 124
Select Cells 126
Using AutoFill for Faster Data Entry 128
Turn On Text Wrapping 130
Center Data Across Columns 131
Adjust Cell Alignment 132
Change the Font and Size 134
Change Number Formats 136
Increase or Decrease Decimals 137
Add Cell Borders and Shading 138
Format Data with Styles 140
Apply Conditional Formatting 142
Insert Rows and Columns 144
Resize Columns and Rows 146
Freeze Column and Row Titles On?Screen 147
Name a Range 148
Clear or Delete Cells 150
Chapter 10 Worksheet Basics
Add a Worksheet 152
Rename a Worksheet 153
Change Page Setup Options 154
Move or Copy Worksheets 156
Delete a Worksheet 157
Find and Replace Data 158
Create a Table 160
Filter or Sort Table Information 162
Analyze Data Quickly 164
Understanding Data Analysis Choices 165
Insert a Note 166
Chapter 11 Working with Formulas and Functions
Understanding Formulas 168
Create a Formula 170
Apply Absolute and Relative Cell References 172
Understanding Functions 174
Insert a Function 176
Total Cells with AutoSum 178
Chapter 12 Working with Charts
Create a Chart 180
Move and Resize Charts 182
Change the Chart Type 184
Change the Chart Style 185
Change the Chart Layout 186
Add Chart Elements 187
Format Chart Elements 188
Change the Chart Data 189
Using Sparklines to View Data Trends 190
Understanding PivotTables 192
Create a PivotTable 194
Create a PivotChart 196
Insert a PivotTable Slicer 198
Part IV PowerPoint
Chapter 13 Creating a Presentation
Create a New Presentation 202
Create a Photo Album Presentation 204
Change PowerPoint Views 206
Insert Slides 208
Change the Slide Layout 210
Change the Slide Size 212
Chapter 14 Populating Presentation Slides
Add and Edit Slide Text 214
Change the Font, Size, and Color 216
Apply a Theme 220
Set Line Spacing 221
Align Text 222
Add a Text Box to a Slide 223
Add a Table to a Slide 224
Add a Chart to a Slide 226
Add a Video Clip to a Slide 228
Move a Slide Object 230
Resize a Slide Object 231
Chapter 15 Assembling and Presenting a Slideshow
Reorganize Slides 232
Reuse a Slide 234
Organize Slides into Sections 236
Define Slide Transitions 238
Add Animation Effects 240
Create a Custom Animation 242
Record Narration 244
Insert a Background Song 245
Create Speaker Notes 246
Rehearse a Slideshow 248
Run a Slideshow 250
Part V Access
Chapter 16 Database Basics
Understanding Database Basics 256
Create a Database Based on a Template 258
Create a Blank Database 260
Create a New Table 262
Change Table Views 264
Add a Field to a Table 266
Delete a Field from a Table 267
Hide a Field in a Table 268
Move a Field in a Table 269
Create a Form 270
Change Form Views 272
Move a Field in a Form 273
Delete a Field in a Form 274
Format Form Fields 275
Chapter 17 Adding, Finding, and Querying Data
Add Records to a Table 276
Add a Record Using a Form 278
Navigate Records Using a Form 280
Search for a Record Using a Form 281
Delete a Record from a Table 282
Delete a Record Using a Form 283
Sort Records 284
Filter Records 286
Perform a Simple Query 288
Create a Report 292
Part VI Outlook
Chapter 18 Organizing with Outlook
Navigate in Outlook 298
Schedule an Appointment 300
Create a New Contact 302
Create a New Task 304
Add a Note 306
Customize the Navigation Bar 308
Peek at Appointments and Tasks 310
Chapter 19 E-mailing with Outlook
Compose and Send a Message 312
Send a File Attachment 314
Read an Incoming Message 315
Reply to or Forward a Message 316
Add a Sender to Your Outlook Contacts 318
Delete a Message 319
Screen Junk E?Mail 320
Create a Message Rule 322
Index 324
