| About the Author |
|
xxiii | |
| About the Technical Reviewers |
|
xxv | |
| Acknowledgments |
|
xxvii | |
| Introduction |
|
xxix | |
| Part 1: Building Essential Office Skills |
|
1 | (162) |
|
Chapter 1 Getting Up to Speed with the Office Apps |
|
|
3 | (24) |
|
Meeting the Office Apps and Learning What You Can Do with Them |
|
|
3 | (5) |
|
|
|
5 | (1) |
|
|
|
6 | (1) |
|
|
|
7 | (1) |
|
|
|
8 | (1) |
|
Understanding the Common Features of the Apps |
|
|
8 | (4) |
|
The Title Bar and the Close, Minimize, and Zoom Buttons |
|
|
9 | (2) |
|
|
|
11 | (1) |
|
|
|
12 | (1) |
|
|
|
12 | (2) |
|
Opening an App from Launchpad or the Dock |
|
|
12 | (1) |
|
Opening an App from the Applications Folder |
|
|
13 | (1) |
|
Making a App Launch Automatically |
|
|
13 | (1) |
|
|
|
14 | (2) |
|
|
|
16 | (3) |
|
|
|
19 | (1) |
|
|
|
20 | (4) |
|
|
|
24 | (1) |
|
|
|
25 | (2) |
|
Chapter 2 Learning Common Tools Across the Office Suite |
|
|
27 | (56) |
|
Using the Menus and the Ribbon |
|
|
27 | (7) |
|
|
|
29 | (1) |
|
Using and Customizing the Quick Access Toolbar |
|
|
30 | (1) |
|
|
|
31 | (2) |
|
Giving Commands from the Ribbon |
|
|
33 | (1) |
|
|
|
34 | (1) |
|
|
|
34 | (2) |
|
Sharing a Document with Other People |
|
|
36 | (9) |
|
Sending a Document via E-mail |
|
|
37 | (1) |
|
Setting Up Connected Services and SharePoint Servers |
|
|
38 | (1) |
|
Setting Up Your First Connected Services |
|
|
38 | (1) |
|
Setting Up Another Connected Service or a SharePoint Connection |
|
|
39 | (2) |
|
Switching Among and Managing Your Services and Servers |
|
|
41 | (3) |
|
Saving a Document to a Connected Service or to a SharePoint Server |
|
|
44 | (1) |
|
Saving Time and Effort with AutoCorrect |
|
|
45 | (13) |
|
Choosing Standard AutoCorrect Options |
|
|
47 | (1) |
|
Choosing AutoFormat as You Type Options |
|
|
48 | (5) |
|
Choosing Math AutoCorrect Options in Word |
|
|
53 | (2) |
|
Creating AutoCorrect Entries |
|
|
55 | (1) |
|
Creating AutoCorrect Exceptions |
|
|
56 | (1) |
|
Working with Smart Buttons |
|
|
57 | (1) |
|
Checking Spelling and Grammar |
|
|
58 | (18) |
|
|
|
59 | (4) |
|
Checking Grammar in Word and Outlook |
|
|
63 | (9) |
|
Taking Control of Spelling Checks with Custom Dictionaries |
|
|
72 | (4) |
|
|
|
76 | (5) |
|
|
|
81 | (2) |
|
Chapter 3 Working with Text |
|
|
83 | (30) |
|
Entering Text in Your Documents |
|
|
83 | (9) |
|
Entering Text in Documents Using Copy and Paste |
|
|
84 | (1) |
|
Entering Text by Scanning a Document and Using Optical Character Recognition |
|
|
84 | (1) |
|
Entering Text by Using Dictation |
|
|
84 | (2) |
|
Inserting Symbols in a Document |
|
|
86 | (6) |
|
Navigating with the Keyboard and Selecting Objects |
|
|
92 | (1) |
|
Applying Direct Formatting to Text and Objects |
|
|
93 | (2) |
|
Using Cut, Copy, and Paste |
|
|
95 | (1) |
|
|
|
96 | (7) |
|
Searching Quickly with the Search Box on the Title Bar |
|
|
96 | (1) |
|
Locating Text with the Find Dialog Box or Advanced Find Dialog Box |
|
|
97 | (3) |
|
Replacing Text with Replace |
|
|
100 | (3) |
|
|
|
103 | (5) |
|
|
|
103 | (2) |
|
Merging and Splitting Cells in a Table |
|
|
105 | (1) |
|
Adding Content to a Table |
|
|
106 | (1) |
|
|
|
107 | (1) |
|
|
|
108 | (4) |
|
|
|
112 | (1) |
|
Chapter 4 Using Pictures and Shapes in Your Documents |
|
|
113 | (30) |
|
Choosing Where to Insert a Graphical Object |
|
|
114 | (1) |
|
Inserting Pictures into Documents |
|
|
115 | (4) |
|
Inserting Pictures from the Photos App |
|
|
116 | (1) |
|
Inserting Pictures from Your Mac's File System |
|
|
117 | (2) |
|
Adding and Formatting a Shape |
|
|
119 | (4) |
|
Applying a Style to a Shape |
|
|
121 | (2) |
|
Rotating a Graphical Object |
|
|
123 | (1) |
|
Positioning a Graphical Object |
|
|
124 | (3) |
|
Choosing Text Wrapping in Word |
|
|
127 | (5) |
|
Changing the Look of a Picture |
|
|
132 | (4) |
|
Adjusting a Picture's Sharpness, Brightness, Contrast, and Colors |
|
|
132 | (1) |
|
|
|
133 | (1) |
|
|
|
133 | (2) |
|
Saving Space by Compressing Pictures in a Document |
|
|
135 | (1) |
|
|
|
136 | (4) |
|
Arranging Graphical Objects |
|
|
140 | (2) |
|
Arranging Graphical Objects Using the Arrange Commands |
|
|
140 | (1) |
|
Rearranging Graphical Objects by Dragging |
|
|
141 | (1) |
|
|
|
142 | (1) |
|
Chapter 5 Customizing Office to Suit You |
|
|
143 | (20) |
|
Customizing the Status Bar |
|
|
143 | (7) |
|
Customizing the Status Bar in Word |
|
|
144 | (2) |
|
Customizing the Status Bar in Excel |
|
|
146 | (2) |
|
Customizing the Status Bar in PowerPoint |
|
|
148 | (2) |
|
Creating Custom Keyboard Shortcuts |
|
|
150 | (5) |
|
Creating Custom Keyboard Shortcuts in Word |
|
|
150 | (3) |
|
Creating Keyboard Shortcuts for Excel, PowerPoint, and Outlook |
|
|
153 | (2) |
|
Choosing Essential Preferences in Word, Excel, and PowerPoint |
|
|
155 | (7) |
|
Opening the Preferences Window |
|
|
155 | (2) |
|
Setting Your User Name, Initials, and Address |
|
|
157 | (1) |
|
Choosing Whether to Display the Gallery Dialog Box When the App Opens |
|
|
158 | (1) |
|
Choosing Whether to Receive Feedback with Sound |
|
|
158 | (1) |
|
Choosing Whether to Confirm Launching Other Apps |
|
|
158 | (1) |
|
Choosing the Default Format for Saving Documents |
|
|
159 | (2) |
|
Setting AutoRecover to Keep Backups of Your Documents for Safety |
|
|
161 | (1) |
|
|
|
162 | (1) |
| Part 2: Creating Documents with Microsoft Word |
|
163 | (158) |
|
Chapter 6 Entering Text and Using Views |
|
|
165 | (22) |
|
Entering Text in Your Word Documents |
|
|
165 | (6) |
|
Inserting Text from One Document to Another |
|
|
166 | (2) |
|
Inserting Prebuilt Blocks of Text with AutoText |
|
|
168 | (3) |
|
Selecting Text in Word-Specific Ways |
|
|
171 | (2) |
|
Selecting Text with the Pointing Device |
|
|
171 | (1) |
|
Selecting Text with the Extend Selection Feature |
|
|
172 | (1) |
|
Selecting Multiple Items at Once |
|
|
173 | (1) |
|
Moving with Keyboard Shortcuts |
|
|
173 | (1) |
|
Moving with the Go To Feature |
|
|
173 | (2) |
|
Telling Word Where to Find Your Templates |
|
|
175 | (2) |
|
Creating Backup Documents and Recovering from Disaster |
|
|
177 | (1) |
|
Using Views and Windows to See What You Need |
|
|
178 | (7) |
|
Picking the Right View for What You're Doing |
|
|
178 | (5) |
|
|
|
183 | (1) |
|
Splitting the Document Window into Two Panes |
|
|
184 | (1) |
|
|
|
185 | (2) |
|
Chapter 7 Formatting Your Documents Swiftly and Easily |
|
|
187 | (38) |
|
Understanding Word's Many Types of Formatting |
|
|
187 | (2) |
|
Understanding Direct Formatting and When to Use It |
|
|
187 | (1) |
|
Understanding Styles and When to Use Them |
|
|
188 | (1) |
|
Formatting Your Documents the Best Way |
|
|
189 | (1) |
|
Applying Styles to a Document |
|
|
190 | (9) |
|
Applying Styles from the Quick Style Box and Quick Style Panel on the Ribbon |
|
|
190 | (1) |
|
Applying Styles with the Styles Pane |
|
|
191 | (4) |
|
Applying Styles Using the Style Dialog Box |
|
|
195 | (1) |
|
Changing the Styles in the Quick Style Gallery |
|
|
196 | (2) |
|
Applying Styles Using the Keyboard |
|
|
198 | (1) |
|
See Which Styles a Document Uses |
|
|
198 | (1) |
|
|
|
199 | (12) |
|
Creating a Custom Style by Example |
|
|
199 | (11) |
|
Modifying an Existing Style |
|
|
210 | (1) |
|
Applying Direct Formatting on Top of Styles |
|
|
211 | (2) |
|
Copying and Pasting Formatting Using the Format Painter |
|
|
212 | (1) |
|
Navigating Quickly Around Your Documents |
|
|
213 | (11) |
|
|
|
213 | (1) |
|
|
|
214 | (8) |
|
Replacing Text, Formatting, and Styles |
|
|
222 | (2) |
|
|
|
224 | (1) |
|
Chapter 8 Creating Complex Documents and Layouts |
|
|
225 | (38) |
|
Working with Word's Extra Table Features |
|
|
225 | (5) |
|
Converting Existing Text into a Table |
|
|
226 | (2) |
|
Converting a Table to Text |
|
|
228 | (1) |
|
Nesting One Table Inside Another Table |
|
|
229 | (1) |
|
Creating Complex Documents with Multiple Sections |
|
|
230 | (2) |
|
Adding Headers, Footers, and Page Numbers |
|
|
232 | (7) |
|
Adding Headers and Footers to a Document |
|
|
232 | (4) |
|
Inserting Page Numbers in a Document |
|
|
236 | (3) |
|
Creating Newspaper-Style Columns of Text |
|
|
239 | (3) |
|
Breaking Your Columns with Column Breaks |
|
|
241 | (1) |
|
Removing Multiple Columns from a Section or Document |
|
|
242 | (1) |
|
Using Bookmarks, Fields, and References |
|
|
242 | (9) |
|
Marking Important Parts of a Document with Bookmarks |
|
|
242 | (3) |
|
Inserting Automated Information with Fields |
|
|
245 | (3) |
|
Adding Cross-References to Other Parts of a Document |
|
|
248 | (3) |
|
Creating Long Documents with Outline View |
|
|
251 | (5) |
|
|
|
251 | (1) |
|
Developing the Outline of a Document |
|
|
251 | (2) |
|
Promoting and Demoting Headings |
|
|
253 | (1) |
|
Expanding and Collapsing the Outline and Headings |
|
|
253 | (2) |
|
Moving Paragraphs Up and Down the Document |
|
|
255 | (1) |
|
Switching from Outline View to Another View |
|
|
255 | (1) |
|
Adding Footnotes and Endnotes |
|
|
256 | (6) |
|
|
|
256 | (2) |
|
|
|
258 | (1) |
|
Customizing Footnotes and Endnotes to Suit Your Document |
|
|
259 | (1) |
|
Converting Footnotes to Endnotes or Endnotes to Footnotes |
|
|
260 | (1) |
|
Navigating Among and Viewing Footnotes or Endnotes |
|
|
261 | (1) |
|
|
|
262 | (1) |
|
Chapter 9 Creating Business Documents with Mail Merge |
|
|
263 | (18) |
|
Understanding How Mail Merge Works |
|
|
263 | (2) |
|
Creating the Main Document for the Mail Merge |
|
|
265 | (2) |
|
Selecting the Recipients for the Mail Merge |
|
|
267 | (5) |
|
Creating a New List in Word |
|
|
267 | (4) |
|
|
|
271 | (1) |
|
Using Contacts from Your Outlook Contacts |
|
|
271 | (1) |
|
Using Contacts from Your OS X Contacts |
|
|
271 | (1) |
|
Using Data from a FileMaker Pro Database |
|
|
271 | (1) |
|
Inserting Merge Fields in Your Main Document |
|
|
272 | (2) |
|
Previewing the Results of the Mail Merge |
|
|
274 | (1) |
|
Completing the Mail Merge |
|
|
275 | (3) |
|
Merging to a New Document |
|
|
276 | (1) |
|
Merging Individual Documents to a Printer |
|
|
276 | (1) |
|
Merging to E-mail Messages |
|
|
277 | (1) |
|
Restoring a Mail Merge Main Document to a Normal Document |
|
|
278 | (1) |
|
|
|
279 | (2) |
|
Chapter 10 Revising and Reviewing Documents |
|
|
281 | (26) |
|
Working on Documents with Your Colleagues |
|
|
281 | (1) |
|
Editing a Document Simultaneously with Your Colleagues |
|
|
282 | (4) |
|
Sharing Documents with Your Colleagues on a Network |
|
|
286 | (2) |
|
Tracking the Changes in a Document |
|
|
288 | (11) |
|
Choosing Which Changes to Track |
|
|
288 | (3) |
|
Turning On Track Changes for a Document |
|
|
291 | (1) |
|
Ensuring Your Colleagues Use the Track Changes Feature |
|
|
292 | (1) |
|
Working in a Document with Track Changes On |
|
|
293 | (2) |
|
Choosing How to View the Document's Changes and Markup |
|
|
295 | (1) |
|
Controlling Which Changes Word Displays |
|
|
295 | (2) |
|
Integrating Tracked Changes into a Document |
|
|
297 | (2) |
|
Adding Comments to a Document |
|
|
299 | (4) |
|
|
|
299 | (2) |
|
Viewing and Reviewing Comments |
|
|
301 | (1) |
|
|
|
302 | (1) |
|
Comparing or Combining Different Versions of the Same Document |
|
|
303 | (3) |
|
|
|
306 | (1) |
|
Chapter 11 Printing, Securing, and Sharing Documents |
|
|
307 | (14) |
|
Using Word's Features for Printing Documents |
|
|
307 | (4) |
|
Printing a Custom Range of Pages |
|
|
307 | (2) |
|
Printing Markup and Other Items |
|
|
309 | (2) |
|
|
|
311 | (6) |
|
Setting Word to Warn You About Tracked Changes or Comments |
|
|
311 | (2) |
|
Protecting a Document with a Password |
|
|
313 | (3) |
|
Removing Sensitive Information from a Document |
|
|
316 | (1) |
|
Marking a Document As Read-Only |
|
|
316 | (1) |
|
Making a Document You Can Open with Earlier Versions of Word |
|
|
317 | (2) |
|
Creating PDF Documents for Digital Distribution |
|
|
319 | (1) |
|
|
|
319 | (2) |
| Part 3: Analyzing Data with Microsoft Excel |
|
321 | (200) |
|
Chapter 12 Creating Workbooks and Entering Data |
|
|
323 | (30) |
|
Creating and Saving a New Workbook |
|
|
323 | (3) |
|
|
|
323 | (2) |
|
|
|
325 | (1) |
|
Navigating the Excel Interface, Worksheets, and Workbooks |
|
|
326 | (4) |
|
Understanding Workbooks, Worksheets, Columns, and Rows |
|
|
328 | (1) |
|
|
|
328 | (1) |
|
Selecting and Manipulating Cells |
|
|
329 | (1) |
|
Enter Data in Your Worksheets |
|
|
330 | (12) |
|
|
|
331 | (1) |
|
|
|
331 | (2) |
|
Entering Data Quickly Using AutoFill |
|
|
333 | (4) |
|
Pasting Data into a Worksheet |
|
|
337 | (4) |
|
Copying and Moving Data with Drag and Drop |
|
|
341 | (1) |
|
Inserting, Deleting, and Rearranging Worksheets |
|
|
342 | (3) |
|
Inserting and Deleting Worksheets |
|
|
342 | (1) |
|
Rearranging the Worksheets in a Workbook |
|
|
343 | (2) |
|
Making Excel Display Worksheets the Way You Need |
|
|
345 | (6) |
|
Understanding Excel's Views |
|
|
345 | (1) |
|
Splitting the Window to View Separate Parts of a Worksheet |
|
|
346 | (1) |
|
Opening Extra Windows to Show Other Parts of a Workbook |
|
|
347 | (1) |
|
Changing the Window and Arranging Open Windows |
|
|
347 | (2) |
|
Zooming to Show the Data You Need to See |
|
|
349 | (1) |
|
Freezing Rows and Columns So That They Stay On-Screen |
|
|
350 | (1) |
|
|
|
351 | (2) |
|
Chapter 13 Formatting Your Worksheets |
|
|
353 | (40) |
|
Working with Rows and Columns |
|
|
353 | (6) |
|
Inserting and Deleting Rows, Columns, and Cells |
|
|
353 | (3) |
|
|
|
356 | (1) |
|
|
|
357 | (1) |
|
|
|
358 | (1) |
|
Formatting Cells and Ranges |
|
|
359 | (4) |
|
Understanding the Two Main Tools for Applying Formatting |
|
|
359 | (1) |
|
Controlling How Data Appears by Applying Number Formatting |
|
|
360 | (3) |
|
Understanding How Excel Stores Dates and Times |
|
|
363 | (5) |
|
Setting the Workbook's Overall Look by Applying a Theme |
|
|
363 | (1) |
|
|
|
363 | (2) |
|
|
|
365 | (1) |
|
Applying Borders and Fills |
|
|
366 | (2) |
|
Applying Protection to Cells |
|
|
368 | (1) |
|
Applying Conditional Formatting to Identify Particular Values |
|
|
368 | (3) |
|
Understanding Excel's Preset Types of Conditional Formatting |
|
|
369 | (1) |
|
Applying a Preset Form of Conditional Formatting |
|
|
370 | (1) |
|
Using Data Validation to Check for Invalid Entries |
|
|
371 | (4) |
|
Formatting Quickly with Table Formatting and Styles |
|
|
375 | (6) |
|
Formatting with Table Formatting |
|
|
376 | (1) |
|
|
|
376 | (5) |
|
Adding Headers and Footers to Your Worksheets |
|
|
381 | (2) |
|
Printing Your Excel Worksheets and Workbooks |
|
|
383 | (3) |
|
Telling Excel Which Part of the Worksheet to Print |
|
|
383 | (1) |
|
Checking the Page Layout and Where the Page Breaks Fall |
|
|
384 | (1) |
|
Printing a Worksheet or Workbook |
|
|
385 | (1) |
|
Sharing Your Workbooks with Your Colleagues |
|
|
386 | (6) |
|
Protecting a Workbook or Some of Its Worksheets |
|
|
386 | (2) |
|
Sharing a Workbook So That Your Colleagues Can Edit It |
|
|
388 | (2) |
|
Working in a Shared Workbook |
|
|
390 | (1) |
|
Resolving Conflicts in a Shared Workbook |
|
|
391 | (1) |
|
|
|
392 | (1) |
|
Chapter 14 Creating Powerful and Persuasive Charts |
|
|
393 | (36) |
|
Learning the Essentials of Charts in Excel |
|
|
393 | (6) |
|
Understanding Embedded Charts and Chart Sheets |
|
|
394 | (1) |
|
Understanding the Components of a Chart |
|
|
395 | (3) |
|
Understanding Excel's Chart Types and Choosing Which to Use |
|
|
398 | (1) |
|
Creating, Laying Out, and Formatting a Chart |
|
|
399 | (23) |
|
|
|
399 | (2) |
|
Changing a Chart from an Embedded Chart to a Chart Sheet |
|
|
401 | (1) |
|
|
|
402 | (1) |
|
Switching the Rows and Columns in a Chart |
|
|
402 | (1) |
|
Changing the Source Data for a Chart |
|
|
402 | (2) |
|
Choosing the Layout for the Chart |
|
|
404 | (1) |
|
Adding a Separate Data Series to a Chart |
|
|
404 | (1) |
|
Applying a Style to a Chart |
|
|
405 | (1) |
|
Adding a Title to a Chart |
|
|
406 | (2) |
|
Adding Axis Titles to the Chart |
|
|
408 | (1) |
|
Changing the Scale or Numbering of an Axis |
|
|
408 | (6) |
|
Adding a Legend to a Chart |
|
|
414 | (1) |
|
Adding Axis Labels from a Range Separate from the Chart Data |
|
|
415 | (1) |
|
Adding Data Labels to the Chart |
|
|
415 | (2) |
|
Choosing Which Gridlines to Display |
|
|
417 | (1) |
|
Formatting a Chart Wall and Chart Floor |
|
|
418 | (3) |
|
Formatting Individual Chart Elements |
|
|
421 | (1) |
|
Copying a Chart's Formatting to Another Chart |
|
|
422 | (1) |
|
Reusing Your Own Designs by Creating Custom Chart Types |
|
|
422 | (1) |
|
Adding Sparklines to Your Worksheets |
|
|
423 | (4) |
|
|
|
424 | (1) |
|
Formatting Your Sparklines |
|
|
425 | (2) |
|
|
|
427 | (2) |
|
Chapter 15 Crunching Numbers with Formulas and Functions |
|
|
429 | (32) |
|
Understanding the Difference Between Formulas and Functions |
|
|
429 | (1) |
|
Referring to Cells and Ranges in Formulas and Functions |
|
|
430 | (4) |
|
|
|
430 | (1) |
|
|
|
431 | (2) |
|
Referring to Named Cells and Ranges |
|
|
433 | (1) |
|
Performing Custom Calculations by Creating Formulas |
|
|
434 | (8) |
|
Meeting Excel's Calculation Operators |
|
|
434 | (2) |
|
Using the Calculation Operators |
|
|
436 | (3) |
|
Understanding the Order in Which Excel Evaluates Operators |
|
|
439 | (1) |
|
Nesting Parts of Formulas to Control Operator Precedence |
|
|
440 | (1) |
|
Breaking Up a Complex Formula into Separate Steps |
|
|
440 | (1) |
|
Entering Formulas Quickly by Copying and Using AutoFill |
|
|
441 | (1) |
|
Choosing Preferences for Error Checking |
|
|
442 | (8) |
|
Troubleshooting Common Problems with Formulas |
|
|
444 | (6) |
|
Performing Standard Calculations by Inserting Functions |
|
|
450 | (9) |
|
Understanding Function Names and Arguments |
|
|
450 | (2) |
|
Inserting Functions with the AutoSum Pop-up Menu |
|
|
452 | (1) |
|
Inserting Functions with the Formula Builder |
|
|
453 | (4) |
|
Inserting Functions with the Function Library Pop-up Menus |
|
|
457 | (1) |
|
Inserting Functions by Typing Them into a Worksheet |
|
|
458 | (1) |
|
|
|
459 | (2) |
|
Chapter 16 Creating Simple Databases and Solving Business Problems |
|
|
461 | (28) |
|
Creating Databases in Excel |
|
|
461 | (14) |
|
Understanding What You Can and Can't Do with Excel Database Tables |
|
|
462 | (1) |
|
Creating a Database Table and Entering Data |
|
|
463 | (4) |
|
Resizing a Database Table |
|
|
467 | (1) |
|
Sorting a Database Table by One or More Fields |
|
|
468 | (3) |
|
Identifying and Removing Duplicate Records in a Database Table |
|
|
471 | (1) |
|
Filtering a Database Table |
|
|
472 | (3) |
|
Solving Business Problems with Scenarios and Goal Seek |
|
|
475 | (12) |
|
Examining Different Scenarios in a Worksheet |
|
|
475 | (10) |
|
|
|
485 | (2) |
|
|
|
487 | (2) |
|
Chapter 17 Manipulating Data with PivotTables |
|
|
489 | (32) |
|
Understanding What PivotTables Are and What You Can Do with Them |
|
|
489 | (2) |
|
Creating and Laying Out a PivotTable |
|
|
491 | (15) |
|
Creating a PivotTable Automatically |
|
|
491 | (2) |
|
Creating a PivotTable Manually |
|
|
493 | (7) |
|
Changing the PivotTable to Show Different Data |
|
|
500 | (4) |
|
Changing the Function Used to Summarize a Field |
|
|
504 | (2) |
|
Controlling the Design of a PivotTable |
|
|
506 | (2) |
|
|
|
508 | (1) |
|
Applying a PivotTable Style |
|
|
508 | (1) |
|
Choosing Options for a PivotTable Style |
|
|
508 | (1) |
|
Naming a PivotTable and Setting Options for It |
|
|
509 | (7) |
|
Choosing Display Options for a PivotTable |
|
|
510 | (2) |
|
Choosing Layout Options for a PivotTable |
|
|
512 | (1) |
|
Choosing Data Options for a PivotTable |
|
|
513 | (2) |
|
Refreshing the Data in a PivotTable |
|
|
515 | (1) |
|
Changing the Source of a PivotTable |
|
|
516 | (1) |
|
Sorting and Filtering a PivotTable |
|
|
516 | (4) |
|
|
|
520 | (1) |
| Part 4: Creating Presentations with Microsoft PowerPoint |
|
521 | (96) |
|
Chapter 18 Starting to Build a Presentation in PowerPoint |
|
|
523 | (24) |
|
|
|
524 | (1) |
|
Changing a Presentation's Theme, Fonts, or Colors |
|
|
525 | (3) |
|
Changing the Slide Size or Orientation |
|
|
528 | (2) |
|
Navigating the PowerPoint Window |
|
|
530 | (1) |
|
|
|
531 | (1) |
|
Adding, Deleting, and Rearranging Slides |
|
|
532 | (3) |
|
|
|
532 | (2) |
|
|
|
534 | (1) |
|
|
|
535 | (1) |
|
Using Views to Work on Your Presentation |
|
|
535 | (5) |
|
Creating Your Slides in Normal View |
|
|
536 | (1) |
|
Developing Your Presentation's Outline in Outline View |
|
|
536 | (1) |
|
Rearranging Your Slides in Slide Sorter View |
|
|
537 | (2) |
|
Creating Notes Pages in Notes Page View |
|
|
539 | (1) |
|
Running a Presentation in Slide Show View |
|
|
540 | (1) |
|
Opening Extra Windows to See Different Parts of the Presentation |
|
|
540 | (1) |
|
Organizing Your Slides into Sections |
|
|
540 | (2) |
|
Editing a Presentation Simultaneously with Your Colleagues |
|
|
542 | (3) |
|
|
|
545 | (2) |
|
Chapter 19 Creating Clear and Compelling Slides |
|
|
547 | (26) |
|
Planning the Slides in Your Presentation |
|
|
547 | (2) |
|
Choosing Slide Layouts to Suit the Contents |
|
|
549 | (1) |
|
Using PowerPoint's Built-in Slide Layouts |
|
|
549 | (1) |
|
Creating Custom Slide Layouts |
|
|
550 | (1) |
|
Formatting Text on Your Slides |
|
|
550 | (9) |
|
Changing the Font, Font Size, and Alignment |
|
|
551 | (2) |
|
Changing the Indentation and Line Spacing of Text |
|
|
553 | (1) |
|
|
|
554 | (2) |
|
|
|
556 | (3) |
|
Adding Tables, SmartArt, Charts, and Hyperlinks to Slides |
|
|
559 | (12) |
|
|
|
560 | (4) |
|
Adding SmartArt Graphics to Slides |
|
|
564 | (1) |
|
|
|
565 | (4) |
|
Adding Hyperlinks to Slides |
|
|
569 | (2) |
|
|
|
571 | (2) |
|
Chapter 20 Adding Life and Interest to Your Presentation |
|
|
573 | (26) |
|
Adding Pictures to a Presentation |
|
|
573 | (2) |
|
Adding Movies and Sounds to a Presentation |
|
|
575 | (6) |
|
Adding a Movie to a Slide |
|
|
575 | (3) |
|
Adding a Sound to a Slide |
|
|
578 | (3) |
|
Adding Transitions to Slides |
|
|
581 | (3) |
|
Adding Animations to Slides |
|
|
584 | (9) |
|
Understanding the Essentials of Animations |
|
|
584 | (1) |
|
Adding an Animation to an Object |
|
|
585 | (2) |
|
Changing the Order of Animations |
|
|
587 | (1) |
|
Using Animation to Display Bulleted Paragraphs One at a Time |
|
|
588 | (2) |
|
Animating SmartArt Graphics, Charts, and Tables |
|
|
590 | (3) |
|
Keeping Extra Information up Your Sleeve with Hidden Slides |
|
|
593 | (1) |
|
Creating Custom Slide Shows Within a Presentation |
|
|
594 | (3) |
|
Opening the Custom Shows Dialog Box |
|
|
595 | (1) |
|
Creating a Custom Slide Show |
|
|
595 | (2) |
|
Playing a Custom Slide Show |
|
|
597 | (1) |
|
Editing or Deleting a Custom Slide Show |
|
|
597 | (1) |
|
|
|
597 | (2) |
|
Chapter 21 Delivering a Presentation Live or Online |
|
|
599 | (18) |
|
Getting Ready to Deliver a Presentation in Person |
|
|
599 | (7) |
|
Setting Up Your Display and Choosing the Resolution |
|
|
600 | (2) |
|
|
|
602 | (3) |
|
Practicing Your Presentation |
|
|
605 | (1) |
|
Rehearsing Timings for Slides |
|
|
605 | (1) |
|
Delivering a Presentation to a Live Audience |
|
|
606 | (4) |
|
|
|
606 | (1) |
|
Displaying the Slides You Need |
|
|
607 | (1) |
|
|
|
608 | (1) |
|
Controlling a Presentation Using the Keyboard |
|
|
609 | (1) |
|
Displaying a White Screen or Black Screen |
|
|
610 | (1) |
|
Creating a Handout for a Presentation |
|
|
610 | (3) |
|
Recording Narration into a Presentation |
|
|
613 | (2) |
|
Exporting and Sharing a Presentation |
|
|
615 | (1) |
|
|
|
616 | (1) |
| Part 5: E-Mailing and Organizing with Outlook |
|
617 | (86) |
|
Chapter 22 Using E-mail Effectively |
|
|
619 | (42) |
|
|
|
620 | (10) |
|
|
|
620 | (1) |
|
Going Through the Welcome to Outlook Routine |
|
|
620 | (1) |
|
Adding an E-mail Account to Outlook |
|
|
621 | (8) |
|
Importing an Existing E-mail Account |
|
|
629 | (1) |
|
Meeting the Outlook Interface |
|
|
630 | (9) |
|
Using the Quick Access Toolbar, Ribbon, and Menu Bar |
|
|
631 | (1) |
|
Using the Navigation Pane |
|
|
631 | (1) |
|
|
|
632 | (1) |
|
Using and Customizing the Message List and Reading Pane |
|
|
633 | (3) |
|
Using and Customizing the Reading Pane |
|
|
636 | (3) |
|
Sending and Receiving Messages |
|
|
639 | (9) |
|
Sending an E-mail Message |
|
|
639 | (8) |
|
Receiving and Reading Messages |
|
|
647 | (1) |
|
Sending and Receiving Attachments |
|
|
648 | (3) |
|
Sending a File as an Attachment |
|
|
649 | (1) |
|
Receiving a File as an Attachment |
|
|
649 | (2) |
|
Replying to and Forwarding Messages |
|
|
651 | (2) |
|
Deleting, Storing, and Organizing Messages |
|
|
653 | (1) |
|
Moving a Message to a Mail Folder |
|
|
653 | (1) |
|
Creating a New Mail Folder |
|
|
654 | (1) |
|
Adding Consistent Closings to Your Messages with Signatures |
|
|
654 | (2) |
|
|
|
656 | (3) |
|
Removing Nonspam Messages from the Junk E-Mail Folder |
|
|
657 | (1) |
|
Marking Spam Messages as Junk |
|
|
657 | (1) |
|
Creating a List of Safe Senders and Domains for E-Mail |
|
|
657 | (1) |
|
Removing Senders You've Blocked by Mistake |
|
|
658 | (1) |
|
|
|
659 | (2) |
|
Chapter 23 Keeping Your Contacts in Order |
|
|
661 | (16) |
|
|
|
661 | (12) |
|
Creating a Contact from Scratch |
|
|
661 | (6) |
|
Importing Contacts from Other Address Books |
|
|
667 | (6) |
|
|
|
673 | (3) |
|
|
|
673 | (1) |
|
|
|
674 | (1) |
|
|
|
674 | (1) |
|
Editing Contact Information |
|
|
675 | (1) |
|
Communicating with Your Contacts |
|
|
675 | (1) |
|
|
|
676 | (1) |
|
Chapter 24 Managing Your Calendar |
|
|
677 | (14) |
|
Meeting the Calendar Interface |
|
|
677 | (4) |
|
Displaying the Dates You Want |
|
|
679 | (1) |
|
Customizing the Calendar Settings |
|
|
679 | (2) |
|
Understanding Appointments, Events, and Meetings |
|
|
681 | (1) |
|
Creating Appointments and Events |
|
|
681 | (5) |
|
Creating One-Time Appointments |
|
|
682 | (2) |
|
Creating Repeating Appointments |
|
|
684 | (2) |
|
|
|
686 | (4) |
|
|
|
686 | (2) |
|
Tracking the Status of Meeting Invitations You've Sent |
|
|
688 | (1) |
|
Dealing with Invitations to Meetings |
|
|
689 | (1) |
|
|
|
690 | (1) |
|
Chapter 25 Working with Tasks and Notes |
|
|
691 | (12) |
|
|
|
691 | (8) |
|
Meeting the Tasks Interface |
|
|
691 | (1) |
|
|
|
692 | (2) |
|
|
|
694 | (2) |
|
Viewing, Arranging, and Filtering the Task List |
|
|
696 | (1) |
|
|
|
697 | (2) |
|
|
|
699 | (3) |
|
Meeting the Notes Interface |
|
|
699 | (1) |
|
|
|
700 | (1) |
|
Editing and Using Your Notes |
|
|
701 | (1) |
|
|
|
702 | (1) |
| Index |
|
703 | |
