| Introduction |
|
1 | (4) |
|
|
|
1 | (2) |
|
|
|
3 | (1) |
|
|
|
3 | (1) |
|
|
|
4 | (1) |
|
|
|
4 | (1) |
| Part 1: Getting Started With Office 2019 |
|
5 | (64) |
|
Chapter 1 The Two-Dollar Tour |
|
|
7 | (20) |
|
Start an Office Application |
|
|
8 | (1) |
|
|
|
9 | (1) |
|
Explore the Office Ribbon and Tabs |
|
|
10 | (4) |
|
Understand the File Menu (Backstage View) |
|
|
14 | (1) |
|
|
|
15 | (1) |
|
|
|
16 | (2) |
|
|
|
18 | (1) |
|
Move Around in a Document |
|
|
19 | (2) |
|
|
|
21 | (2) |
|
|
|
23 | (1) |
|
|
|
24 | (3) |
|
Chapter 2 Exploring the Common Features of Office Applications |
|
|
27 | (20) |
|
|
|
28 | (1) |
|
|
|
29 | (4) |
|
Choose Fonts and Font Sizes |
|
|
33 | (2) |
|
|
|
35 | (2) |
|
|
|
37 | (1) |
|
|
|
38 | (4) |
|
Check Your Spelling and Grammar |
|
|
42 | (5) |
|
Chapter 3 Opening, Saving, and Printing Files |
|
|
47 | (22) |
|
|
|
48 | (7) |
|
|
|
48 | (2) |
|
Changing the Save Location |
|
|
50 | (4) |
|
|
|
54 | (1) |
|
Open a Previously Saved File |
|
|
55 | (1) |
|
Change the File Listing View |
|
|
56 | (1) |
|
Email Your Work to Others |
|
|
57 | (4) |
|
Emailing a Link to a Document |
|
|
58 | (1) |
|
Emailing a Copy of a Document |
|
|
59 | (2) |
|
Share Your Work in Other Formats |
|
|
61 | (3) |
|
|
|
64 | (2) |
|
|
|
66 | (3) |
| Part 2: Word |
|
69 | (60) |
|
Chapter 4 Composing Your Thoughts in Word |
|
|
71 | (20) |
|
Examine the Word Interface |
|
|
72 | (1) |
|
Move Around and Select Text |
|
|
73 | (1) |
|
Choose Paper Size and Orientation |
|
|
74 | (2) |
|
|
|
76 | (2) |
|
Select the Right Screen View |
|
|
78 | (2) |
|
Align and Indent Paragraphs |
|
|
80 | (6) |
|
|
|
86 | (2) |
|
Create Bulleted and Numbered Lists |
|
|
88 | (3) |
|
Chapter 5 Dressing Up Your Documents |
|
|
91 | (20) |
|
Apply Styles and Style Sets |
|
|
92 | (5) |
|
|
|
97 | (3) |
|
Size and Format a Picture |
|
|
100 | (1) |
|
|
|
101 | (1) |
|
|
|
102 | (2) |
|
Apply a Background Color to a Page |
|
|
104 | (2) |
|
|
|
106 | (3) |
|
|
|
109 | (2) |
|
Chapter 6 Taking Word to the Next Level |
|
|
111 | (18) |
|
|
|
112 | (2) |
|
|
|
114 | (3) |
|
Insert Cover Pages and Other Building Blocks |
|
|
117 | (2) |
|
|
|
119 | (2) |
|
|
|
121 | (6) |
|
|
|
127 | (2) |
| Part 3: Excel |
|
129 | (68) |
|
Chapter 7 Creating Basic Spreadsheets in Excel |
|
|
131 | (18) |
|
Understand Excel's Unique Features |
|
|
132 | (2) |
|
Get Familiar with Spreadsheet Structure |
|
|
134 | (1) |
|
|
|
134 | (1) |
|
|
|
135 | (4) |
|
Type and Edit Cell Contents |
|
|
139 | (2) |
|
Insert and Delete Rows, Columns, and Cells |
|
|
141 | (4) |
|
|
|
145 | (4) |
|
Chapter 8 Doing the Math: Formulas and Functions |
|
|
149 | (14) |
|
Learn How Formulas Are Structured |
|
|
150 | (1) |
|
Write Formulas That Reference Cells |
|
|
150 | (2) |
|
Move and Copy Cell Content |
|
|
152 | (2) |
|
Reference a Cell on Another Sheet |
|
|
154 | (1) |
|
|
|
154 | (3) |
|
Take a Tour of Some Basic Functions |
|
|
157 | (2) |
|
Explore Financial Functions |
|
|
159 | (4) |
|
Chapter 9 Creating Visual Interest with Formatting and Charts |
|
|
163 | (20) |
|
Adjust Row Height and Column Width |
|
|
164 | (1) |
|
|
|
165 | (1) |
|
Apply Gridlines or Borders |
|
|
166 | (3) |
|
|
|
169 | (2) |
|
|
|
171 | (2) |
|
Format the Spreadsheet as a Whole |
|
|
173 | (1) |
|
|
|
174 | (3) |
|
Identify the Parts of a Chart |
|
|
177 | (1) |
|
|
|
178 | (5) |
|
Chapter 10 Using Excel as a Database |
|
|
183 | (14) |
|
|
|
184 | (1) |
|
Prepare a List for a Mail Merge |
|
|
184 | (1) |
|
|
|
185 | (2) |
|
|
|
187 | (2) |
|
|
|
189 | (3) |
|
|
|
192 | (3) |
|
Merge the Contents of Columns |
|
|
195 | (2) |
| Part 4: Outlook |
|
197 | (54) |
|
Chapter 11 Managing Email with Outlook |
|
|
199 | (20) |
|
Set Up Outlook for the First Time |
|
|
200 | (1) |
|
Set Up Additional Mail Accounts |
|
|
201 | (1) |
|
Troubleshoot Mail Setup Problems |
|
|
202 | (4) |
|
Take a Quick Tour of Outlook's Mail Feature |
|
|
206 | (1) |
|
Receive and Read Your Mail |
|
|
207 | (2) |
|
View Photos and Other Attachments |
|
|
209 | (1) |
|
|
|
210 | (1) |
|
|
|
211 | (1) |
|
|
|
212 | (2) |
|
Attach a File to a Message |
|
|
214 | (1) |
|
Avoid Frauds, Scams, and Viruses |
|
|
215 | (4) |
|
Chapter 12 Managing the Details: Contacts, Notes, and Tasks |
|
|
219 | (20) |
|
Store Contact Information |
|
|
220 | (3) |
|
|
|
223 | (1) |
|
Choose How the Contact List Appears |
|
|
224 | (1) |
|
|
|
225 | (2) |
|
|
|
227 | (3) |
|
|
|
230 | (2) |
|
Use Tasks and the To-Do List |
|
|
232 | (3) |
|
Update the Status of a Task |
|
|
235 | (1) |
|
|
|
236 | (3) |
|
Chapter 13 Your Busy Life: Using the Calendar |
|
|
239 | (12) |
|
|
|
239 | (3) |
|
Create and Delete a Calendar Event |
|
|
242 | (1) |
|
|
|
243 | (2) |
|
Configure Event Reminders |
|
|
245 | (1) |
|
|
|
246 | (1) |
|
Print a Hard Copy of Your Calendar |
|
|
247 | (4) |
| Part 5: Powerpoint |
|
251 | (56) |
|
Chapter 14 Getting Started with PowerPoint |
|
|
253 | (16) |
|
Explore the PowerPoint Interface |
|
|
254 | (1) |
|
Work with PowerPoint Files |
|
|
255 | (1) |
|
Understand PowerPoint Views |
|
|
256 | (2) |
|
|
|
258 | (1) |
|
|
|
259 | (2) |
|
Turn Text AutoFit Off or On |
|
|
261 | (2) |
|
|
|
263 | (1) |
|
Move or Resize Slide Content |
|
|
263 | (1) |
|
Manually Place Text on a Slide |
|
|
264 | (1) |
|
|
|
265 | (2) |
|
|
|
267 | (2) |
|
Chapter 15 Dressing Up Your Presentations |
|
|
269 | (14) |
|
Understand and Apply Themes and Variants |
|
|
270 | (1) |
|
Change the Presentation Colors |
|
|
271 | (1) |
|
|
|
272 | (2) |
|
Format Text Boxes and Placeholders |
|
|
274 | (1) |
|
|
|
275 | (4) |
|
Create a Photo Album Presentation |
|
|
279 | (4) |
|
Chapter 16 Adding Movement and Sound |
|
|
283 | (10) |
|
Animate Objects on a Slide |
|
|
284 | (5) |
|
Add Slide Transition Effects |
|
|
289 | (2) |
|
Set Slides to Automatically Advance |
|
|
291 | (1) |
|
|
|
292 | (1) |
|
Chapter 17 Presenting the Show |
|
|
293 | (14) |
|
Display a Slide Show Onscreen |
|
|
294 | (2) |
|
|
|
296 | (3) |
|
Print Copies of a Presentation |
|
|
299 | (2) |
|
Package a Presentation for Distribution |
|
|
301 | (3) |
|
Make a Video of the Presentation |
|
|
304 | (3) |
| Appendix: Customizing Office Applications |
|
307 | (8) |
| Index |
|
315 | |