Home Page Icon
Home Page
Table of Contents for
Teach Yourself VISUALLY Microsoft 365
Close
Teach Yourself VISUALLY Microsoft 365
by Paul McFedries
Teach Yourself VISUALLY Microsoft 365
Cover
Title Page
Copyright
Part I: Microsoft 365 Features
Part II: Word
Part III: Excel
Part IV: PowerPoint
Part V: Access
Part VI: Outlook
Index
End User License Agreement
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Title Page
Next
Next Chapter
Part I: Microsoft 365 Features
Teach Yourself VISUALLY™ Microsoft 365
Table of Contents
Cover
Title Page
Copyright
Part I: Microsoft 365 Features
Chapter 1: Microsoft 365 Basics
Start and Exit Microsoft 365 Apps
Explore the App Window
Work with Backstage View
Change the Color Scheme
Search for a Ribbon Command
Work with the Ribbon
Customize the Quick Access Toolbar
Using a Microsoft 365 App with a Touch Screen
Chapter 2: Working with Files
Create a New File
Save a File
Open a File
Print a File
Select Data
Chapter 3: Microsoft 365 Graphics Tools
Insert a Picture from Your PC
Insert an Online Picture
Resize and Move Graphic Objects
Understanding Graphics Modification Techniques
Chapter 4: Working with Microsoft 365 Files Online
Microsoft 365 and the Cloud
Sign In to Microsoft 365
Share a Document from Microsoft 365
Sign In to OneDrive
Using an Online App in OneDrive
Open a Document in a Desktop App from OneDrive
Upload a Document to OneDrive
Share a Document Using OneDrive
Part II: Word
Chapter 5: Adding Text
Change Word’s Views
Type and Edit Text
Insert Quick Parts
Insert Symbols
Chapter 6: Formatting Text
Change the Font, Size, and Color
Align Text
Set Line Spacing
Indent Text
Set Tabs
Set Margins
Create Lists
Copy Formatting
Clear Formatting
Format with Styles
Using a Template
Chapter 7: Adding Extra Touches
Insert an Online Video
Assign a Theme
Add Borders
Create Columns
Insert a Table
Apply Table Styles
Insert Table Rows or Columns
Add Headers and Footers
Insert Footnotes and Endnotes
Chapter 8: Reviewing Documents
Work in Read Mode View
Find and Replace Text
Navigate Document Content
Check Spelling and Grammar
Customize AutoCorrect
Using Word’s Thesaurus and Dictionary
Translate Text
Track and Review Document Changes
Lock and Unlock Tracking
Combine Reviewers’ Changes
Work with Comments
Part III: Excel
Chapter 9: Building Spreadsheets
Enter Cell Data
Select Cells
Using AutoFill for Faster Data Entry
Turn On Text Wrapping
Center Data Across Columns
Adjust Cell Alignment
Change the Font and Size
Change Number Formats
Increase or Decrease Decimals
Add Cell Borders and Shading
Format Data with Styles
Apply Conditional Formatting
Insert Rows and Columns
Resize Columns and Rows
Freeze Column and Row Titles On-Screen
Name a Range
Clear or Delete Cells
Chapter 10: Worksheet Basics
Add a Worksheet
Rename a Worksheet
Change Page Setup Options
Move or Copy Worksheets
Delete a Worksheet
Find and Replace Data
Create a Table
Filter or Sort Table Information
Analyze Data Quickly
Understanding Data Analysis Choices
Insert a Note
Chapter 11: Working with Formulas and Functions
Understanding Formulas
Create a Formula
Apply Absolute and Relative Cell References
Understanding Functions
Insert a Function
Total Cells with AutoSum
Chapter 12: Working with Charts
Create a Chart
Move and Resize Charts
Change the Chart Type
Change the Chart Style
Change the Chart Layout
Add Chart Elements
Format Chart Elements
Change the Chart Data
Using Sparklines to View Data Trends
Understanding PivotTables
Create a PivotTable
Create a PivotChart
Insert a PivotTable Slicer
Part IV: PowerPoint
Chapter 13: Creating a Presentation
Create a New Presentation
Create a Photo Album Presentation
Change PowerPoint Views
Insert Slides
Change the Slide Layout
Change the Slide Size
Chapter 14: Populating Presentation Slides
Add and Edit Slide Text
Change the Font, Size, and Color
Apply a Theme
Set Line Spacing
Align Text
Add a Text Box to a Slide
Add a Table to a Slide
Add a Chart to a Slide
Add a Video Clip to a Slide
Move a Slide Object
Resize a Slide Object
Chapter 15: Assembling and Presenting a Slideshow
Reorganize Slides
Reuse a Slide
Organize Slides into Sections
Define Slide Transitions
Add Animation Effects
Create a Custom Animation
Record Narration
Insert a Background Song
Create Speaker Notes
Rehearse a Slideshow
Run a Slideshow
Part V: Access
Chapter 16: Database Basics
Understanding Database Basics
Create a Database Based on a Template
Create a Blank Database
Create a New Table
Change Table Views
Add a Field to a Table
Delete a Field from a Table
Hide a Field in a Table
Move a Field in a Table
Create a Form
Change Form Views
Move a Field in a Form
Delete a Field in a Form
Format Form Fields
Chapter 17: Adding, Finding, and Querying Data
Add Records to a Table
Add a Record Using a Form
Navigate Records Using a Form
Search for a Record Using a Form
Delete a Record from a Table
Delete a Record Using a Form
Sort Records
Filter Records
Perform a Simple Query
Create a Report
Part VI: Outlook
Chapter 18: Organizing with Outlook
Navigate in Outlook
Schedule an Appointment
Create a New Contact
Create a New Task
Add a Note
Customize the Navigation Bar
Peek at Appointments and Tasks
Chapter 19: E-mailing with Outlook
Compose and Send a Message
Send a File Attachment
Read an Incoming Message
Reply to or Forward a Message
Add a Sender to Your Outlook Contacts
Delete a Message
Screen Junk E-Mail
Create a Message Rule
Index
End User License Agreement
Guide
Cover
Title Page
Copyright
Table of Contents
Begin Reading
Index
Pages
i
ii
iii
v
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset