Teach Yourself VISUALLY Microsoft 365

by Paul McFedries

Overview

An illustrated, A-to-Z, and newly updated guide to mastering Microsoft Office 365

Teach Yourself VISUALLY Microsoft 365, 2nd Edition is a newly revised edition of the easy-to-use and up-to-date visual walkthrough of Microsoft's ubiquitous office products. It#s the fastest and most efficient way to get up to speed on world-famous apps like Word, Excel, and PowerPoint, offering crystal-clear, high-resolution screenshots that show you exactly how to get things done.

Tired of confusing, text-based "instructions" that leave you scratching your head and wondering, "Why didn't that work?" Then grab a copy of TYV Microsoft 365, 2nd Edition for a complete, A-to-Z tour of Microsoft 365 that takes you through how to generate sophisticated documents in Word, crunch numbers in Excel, keep your life organized in Outlook, and build attractive and persuasive presentations in PowerPoint.

This book shows you how to master basic, foundational features that have been around for years, as well as cutting-edge new additions to the software--like Microsoft's Copilot AI--that make your job easier and make you more productive. From working with files in the cloud to setting up your own local databases in Access, TYV Microsoft 365, 2nd Edition puts the info, screenshots, and instructions you need at your fingertips.

Readers will find:

• Hundreds of hi-res, full-page screenshots that demonstrate Microsoft 365's most useful features
• Specific instructions on how to get more from your favorite Office 365 apps, like how to add attachments to your Outlook emails or include narration in a PowerPoint presentation
• Techniques to incorporate artificial intelligence in your everyday work to supercharge your productivity by summarizing Word documents or automatically generating Excel formulas

Perfect for anyone looking for an intuitive and visual guide to Microsoft 365 that comes with full-screen images that show you exactly what to do and where to click, Teach Yourself VISUALLY Microsoft 365, 2nd Edition is the simplest and most effective resource for mastering the world's most popular suite of office apps.

Product Details

ISBN-13:	9781394298273
Publisher:	Wiley
Publication date:	03/25/2025
Edition description:	2nd ed.
Pages:	320
Product dimensions:	7.30(w) x 9.20(h) x 0.80(d)

About the Author

Paul McFedries is a full-time technical writer. Paul has been authoring computer books since 1991, and he has more than 100 books to his credit. Paul's books have sold more than four million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Windows 11, Second Edition, Teach Yourself VISUALLY Microsoft 365, Second Edition, Google Workspace For Dummies, and HTML, CSS, and JavaScript for Dummies. Paul invites you to drop by his personal website at https://paulmcfedries.com and to follow him on X @paulmcf and on Facebook at https://facebook.com/PaulMcFedries.

Table of Contents

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 Formulas 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