Introduction |
|
1 | (4) |
|
|
1 | (2) |
|
|
3 | (1) |
|
|
3 | (1) |
|
|
4 | (1) |
|
|
4 | (1) |
Part 1: Getting Started With Office |
|
5 | (68) |
|
Chapter 1 The Two-Dollar Tour |
|
|
7 | (20) |
|
Start an Office Application |
|
|
8 | (1) |
|
|
9 | (1) |
|
Explore the Office Ribbon and Tabs |
|
|
10 | (5) |
|
Understand the File Menu (Backstage View) |
|
|
15 | (1) |
|
|
16 | (1) |
|
|
17 | (2) |
|
|
19 | (1) |
|
Move Around in a Document |
|
|
20 | (2) |
|
|
22 | (2) |
|
|
24 | (1) |
|
|
25 | (2) |
|
Chapter 2 Exploring the Common Features of Office Applications |
|
|
27 | (22) |
|
|
28 | (1) |
|
|
29 | (4) |
|
Choose Fonts and Font Sizes |
|
|
33 | (3) |
|
|
36 | (2) |
|
|
38 | (1) |
|
|
39 | (4) |
|
Check Your Spelling and Grammar |
|
|
43 | (6) |
|
Chapter 3 Opening, Saving, and Printing Files |
|
|
49 | (24) |
|
|
50 | (7) |
|
|
50 | (2) |
|
Changing the Save Location |
|
|
52 | (5) |
|
|
57 | (1) |
|
Open a Previously Saved File |
|
|
57 | (2) |
|
Change the File Listing View |
|
|
59 | (1) |
|
Email Your Work to Others |
|
|
60 | (5) |
|
Emailing a Link to a Document |
|
|
61 | (2) |
|
Emailing a Copy of a Document |
|
|
63 | (2) |
|
Share Your Work in Other Formats |
|
|
65 | (3) |
|
|
68 | (2) |
|
|
70 | (3) |
Part 2: Word |
|
73 | (62) |
|
Chapter 4 Composing Your Thoughts in Word |
|
|
75 | (20) |
|
Examine the Word Interface |
|
|
76 | (1) |
|
Move Around and Select Text |
|
|
77 | (2) |
|
Choose Paper Size and Orientation |
|
|
79 | (1) |
|
|
80 | (2) |
|
Select the Right Screen View |
|
|
82 | (2) |
|
Align and Indent Paragraphs |
|
|
84 | (6) |
|
|
90 | (2) |
|
Create Bulleted and Numbered Lists |
|
|
92 | (3) |
|
Chapter 5 Dressing Up Your Documents |
|
|
95 | (22) |
|
Apply Styles and Style Sets |
|
|
96 | (5) |
|
|
101 | (4) |
|
Size and Format a Picture |
|
|
105 | (1) |
|
|
106 | (2) |
|
|
108 | (2) |
|
Apply a Background Color to a Page |
|
|
110 | (2) |
|
|
112 | (3) |
|
|
115 | (2) |
|
Chapter 6 Taking Word to the Next Level |
|
|
117 | (18) |
|
|
118 | (2) |
|
|
120 | (3) |
|
Insert Cover Pages and Other Building Blocks |
|
|
123 | (2) |
|
|
125 | (2) |
|
|
127 | (6) |
|
|
133 | (2) |
Part 3: Excel |
|
135 | (70) |
|
Chapter 7 Creating Basic Spreadsheets in Excel |
|
|
137 | (18) |
|
Understand Excel's Unique Features |
|
|
138 | (2) |
|
Get Familiar with Spreadsheet Structure |
|
|
140 | (1) |
|
|
140 | (2) |
|
|
142 | (3) |
|
Type and Edit Cell Contents |
|
|
145 | (2) |
|
Insert and Delete Rows, Columns, and Cells |
|
|
147 | (4) |
|
|
151 | (4) |
|
Chapter 8 Doing the Math: Formulas and Functions |
|
|
155 | (14) |
|
Learn How Formulas Are Structured |
|
|
156 | (1) |
|
Write Formulas That Reference Cells |
|
|
156 | (1) |
|
Move and Copy Cell Content |
|
|
157 | (2) |
|
Reference a Cell on Another Sheet |
|
|
159 | (1) |
|
|
160 | (3) |
|
Take a Tour of Some Basic Functions |
|
|
163 | (2) |
|
Explore Financial Functions |
|
|
165 | (4) |
|
Chapter 9 Creating Visual Interest with Formatting and Charts |
|
|
169 | (20) |
|
Adjust Row Height and Column Width |
|
|
170 | (2) |
|
|
172 | (1) |
|
Apply Gridlines or Borders |
|
|
172 | (4) |
|
|
176 | (1) |
|
|
177 | (2) |
|
Format the Spreadsheet as a Whole |
|
|
179 | (2) |
|
|
181 | (2) |
|
Identify the Parts of a Chart |
|
|
183 | (2) |
|
|
185 | (4) |
|
Chapter 10 Using Excel as a Database |
|
|
189 | (16) |
|
|
190 | (1) |
|
Prepare a List fora Mail Merge |
|
|
190 | (1) |
|
|
191 | (2) |
|
|
193 | (3) |
|
|
196 | (3) |
|
|
199 | (2) |
|
Merge the Contents of Columns |
|
|
201 | (4) |
Part 4: Outlook |
|
205 | (56) |
|
Chapter 11 Managing Email with Outlook |
|
|
207 | (22) |
|
Set Up Outlook for the First Time |
|
|
208 | (1) |
|
Set Up Additional Mail Accounts |
|
|
209 | (1) |
|
Troubleshoot Mail Setup Problems |
|
|
210 | (4) |
|
Take a Quick Tour of Outlook's Mail Feature |
|
|
214 | (2) |
|
|
216 | (1) |
|
Receive and Read Your Mail |
|
|
216 | (2) |
|
View and Download Photos and Other Attachments |
|
|
218 | (1) |
|
|
219 | (2) |
|
|
221 | (1) |
|
|
221 | (3) |
|
Attach a File to a Message |
|
|
224 | (2) |
|
Avoid Frauds, Scams, and Viruses |
|
|
226 | (3) |
|
Chapter 12 Managing the Details: Contacts, Notes, and Tasks |
|
|
229 | (20) |
|
Store Contact Information |
|
|
230 | (3) |
|
|
233 | (2) |
|
Choose How the Contacts List Appears |
|
|
235 | (1) |
|
|
235 | (3) |
|
|
238 | (2) |
|
|
240 | (3) |
|
Use Tasks and the To-Do List |
|
|
243 | (3) |
|
Update the Status of a Task |
|
|
246 | (1) |
|
|
247 | (2) |
|
Chapter 13 Your Busy Life: Using the Calendar |
|
|
249 | (12) |
|
|
250 | (2) |
|
Create and Delete a Calendar Event |
|
|
252 | (2) |
|
|
254 | (1) |
|
Configure Event Reminders |
|
|
255 | (2) |
|
|
257 | (1) |
|
Print a Hard Copy of Your Calendar |
|
|
258 | (3) |
Part 5: Powerpoint |
|
261 | (58) |
|
Chapter 14 Getting Started with PowerPoint |
|
|
263 | (16) |
|
Explore the PowerPoint Interface |
|
|
264 | (2) |
|
Work with PowerPoint Files |
|
|
266 | (1) |
|
Understand PowerPoint Views |
|
|
266 | (2) |
|
|
268 | (2) |
|
|
270 | (1) |
|
Turn Text AutoFit Off or On |
|
|
271 | (2) |
|
|
273 | (1) |
|
Move or Resize Slide Content |
|
|
274 | (1) |
|
Manually Place Text on a Slide |
|
|
275 | (1) |
|
|
276 | (1) |
|
|
277 | (2) |
|
Chapter 15 Dressing Up Your Presentations |
|
|
279 | (14) |
|
Understand and Apply Themes and Variants |
|
|
280 | (1) |
|
Change the Presentation Colors |
|
|
281 | (2) |
|
|
283 | (1) |
|
Format Text Boxes and Placeholders |
|
|
284 | (2) |
|
|
286 | (4) |
|
Create a Photo Album Presentation |
|
|
290 | (3) |
|
Chapter 16 Adding Movement and Sound |
|
|
293 | (12) |
|
Animate Objects on a Slide |
|
|
294 | (7) |
|
Add Slide Transition Effects |
|
|
301 | (1) |
|
Set Slides to Automatically Advance |
|
|
302 | (1) |
|
|
303 | (2) |
|
Chapter 17 Presenting the Show |
|
|
305 | (14) |
|
Display a Slide Show On-Screen |
|
|
306 | (2) |
|
|
308 | (3) |
|
Print Copies of a Presentation |
|
|
311 | (2) |
|
Package a Presentation for Distribution |
|
|
313 | (3) |
|
Make a Video of the Presentation |
|
|
316 | (3) |
Part 6: Going Deeper With Office |
|
319 | (54) |
|
Chapter 18 Integrating Office with Other Apps |
|
|
321 | (20) |
|
Use Microsoft Money in Excel to Track Bank Accounts |
|
|
322 | (2) |
|
Subscribe to a Google Calendar in Outlook |
|
|
324 | (3) |
|
Import a Google Calendar Into Outlook |
|
|
327 | (2) |
|
Access Gmail Contacts in Outlook |
|
|
329 | (3) |
|
Integrating Office with iCloud |
|
|
332 | (5) |
|
Share Content Between Google Apps and Office Apps |
|
|
337 | (2) |
|
Include Online Videos in PowerPoint Presentations |
|
|
339 | (2) |
|
Chapter 19 Customizing Office Applications |
|
|
341 | (14) |
|
Customize the Quick Access Toolbar |
|
|
342 | (4) |
|
|
346 | (3) |
|
|
349 | (2) |
|
Set Options in Word, Excel, and PowerPoint |
|
|
351 | (1) |
|
|
352 | (3) |
|
Chapter 20 Troubleshooting Common Problems |
|
|
355 | (18) |
|
|
356 | (1) |
|
Repair a Malfunctioning App |
|
|
357 | (3) |
|
Fix Inconsistent Formatting in Word |
|
|
360 | (3) |
|
Improve an Ugly Presentation in PowerPoint |
|
|
363 | (1) |
|
Fix Formula Errors in Excel |
|
|
364 | (1) |
|
Pick the Right Function in Excel |
|
|
365 | (2) |
|
Minimize Document File Size |
|
|
367 | (1) |
|
Move Outlook Data Files to Another PC |
|
|
368 | (5) |
Index |
|
373 | |