| About the authors |
|
xi | |
| i Introduction |
|
xiii | |
| Who this book is for |
|
xiii | |
| The Step by Step approach |
|
xiii | |
| Features and conventions |
|
xiv | |
| Download the practice files |
|
xv | |
| E-book edition |
|
xviii | |
| Get support and give feedback |
|
xix | |
| Errata and support |
|
xix | |
| Stay in touch |
|
xix | |
|
Part 1 Microsoft Office 2019 |
|
|
|
|
|
3 | (44) |
|
Work in the Office user interface |
|
|
4 | (15) |
|
Identify app window elements |
|
|
5 | (7) |
|
Work with the ribbon and status bar |
|
|
12 | (2) |
|
Sidebar: Adapt procedures for your environment |
|
|
14 | (5) |
|
Change Office and app options |
|
|
19 | (8) |
|
Manage account information |
|
|
19 | (1) |
|
Sidebar: Microsoft account options |
|
|
20 | (4) |
|
|
|
24 | (3) |
|
Customize the Quick Access Toolbar |
|
|
27 | (4) |
|
|
|
31 | (5) |
|
Get help and provide feedback |
|
|
36 | (5) |
|
|
|
41 | (1) |
|
|
|
42 | (5) |
|
2 Create and manage files |
|
|
47 | (28) |
|
|
|
48 | (4) |
|
Open and move around in files |
|
|
52 | (4) |
|
Display different views of files |
|
|
56 | (4) |
|
Display and edit file properties |
|
|
60 | (4) |
|
Sidebar: File types and compatibility with earlier versions of Office apps |
|
|
62 | (2) |
|
|
|
64 | (3) |
|
|
|
67 | (3) |
|
Sidebar: Save files to OneDrive |
|
|
68 | (2) |
|
|
|
70 | (5) |
|
Part 2 Microsoft Word 2019 |
|
|
|
3 Modify the structure and appearance of text |
|
|
75 | (44) |
|
Apply paragraph formatting |
|
|
76 | (10) |
|
|
|
77 | (1) |
|
Configure vertical spacing |
|
|
78 | (4) |
|
|
|
82 | (3) |
|
Sidebar: Configure paragraph borders and shading |
|
|
85 | (1) |
|
Structure content manually |
|
|
86 | (4) |
|
Apply character formatting |
|
|
90 | (7) |
|
Sidebar: Character formatting and case considerations |
|
|
97 | (1) |
|
|
|
97 | (5) |
|
Sidebar: Format text as you type |
|
|
101 | (1) |
|
Apply built-in styles to text |
|
|
102 | (7) |
|
|
|
103 | (4) |
|
|
|
107 | (2) |
|
Change the document theme |
|
|
109 | (4) |
|
|
|
113 | (1) |
|
|
|
114 | (5) |
|
4 Collaborate on documents |
|
|
119 | (40) |
|
|
|
120 | (5) |
|
|
|
120 | (3) |
|
|
|
123 | (2) |
|
Display and review document markup |
|
|
125 | (9) |
|
|
|
126 | (4) |
|
Review and respond to comments |
|
|
130 | (2) |
|
Review and process tracked changes |
|
|
132 | (2) |
|
Sidebar: Remember to check for errors |
|
|
134 | (1) |
|
Compare and merge documents |
|
|
134 | (5) |
|
Compare and combine separate copies of a document |
|
|
135 | (3) |
|
Compare separate versions of a document |
|
|
138 | (1) |
|
|
|
139 | (10) |
|
|
|
139 | (5) |
|
Restrict access by using a password |
|
|
144 | (5) |
|
|
|
149 | (4) |
|
|
|
153 | (1) |
|
|
|
154 | (5) |
|
5 Merge data with documents and labels |
|
|
159 | (38) |
|
Understand the mail merge process |
|
|
160 | (1) |
|
Start the mail merge process |
|
|
161 | (7) |
|
|
|
162 | (1) |
|
|
|
163 | (3) |
|
Get started with email messages |
|
|
166 | (2) |
|
Choose and refine the data source |
|
|
168 | (9) |
|
Select an existing data source |
|
|
169 | (3) |
|
|
|
172 | (1) |
|
Refine the data source records |
|
|
173 | (4) |
|
|
|
177 | (1) |
|
|
|
177 | (3) |
|
Preview and complete the merge |
|
|
180 | (2) |
|
Create individual envelopes and labels |
|
|
182 | (8) |
|
Generate individual envelopes |
|
|
183 | (4) |
|
Generate individual mailing labels |
|
|
187 | (3) |
|
|
|
190 | (1) |
|
|
|
191 | (6) |
|
Part 3 Microsoft Excel 2019 |
|
|
|
6 Perform calculations on data |
|
|
197 | (34) |
|
|
|
198 | (3) |
|
Create formulas to calculate values |
|
|
201 | (11) |
|
Sidebar: Operators and precedence |
|
|
210 | (2) |
|
Summarize data that meets specific conditions |
|
|
212 | (5) |
|
Set iterative calculation options and enable or disable automatic calculation |
|
|
217 | (3) |
|
|
|
220 | (2) |
|
Find and correct errors in calculations |
|
|
222 | (5) |
|
|
|
227 | (1) |
|
|
|
228 | (3) |
|
|
|
231 | (18) |
|
Limit data that appears on your screen |
|
|
232 | (4) |
|
Manipulate worksheet data |
|
|
236 | (8) |
|
Select list rows at random |
|
|
236 | (1) |
|
Summarize data in worksheets that have hidden and filtered rows |
|
|
237 | (6) |
|
Find unique values within a data set |
|
|
243 | (1) |
|
Define valid sets of values for ranges of cells |
|
|
244 | (2) |
|
|
|
246 | (1) |
|
|
|
247 | (2) |
|
8 Reorder and summarize data |
|
|
249 | (18) |
|
|
|
250 | (5) |
|
Sort data by using custom lists |
|
|
255 | (2) |
|
Organize data into levels |
|
|
257 | (4) |
|
Look up information in a worksheet |
|
|
261 | (3) |
|
|
|
264 | (1) |
|
|
|
265 | (2) |
|
9 Analyze alternative data sets |
|
|
267 | (28) |
|
Examine data by using the Quick Analysis Lens |
|
|
268 | (1) |
|
Define an alternative data set |
|
|
269 | (4) |
|
Define multiple alternative data sets |
|
|
273 | (1) |
|
Analyze data by using data tables |
|
|
274 | (4) |
|
Vary your data to get a specific result by using Goal Seek |
|
|
278 | (2) |
|
Find optimal solutions by using Solver |
|
|
280 | (6) |
|
Analyze data by using descriptive statistics |
|
|
286 | (2) |
|
|
|
288 | (1) |
|
|
|
289 | (6) |
|
Part 4 Microsoft PowerPoint 2019 |
|
|
|
10 Create and manage slides |
|
|
295 | (32) |
|
|
|
296 | (9) |
|
|
|
297 | (1) |
|
Copy and import slides and content |
|
|
298 | (6) |
|
|
|
304 | (1) |
|
|
|
305 | (5) |
|
|
|
310 | (7) |
|
Sidebar: Non-theme colors |
|
|
316 | (1) |
|
Divide presentations into sections |
|
|
317 | (2) |
|
Rearrange slides and sections |
|
|
319 | (3) |
|
|
|
322 | (1) |
|
|
|
323 | (4) |
|
11 Insert and manage simple graphics |
|
|
327 | (40) |
|
Insert, move, and resize pictures |
|
|
328 | (4) |
|
|
|
330 | (2) |
|
|
|
332 | (5) |
|
Provide additional information about pictures |
|
|
337 | (3) |
|
|
|
340 | (5) |
|
Capture and insert screen clippings |
|
|
345 | (3) |
|
|
|
348 | (3) |
|
Sidebar: Work with scalable vector graphics |
|
|
350 | (1) |
|
|
|
351 | (10) |
|
Draw and add text to shapes |
|
|
351 | (2) |
|
Sidebar: Locate additional formatting commands |
|
|
353 | (1) |
|
|
|
354 | (2) |
|
|
|
356 | (4) |
|
|
|
360 | (1) |
|
|
|
361 | (1) |
|
|
|
362 | (5) |
|
12 Add sound and movement to slides |
|
|
367 | (40) |
|
Animate text and pictures on slides |
|
|
368 | (10) |
|
|
|
373 | (5) |
|
Sidebar: Morphing slide content into new forms |
|
|
378 | (1) |
|
Customize animation effects |
|
|
378 | (8) |
|
Sidebar: Bookmark points of interest in media clips |
|
|
384 | (2) |
|
Add audio content to slides |
|
|
386 | (5) |
|
Add video content to slides |
|
|
391 | (4) |
|
Compress media to decrease file size |
|
|
395 | (5) |
|
Sidebar: Hyperlink to additional resources |
|
|
398 | (2) |
|
|
|
400 | (1) |
|
|
|
401 | (6) |
|
Part 5 Microsoft Outlook 2019 |
|
|
|
13 Send and receive email messages |
|
|
407 | (44) |
|
|
|
408 | (15) |
|
|
|
410 | (4) |
|
Troubleshoot message addressing |
|
|
414 | (5) |
|
|
|
419 | (1) |
|
Sidebar: Send from a specific account |
|
|
420 | (3) |
|
Attach files and Outlook items to messages |
|
|
423 | (7) |
|
Sidebar: New mail notifications |
|
|
429 | (1) |
|
Display messages and message attachments |
|
|
430 | (6) |
|
|
|
430 | (2) |
|
Display attachment content |
|
|
432 | (4) |
|
Display message participant information |
|
|
436 | (4) |
|
|
|
440 | (6) |
|
Sidebar: Resending and recalling messages |
|
|
444 | (2) |
|
|
|
446 | (1) |
|
|
|
447 | (4) |
|
|
|
451 | (30) |
|
Display and manage messages |
|
|
452 | (7) |
|
Select the primary Inbox content |
|
|
452 | (1) |
|
Display and manage conversations |
|
|
453 | (6) |
|
Arrange messages by specific attributes |
|
|
459 | (4) |
|
|
|
463 | (8) |
|
Sidebar: Store information in Outlook notes |
|
|
468 | (3) |
|
Organize messages in folders |
|
|
471 | (6) |
|
|
|
474 | (3) |
|
|
|
477 | (1) |
|
|
|
478 | (3) |
|
|
|
481 | (36) |
|
Display different views of a calendar |
|
|
482 | (6) |
|
Sidebar: Use the Date Navigator |
|
|
486 | (2) |
|
Schedule appointments and events |
|
|
488 | (5) |
|
|
|
493 | (4) |
|
Sidebar: Add holidays to your calendar |
|
|
494 | (3) |
|
Configure calendar item options |
|
|
497 | (5) |
|
Schedule and change meetings |
|
|
502 | (7) |
|
Respond to meeting requests |
|
|
509 | (3) |
|
|
|
512 | (1) |
|
|
|
513 | (4) |
| Appendix: Define Excel tables |
|
517 | (6) |
| Index |
|
523 | |
Lisainfo e-raamatute kohta