| Acknowiedgments | p. xv |
| About the authors | p. xvii |
| i | Introduction | p. xix |
| Who this book is for | p. xix |
| The Step by Step approach | p. xix |
| Features and conventions | p. xx |
| Download the practice files | p. xxi |
| E-book edition | p. xxv |
| Get support and give feedback | p. xxv |
| Errata and support | p. xxv |
| Stay in touch | p. xxv |
| Adapt exercise steps | p. xxvi |
| Part 1 | Microsoft Office (Microsoft 365 Apps) | |
| 1 | Explore Office | p. 3 |
| Work in the Office user interface | p. 4 |
| Identify app window elements | p. 6 |
| Work with the ribbon and status bar | p. 12 |
| Adapt procedures for your environment | p. 14 |
| Discover new features | p. 19 |
| Change Office and app options | p. 21 |
| Manage account information | p. 21 |
| Microsoft account options | p. 22 |
| Manage app options | p. 25 |
| Display and customize the Quick Access Toolbar | p. 29 |
| Customize the ribbon | p. 34 |
| Get help and provide feedback | p. 38 |
| Key points | p. 43 |
| Practice tasks | p. 44 |
| 2 | Create and manaqe files | p. 49 |
| Create files | p. 50 |
| Open and move around in files | p. 54 |
| Display different views of files | p. 59 |
| Display and edit file properties | p. 63 |
| File types and compatibility with earlier versions of Office apps | p. 64 |
| Save and close files | p. 67 |
| Save files to OneDrive | p. 70 |
| Key points | p. 72 |
| Practice tasks | p. 73 |
| Part 2 | Microsoft Word | |
| 3 | Modify the structure and appearance of text | p. 79 |
| Apply paragraph formatting | p. 80 |
| Configure alignment | p. 81 |
| Configure vertical spacing | p. 82 |
| Configure indents | p. 85 |
| Configure paragraph borders and shading | p. 88 |
| Apply character formatting | p. 89 |
| Character formatting and case considerations | p. 94 |
| Format the first letter of a paragraph as a drop cap | p. 96 |
| Structure content manually | p. 97 |
| Create and modify lists | p. 101 |
| Format text as you type | p. 106 |
| Apply built-in styles to text | p. 107 |
| Apply styles | p. 107 |
| Manage outline levels | p. 112 |
| Change the document theme | p. 114 |
| Key points | p. 118 |
| Practice tasks | p. 119 |
| 4 | Collaborate on documents | p. 125 |
| Mark up documents | p. 126 |
| Insert comments | p. 126 |
| Track changes | p. 128 |
| Display and review document markup | p. 132 |
| Display markup | p. 132 |
| Review and respond to comments | p. 138 |
| Review and process tracked changes | p. 140 |
| Remember to check for errors | p. 142 |
| Compare and combine documents | p. 143 |
| Compare and combine separate copies of a document | p. 143 |
| Compare separate versions of a document | p. 146 |
| Control content changes | p. 147 |
| Restrict actions | p. 148 |
| Restrict access by using a password | p. 153 |
| Coauthor documents | p. 158 |
| Key points | p. 162 |
| Practice tasks | p. 163 |
| 5 | Merge data with documents and labels | p. 167 |
| Understand the mail merge process | p. 168 |
| Start the mail merge process | p. 169 |
| Get started with letters | p. 170 |
| Get started with labels | p. 171 |
| Get started with email messages | p. 174 |
| Attaching files to email merge messages | p. 175 |
| Choose and refine the data source | p. 176 |
| Select an existing data source | p. 177 |
| Create a new data source | p. 180 |
| Refine the data source records | p. 181 |
| Refresh data | p. 186 |
| Insert merge fields | p. 186 |
| Preview and complete the merge | p. 189 |
| Create individual envelopes and labels | p. 191 |
| Generate individual envelopes | p. 192 |
| Generate individual mailing labels | p. 195 |
| Key points | p. 198 |
| Practice tasks | p. 199 |
| Part 3 | Excel | |
| 6 | Perform calculations on data | p. 205 |
| Name data ranges | p. 206 |
| Operators and precedence | p. 210 |
| Create formulas to calculate values | p. 210 |
| Summarize data that meets specific conditions | p. 217 |
| Copy and move formulas | p. 221 |
| Create array formulas | p. 224 |
| Find and correct errors in calculations | p. 226 |
| Configure automatic and iterative calculation options | p. 230 |
| Key points | p. 233 |
| Practice tasks | p. 234 |
| 7 | Manage worksheet data | p. 237 |
| Filter data ranges and tables | p. 238 |
| Summarize filtered data | p. 243 |
| Randomly select list rows | p. 249 |
| Enforce data entry criteria | p. 250 |
| Key points | p. 256 |
| Practice tasks | p. 257 |
| 8 | Reorder and summarize data | p. 259 |
| Sort worksheet data | p. 260 |
| Sort data by using custom lists | p. 266 |
| Outline and subtotal data | p. 268 |
| Key points | p. 272 |
| Practice tasks | p. 273 |
| 9 | Analyze alternative data sets | p. 275 |
| Define and display alternative data sets | p. 276 |
| Forecast data by using data tables | p. 281 |
| Identify the input necessary to achieve a specific result | p. 284 |
| Key points | p. 286 |
| Practice tasks | p. 287 |
| Part 4 | PowerPoint | |
| 10 | Create and manage slides | p. 291 |
| Add and remove slides | p. 292 |
| Insert new slides | p. 293 |
| Copy and import slides and content | p. 294 |
| Hide and delete slides | p. 300 |
| Apply themes | p. 301 |
| Change slide backgrounds | p. 305 |
| Non-theme colors | p. 313 |
| Divide presentations into sections | p. 314 |
| Rearrange slides and sections | p. 316 |
| Key points | p. 319 |
| Practice tasks | p. 320 |
| 11 | Insert and manage simple graphics | p. 323 |
| Insert, move, and resize pictures | p. 324 |
| Graphic formats | p. 326 |
| Edit and format pictures | p. 329 |
| Provide additional information about pictures | p. 334 |
| Create a photo album | p. 337 |
| Insert and format icons | p. 342 |
| Work with scalable vector graphics | p. 344 |
| Draw and modify shapes | p. 345 |
| Draw and add text to shapes | p. 345 |
| Locate additional formatting commands | p. 347 |
| Move and modify shapes | p. 348 |
| Format shapes | p. 350 |
| Connect shapes | p. 354 |
| Key points | p. 355 |
| Practice tasks | p. 356 |
| 12 | Add sound and movement to slides | p. 361 |
| Animate text and pictures on slides | p. 362 |
| Animate this | p. 368 |
| Morphing slide content into new forms | p. 372 |
| Customize animation effects | p. 372 |
| Bookmark points of interest in media clips | p. 378 |
| Add audio content to slides | p. 380 |
| Add video content to slides | p. 386 |
| Compress media to decrease file size | p. 390 |
| Hyperlink to additional resources | p. 393 |
| Key points | p. 394 |
| Practice tasks | p. 395 |
| Part 5 | Microsoft Outlook | |
| 13 | Send and receive email messages | p. 401 |
| Create and send messages | p. 402 |
| Create messages | p. 404 |
| Troubleshoot message addressing | p. 409 |
| Save and send messages | p. 414 |
| Send from a specific account | p. 415 |
| Attach files and Outlook items to messages | p. 418 |
| New mail notifications | p. 426 |
| Display messages and message attachments | p. 427 |
| Display message content | p. 427 |
| Display attachment content | p. 429 |
| Display message participant information | p. 433 |
| Respond to messages | p. 436 |
| Resending and recalling messages | p. 440 |
| Key points | p. 442 |
| Practice tasks | p. 443 |
| 14 | Organize your Inbox | p. 447 |
| Display and manage messages | p. 448 |
| Select the primary Inbox content | p. 448 |
| Display and manage conversations | p. 449 |
| Arrange messages by specific attributes | p. 455 |
| Categorize items | p. 459 |
| Store information in Outlook notes | p. 464 |
| Organize messages in folders | p. 467 |
| Print messages | p. 471 |
| Key points | p. 473 |
| Practice tasks | p. 474 |
| 15 | Manage scheduling | p. 477 |
| Display different views of a calendar | p. 478 |
| Use the Date Navigator | p. 482 |
| Schedule appointments and events | p. 484 |
| Convert calendar items | p. 489 |
| Add holidays to your calendar | p. 490 |
| Configure calendar item options | p. 493 |
| Schedule and change meetings | p. 498 |
| Respond to meeting requests | p. 506 |
| Key points | p. 508 |
| Practice tasks | p. 509 |
| Appendix: Keyboard shortcuts | p. 513 |
| Index | p. 521 |
