Teach Yourself Visually Microsoft 365 - Paul McFedries

. .

Résumé :

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

Sommaire:

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

Work with the Ribbon 10

Select Data 12

Using a Microsoft 365 App with a Touch Screen 14

Create a New File 16

Save a File 18

Open a File 20

Chapter 2 Microsoft 365 Graphics Tools

Insert a Picture from Your PC 22

Insert an Online Picture 24

Resize and Move Graphic Objects 26

Understanding Graphics Modification Techniques 28

Chapter 3 Working with Microsoft 365 Files Online

Microsoft 365 and the Cloud 30

Sign In to Microsoft 365 32

Share a Document from Microsoft 365 34

Sign In to OneDrive 36

Using an Online App in OneDrive 38

Open a Document in a Desktop App from OneDrive 40

Upload a Document to OneDrive 42

Chapter 4 Getting AI Assistance with Copilot

Understanding Copilot 44

Draft New Text in Word 46

Rewrite Existing Text 48

Get Help with a Word Document 50

Analyze Excel Data 52

Create Excel Formulas 54

Draft a PowerPoint Presentation 56

Create an Image 58

Part II Word

Chapter 5 Adding Text

Change Word's Views 62

Create Lists 64

Insert Quick Parts 66

Insert Symbols 68

Chapter 6 Formatting Text

Align Text 70

Set Line Spacing 71

Indent Text 72

Set Tabs 74

Set Margins 76

Copy Formatting 78

Clear Formatting 79

Format with Styles 80

Chapter 7 Adding Extra Touches

Assign a Theme 82

Add Borders 84

Create Columns 86

Insert a Table 88

Apply Table Styles 90

Insert Table Rows or Columns 91

Add Headers and Footers 92

Chapter 8 Reviewing Documents

Work in Read Mode View 94

Find and Replace Text 98

Navigate Document Content 100

Check Spelling and Grammar 102

Customize AutoCorrect 104

Using Word's Thesaurus and Dictionary 106

Translate Text 108

Track and Review Document Changes 110

Lock and Unlock Tracking 112

Part III Excel

Chapter 9 Building Spreadsheets

Enter Cell Data 116

Select Cells 118

Using AutoFill for Faster Data Entry 120

Turn On Text Wrapping 122

Center Data Across Columns 123

Adjust Cell Alignment 124

Change the Font and Font Size 126

Change Number Formats 128

Increase or Decrease Decimals 129

Add Cell Borders and Shading 130

Format Data with Styles 132

Apply Conditional Formatting 134

Insert Rows and Columns 136

Resize Columns and Rows 138

Freeze Column and Row Titles On-Screen 139

Name a Range 140

Clear or Delete Cells 142

Chapter 10 Worksheet Basics

Add a Worksheet 144

Rename a Worksheet 145

Move or Copy Worksheets 146

Delete a Worksheet 147

Find and Replace Data 148

Create a Table 150

Filter or Sort Table Information 152

Analyze Data Quickly 154

Understanding Data Analysis Choices 155

Chapter 11 Working with Formulas and Functions

Understanding Formulas 156

Create a Formula 158

Apply Absolute and Relative Cell References 160

Understanding Functions 162

Insert a Function 164

Total Cells with AutoSum 166

Chapter 12 Working with Charts

Create a Chart 168

Move and Resize a Chart 170

Change the Chart Type 172

Change the Ch...