Acknowledgments |
|
xxiii | |
About the Author |
|
xxiv | |
Introduction |
|
xxv | |
Who this book is for |
|
xxv | |
Assumptions about you |
|
xxv | |
How this book is organized |
|
xxvi | |
Errata, uspdates & book support |
|
xxvii | |
|
Part I Getting started with the Microsoft 365 apps |
|
|
|
Chapter 1 Getting oriented to the Microsoft 365 applications |
|
|
3 | (16) |
|
Introducing Microsoft 365 |
|
|
3 | (5) |
|
New features and tools in Microsoft 365 |
|
|
8 | (4) |
|
Collaborating in the cloud |
|
|
8 | (1) |
|
Collaborating with Microsoft Teams |
|
|
9 | (1) |
|
Other 365 improvements and updates |
|
|
10 | (2) |
|
The 365 suite applications |
|
|
12 | (1) |
|
The different versions of the 365 app suite |
|
|
12 | (2) |
|
Hardware and software requirements for 365 |
|
|
14 | (1) |
|
|
15 | (1) |
|
Getting Help in the 365 applications |
|
|
16 | (3) |
|
Chapter 2 Navigating and customizing the 365 interface |
|
|
19 | (30) |
|
Getting familiar with the 365 interface |
|
|
19 | (5) |
|
|
20 | (1) |
|
|
21 | (1) |
|
Overview of the 365 application window |
|
|
22 | (2) |
|
Navigating the 365 applications |
|
|
24 | (7) |
|
|
25 | (3) |
|
|
28 | (3) |
|
Customizing an application interface |
|
|
31 | (7) |
|
|
32 | (3) |
|
Customizing the Quick Access Toolbar |
|
|
35 | (2) |
|
Customizing the status bar |
|
|
37 | (1) |
|
Configuring application options |
|
|
38 | (5) |
|
Advanced Options settings |
|
|
40 | (1) |
|
|
41 | (1) |
|
Using Application add-ins |
|
|
42 | (1) |
|
|
43 | (6) |
|
|
45 | (1) |
|
|
46 | (3) |
|
Chapter 3 Managing and sharing 365 files |
|
|
49 | (20) |
|
Understanding 365 file formats |
|
|
49 | (6) |
|
Saving files as different file types |
|
|
52 | (1) |
|
Converting files to different file types |
|
|
53 | (2) |
|
Configuring save file options |
|
|
55 | (1) |
|
Creating and managing files |
|
|
56 | (7) |
|
|
59 | (1) |
|
|
60 | (1) |
|
|
61 | (1) |
|
Viewing file versions in an application |
|
|
62 | (1) |
|
|
63 | (2) |
|
|
65 | (2) |
|
Preparing a file for sharing |
|
|
67 | (2) |
|
Chapter 4 Using and creating graphics |
|
|
69 | (28) |
|
The 365 options for graphics and pictures |
|
|
69 | (12) |
|
Working with SmartArt graphics |
|
|
74 | (2) |
|
Inserting SmartArt graphics |
|
|
76 | (3) |
|
Modifying SmartArt graphics |
|
|
79 | (2) |
|
Working with your digital pictures |
|
|
81 | (7) |
|
|
82 | (1) |
|
|
83 | (3) |
|
|
86 | (1) |
|
Using the Background Removal tool |
|
|
86 | (2) |
|
Using shapes and the 365 drawing tools |
|
|
88 | (5) |
|
Adding and combining multiple shapes |
|
|
89 | (2) |
|
Using the Shape Format tools |
|
|
91 | (2) |
|
Using the screenshot tool |
|
|
93 | (1) |
|
|
94 | (3) |
|
Chapter 5 Using the 365 Online apps |
|
|
97 | (28) |
|
What the Online apps can do |
|
|
97 | (2) |
|
Where the Online apps live |
|
|
99 | (2) |
|
Saving Online application files to the cloud |
|
|
101 | (5) |
|
Saving a file to OneDrive or OneDrive for Business |
|
|
103 | (1) |
|
Sharing a file saved to the cloud |
|
|
104 | (2) |
|
Using the Word Online app |
|
|
106 | (6) |
|
The Word Online app's File tab |
|
|
107 | (2) |
|
The Word Online app's Home tab |
|
|
109 | (1) |
|
The Word Online app's Insert tab |
|
|
110 | (1) |
|
The Word Online app's Review tab |
|
|
111 | (1) |
|
The Word Online app's View tab |
|
|
112 | (1) |
|
|
112 | (5) |
|
The Excel Online app's File tab |
|
|
113 | (1) |
|
Working in the Excel Online app |
|
|
114 | (1) |
|
Inserting functions and charts in the Excel Online app |
|
|
115 | (2) |
|
|
117 | (8) |
|
|
119 | (1) |
|
Adding pictures and SmartArt |
|
|
120 | (5) |
|
|
|
Chapter 6 Essential Word features |
|
|
125 | (36) |
|
|
125 | (4) |
|
|
125 | (2) |
|
New features and improvements |
|
|
127 | (2) |
|
Options for creating a new Word document |
|
|
129 | (3) |
|
|
132 | (5) |
|
|
134 | (2) |
|
|
136 | (1) |
|
Navigating a Word document |
|
|
137 | (3) |
|
Moving around a document with the mouse |
|
|
138 | (1) |
|
Moving around a document with the keyboard |
|
|
139 | (1) |
|
|
140 | (1) |
|
Understanding document formatting |
|
|
140 | (2) |
|
Character formatting versus paragraph formatting |
|
|
141 | (1) |
|
Manual formatting versus styles and themes |
|
|
142 | (1) |
|
Working with fonts and text formatting |
|
|
142 | (4) |
|
|
143 | (3) |
|
Working with paragraph formatting |
|
|
146 | (9) |
|
Setting paragraph alignment |
|
|
147 | (1) |
|
|
148 | (2) |
|
Setting line and page breaks |
|
|
150 | (1) |
|
|
151 | (1) |
|
|
152 | (3) |
|
Page layout: margins and page options |
|
|
155 | (2) |
|
|
155 | (1) |
|
Changing page orientation and paper size |
|
|
156 | (1) |
|
|
157 | (1) |
|
|
157 | (4) |
|
Chapter 7 Enhancing Word documents |
|
|
161 | (48) |
|
Creating better documents |
|
|
161 | (1) |
|
Creating bulleted and numbered lists |
|
|
162 | (4) |
|
|
162 | (2) |
|
|
164 | (1) |
|
|
165 | (1) |
|
Working with borders and shading |
|
|
166 | (2) |
|
|
168 | (4) |
|
Creating headers and footers |
|
|
172 | (7) |
|
Inserting headers and footers |
|
|
174 | (1) |
|
The header and footer tools |
|
|
175 | (3) |
|
Working with page numbering |
|
|
178 | (1) |
|
Inserting pictures and charts |
|
|
179 | (8) |
|
|
180 | (2) |
|
Inserting stock images and online pictures |
|
|
182 | (2) |
|
|
184 | (2) |
|
Integrating text and images |
|
|
186 | (1) |
|
Changing the document display |
|
|
187 | (5) |
|
Using the navigation pane |
|
|
189 | (1) |
|
|
190 | (2) |
|
Splitting the document window |
|
|
192 | (1) |
|
|
192 | (4) |
|
|
193 | (2) |
|
|
195 | (1) |
|
|
195 | (1) |
|
|
196 | (3) |
|
Creating and inserting an AutoText entry |
|
|
196 | (1) |
|
Creating and inserting building blocks |
|
|
197 | (2) |
|
|
199 | (1) |
|
|
200 | (9) |
|
|
201 | (1) |
|
|
202 | (1) |
|
|
203 | (1) |
|
|
204 | (5) |
|
Chapter 8 Working with tables, columns, and sections |
|
|
209 | (22) |
|
Options for adding a table |
|
|
209 | (7) |
|
|
211 | (2) |
|
|
213 | (1) |
|
Converting text to a table |
|
|
214 | (1) |
|
Entering and deleting text and navigating a table |
|
|
214 | (1) |
|
Selecting and positioning a table |
|
|
215 | (1) |
|
|
216 | (8) |
|
Adjusting columns and rows |
|
|
217 | (2) |
|
|
219 | (1) |
|
|
220 | (4) |
|
|
224 | (1) |
|
|
225 | (1) |
|
Adding columns to a document |
|
|
226 | (2) |
|
|
228 | (3) |
|
Adding and removing section breaks |
|
|
228 | (2) |
|
Formatting page attributes in a section |
|
|
230 | (1) |
|
Chapter 9 Managing mailings and forms |
|
|
231 | (26) |
|
Options for mail-related documents |
|
|
231 | (1) |
|
|
232 | (2) |
|
Creating a label or labels |
|
|
234 | (2) |
|
Understanding mass mailings |
|
|
236 | (1) |
|
|
236 | (16) |
|
Using the mail merge commands |
|
|
238 | (2) |
|
Understanding recipient lists |
|
|
240 | (1) |
|
Creating a recipient list |
|
|
241 | (2) |
|
Editing and manipulating a recipient list |
|
|
243 | (2) |
|
|
245 | (3) |
|
|
248 | (1) |
|
|
249 | (1) |
|
|
250 | (1) |
|
Creating merged envelopes and labels |
|
|
251 | (1) |
|
Understanding Word fields |
|
|
252 | (2) |
|
Building a form with form controls |
|
|
254 | (3) |
|
Chapter 10 Creating special documents |
|
|
257 | (40) |
|
Options for large documents |
|
|
257 | (1) |
|
Creating a table of contents |
|
|
258 | (8) |
|
Creating a table of contents with built-in styles |
|
|
259 | (2) |
|
Creating a table of contents with your own styles |
|
|
261 | (2) |
|
Adding entries and updating the TOC |
|
|
263 | (1) |
|
Building a TOC with field codes |
|
|
264 | (2) |
|
Working with captions and tables of figures |
|
|
266 | (5) |
|
|
266 | (1) |
|
Inserting a table of figures |
|
|
267 | (2) |
|
|
269 | (2) |
|
|
271 | (3) |
|
|
271 | (1) |
|
|
272 | (2) |
|
Working with citations and bibliographies |
|
|
274 | (6) |
|
|
274 | (2) |
|
|
276 | (1) |
|
Inserting the bibliography |
|
|
277 | (1) |
|
Inserting footnotes and endnotes |
|
|
278 | (2) |
|
Tracking document changes |
|
|
280 | (7) |
|
Options for viewing changes |
|
|
283 | (1) |
|
|
284 | (1) |
|
|
285 | (2) |
|
Building a better "big" document |
|
|
287 | (3) |
|
|
288 | (1) |
|
|
289 | (1) |
|
Creating a master document |
|
|
290 | (7) |
|
|
290 | (2) |
|
Creating subdocuments from scratch |
|
|
292 | (1) |
|
Inserting existing document files into a master document outline |
|
|
293 | (1) |
|
Manipulating the master document |
|
|
294 | (3) |
|
|
|
Chapter 11 Essential Excel features |
|
|
297 | (48) |
|
|
297 | (2) |
|
Navigating the Excel workspace |
|
|
299 | (4) |
|
|
300 | (2) |
|
Moving around a worksheet |
|
|
302 | (1) |
|
Creating workbooks and worksheets |
|
|
303 | (4) |
|
Using Office.com templates |
|
|
304 | (2) |
|
Inserting and rearranging worksheets |
|
|
306 | (1) |
|
|
307 | (10) |
|
Protecting workbooks and worksheets |
|
|
310 | (1) |
|
|
311 | (2) |
|
|
313 | (2) |
|
Preparing a workbook for sharing |
|
|
315 | (2) |
|
Recovering unsaved workbooks |
|
|
317 | (1) |
|
Entering data in a worksheet |
|
|
317 | (10) |
|
|
318 | (1) |
|
|
319 | (1) |
|
|
320 | (1) |
|
Filling and entering series |
|
|
321 | (6) |
|
Copying, moving, and deleting cell contents |
|
|
327 | (6) |
|
Using the Paste Special dialog box |
|
|
329 | (2) |
|
|
331 | (1) |
|
Clearing and deleting cells |
|
|
332 | (1) |
|
|
333 | (1) |
|
|
334 | (2) |
|
|
336 | (9) |
|
Using the Page Layout commands |
|
|
337 | (2) |
|
|
339 | (1) |
|
|
339 | (1) |
|
|
340 | (1) |
|
Working on the print page |
|
|
340 | (2) |
|
Inserting headers and footers |
|
|
342 | (3) |
|
Chapter 12 Worksheet formatting and management |
|
|
345 | (38) |
|
|
345 | (4) |
|
Accessing the Format Cells dialog box |
|
|
346 | (2) |
|
Changing text orientation |
|
|
348 | (1) |
|
|
349 | (5) |
|
Using the Format Cells dialog box |
|
|
351 | (1) |
|
Creating custom number formats |
|
|
352 | (2) |
|
Adding comments and notes to cells |
|
|
354 | (3) |
|
|
354 | (1) |
|
Viewing and deleting comments |
|
|
355 | (1) |
|
Inserting and deleting notes |
|
|
356 | (1) |
|
|
357 | (1) |
|
Formatting cells using borders and color |
|
|
357 | (3) |
|
|
358 | (2) |
|
|
360 | (1) |
|
Using cell styles and the Format Painter |
|
|
360 | (3) |
|
|
361 | (1) |
|
|
362 | (1) |
|
Using conditional formatting |
|
|
363 | (6) |
|
Using highlight cell rules |
|
|
364 | (1) |
|
|
365 | (1) |
|
|
365 | (1) |
|
|
366 | (1) |
|
|
367 | (1) |
|
Creating and copying conditional formatting rules |
|
|
367 | (2) |
|
Manipulating cells and cell content |
|
|
369 | (4) |
|
|
369 | (1) |
|
Merging cells and wrapping text |
|
|
370 | (1) |
|
Finding and replacing cell items |
|
|
371 | (2) |
|
Working with columns and rows |
|
|
373 | (2) |
|
Changing column width and row height |
|
|
373 | (1) |
|
Inserting columns and rows |
|
|
374 | (1) |
|
Deleting columns and rows |
|
|
375 | (1) |
|
|
375 | (1) |
|
|
375 | (3) |
|
Freezing rows and columns |
|
|
375 | (2) |
|
|
377 | (1) |
|
|
377 | (1) |
|
|
378 | (3) |
|
Creating range names from selections |
|
|
379 | (1) |
|
|
380 | (1) |
|
Adding images and graphics to worksheets |
|
|
381 | (2) |
|
Chapter 13 Getting the most from formulas and functions |
|
|
383 | (40) |
|
Performing calculations in Excel worksheets |
|
|
383 | (2) |
|
Relative versus absolute referencing |
|
|
385 | (4) |
|
Creating and editing formulas |
|
|
389 | (3) |
|
Understanding operator precedence |
|
|
390 | (1) |
|
|
391 | (1) |
|
|
391 | (1) |
|
Working with Excel functions |
|
|
392 | (1) |
|
Entering a function in a cell |
|
|
393 | (6) |
|
|
394 | (1) |
|
Using the status bar statistical functions |
|
|
395 | (1) |
|
Using the Insert Function dialog box |
|
|
396 | (1) |
|
Using the Function Library |
|
|
397 | (2) |
|
Using range names in formulas and functions |
|
|
399 | (3) |
|
Inserting a range name into a formula |
|
|
400 | (1) |
|
Inserting a range name into a function |
|
|
401 | (1) |
|
Referencing cells or ranges on other worksheets |
|
|
402 | (2) |
|
Copying and moving formulas and functions |
|
|
404 | (1) |
|
Choosing the right function |
|
|
405 | (12) |
|
|
405 | (2) |
|
|
407 | (2) |
|
|
409 | (1) |
|
Lookup & Reference functions |
|
|
410 | (4) |
|
|
414 | (1) |
|
|
414 | (2) |
|
Other function categories |
|
|
416 | (1) |
|
Proofing your formulas and functions |
|
|
417 | (6) |
|
|
417 | (2) |
|
|
419 | (1) |
|
|
420 | (3) |
|
Chapter 14 Enhancing worksheets with charts |
|
|
423 | (38) |
|
Understanding Excel charts |
|
|
423 | (12) |
|
|
424 | (3) |
|
Using different chart types |
|
|
427 | (8) |
|
|
435 | (6) |
|
Inserting a chart from the ribbon |
|
|
436 | (1) |
|
Selecting a recommended chart |
|
|
437 | (1) |
|
Inserting charts with the Quick Analysis gallery |
|
|
438 | (1) |
|
Tools for quickly customizing a chart |
|
|
439 | (1) |
|
Moving, copying, or deleting a chart |
|
|
440 | (1) |
|
|
441 | (3) |
|
Changing chart type or chart data |
|
|
441 | (2) |
|
Selecting chart layouts and styles |
|
|
443 | (1) |
|
Working with chart elements |
|
|
444 | (10) |
|
Modifying titles and data labels |
|
|
447 | (1) |
|
Working with the legend and data points |
|
|
447 | (2) |
|
Manipulating axes and gridlines |
|
|
449 | (1) |
|
Adding trendlines, drop lines, and bars to a chart |
|
|
450 | (4) |
|
Creating a combination chart |
|
|
454 | (7) |
|
Working with a pie of pie chart |
|
|
455 | (1) |
|
Creating a custom combination chart |
|
|
455 | (2) |
|
|
457 | (1) |
|
|
457 | (2) |
|
|
459 | (2) |
|
Chapter 15 Using Excel tables and pivot tables |
|
|
461 | (42) |
|
|
461 | (2) |
|
|
463 | (1) |
|
Creating a table using styles |
|
|
464 | (1) |
|
Using the Table Design Tools |
|
|
465 | (2) |
|
|
467 | (3) |
|
|
468 | (1) |
|
Using the Sort dialog box |
|
|
468 | (2) |
|
|
470 | (9) |
|
Using the AutoFilter Search box |
|
|
471 | (1) |
|
Creating custom AutoFilters |
|
|
471 | (3) |
|
Filtering tables with slicers |
|
|
474 | (1) |
|
Creating advanced filters |
|
|
475 | (3) |
|
Creating custom sheet views |
|
|
478 | (1) |
|
|
479 | (1) |
|
Creating outlines and subtotals |
|
|
480 | (4) |
|
Working with external data |
|
|
484 | (4) |
|
Importing data from Access |
|
|
484 | (2) |
|
|
486 | (1) |
|
|
486 | (2) |
|
Connecting to other data sources |
|
|
488 | (6) |
|
|
490 | (3) |
|
Viewing and refreshing connections |
|
|
493 | (1) |
|
Working with pivot tables |
|
|
494 | (9) |
|
Using the Recommended PivotTables command |
|
|
496 | (1) |
|
|
497 | (3) |
|
Working with the pivot table tools |
|
|
500 | (2) |
|
|
502 | (1) |
|
Chapter 16 Validating and analyzing worksheet data |
|
|
503 | (26) |
|
Taking advantage of data validation |
|
|
503 | (7) |
|
Specifying validation criteria |
|
|
504 | (2) |
|
Configuring input messages and error alerts |
|
|
506 | (2) |
|
|
508 | (2) |
|
Performing a what-if analysis |
|
|
510 | (8) |
|
|
511 | (2) |
|
|
513 | (3) |
|
Viewing scenarios and creating reports |
|
|
516 | (2) |
|
Using Goal Seek, Solver, and Forecast Sheet |
|
|
518 | (11) |
|
|
518 | (1) |
|
|
519 | (4) |
|
Creating a Forecast Sheet |
|
|
523 | (6) |
|
|
|
Chapter 17 Essential PowerPoint features |
|
|
529 | (26) |
|
|
529 | (1) |
|
Options for creating a new presentation |
|
|
530 | (7) |
|
|
532 | (3) |
|
Using a theme to create a new presentation |
|
|
535 | (1) |
|
Creating a presentation from an existing presentation |
|
|
535 | (1) |
|
Inserting slides from the Reuse Slides task pane |
|
|
536 | (1) |
|
|
537 | (3) |
|
|
540 | (3) |
|
|
541 | (1) |
|
Inserting slides from a Word outline |
|
|
542 | (1) |
|
Inserting other object content |
|
|
542 | (1) |
|
Modifying a slide's layout |
|
|
543 | (1) |
|
Working with slides in different views |
|
|
543 | (5) |
|
|
545 | (1) |
|
Rulers, gridlines, and guides |
|
|
546 | (1) |
|
|
547 | (1) |
|
Opening a new presentation window |
|
|
548 | (1) |
|
Rearranging and deleting slides |
|
|
549 | (1) |
|
|
549 | (2) |
|
|
551 | (1) |
|
Viewing a presentation during editing |
|
|
552 | (3) |
|
Chapter 18 Advanced presentation formatting, themes, and masters |
|
|
555 | (30) |
|
Working with text boxes and formatting |
|
|
555 | (11) |
|
|
556 | (1) |
|
|
557 | (2) |
|
Formatting a text box with the Shape Format tools |
|
|
559 | (1) |
|
Selecting quick styles and shape attributes |
|
|
559 | (1) |
|
Shape fill, outline, and effects |
|
|
559 | (4) |
|
Using WordArt styles and text settings |
|
|
563 | (3) |
|
|
566 | (4) |
|
Inserting a table on an existing slide |
|
|
566 | (1) |
|
|
567 | (1) |
|
|
567 | (3) |
|
|
570 | (6) |
|
|
571 | (1) |
|
|
571 | (4) |
|
|
575 | (1) |
|
Using headers and footers |
|
|
576 | (1) |
|
|
577 | (2) |
|
Altering and creating master slides |
|
|
579 | (2) |
|
|
581 | (1) |
|
|
582 | (3) |
|
Chapter 19 Better slides with pictures, objects, and SmartArt |
|
|
585 | (26) |
|
Using graphics to enhance slides |
|
|
585 | (2) |
|
|
587 | (2) |
|
Adding stock images to slides |
|
|
589 | (2) |
|
|
591 | (2) |
|
Adjusting picture settings |
|
|
592 | (1) |
|
Configuring album layout settings |
|
|
592 | (1) |
|
|
593 | (2) |
|
|
595 | (1) |
|
|
596 | (6) |
|
Inserting a SmartArt graphic |
|
|
599 | (1) |
|
Converting text to a SmartArt graphic |
|
|
600 | (1) |
|
|
600 | (2) |
|
|
602 | (4) |
|
Inserting a chart onto a slide |
|
|
602 | (2) |
|
Modifying and formatting a chart |
|
|
604 | (2) |
|
Working with slide objects |
|
|
606 | (2) |
|
|
607 | (1) |
|
|
607 | (1) |
|
Adding hyperlinks to slides |
|
|
608 | (1) |
|
Using PowerPoint Designer |
|
|
609 | (2) |
|
Chapter 20 Enhancing slides with animation, transitions, and multimedia |
|
|
611 | (30) |
|
Animations versus transitions |
|
|
611 | (3) |
|
Assigning animation to a slide object |
|
|
614 | (8) |
|
Accessing additional animation effects |
|
|
615 | (1) |
|
|
616 | (1) |
|
|
617 | (1) |
|
|
618 | (3) |
|
Creating a custom motion path |
|
|
621 | (1) |
|
Advanced animation techniques |
|
|
622 | (6) |
|
|
623 | (1) |
|
Adding additional animations |
|
|
624 | (1) |
|
Using the animation painter |
|
|
625 | (1) |
|
Including sound effects with animations |
|
|
625 | (2) |
|
Setting timings for animations |
|
|
627 | (1) |
|
Managing slide animations |
|
|
628 | (2) |
|
Adding transitions to slides |
|
|
630 | (4) |
|
|
631 | (1) |
|
Using the Morph transition |
|
|
632 | (2) |
|
|
634 | (1) |
|
|
635 | (1) |
|
The trim audio dialog box |
|
|
636 | (1) |
|
|
636 | (5) |
|
|
636 | (3) |
|
|
639 | (1) |
|
Modifying your video clips |
|
|
640 | (1) |
|
Chapter 21 Delivering a presentation and creating support materials |
|
|
641 | (28) |
|
Planning your presentation |
|
|
641 | (1) |
|
Checking the presentation for spelling and grammar errors |
|
|
642 | (2) |
|
Running through a completed presentation |
|
|
644 | (1) |
|
Using the presenter coach S |
|
|
645 | (1) |
|
|
646 | (2) |
|
|
648 | (1) |
|
Creating a custom slide show |
|
|
649 | (3) |
|
Creating a self-running presentation |
|
|
652 | (4) |
|
|
652 | (2) |
|
|
654 | (1) |
|
|
654 | (2) |
|
Creating an interactive presentation |
|
|
656 | (3) |
|
Working with the notes and handout masters |
|
|
659 | (2) |
|
Setting handout master options |
|
|
659 | (2) |
|
Setting notes master options |
|
|
661 | (1) |
|
Printing presentations, notes, and handouts |
|
|
661 | (2) |
|
|
663 | (2) |
|
Sharing your presentation |
|
|
665 | (4) |
|
|
|
Chapter 22 Outlook configuration and essential features |
|
|
669 | (32) |
|
|
669 | (1) |
|
Outlook and email accounts |
|
|
670 | (3) |
|
|
671 | (1) |
|
|
672 | (1) |
|
|
672 | (1) |
|
Configuring Outlook at first start |
|
|
673 | (1) |
|
Adding email accounts to Outlook |
|
|
674 | (3) |
|
Understanding Outlook profiles |
|
|
677 | (4) |
|
|
678 | (1) |
|
|
679 | (2) |
|
|
681 | (1) |
|
Understanding Outlook data files |
|
|
681 | (6) |
|
Configuring Outlook for Microsoft Exchange Server |
|
|
682 | (2) |
|
Creating personal folders files |
|
|
684 | (1) |
|
Repairing Outlook data files |
|
|
685 | (2) |
|
Importing and exporting data |
|
|
687 | (2) |
|
|
687 | (2) |
|
|
689 | (1) |
|
Navigating the Outlook workspace |
|
|
689 | (3) |
|
Accessing Outlook items using the Navigation bar |
|
|
691 | (1) |
|
Working with views in Outlook |
|
|
692 | (3) |
|
Categorizing Outlook items |
|
|
695 | (1) |
|
Searching for Outlook items |
|
|
696 | (2) |
|
|
697 | (1) |
|
|
697 | (1) |
|
|
698 | (3) |
|
Chapter 23 Managing email in Outlook |
|
|
701 | (38) |
|
Working in the Outlook window |
|
|
701 | (3) |
|
Creating an email message |
|
|
704 | (2) |
|
Using the Outlook Address Book |
|
|
706 | (2) |
|
|
708 | (7) |
|
|
708 | (1) |
|
Setting message flags, importance, and sensitivity |
|
|
709 | (2) |
|
Configuring voting buttons, receipts, and delivery options |
|
|
711 | (2) |
|
The Message Properties dialog box |
|
|
713 | (2) |
|
Attaching files and items to a message |
|
|
715 | (3) |
|
Attaching a business card |
|
|
716 | (1) |
|
|
717 | (1) |
|
Using themes and email stationery |
|
|
718 | (1) |
|
|
719 | (1) |
|
|
720 | (1) |
|
|
720 | (1) |
|
Working with received email |
|
|
721 | (3) |
|
Organizing messages in the Inbox |
|
|
722 | (1) |
|
Showing messages as conversations |
|
|
723 | (1) |
|
|
724 | (1) |
|
|
724 | (8) |
|
|
725 | (2) |
|
|
727 | (1) |
|
|
728 | (1) |
|
|
728 | (1) |
|
|
729 | (1) |
|
|
729 | (2) |
|
|
731 | (1) |
|
|
731 | (1) |
|
|
732 | (4) |
|
Editing email account settings |
|
|
734 | (1) |
|
Adding an email account automatically |
|
|
735 | (1) |
|
Adding a mail account manually |
|
|
735 | (1) |
|
Setting Outlook mail options |
|
|
736 | (3) |
|
Chapter 24 Using the calendar for appointments and tasks |
|
|
739 | (30) |
|
|
739 | (4) |
|
Changing the calendar view |
|
|
741 | (1) |
|
Change the time scale and time zone |
|
|
742 | (1) |
|
Scheduling an appointment |
|
|
743 | (5) |
|
Scheduling a recurring appointment |
|
|
745 | (1) |
|
|
745 | (2) |
|
Editing and managing appointments |
|
|
747 | (1) |
|
|
748 | (2) |
|
|
750 | (8) |
|
Creating a calendar share invitation |
|
|
750 | (2) |
|
Opening a shared calendar |
|
|
752 | (1) |
|
Viewing multiple calendars |
|
|
752 | (2) |
|
|
754 | (1) |
|
|
754 | (1) |
|
Publishing a calendar online |
|
|
755 | (2) |
|
|
757 | (1) |
|
|
758 | (2) |
|
|
760 | (9) |
|
Creating a new task from the Tasks folder |
|
|
761 | (1) |
|
Creating a recurring task |
|
|
761 | (1) |
|
Assigning and accepting tasks |
|
|
762 | (1) |
|
Viewing and managing tasks |
|
|
763 | (3) |
|
|
766 | (1) |
|
|
767 | (2) |
|
Chapter 25 Working with contacts and planning meetings |
|
|
769 | (28) |
|
Navigating the Contacts list |
|
|
769 | (3) |
|
|
772 | (4) |
|
|
774 | (1) |
|
Adding fields for a contact |
|
|
775 | (1) |
|
Editing contact information |
|
|
776 | (4) |
|
|
777 | (2) |
|
Tagging contacts with flags and categories |
|
|
779 | (1) |
|
Mapping a contact's address |
|
|
780 | (1) |
|
Searching the Contacts folder |
|
|
780 | (1) |
|
Organizing contacts with groups |
|
|
781 | (1) |
|
Forwarding and sharing contacts |
|
|
782 | (3) |
|
|
783 | (1) |
|
|
784 | (1) |
|
Communicating with contacts |
|
|
785 | (2) |
|
|
787 | (1) |
|
Printing contact information |
|
|
788 | (1) |
|
|
788 | (1) |
|
|
789 | (4) |
|
Selecting the meeting location |
|
|
790 | (1) |
|
Using the Scheduling Assistant |
|
|
791 | (1) |
|
Viewing and editing meeting information |
|
|
792 | (1) |
|
Responding to meeting requests |
|
|
793 | (4) |
|
Chapter 26 Securing and maintaining Outlook |
|
|
797 | (32) |
|
|
797 | (4) |
|
Malware and antivirus software |
|
|
798 | (1) |
|
Strong password protection |
|
|
799 | (2) |
|
Configuring Outlook security settings |
|
|
801 | (3) |
|
Encrypting email and using digital signatures |
|
|
804 | (2) |
|
Options for encrypting email |
|
|
805 | (1) |
|
|
806 | (1) |
|
|
806 | (1) |
|
Dealing with message attachments |
|
|
807 | (3) |
|
|
810 | (3) |
|
Working with the junk email commands |
|
|
810 | (2) |
|
Setting junk email options |
|
|
812 | (1) |
|
|
813 | (5) |
|
Creating a quick rule for a specific sender |
|
|
814 | (1) |
|
|
815 | (1) |
|
|
816 | (2) |
|
|
818 | (6) |
|
|
819 | (1) |
|
Configuring AutoArchive settings |
|
|
820 | (1) |
|
Setting AutoArchive options for a folder |
|
|
821 | (1) |
|
|
822 | (2) |
|
Configuring an autoreply message |
|
|
824 | (5) |
|
|
|
Chapter 27 Essential Publisher features |
|
|
829 | (32) |
|
|
829 | (1) |
|
Planning your publication |
|
|
830 | (1) |
|
Working with publication templates |
|
|
831 | (2) |
|
Creating a new publication |
|
|
833 | (8) |
|
|
833 | (1) |
|
|
834 | (1) |
|
|
835 | (1) |
|
Navigating the Publisher workspace |
|
|
836 | (1) |
|
Using the rulers and guides |
|
|
837 | (3) |
|
Options for viewing the publication |
|
|
840 | (1) |
|
Creating a business information set |
|
|
841 | (2) |
|
Creating a new business information set |
|
|
841 | (1) |
|
Creating additional business information sets |
|
|
842 | (1) |
|
|
843 | (9) |
|
Editing text in a text box |
|
|
844 | (1) |
|
Creating your own text boxes |
|
|
844 | (1) |
|
|
844 | (5) |
|
|
849 | (2) |
|
|
851 | (1) |
|
|
852 | (5) |
|
Options for inserting pictures |
|
|
852 | (3) |
|
|
855 | (1) |
|
|
856 | (1) |
|
|
857 | (1) |
|
|
857 | (1) |
|
|
858 | (3) |
|
Chapter 28 Advanced Publisher features |
|
|
861 | (26) |
|
Adding pages to a publication |
|
|
861 | (2) |
|
Configuring page settings |
|
|
863 | (3) |
|
Changing the current template |
|
|
866 | (2) |
|
Working with master pages |
|
|
868 | (4) |
|
Placing objects on the master page |
|
|
869 | (1) |
|
Inserting headers and footers |
|
|
870 | (1) |
|
|
871 | (1) |
|
Using tables in publications |
|
|
872 | (2) |
|
|
872 | (1) |
|
|
873 | (1) |
|
Manipulating publication objects |
|
|
874 | (3) |
|
|
875 | (1) |
|
|
876 | (1) |
|
|
876 | (1) |
|
Merging data into a publication |
|
|
877 | (5) |
|
|
877 | (3) |
|
Performing a catalog merge |
|
|
880 | (2) |
|
Fine-tuning your publications |
|
|
882 | (5) |
|
|
882 | (1) |
|
|
882 | (1) |
|
|
883 | (4) |
|
|
|
Appendix A Microsoft 365 Application integration |
|
|
887 | (16) |
|
|
887 | (1) |
|
Understanding object linking and embedding |
|
|
888 | (3) |
|
Choosing between linking and embedding |
|
|
890 | (1) |
|
|
891 | (4) |
|
Linking with Paste Special |
|
|
891 | (2) |
|
Linking with the Paste Options gallery |
|
|
893 | (1) |
|
Linking using the Object command |
|
|
894 | (1) |
|
Updating and breaking links |
|
|
895 | (3) |
|
|
897 | (1) |
|
|
898 | (3) |
|
Embedding with Paste Special |
|
|
899 | (1) |
|
Embedding using the Object command |
|
|
899 | (1) |
|
|
900 | (1) |
|
|
901 | (1) |
|
Sharing data with Outlook using actions |
|
|
901 | (2) |
|
Appendix B Microsoft 365 macros |
|
|
903 | (20) |
|
|
903 | (5) |
|
Adding the Developer tab to the ribbon |
|
|
904 | (1) |
|
Enabling macros in the Trust Center |
|
|
905 | (2) |
|
Creating macro-enabled Office files |
|
|
907 | (1) |
|
|
908 | (2) |
|
|
910 | (4) |
|
|
911 | (1) |
|
Assigning a macro button to the Quick Access Toolbar |
|
|
912 | (2) |
|
|
914 | (1) |
|
|
914 | (3) |
|
|
915 | (1) |
|
|
916 | (1) |
|
|
917 | (6) |
Index |
|
923 | |