Introduction |
|
1 | (4) |
|
What Makes This Book Different |
|
|
2 | (1) |
|
|
3 | (1) |
|
Conventions Used in This Book |
|
|
3 | (1) |
|
|
4 | (1) |
|
|
4 | (1) |
Book 1: Common Office Tasks |
|
5 | (50) |
|
Chapter 1 Office Nuts and Bolts |
|
|
7 | (20) |
|
A Survey of Office Applications |
|
|
7 | (2) |
|
|
9 | (2) |
|
Finding Your Way Around the Office Interface |
|
|
11 | (7) |
|
The File tab and Backstage |
|
|
11 | (1) |
|
|
12 | (1) |
|
|
12 | (2) |
|
|
14 | (1) |
|
|
14 | (2) |
|
Mini-toolbars and shortcut menus |
|
|
16 | (1) |
|
Office 2019 for keyboard lovers |
|
|
16 | (2) |
|
|
18 | (1) |
|
|
18 | (1) |
|
Saving a file for the first time |
|
|
18 | (1) |
|
Saving AutoRecovery information |
|
|
18 | (1) |
|
Navigating the Save As and Open Windows |
|
|
19 | (2) |
|
Opening and Closing Files |
|
|
21 | (1) |
|
|
21 | (1) |
|
|
21 | (1) |
|
Reading and Recording File Properties |
|
|
22 | (1) |
|
Locking a File with a Password |
|
|
23 | (1) |
|
Password-protecting a file |
|
|
23 | (1) |
|
Removing a password from a file |
|
|
24 | (1) |
|
Trusting (or not Trusting) Microsoft with Your "Content" |
|
|
24 | (3) |
|
Chapter 2 Wrestling with the Text |
|
|
27 | (20) |
|
|
27 | (3) |
|
|
28 | (1) |
|
|
28 | (1) |
|
Taking advantage of the Clipboard task pane |
|
|
29 | (1) |
|
|
30 | (1) |
|
Speaking, not Typing, the Words |
|
|
30 | (2) |
|
Changing the Look of Text |
|
|
32 | (7) |
|
|
32 | (2) |
|
Changing the font size of text |
|
|
34 | (2) |
|
Applying font styles to text |
|
|
36 | (1) |
|
Applying text effects to text |
|
|
37 | (1) |
|
|
38 | (1) |
|
Changing the color of text |
|
|
38 | (1) |
|
Quick Ways to Handle Case, or Capitalization |
|
|
39 | (2) |
|
Entering Symbols and Foreign Characters |
|
|
41 | (1) |
|
|
42 | (5) |
|
Linking a hyperlink to a web page |
|
|
42 | (2) |
|
Creating a hyperlink to another place in your file |
|
|
44 | (1) |
|
Creating an email hyperlink |
|
|
45 | (1) |
|
Repairing and removing hyperlinks |
|
|
46 | (1) |
|
Chapter 3 Speed Techniques Worth Knowing About |
|
|
47 | (8) |
|
Undoing and Repeating Commands |
|
|
47 | (2) |
|
|
48 | (1) |
|
Repeating an action - and quicker this time |
|
|
48 | (1) |
|
|
49 | (1) |
|
Viewing a File Through More Than One Window |
|
|
50 | (1) |
|
Correcting Typos on the Fly |
|
|
51 | (1) |
|
Entering Text Quickly with the AutoCorrect Command |
|
|
52 | (3) |
Book 2: Word 2019 |
|
55 | (178) |
|
Chapter 1 Speed Techniques for Using Word |
|
|
57 | (20) |
|
Introducing the Word Screen |
|
|
57 | (2) |
|
|
59 | (2) |
|
Getting a Better Look at Your Documents |
|
|
61 | (5) |
|
Viewing documents in different ways |
|
|
62 | (2) |
|
|
64 | (2) |
|
Selecting Text in Speedy Ways |
|
|
66 | (1) |
|
Moving Around Quickly in Documents |
|
|
67 | (4) |
|
Keys for getting around quickly |
|
|
67 | (1) |
|
Navigating from page to page or heading to heading |
|
|
68 | (1) |
|
Going there fast with the Go To command |
|
|
69 | (1) |
|
Bookmarks for hopping around |
|
|
70 | (1) |
|
Inserting a Whole File into a Document |
|
|
71 | (1) |
|
|
72 | (1) |
|
Entering Information Quickly in a Computerized Form |
|
|
72 | (5) |
|
Creating a computerized form |
|
|
73 | (2) |
|
Entering data in the form |
|
|
75 | (2) |
|
Chapter 2 Laying Out Text and Pages |
|
|
77 | (28) |
|
Paragraphs and Formatting |
|
|
77 | (1) |
|
Inserting a Section Break for Formatting Purposes |
|
|
78 | (3) |
|
|
81 | (1) |
|
|
81 | (1) |
|
Setting Up and Changing the Margins |
|
|
82 | (2) |
|
Indenting Paragraphs and First Lines |
|
|
84 | (2) |
|
Clicking an Indent button (for left-indents) |
|
|
84 | (1) |
|
"Eyeballing" it with the ruler |
|
|
84 | (2) |
|
Indenting in the Paragraph dialog box |
|
|
86 | (1) |
|
|
86 | (3) |
|
Numbering with page numbers only |
|
|
87 | (1) |
|
Including a page number in a header or footer |
|
|
88 | (1) |
|
Changing page number formats |
|
|
88 | (1) |
|
Putting Headers and Footers on Pages |
|
|
89 | (4) |
|
Creating, editing, and removing headers and footers |
|
|
91 | (1) |
|
Fine-tuning a header or footer |
|
|
92 | (1) |
|
Adjusting the Space Between Lines |
|
|
93 | (2) |
|
Adjusting the Space Between Paragraphs |
|
|
95 | (1) |
|
Creating Numbered and Bulleted Lists |
|
|
96 | (3) |
|
Simple numbered and bulleted lists |
|
|
96 | (1) |
|
Constructing lists of your own |
|
|
97 | (1) |
|
Managing a multilevel list |
|
|
98 | (1) |
|
|
99 | (2) |
|
|
101 | (4) |
|
Automatically and manually hyphenating a document |
|
|
102 | (1) |
|
Unhyphenating and other hyphenation tasks |
|
|
102 | (3) |
|
|
105 | (18) |
|
|
105 | (2) |
|
|
106 | (1) |
|
|
106 | (1) |
|
Applying Styles to Text and Paragraphs |
|
|
107 | (5) |
|
|
107 | (2) |
|
Experimenting with style sets |
|
|
109 | (1) |
|
Choosing which style names appear on the Style menus |
|
|
109 | (3) |
|
|
112 | (2) |
|
Creating a style from a paragraph |
|
|
112 | (1) |
|
Creating a style from the ground up |
|
|
113 | (1) |
|
|
114 | (2) |
|
Creating and Managing Templates |
|
|
116 | (7) |
|
|
116 | (4) |
|
Opening a template so that you can modify it |
|
|
120 | (1) |
|
Modifying, deleting, and renaming styles in templates |
|
|
121 | (2) |
|
Chapter 4 Constructing the Perfect Table |
|
|
123 | (24) |
|
|
124 | (1) |
|
|
124 | (3) |
|
Entering the Text and Numbers |
|
|
127 | (1) |
|
Selecting Different Parts of a Table |
|
|
128 | (1) |
|
|
128 | (5) |
|
Changing the size of a table, columns, and rows |
|
|
128 | (1) |
|
Adjusting column and row size |
|
|
129 | (1) |
|
Inserting columns and rows |
|
|
130 | (1) |
|
Deleting columns and rows |
|
|
131 | (2) |
|
|
133 | (1) |
|
Aligning Text in Columns and Rows |
|
|
133 | (1) |
|
Merging and Splitting Cells |
|
|
134 | (1) |
|
Repeating Header Rows on Subsequent Pages |
|
|
135 | (2) |
|
|
137 | (3) |
|
Designing a table with a table style |
|
|
137 | (1) |
|
Calling attention to different rows and columns |
|
|
138 | (1) |
|
Decorating your table with borders and colors |
|
|
139 | (1) |
|
Using Math Formulas in Tables |
|
|
140 | (1) |
|
|
141 | (6) |
|
Changing the direction of header row text |
|
|
141 | (1) |
|
Wrapping text around a table |
|
|
142 | (1) |
|
Using a picture as the table background |
|
|
143 | (2) |
|
Drawing diagonal lines on tables |
|
|
145 | (1) |
|
|
145 | (2) |
|
Chapter 5 Taking Advantage of the Proofing Tools |
|
|
147 | (20) |
|
Correcting Your Spelling Errors |
|
|
148 | (3) |
|
Correcting misspellings one at a time |
|
|
148 | (1) |
|
|
149 | (2) |
|
Preventing text from being spell checked |
|
|
151 | (1) |
|
Correcting Grammatical Errors |
|
|
151 | (2) |
|
Finding and Replacing Text |
|
|
153 | (8) |
|
The basics: Finding stray words and phrases |
|
|
153 | (1) |
|
|
154 | (5) |
|
Conducting a find-and-replace operation |
|
|
159 | (2) |
|
Finding the Right Word with the Thesaurus |
|
|
161 | (1) |
|
Proofing Text Written in a Foreign Language |
|
|
162 | (2) |
|
Telling Office which languages you will use |
|
|
163 | (1) |
|
Marking text as foreign language text |
|
|
163 | (1) |
|
Translating Foreign Language Text |
|
|
164 | (3) |
|
Chapter 6 Desktop Publishing with Word |
|
|
167 | (20) |
|
Experimenting with Themes |
|
|
167 | (1) |
|
|
168 | (3) |
|
Decorating a page with a border |
|
|
169 | (1) |
|
Putting a background color on pages |
|
|
170 | (1) |
|
Getting Word's help with cover letters |
|
|
170 | (1) |
|
Making Use of Charts, Diagrams, Shapes, and Photos |
|
|
171 | (1) |
|
Working with the Drawing Canvas |
|
|
172 | (1) |
|
Positioning and Wrapping Objects Relative to the Page and Text |
|
|
173 | (4) |
|
Wrapping text around an object |
|
|
174 | (1) |
|
Positioning an object on a page |
|
|
175 | (2) |
|
|
177 | (2) |
|
|
178 | (1) |
|
Making text flow from text box to text box |
|
|
178 | (1) |
|
|
179 | (1) |
|
Watermarking for the Elegant Effect |
|
|
180 | (1) |
|
Putting Newspaper-Style Columns in a Document |
|
|
181 | (2) |
|
Doing the preliminary work |
|
|
181 | (1) |
|
Running text into columns |
|
|
182 | (1) |
|
|
183 | (1) |
|
Printing on Different Size Paper |
|
|
184 | (1) |
|
Showing Online Video in a Document |
|
|
184 | (3) |
|
Chapter 7 Getting Word's Help with Office Chores |
|
|
187 | (22) |
|
Highlighting Parts of a Document |
|
|
187 | (1) |
|
|
188 | (4) |
|
|
188 | (2) |
|
Viewing and displaying comments |
|
|
190 | (1) |
|
Caring for and feeding comments |
|
|
190 | (2) |
|
Tracking Changes to Documents |
|
|
192 | (5) |
|
Telling Word to start marking changes |
|
|
193 | (1) |
|
Reading and reviewing a document with change marks |
|
|
193 | (1) |
|
Marking changes when you forgot to turn on change marks |
|
|
194 | (2) |
|
Accepting and rejecting changes to a document |
|
|
196 | (1) |
|
Printing an Address on an Envelope |
|
|
197 | (2) |
|
Printing a Single Address Label (Or a Page of the Same Label) |
|
|
199 | (1) |
|
Churning Out Letters, Envelopes, and Labels for Mass Mailings |
|
|
200 | (9) |
|
Preparing the source file |
|
|
201 | (1) |
|
Merging the document with the source file |
|
|
202 | (4) |
|
Printing form letters, envelopes, and labels |
|
|
206 | (3) |
|
Chapter 8 Tools for Reports and Scholarly Papers |
|
|
209 | (24) |
|
|
209 | (1) |
|
Outlines for Organizing Your Work |
|
|
210 | (2) |
|
Viewing the outline in different ways |
|
|
210 | (2) |
|
Rearranging document sections in Outline view |
|
|
212 | (1) |
|
Collapsing and Expanding Parts of a Document |
|
|
212 | (1) |
|
Generating a Table of Contents |
|
|
213 | (5) |
|
|
214 | (1) |
|
Updating and removing a TOC |
|
|
214 | (1) |
|
|
214 | (2) |
|
Changing the structure of a TOC |
|
|
216 | (2) |
|
|
218 | (4) |
|
Marking index items in the document |
|
|
218 | (2) |
|
|
220 | (2) |
|
|
222 | (1) |
|
Putting Cross-References in a Document |
|
|
222 | (3) |
|
Putting Footnotes and Endnotes in Documents |
|
|
225 | (2) |
|
Entering a footnote or endnote |
|
|
225 | (1) |
|
Choosing the numbering scheme and position of notes |
|
|
226 | (1) |
|
Deleting, moving, and editing notes |
|
|
227 | (1) |
|
|
227 | (8) |
|
Inserting a citation for your bibliography |
|
|
228 | (2) |
|
|
230 | (1) |
|
Changing how' citations appear in text |
|
|
230 | (1) |
|
Generating the bibliography |
|
|
230 | (3) |
Book 3: Excel 2019 |
|
233 | (102) |
|
Chapter 1 Up and Running with Excel |
|
|
235 | (18) |
|
Creating a New Excel Workbook |
|
|
235 | (2) |
|
Getting Acquainted with Excel |
|
|
237 | (2) |
|
Rows, columns, and cell addresses |
|
|
239 | (1) |
|
|
239 | (1) |
|
Entering Data in a Worksheet |
|
|
239 | (6) |
|
The basics of entering data |
|
|
239 | (2) |
|
|
241 | (1) |
|
|
241 | (1) |
|
Entering date and time values |
|
|
242 | (3) |
|
Quickly Entering Lists and Serial Data with the AutoFill Command |
|
|
245 | (3) |
|
Formatting Numbers, Dates, and Time Values |
|
|
248 | (1) |
|
Establishing Data-Validation Rules |
|
|
249 | (4) |
|
Chapter 2 Refining Your Worksheet |
|
|
253 | (14) |
|
|
253 | (1) |
|
Moving Around in a Worksheet |
|
|
254 | (1) |
|
Getting a Better Look at the Worksheet |
|
|
255 | (3) |
|
Freezing and splitting columns and rows |
|
|
255 | (2) |
|
|
257 | (1) |
|
Comments for Documenting Your Worksheet |
|
|
258 | (2) |
|
Selecting Cells in a Worksheet |
|
|
260 | (1) |
|
Deleting, Copying, and Moving Data |
|
|
261 | (1) |
|
Handling the Worksheets in a Workbook |
|
|
261 | (3) |
|
Keeping Others from Tampering with Worksheets |
|
|
264 | (3) |
|
|
264 | (1) |
|
|
264 | (3) |
|
Chapter 3 Formulas and Functions for Crunching Numbers |
|
|
267 | (32) |
|
|
267 | (6) |
|
Referring to cells in formulas |
|
|
268 | (2) |
|
Referring to formula results in formulas |
|
|
270 | (1) |
|
|
271 | (2) |
|
The Basics of Entering a Formula |
|
|
273 | (1) |
|
Speed Techniques for Entering Formulas |
|
|
273 | (6) |
|
Clicking cells to enter cell references |
|
|
273 | (1) |
|
|
274 | (1) |
|
Naming cell ranges so that you can use them in formulas |
|
|
275 | (3) |
|
Referring to cells in different worksheets |
|
|
278 | (1) |
|
Copying Formulas from Cell to Cell |
|
|
279 | (2) |
|
Detecting and Correcting Errors in Formulas |
|
|
281 | (3) |
|
Correcting errors one at a time |
|
|
281 | (1) |
|
Running the error checker |
|
|
282 | (1) |
|
|
283 | (1) |
|
|
284 | (5) |
|
Using arguments in functions |
|
|
285 | (1) |
|
Entering a function in a formula |
|
|
285 | (4) |
|
A Look at Some Very Useful Functions |
|
|
289 | (10) |
|
AVERAGE for averaging data |
|
|
289 | (1) |
|
COUNT and COUNTIF for tabulating data items |
|
|
290 | (1) |
|
CONCATENATE for combining values |
|
|
291 | (1) |
|
PMT for calculating how much you can borrow |
|
|
292 | (2) |
|
|
294 | (1) |
|
LEFT, MID, and RIGHT for cleaning up data |
|
|
295 | (1) |
|
PROPER for capitalizing words |
|
|
296 | (1) |
|
LARGE and SMALL for comparing values |
|
|
296 | (1) |
|
NETVVORKDAY and TODAY for measuring time in days |
|
|
297 | (1) |
|
LEN for Counting Characters in Cells |
|
|
298 | (1) |
|
Chapter 4 Making a Worksheet Easier to Read and Understand |
|
|
299 | (18) |
|
|
299 | (6) |
|
Aligning numbers and text in columns and rows |
|
|
300 | (2) |
|
Inserting and deleting rows and columns |
|
|
302 | (1) |
|
Changing the size of columns and rows |
|
|
303 | (2) |
|
Decorating a Worksheet with Borders and Colors |
|
|
305 | (5) |
|
Cell styles for quickly formatting a worksheet |
|
|
305 | (2) |
|
Formatting cells with table styles |
|
|
307 | (1) |
|
Slapping borders on worksheet cells |
|
|
308 | (2) |
|
Decorating worksheets with colors |
|
|
310 | (1) |
|
Getting Ready to Print a Worksheet |
|
|
310 | (7) |
|
Making a worksheet fit on a page |
|
|
310 | (4) |
|
Making a worksheet more presentable |
|
|
314 | (1) |
|
Repeating row and column headings on each page |
|
|
315 | (2) |
|
Chapter 5 Advanced Techniques for Analyzing Data |
|
|
317 | (18) |
|
Seeing What the Sparklines Say |
|
|
317 | (2) |
|
Conditional Formats for Calling Attention to Data |
|
|
319 | (1) |
|
Managing Information in Lists |
|
|
320 | (3) |
|
|
320 | (1) |
|
|
321 | (2) |
|
Forecasting with the Goal Seek Command |
|
|
323 | (2) |
|
Performing What-If Analyses with Data Tables |
|
|
325 | (4) |
|
Using a one-input table for analysis |
|
|
325 | (2) |
|
Using a two-input table for analysis |
|
|
327 | (2) |
|
Analyzing Data with PivotTables |
|
|
329 | (8) |
|
Getting a PivotTable recommendation from Excel |
|
|
330 | (1) |
|
Creating a PivotTable from scratch |
|
|
331 | (2) |
|
Putting the finishing touches on a PivotTable |
|
|
333 | (2) |
Book 4: Powerpoint 2019 |
|
335 | (90) |
|
Chapter 1 Getting Started in PowerPoint |
|
|
337 | (22) |
|
Getting Acquainted with PowerPoint |
|
|
338 | (1) |
|
|
339 | (1) |
|
A Whirlwind Tour of PowerPoint |
|
|
340 | (1) |
|
Creating a New Presentation |
|
|
341 | (3) |
|
Advice for Building Persuasive Presentations |
|
|
344 | (2) |
|
Creating New Slides for Your Presentation |
|
|
346 | (4) |
|
|
347 | (1) |
|
Speed techniques for inserting slides |
|
|
348 | (1) |
|
Conjuring slides from Word document headings |
|
|
348 | (2) |
|
Selecting a different layout for a slide |
|
|
350 | (1) |
|
Getting a Better View of Your Work |
|
|
350 | (2) |
|
|
350 | (1) |
|
Looking at the different views |
|
|
350 | (2) |
|
Hiding and Displaying the Slides Pane and Notes Pane |
|
|
352 | (1) |
|
Selecting, Moving, and Deleting Slides |
|
|
352 | (2) |
|
|
353 | (1) |
|
|
353 | (1) |
|
|
353 | (1) |
|
Putting Together a Photo Album |
|
|
354 | (3) |
|
Creating your photo album |
|
|
354 | (2) |
|
Putting on the final touches |
|
|
356 | (1) |
|
|
357 | (1) |
|
Hidden Slides for All Contingencies |
|
|
357 | (2) |
|
|
357 | (1) |
|
Showing a hidden slide during a presentation |
|
|
358 | (1) |
|
Chapter 2 Fashioning a Look for Your Presentation |
|
|
359 | (14) |
|
Looking at Themes and Slide Backgrounds |
|
|
360 | (1) |
|
Choosing a Theme for Your Presentation |
|
|
361 | (1) |
|
Creating Slide Backgrounds on Your Own |
|
|
362 | (6) |
|
Using a solid (or transparent) color for the slide background |
|
|
362 | (1) |
|
Creating a gradient color blend for slide backgrounds |
|
|
363 | (2) |
|
Placing a picture in the slide background |
|
|
365 | (1) |
|
Using a photo of your own for a slide background |
|
|
366 | (1) |
|
Using a texture for a slide background |
|
|
367 | (1) |
|
Changing the Background of a Single or Handful of Slides |
|
|
368 | (1) |
|
|
369 | (1) |
|
Using Master Slides and Master Styles for a Consistent Design |
|
|
370 | (3) |
|
Switching to Slide Master view |
|
|
370 | (1) |
|
Understanding master slides and master styles |
|
|
370 | (2) |
|
|
372 | (1) |
|
Changing a master slide layout |
|
|
372 | (1) |
|
Chapter 3 Entering the Text |
|
|
373 | (16) |
|
|
373 | (4) |
|
|
374 | (1) |
|
Changing the font size of text |
|
|
375 | (1) |
|
Changing the look of text |
|
|
375 | (2) |
|
Fun with Text Boxes and Text Box Shapes |
|
|
377 | (2) |
|
Controlling How Text Fits in Text Frames and Text Boxes |
|
|
379 | (3) |
|
Choosing how AutoFit works in text frames |
|
|
379 | (2) |
|
Choosing how AutoFits works in text boxes |
|
|
381 | (1) |
|
Positioning Text in Frames and Text Boxes |
|
|
382 | (1) |
|
Handling Bulleted and Numbered Lists |
|
|
382 | (3) |
|
Creating a standard bulleted or numbered list |
|
|
383 | (1) |
|
Choosing a different bullet character, size, and color |
|
|
383 | (2) |
|
Choosing a different list-numbering style, size, and color |
|
|
385 | (1) |
|
Putting Footers (and Headers) on Slides |
|
|
385 | (4) |
|
Some background on footers and headers |
|
|
386 | (1) |
|
Putting a standard footer on all your slides |
|
|
386 | (1) |
|
Creating a nonstandard footer |
|
|
387 | (1) |
|
Removing a footer from a single slide |
|
|
388 | (1) |
|
Chapter 4 Making Your Presentations Livelier |
|
|
389 | (16) |
|
Suggestions for Enlivening Your Presentation |
|
|
389 | (1) |
|
Presenting Information in a Table |
|
|
390 | (3) |
|
Exploring Transitions and Animations |
|
|
393 | (3) |
|
Showing transitions between slides |
|
|
393 | (1) |
|
Animating parts of a slide |
|
|
394 | (2) |
|
Making Audio Part of Your Presentation |
|
|
396 | (3) |
|
Inserting an audio file on a slide |
|
|
397 | (1) |
|
Telling PowerPoint when and how to play an audio file |
|
|
398 | (1) |
|
Playing audio during a presentation |
|
|
399 | (1) |
|
|
399 | (4) |
|
Inserting a video on a slide |
|
|
400 | (1) |
|
Fine-tuning a video presentation |
|
|
400 | (2) |
|
Experimenting with the look of the video |
|
|
402 | (1) |
|
Recording a Voice Narration for Slides |
|
|
403 | (2) |
|
Chapter 5 Delivering a Presentation |
|
|
405 | (20) |
|
|
405 | (1) |
|
Rehearsing and Timing Your Presentation |
|
|
406 | (2) |
|
Showing Your Presentation |
|
|
408 | (3) |
|
Starting and ending a presentation |
|
|
408 | (1) |
|
Going from slide to slide |
|
|
408 | (3) |
|
Tricks for Making Presentations a Little Livelier |
|
|
411 | (3) |
|
Wielding a pen or highlighter in a presentation |
|
|
412 | (2) |
|
|
414 | (1) |
|
|
414 | (1) |
|
Delivering a Presentation When You Can't Be There in Person |
|
|
414 | (13) |
|
Providing handouts for your audience |
|
|
415 | (1) |
|
Creating a self-running, kiosk-style presentation |
|
|
416 | (2) |
|
Creating a user-run presentation |
|
|
418 | (2) |
|
Presenting a Presentation Online |
|
|
420 | (2) |
|
Packaging your presentation on a CD or DVD |
|
|
422 | (1) |
|
Creating a presentation video |
|
|
423 | (2) |
Book 5: Outlook 2019 |
|
425 | (64) |
|
|
427 | (14) |
|
|
427 | (2) |
|
Navigating the Outlook Folders |
|
|
429 | (1) |
|
|
430 | (2) |
|
|
430 | (1) |
|
Assigning items to categories |
|
|
431 | (1) |
|
Arranging items by category in folders |
|
|
432 | (1) |
|
Searching for Stray Folder Items |
|
|
432 | (3) |
|
Conducting an instant search |
|
|
433 | (1) |
|
|
433 | (1) |
|
Conducting an advanced search |
|
|
434 | (1) |
|
Deleting Email Messages, Contacts, Tasks, and Other Items |
|
|
435 | (1) |
|
Cleaning Out Your Folders |
|
|
436 | (5) |
|
|
436 | (2) |
|
Running the Mailbox Cleanup command |
|
|
438 | (3) |
|
Chapter 2 Maintaining the Contacts Folder |
|
|
441 | (10) |
|
Maintaining a Happy and Healthy Contacts Folder |
|
|
442 | (3) |
|
Entering a new contact in the Contacts folder |
|
|
442 | (2) |
|
Changing a contact's information |
|
|
444 | (1) |
|
Contact Groups for Sending Messages to Groups |
|
|
445 | (2) |
|
|
445 | (2) |
|
Addressing email to a contact group |
|
|
447 | (1) |
|
|
447 | (1) |
|
Finding a Contact in the Contacts Folder |
|
|
447 | (1) |
|
Printing the Contacts Folder |
|
|
448 | (3) |
|
Different ways to print contact information |
|
|
448 | (1) |
|
Changing the look of printed pages |
|
|
449 | (2) |
|
Chapter 3 Handling Your Email |
|
|
451 | (22) |
|
Setting Up an Email Account |
|
|
451 | (1) |
|
Addressing and Sending Email Messages |
|
|
452 | (6) |
|
The basics: Sending an email message |
|
|
453 | (1) |
|
Addressing an email message |
|
|
454 | (2) |
|
Sending copies and blind copies of messages |
|
|
456 | (1) |
|
Replying to and forwarding email messages |
|
|
456 | (2) |
|
|
458 | (2) |
|
Sending a file along with a message |
|
|
458 | (1) |
|
Including a photo in an email message |
|
|
459 | (1) |
|
|
460 | (1) |
|
|
460 | (1) |
|
Being notified that email has arrived |
|
|
461 | (1) |
|
Reading Your Email in the Inbox Window |
|
|
461 | (2) |
|
Handling Files That Were Sent to You |
|
|
463 | (1) |
|
Opening a file you received |
|
|
464 | (1) |
|
Saving a file you received |
|
|
464 | (1) |
|
Techniques for Organizing Email Messages |
|
|
464 | (4) |
|
|
466 | (1) |
|
Rules for earmarking messages as they arrive |
|
|
466 | (2) |
|
|
468 | (2) |
|
Moving email messages to different folders |
|
|
468 | (1) |
|
Creating a new folder for storing email |
|
|
469 | (1) |
|
Yes, You Can Prevent Junk Mail (Sort of) |
|
|
470 | (3) |
|
Defining what constitutes junk email |
|
|
470 | (1) |
|
Preventative medicine for junk email |
|
|
471 | (2) |
|
Chapter 4 Managing Your Time and Schedule |
|
|
473 | (8) |
|
|
473 | (1) |
|
The Different Kinds of Activities |
|
|
474 | (1) |
|
|
475 | (2) |
|
Going to a different day, week, or month |
|
|
476 | (1) |
|
Rearranging the Calendar window |
|
|
476 | (1) |
|
Scheduling Appointments and Events |
|
|
477 | (3) |
|
Scheduling an activity: The basics |
|
|
477 | (1) |
|
Scheduling a recurring appointment or event |
|
|
478 | (1) |
|
|
479 | (1) |
|
Canceling, Rescheduling, and Altering Activities |
|
|
480 | (1) |
|
Chapter 5 Tasks, Reminders, and Notes |
|
|
481 | (8) |
|
Tasks: Seeing What Needs to Get Done |
|
|
481 | (3) |
|
Entering a task in the Tasks window |
|
|
482 | (2) |
|
Examining tasks in the Tasks window |
|
|
484 | (1) |
|
Handling and managing tasks |
|
|
484 | (1) |
|
Reminders for Being Alerted to Activities and Tasks |
|
|
484 | (3) |
|
Handling reminder messages |
|
|
485 | (1) |
|
Scheduling a reminder message |
|
|
486 | (1) |
|
Making reminders work your way |
|
|
486 | (1) |
|
|
487 | (2) |
Book 6: Access 2019 |
|
489 | (84) |
|
Chapter 1 Introducing Access |
|
|
491 | (16) |
|
What Is a Database, Anyway? |
|
|
492 | (1) |
|
Tables, Queries, Forms, and Other Objects |
|
|
492 | (5) |
|
Database tables for storing information |
|
|
492 | (2) |
|
|
494 | (1) |
|
Queries for getting the data out |
|
|
495 | (1) |
|
Reports for presenting and examining data |
|
|
496 | (1) |
|
|
497 | (1) |
|
|
497 | (2) |
|
Creating a blank database file |
|
|
498 | (1) |
|
Getting the help of a template |
|
|
498 | (1) |
|
Finding Your Way Around the Navigation Pane |
|
|
499 | (2) |
|
|
501 | (6) |
|
Deciding what information you need |
|
|
501 | (1) |
|
Separating information into different database tables |
|
|
502 | (1) |
|
Choosing fields for database tables |
|
|
503 | (1) |
|
Deciding on a primary key field for each database table |
|
|
504 | (1) |
|
Mapping the relationships between tables |
|
|
505 | (2) |
|
Chapter 2 Building Your Database Tables |
|
|
507 | (28) |
|
Creating a Database Table |
|
|
507 | (4) |
|
Creating a database table from scratch |
|
|
508 | (1) |
|
Creating a database table from a template |
|
|
509 | (1) |
|
Importing a table from another database |
|
|
510 | (1) |
|
Opening and Viewing Tables |
|
|
511 | (1) |
|
Entering and Altering Table Fields |
|
|
512 | (6) |
|
|
512 | (2) |
|
|
514 | (1) |
|
Designating the primary key field |
|
|
515 | (2) |
|
Moving, renaming, and deleting fields |
|
|
517 | (1) |
|
Field Properties for Making Sure That Data Entries Are Accurate |
|
|
518 | (8) |
|
A look at the Field Properties settings |
|
|
518 | (6) |
|
Creating a lookup data-entry list |
|
|
524 | (2) |
|
Indexing for Faster Sorts, Searches, and Queries |
|
|
526 | (2) |
|
|
527 | (1) |
|
Indexing based on more than one field |
|
|
527 | (1) |
|
Establishing Relationships Among Database Tables |
|
|
528 | (7) |
|
|
530 | (1) |
|
Handling tables in the Relationships window |
|
|
530 | (2) |
|
Forging relationships between tables |
|
|
532 | (2) |
|
Editing table relationships |
|
|
534 | (1) |
|
Chapter 3 Entering the Data |
|
|
535 | (10) |
|
The Two Ways to Enter Data |
|
|
535 | (1) |
|
Entering the Data in Datasheet View |
|
|
536 | (4) |
|
|
537 | (1) |
|
Two tricks for entering data quicker |
|
|
538 | (1) |
|
Changing the appearance of the datasheet |
|
|
539 | (1) |
|
Entering the Data in a Form |
|
|
540 | (2) |
|
|
540 | (1) |
|
|
541 | (1) |
|
|
542 | (1) |
|
Finding and Replacing Data |
|
|
543 | (2) |
|
Chapter 4 Sorting, Querying, and Filtering for Data |
|
|
545 | (22) |
|
Sorting Records in a Database Table |
|
|
545 | (1) |
|
Ascending vs. descending sorts |
|
|
546 | (1) |
|
|
546 | (1) |
|
Filtering to Find Information |
|
|
546 | (6) |
|
Different ways to filter a database table |
|
|
548 | (1) |
|
"Unfiltering" a database table |
|
|
548 | (1) |
|
|
549 | (1) |
|
|
549 | (1) |
|
|
550 | (2) |
|
|
552 | (8) |
|
|
553 | (1) |
|
Viewing queries in Datasheet and Design views |
|
|
554 | (1) |
|
Finding your way around the Query Design window |
|
|
554 | (1) |
|
Choosing which database tables to query |
|
|
554 | (1) |
|
Choosing which fields to query |
|
|
555 | (1) |
|
Sorting the query results |
|
|
556 | (1) |
|
Choosing which fields appear in query results |
|
|
556 | (2) |
|
Entering criteria for a query |
|
|
558 | (2) |
|
At last - saving and running a query |
|
|
560 | (1) |
|
|
560 | (7) |
|
|
561 | (1) |
|
|
561 | (1) |
|
|
561 | (1) |
|
|
562 | (2) |
|
|
564 | (1) |
|
|
564 | (3) |
|
Chapter 5 Presenting Data in a Report |
|
|
567 | (6) |
|
|
567 | (2) |
|
Opening and Viewing Reports |
|
|
569 | (1) |
|
|
569 | (4) |
Book 7: Publisher 2019 |
|
573 | (38) |
|
Chapter 1 Introducing Publisher |
|
|
575 | (12) |
|
|
575 | (1) |
|
|
576 | (1) |
|
|
577 | (1) |
|
Redesigning a Publication |
|
|
578 | (2) |
|
Choosing a different template |
|
|
578 | (1) |
|
|
578 | (1) |
|
|
578 | (1) |
|
|
579 | (1) |
|
Getting a Better View of Your Work |
|
|
580 | (2) |
|
|
580 | (1) |
|
Viewing single pages and two-page spreads |
|
|
581 | (1) |
|
|
581 | (1) |
|
Understanding and Using the Layout Guides |
|
|
582 | (5) |
|
Making use of layout guides |
|
|
582 | (3) |
|
Snapping objects to ruler and grid lines |
|
|
585 | (2) |
|
Chapter 2 Refining a Publication |
|
|
587 | (12) |
|
Entering Text on the Pages |
|
|
587 | (1) |
|
Making Text Fit in Text Frames |
|
|
588 | (4) |
|
Fitting overflow text in a single frame |
|
|
589 | (1) |
|
Making text flow from frame to frame |
|
|
590 | (1) |
|
|
591 | (1) |
|
|
592 | (1) |
|
Making Text Wrap around a Frame or Graphic |
|
|
592 | (1) |
|
Replacing the Placeholder Pictures |
|
|
593 | (1) |
|
Inserting Frames on the Pages |
|
|
594 | (2) |
|
|
594 | (1) |
|
Changing the size and position of frames |
|
|
595 | (1) |
|
|
596 | (1) |
|
Inserting, Removing, and Moving Pages |
|
|
596 | (3) |
|
Chapter 3 Putting on the Finishing Touches |
|
|
599 | (12) |
|
|
600 | (2) |
|
Drawing a horizontal rule on a frame |
|
|
600 | (1) |
|
|
601 | (1) |
|
Techniques for Decorating Pages |
|
|
602 | (4) |
|
|
602 | (2) |
|
Experimenting with borders and accents |
|
|
604 | (1) |
|
Taking advantage of attention getters |
|
|
604 | (1) |
|
|
605 | (1) |
|
Master Pages for Handling Page Backgrounds |
|
|
606 | (2) |
|
Switching to Master Page view |
|
|
606 | (1) |
|
Changing the look of a master page |
|
|
607 | (1) |
|
Applying (or unapplying) a master page to publication pages |
|
|
607 | (1) |
|
Running the Design Checker |
|
|
608 | (1) |
|
Commercially Printing a Publication |
|
|
609 | (2) |
Book 8: Working With Charts And Graphics |
|
611 | (94) |
|
Chapter 1 Creating a Chart |
|
|
613 | (20) |
|
The Basics: Creating a Chart |
|
|
613 | (2) |
|
|
615 | (2) |
|
Providing the Raw Data for Your Chart |
|
|
617 | (2) |
|
Positioning Your Chart in a Workbook, Page, or Slide |
|
|
619 | (1) |
|
Changing a Chart's Appearance |
|
|
620 | (6) |
|
|
620 | (1) |
|
Changing the size and shape of a chart |
|
|
621 | (1) |
|
Choosing a new look for your chart |
|
|
622 | (1) |
|
Changing the layout of a chart |
|
|
622 | (2) |
|
|
624 | (1) |
|
Changing a chart element's color, font, or other particular |
|
|
624 | (2) |
|
Saving a Chart as a Template So That You Can Use It Again |
|
|
626 | (1) |
|
Saving a chart as a template |
|
|
626 | (1) |
|
Creating a chart from a template |
|
|
626 | (1) |
|
Chart Tricks for the Daring and Heroic |
|
|
627 | (3) |
|
Decorating a chart with a picture |
|
|
627 | (1) |
|
|
628 | (1) |
|
Displaying the raw data alongside the chart |
|
|
629 | (1) |
|
Placing a trendline on a chart |
|
|
629 | (1) |
|
|
630 | (3) |
|
Chapter 2 Making a SmartArt Diagram |
|
|
633 | (20) |
|
The Basics: Creating SmartArt Diagrams |
|
|
633 | (3) |
|
|
634 | (1) |
|
Making the diagram your own |
|
|
635 | (1) |
|
Creating the Initial Diagram |
|
|
636 | (2) |
|
|
636 | (1) |
|
Swapping one diagram for another |
|
|
637 | (1) |
|
Changing the Size and Position of a Diagram |
|
|
638 | (1) |
|
Laying Out the Diagram Shapes |
|
|
638 | (6) |
|
Selecting a diagram shape |
|
|
638 | (1) |
|
Removing a shape from a diagram |
|
|
639 | (1) |
|
Moving diagram shapes to different positions |
|
|
639 | (1) |
|
Adding shapes to diagrams apart from hierarchy diagrams |
|
|
639 | (1) |
|
Adding shapes to hierarchy diagrams |
|
|
640 | (2) |
|
Adding shapes to Organization charts |
|
|
642 | (2) |
|
Promoting and demoting shapes in hierarchy diagrams |
|
|
644 | (1) |
|
Handling the Text on Diagram Shapes |
|
|
644 | (3) |
|
Entering text on a diagram shape |
|
|
645 | (1) |
|
Entering bulleted lists on diagram shapes |
|
|
645 | (2) |
|
Changing a Diagram's Direction |
|
|
647 | (1) |
|
Choosing a Look for Your Diagram |
|
|
647 | (1) |
|
Changing the Appearance of Diagram Shapes |
|
|
648 | (3) |
|
Changing the size of a diagram shape |
|
|
649 | (1) |
|
Exchanging one shape for another |
|
|
649 | (1) |
|
Changing a shape's color, fill, or outline |
|
|
650 | (1) |
|
Changing fonts and font sizes on shapes |
|
|
650 | (1) |
|
Creating a Diagram from Scratch |
|
|
651 | (2) |
|
Chapter 3 Handling Graphics and Photos |
|
|
653 | (18) |
|
All about Picture File Formats |
|
|
653 | (4) |
|
Bitmap and vector graphics |
|
|
654 | (1) |
|
|
655 | (1) |
|
|
656 | (1) |
|
|
656 | (1) |
|
Choosing file formats for graphics |
|
|
657 | (1) |
|
Inserting a Picture in an Office File |
|
|
657 | (3) |
|
Inserting a picture of your own |
|
|
657 | (1) |
|
Obtaining a picture online |
|
|
658 | (2) |
|
|
660 | (8) |
|
Softening and sharpening pictures |
|
|
661 | (1) |
|
Correcting a picture's brightness and contrast |
|
|
662 | (1) |
|
|
662 | (1) |
|
Choosing an artistic effect |
|
|
663 | (2) |
|
Selecting a picture style |
|
|
665 | (1) |
|
Cropping off part of a picture |
|
|
665 | (2) |
|
|
667 | (1) |
|
Compressing Pictures to Save Disk Space |
|
|
668 | (3) |
|
Chapter 4 Drawing and Manipulating Lines, Shapes, and Other Objects |
|
|
671 | (34) |
|
The Basics: Making Lines, Arrows, and Shapes |
|
|
672 | (2) |
|
Handling Lines, Arrows, and Connectors |
|
|
674 | (4) |
|
Changing the length and position of a line or arrow |
|
|
674 | (1) |
|
Changing the appearance of a line, arrow, or connector |
|
|
674 | (1) |
|
Attaching and handling arrowheads on lines and connectors |
|
|
675 | (1) |
|
Connecting shapes by using connectors |
|
|
676 | (2) |
|
Handling Rectangles, Ovals, Stars, and Other Shapes |
|
|
678 | (4) |
|
|
679 | (1) |
|
Changing a shape's symmetry |
|
|
680 | (1) |
|
Using a shape as a text box |
|
|
681 | (1) |
|
|
682 | (3) |
|
Freehand drawing with a pen or highlighter |
|
|
682 | (1) |
|
Changing the look of freehand drawings |
|
|
683 | (1) |
|
Drawing a math expression |
|
|
684 | (1) |
|
Decorating Your Work with Icons |
|
|
685 | (1) |
|
|
686 | (1) |
|
WordArt for Embellishing Letters and Words |
|
|
686 | (2) |
|
|
687 | (1) |
|
|
687 | (1) |
|
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects |
|
|
688 | (3) |
|
Selecting objects so that you can manipulate them |
|
|
689 | (1) |
|
Hiding and displaying the rulers and grid |
|
|
690 | (1) |
|
Changing an Object's Size and Shape |
|
|
691 | (1) |
|
Changing an Object's Color, Outline Color, and Transparency |
|
|
692 | (5) |
|
Filling an object with color, a picture, or a texture |
|
|
693 | (2) |
|
Making a color transparent |
|
|
695 | (1) |
|
Putting the outline around an object |
|
|
696 | (1) |
|
Moving and Positioning Objects |
|
|
697 | (10) |
|
Tricks for aligning and distributing objects |
|
|
697 | (3) |
|
When objects overlap: Choosing which appears above the other |
|
|
700 | (2) |
|
Rotating and flipping objects |
|
|
702 | (1) |
|
Grouping objects to make working with them easier |
|
|
703 | (2) |
Book 9: Office 2019: One Step Beyond |
|
705 | (24) |
|
Chapter 1 Customizing an Office Program |
|
|
707 | (14) |
|
|
707 | (6) |
|
Displaying and selecting tab, group, and command names |
|
|
709 | (1) |
|
Moving tabs and groups on the Ribbon |
|
|
710 | (1) |
|
Adding, removing, and renaming tabs, groups, and commands |
|
|
710 | (2) |
|
Creating new tabs and groups |
|
|
712 | (1) |
|
Resetting your Ribbon customizations |
|
|
712 | (1) |
|
Customizing the Quick Access Toolbar |
|
|
713 | (3) |
|
Adding buttons to the Quick Access toolbar |
|
|
714 | (1) |
|
Changing the order of buttons on the Quick Access toolbar |
|
|
715 | (1) |
|
Removing buttons from the Quick Access toolbar |
|
|
716 | (1) |
|
Placing the Quick Access toolbar above or below the Ribbon |
|
|
716 | (1) |
|
Customizing the Status Bar |
|
|
716 | (1) |
|
Changing the Screen Background and Office Theme |
|
|
717 | (1) |
|
Customizing Keyboard Shortcuts in Word |
|
|
718 | (3) |
|
Chapter 2 Ways of Distributing Your Work |
|
|
721 | (8) |
|
Printing - the Old Standby |
|
|
721 | (2) |
|
Distributing a File in PDF Format |
|
|
723 | (2) |
|
|
724 | (1) |
|
Saving an Office file as a PDF |
|
|
724 | (1) |
|
Sending Your File in an Email Message |
|
|
725 | (1) |
|
Saving an Office File as a Web Page |
|
|
726 | (5) |
|
Turning a file into a web page |
|
|
726 | (1) |
|
Opening a web page in your browser |
|
|
727 | (2) |
Book 10: File Sharing And Collaborating |
|
729 | (22) |
|
Chapter 1 Up and Running on OneDrive |
|
|
731 | (12) |
|
|
731 | (2) |
|
Exploring the OneDrive Window |
|
|
733 | (1) |
|
Managing Your OneDrive Folders |
|
|
733 | (5) |
|
|
734 | (1) |
|
Viewing and locating folders in the OneDrive window |
|
|
734 | (2) |
|
Selecting folders and files |
|
|
736 | (1) |
|
Going from folder to folder in OneDrive |
|
|
736 | (1) |
|
Deleting, moving, and renaming folders |
|
|
736 | (2) |
|
Uploading Files to a Folder on OneDrive |
|
|
738 | (1) |
|
Saving a File from Office 2019 to OneDrive |
|
|
739 | (1) |
|
Opening a File from OneDrive |
|
|
740 | (1) |
|
Starting in an Office 2019 application |
|
|
740 | (1) |
|
|
741 | (1) |
|
Downloading Files from OneDrive to Your Computer |
|
|
741 | (2) |
|
Chapter 2 File Sharing and Collaborating |
|
|
743 | (8) |
|
Sharing Files: The Big Picture |
|
|
743 | (2) |
|
Sharing Your Files and Folders with Others |
|
|
745 | (3) |
|
|
745 | (1) |
|
Generating a link to shared files |
|
|
746 | (1) |
|
|
747 | (1) |
|
Seeing Files and Folders Others Shared with You |
|
|
748 | (1) |
|
Investigating and Managing How Files and Folders Are Shared |
|
|
749 | (2) |
Index |
|
751 | |