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