Introduction |
|
1 | (6) |
|
|
1 | (1) |
|
What's in This Book, Anyway? |
|
|
2 | (1) |
|
What Makes This Book Different |
|
|
3 | (1) |
|
Easy-to-look-up information |
|
|
3 | (1) |
|
|
3 | (1) |
|
|
3 | (1) |
|
|
4 | (1) |
|
Conventions Used in This Book |
|
|
4 | (1) |
|
|
5 | (1) |
|
|
5 | (2) |
|
Book I Common Office Tools |
|
|
7 | (180) |
|
Chapter 1 Office Nuts and Bolts |
|
|
9 | (24) |
|
A Survey of Office 2010 Home and Student Programs |
|
|
9 | (1) |
|
Starting an Office Program |
|
|
10 | (3) |
|
Finding Your Way around the Office Interface |
|
|
13 | (7) |
|
|
13 | (1) |
|
|
13 | (1) |
|
|
14 | (1) |
|
|
15 | (1) |
|
|
16 | (2) |
|
|
18 | (1) |
|
|
19 | (1) |
|
Office 2010 for keyboard lovers |
|
|
19 | (1) |
|
|
20 | (5) |
|
|
20 | (1) |
|
Saving a file for the first time |
|
|
20 | (1) |
|
Declaring where you like to save files |
|
|
21 | (1) |
|
Saving files for use in earlier versions of an Office program |
|
|
21 | (3) |
|
Saving AutoRecovery information |
|
|
24 | (1) |
|
Navigating the Save As and Open Dialog Boxes |
|
|
25 | (1) |
|
Opening and Closing Files |
|
|
26 | (2) |
|
|
26 | (2) |
|
|
28 | (1) |
|
Reading and Recording File Properties |
|
|
28 | (1) |
|
Locking a File with a Password |
|
|
29 | (4) |
|
Password-protecting a file |
|
|
29 | (2) |
|
Removing a password from a file |
|
|
31 | (2) |
|
Chapter 2 Wrestling with the Text |
|
|
33 | (26) |
|
|
33 | (3) |
|
|
33 | (2) |
|
|
35 | (1) |
|
Taking advantage of the Clipboard task pane |
|
|
35 | (1) |
|
|
36 | (1) |
|
Changing the Look of Text |
|
|
36 | (6) |
|
|
38 | (1) |
|
Changing the font size of text |
|
|
39 | (1) |
|
Applying font styles to text |
|
|
39 | (1) |
|
Applying text effects to text |
|
|
40 | (1) |
|
|
41 | (1) |
|
Changing the color of text |
|
|
42 | (1) |
|
Quick Ways to Handle Case, or Capitalization |
|
|
42 | (2) |
|
Entering Symbols and Foreign Characters |
|
|
44 | (1) |
|
Finding and Replacing Text |
|
|
45 | (8) |
|
The basics: Finding stray words and phrases |
|
|
45 | (2) |
|
|
47 | (4) |
|
Conducting a find-and-replace operation |
|
|
51 | (2) |
|
|
53 | (6) |
|
Linking a hyperlink to a Web page |
|
|
53 | (1) |
|
Creating a hyperlink to another place in your file |
|
|
54 | (2) |
|
Creating an e-mail hyperlink |
|
|
56 | (1) |
|
Repairing and removing hyperlinks |
|
|
56 | (3) |
|
Chapter 3 Speed Techniques Worth Knowing About |
|
|
59 | (8) |
|
Undoing and Repeating Commands |
|
|
59 | (2) |
|
|
59 | (1) |
|
Repeating an action---and quicker this time |
|
|
60 | (1) |
|
|
61 | (1) |
|
Viewing a File through More Than One Window |
|
|
62 | (1) |
|
Correcting Typos on the Fly |
|
|
62 | (5) |
|
Opening the AutoCorrect dialog box |
|
|
63 | (2) |
|
Telling Office which typos and misspellings to correct |
|
|
65 | (1) |
|
Preventing capitalization errors with AutoCorrect |
|
|
65 | (2) |
|
Chapter 4 Taking Advantage of the Proofing Tools |
|
|
67 | (16) |
|
Correcting Your Spelling Errors |
|
|
67 | (6) |
|
Correcting misspellings one at a time |
|
|
68 | (1) |
|
|
68 | (2) |
|
Fine-tuning the spell checker |
|
|
70 | (3) |
|
Checking for Grammatical Errors in Word |
|
|
73 | (1) |
|
Researching a Topic inside an Office Program |
|
|
74 | (3) |
|
Looking at the research services |
|
|
75 | (1) |
|
Using the Research task pane |
|
|
76 | (1) |
|
Choosing your research options |
|
|
77 | (1) |
|
Finding the Right Word with the Thesaurus |
|
|
77 | (2) |
|
Proofing Text Written in a Foreign Language |
|
|
79 | (4) |
|
Telling Office which languages you will use |
|
|
79 | (1) |
|
Marking text as foreign language text |
|
|
80 | (3) |
|
Chapter 5 Creating a Table |
|
|
83 | (20) |
|
|
83 | (1) |
|
|
84 | (2) |
|
Entering the Text and Numbers |
|
|
86 | (1) |
|
Selecting Different Parts of a Table |
|
|
86 | (1) |
|
Aligning Text in Columns and Rows |
|
|
87 | (1) |
|
Merging and Splitting Cells |
|
|
87 | (1) |
|
|
88 | (3) |
|
Changing the size of a table, column, or rows |
|
|
89 | (1) |
|
Adjusting column and row size |
|
|
89 | (1) |
|
Inserting and deleting columns and rows |
|
|
90 | (1) |
|
|
91 | (1) |
|
|
91 | (4) |
|
Designing a table with a table style |
|
|
91 | (1) |
|
Calling attention to different rows and columns |
|
|
92 | (1) |
|
Decorating your table with borders and colors |
|
|
93 | (2) |
|
Using Math Formulas in Word Tables |
|
|
95 | (1) |
|
|
96 | (7) |
|
Changing the direction of header row text |
|
|
96 | (1) |
|
Using a picture as the table background |
|
|
97 | (2) |
|
Drawing diagonal lines on tables |
|
|
99 | (2) |
|
|
101 | (2) |
|
Chapter 6 Creating a Chart |
|
|
103 | (38) |
|
A Mercifully Brief Anatomy Lesson |
|
|
103 | (2) |
|
The Basics: Creating a Chart |
|
|
105 | (2) |
|
|
107 | (17) |
|
Ground rules for choosing a chart |
|
|
108 | (1) |
|
Examining the different kinds of charts |
|
|
108 | (16) |
|
Providing the Raw Data for Your Chart |
|
|
124 | (1) |
|
Positioning Your Chart in a Workbook, Page, or Slide |
|
|
124 | (1) |
|
Changing a Chart's Appearance |
|
|
125 | (8) |
|
|
126 | (1) |
|
Changing the size and shape of a chart |
|
|
126 | (1) |
|
Relying on a chart style to change appearances |
|
|
126 | (1) |
|
Changing the layout of a chart |
|
|
127 | (3) |
|
|
130 | (2) |
|
Changing a chart element's color, font, or other particular |
|
|
132 | (1) |
|
Saving a Chart as a Template So That You Can Use It Again |
|
|
133 | (1) |
|
Saving a chart as a template |
|
|
134 | (1) |
|
Creating a chart from a template |
|
|
134 | (1) |
|
Chart Tricks for the Daring and Heroic |
|
|
134 | (4) |
|
Decorating a chart with a picture |
|
|
135 | (1) |
|
Displaying the raw data alongside the chart |
|
|
136 | (1) |
|
Creating an overlay chart |
|
|
136 | (1) |
|
Placing a trendline on a chart |
|
|
137 | (1) |
|
|
138 | (3) |
|
Chapter 7 Making a SmartArt Diagram |
|
|
141 | (18) |
|
The Basics: Creating SmartArt Diagrams |
|
|
141 | (2) |
|
|
141 | (2) |
|
Making the diagram your own |
|
|
143 | (1) |
|
Creating the Initial Diagram |
|
|
143 | (2) |
|
|
144 | (1) |
|
Swapping one diagram for another |
|
|
144 | (1) |
|
Changing the Size and Position of a Diagram |
|
|
145 | (1) |
|
Laying Out the Diagram Shapes |
|
|
145 | (6) |
|
Selecting a diagram shape |
|
|
146 | (1) |
|
Removing a shape from a diagram |
|
|
146 | (1) |
|
Moving diagram shapes to different positions |
|
|
146 | (1) |
|
Adding shapes to diagrams apart from hierarchy diagrams |
|
|
147 | (1) |
|
Adding shapes to hierarchy diagrams |
|
|
148 | (1) |
|
Adding shapes to Organization charts |
|
|
149 | (2) |
|
Promoting and demoting shapes in hierarchy diagrams |
|
|
151 | (1) |
|
Handling the Text on Diagram Shapes |
|
|
151 | (2) |
|
Entering text on a diagram shape |
|
|
151 | (1) |
|
Entering bulleted lists on diagram shapes |
|
|
152 | (1) |
|
Changing a Diagram's Direction |
|
|
153 | (1) |
|
Choosing a Look for Your Diagram |
|
|
154 | (1) |
|
Changing the Appearance of Diagram Shapes |
|
|
155 | (4) |
|
Changing the size of a diagram shape |
|
|
155 | (1) |
|
Exchanging one shape for another |
|
|
156 | (1) |
|
Changing a shape's color, fill, or outline |
|
|
156 | (2) |
|
Changing fonts and font sizes on shapes |
|
|
158 | (1) |
|
Chapter 8 Drawing and Manipulating Lines, Shapes, and Other Objects |
|
|
159 | (28) |
|
The Basics: Drawing Lines, Arrows, and Shapes |
|
|
160 | (1) |
|
Handling Lines, Arrows, and Connectors |
|
|
161 | (4) |
|
Changing the length and position of a line or arrow |
|
|
161 | (1) |
|
Changing the appearance of a line, arrow, or connector |
|
|
162 | (1) |
|
Attaching and handling arrowheads on lines and connectors |
|
|
163 | (1) |
|
Attaching and handling arrowConnecting shapes by using connectors |
|
|
164 | (1) |
|
Handling Rectangles, Ovals, Stars, and Other Shapes |
|
|
165 | (4) |
|
|
166 | (1) |
|
Changing a shape's symmetry |
|
|
167 | (1) |
|
Using a shape as a text box |
|
|
167 | (2) |
|
WordArt for Bending, Spindling, and Multilating Text |
|
|
169 | (1) |
|
|
169 | (1) |
|
|
169 | (1) |
|
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects |
|
|
170 | (12) |
|
Selecting objects so that you can manipulate them |
|
|
172 | (1) |
|
Hiding and displaying the rulers and grid |
|
|
173 | (1) |
|
Changing an object's size and shape |
|
|
173 | (1) |
|
Moving and positioning objects |
|
|
174 | (1) |
|
Tricks for aligning and distributing objects |
|
|
175 | (3) |
|
When objects overlap: Choosing which appears above the other |
|
|
178 | (1) |
|
Rotating and flipping objects |
|
|
179 | (2) |
|
Grouping objects to make working with them easier |
|
|
181 | (1) |
|
Changing an Object's Color, Outline Color, and Transparency |
|
|
182 | (5) |
|
Filling an object with a color, picture, or texture |
|
|
182 | (1) |
|
Making a color transparent |
|
|
183 | (1) |
|
Putting the outline around an object |
|
|
184 | (3) |
|
|
187 | (116) |
|
Chapter 1 Speed Techniques for Using Word |
|
|
189 | (18) |
|
Introducing the Word Screen |
|
|
189 | (2) |
|
|
191 | (2) |
|
Getting a Better Look at Your Documents |
|
|
193 | (3) |
|
Viewing documents in different ways |
|
|
193 | (2) |
|
|
195 | (1) |
|
Selecting Text in Speedy Ways |
|
|
196 | (2) |
|
Moving Around Quickly in Documents |
|
|
198 | (4) |
|
Keys for getting around quickly |
|
|
198 | (1) |
|
Navigating from page to page or heading to heading |
|
|
199 | (1) |
|
"Browsing" around a document |
|
|
200 | (1) |
|
Going there fast with the Go To command |
|
|
200 | (1) |
|
Bookmarks for hopping around |
|
|
201 | (1) |
|
Entering Information Quickly in a Computerized Form |
|
|
202 | (5) |
|
Creating a computerized form |
|
|
202 | (2) |
|
Entering data in the form |
|
|
204 | (3) |
|
Chapter 2 Laying Out Text and Pages |
|
|
207 | (22) |
|
Paragraphs and Formatting |
|
|
207 | (1) |
|
Inserting a Section Break for Formatting Purposes |
|
|
208 | (1) |
|
|
209 | (1) |
|
|
210 | (1) |
|
Setting Up and Changing the Margins |
|
|
210 | (2) |
|
Indenting Paragraphs and First Lines |
|
|
212 | (2) |
|
Clicking an Indent button (for left-indents) |
|
|
212 | (1) |
|
"Eye-balling it" with the ruler |
|
|
213 | (1) |
|
Indenting in the Paragraph dialog box |
|
|
214 | (1) |
|
|
214 | (2) |
|
Numbering with page numbers only |
|
|
214 | (1) |
|
Including a page number in a header or footer |
|
|
215 | (1) |
|
Changing page number formats |
|
|
216 | (1) |
|
Putting Headers and Footers on Pages |
|
|
216 | (3) |
|
Creating, editing, and removing headers and footers |
|
|
217 | (1) |
|
Fine-tuning a header or footer |
|
|
218 | (1) |
|
Adjusting the Space between Lines |
|
|
219 | (1) |
|
Adjusting the Space between Paragraphs |
|
|
220 | (1) |
|
Creating Numbered and Bulleted Lists |
|
|
220 | (3) |
|
Simple numbered and bulleted lists |
|
|
221 | (1) |
|
Constructing lists of your own |
|
|
222 | (1) |
|
Managing a multilevel list |
|
|
222 | (1) |
|
|
223 | (2) |
|
|
225 | (4) |
|
Automatically and manually hyphenating a document |
|
|
225 | (1) |
|
Unhyphenating and other hyphenation tasks |
|
|
226 | (3) |
|
|
229 | (16) |
|
|
229 | (2) |
|
|
229 | (1) |
|
|
230 | (1) |
|
Applying Styles to Text and Paragraphs |
|
|
231 | (4) |
|
|
231 | (2) |
|
Experimenting with style sets |
|
|
233 | (1) |
|
Choosing which style names appear on the Style menus |
|
|
233 | (2) |
|
|
235 | (2) |
|
Creating a style from a paragraph |
|
|
235 | (1) |
|
Creating a style from the ground up |
|
|
235 | (2) |
|
|
237 | (1) |
|
Creating and Managing Templates |
|
|
238 | (7) |
|
|
238 | (1) |
|
Opening a template so that you can modify it |
|
|
239 | (1) |
|
Copying styles from different documents and templates |
|
|
240 | (2) |
|
Modifying, deleting, and renaming styles in templates |
|
|
242 | (3) |
|
Chapter 4 Desktop Publishing with Word |
|
|
245 | (18) |
|
Making Use of Charts, Diagrams, Shapes, Clip Art, and Photos |
|
|
245 | (1) |
|
Constructing the Perfect Table |
|
|
246 | (2) |
|
Repeating header rows on subsequent pages |
|
|
247 | (1) |
|
Turning a list into a table |
|
|
248 | (1) |
|
Positioning and Wrapping Objects Relative to the Page and Text |
|
|
248 | (3) |
|
Wrapping text around an object |
|
|
249 | (1) |
|
Positioning an object on a page |
|
|
250 | (1) |
|
Working with the Drawing Canvas |
|
|
251 | (1) |
|
Choosing a Theme for Your Document |
|
|
252 | (1) |
|
Putting Newspaper-Style Columns in a Document |
|
|
253 | (2) |
|
Doing the preliminary work |
|
|
253 | (1) |
|
Running text into columns |
|
|
253 | (2) |
|
|
255 | (1) |
|
|
255 | (1) |
|
Making text flow from text box to text box |
|
|
256 | (1) |
|
|
256 | (2) |
|
Decorating a page with a border |
|
|
256 | (2) |
|
Putting a background color on pages |
|
|
258 | (1) |
|
|
258 | (1) |
|
Watermarking for the Elegant Effect |
|
|
259 | (1) |
|
|
260 | (1) |
|
Printing on Different Size Paper |
|
|
261 | (2) |
|
Chapter 5 Getting Word's Help with Office Chores |
|
|
263 | (18) |
|
Highlighting Parts of a Document |
|
|
263 | (1) |
|
|
264 | (2) |
|
|
264 | (1) |
|
Caring for and feeding comments |
|
|
265 | (1) |
|
Tracking Changes to Documents |
|
|
266 | (5) |
|
Telling Word to start marking changes |
|
|
266 | (1) |
|
Telling Word how to mark changes |
|
|
267 | (1) |
|
Reading and reviewing a document with change marks |
|
|
268 | (1) |
|
Marking changes when you forgot to turn on change marks |
|
|
268 | (2) |
|
Accepting and rejecting changes to a document |
|
|
270 | (1) |
|
Printing an Address on an Envelope |
|
|
271 | (1) |
|
Printing a Single Address Label (Or a Page of the Same Label) |
|
|
272 | (2) |
|
Churning Out Letters, Envelopes, and Labels for Mass Mailings |
|
|
274 | (7) |
|
Preparing the source file |
|
|
274 | (1) |
|
Merging the document with the source file |
|
|
275 | (4) |
|
Printing form letters, envelopes, and labels |
|
|
279 | (2) |
|
Chapter 6 Tools for Reports and Scholarly Papers |
|
|
281 | (22) |
|
|
281 | (1) |
|
Outlines for Organizing Your Work |
|
|
282 | (2) |
|
Viewing the outline in different ways |
|
|
283 | (1) |
|
Rearranging document sections in Outline view |
|
|
283 | (1) |
|
Generating a Table of Contents |
|
|
284 | (3) |
|
|
284 | (1) |
|
Updating and removing a TOC |
|
|
285 | (1) |
|
|
285 | (1) |
|
Changing the structure of a TOC |
|
|
286 | (1) |
|
|
287 | (5) |
|
Marking index items in the document |
|
|
288 | (2) |
|
|
290 | (1) |
|
|
291 | (1) |
|
Putting Cross-References in a Document |
|
|
292 | (2) |
|
Putting Footnotes and Endnotes in Documents |
|
|
294 | (2) |
|
Entering a footnote or endnote |
|
|
294 | (1) |
|
Choosing the numbering scheme and position of notes |
|
|
295 | (1) |
|
Deleting, moving, and editing notes |
|
|
296 | (1) |
|
|
296 | (7) |
|
Inserting a citation for your bibliography |
|
|
297 | (1) |
|
|
298 | (1) |
|
Changing how citations appear in text |
|
|
299 | (1) |
|
Generating the bibliograpy |
|
|
299 | (4) |
|
|
303 | (90) |
|
Chapter 1 Getting Started in PowerPoint |
|
|
305 | (22) |
|
Getting Acquainted with PowerPoint |
|
|
306 | (2) |
|
|
308 | (1) |
|
A Whirlwind Tour of PowerPoint |
|
|
309 | (1) |
|
Creating a New Presentation |
|
|
310 | (1) |
|
Advice for Building Persuasive Presentations |
|
|
311 | (3) |
|
Creating New Slides for Your Presentation |
|
|
314 | (4) |
|
|
314 | (1) |
|
Speed techniques for inserting slides |
|
|
315 | (1) |
|
Conjuring slides from Word document headings |
|
|
315 | (3) |
|
Selecting a different layout for a slide |
|
|
318 | (1) |
|
Getting a Better View of Your Work |
|
|
318 | (2) |
|
|
319 | (1) |
|
Looking at the different views |
|
|
319 | (1) |
|
Hiding and Displaying the Slides Pane and Notes Pane |
|
|
320 | (1) |
|
Selecting, Moving, and Deleting Slides |
|
|
321 | (1) |
|
|
321 | (1) |
|
|
322 | (1) |
|
|
322 | (1) |
|
Putting Together a Photo Album |
|
|
322 | (5) |
|
Creating your photo album |
|
|
322 | (3) |
|
Putting on the final touches |
|
|
325 | (1) |
|
|
326 | (1) |
|
Chapter 2 Fashioning a Look for Your Presentation |
|
|
327 | (14) |
|
Looking at Themes and Background Styles |
|
|
327 | (2) |
|
Choosing a Theme for Your Presentation |
|
|
329 | (1) |
|
|
329 | (1) |
|
|
329 | (1) |
|
Creating Slide Backgrounds on Your Own |
|
|
330 | (6) |
|
Using a solid (or transparent) color for the slide background |
|
|
330 | (1) |
|
Creating a gradient color blend for slide backgrounds |
|
|
331 | (2) |
|
Placing a clip-art image in the slide background |
|
|
333 | (1) |
|
Using a picture for a slide background |
|
|
334 | (1) |
|
Using a texture for a slide background |
|
|
335 | (1) |
|
Changing the Background of a Single or Handful of Slides |
|
|
336 | (1) |
|
Using Master Slides and Master Styles for a Consistent Design |
|
|
337 | (4) |
|
Switching to Slide Master view |
|
|
338 | (1) |
|
Understanding master slides and master styles |
|
|
338 | (1) |
|
|
339 | (1) |
|
Changing a master slide layout |
|
|
340 | (1) |
|
Chapter 3 Entering the Text |
|
|
341 | (16) |
|
|
341 | (3) |
|
|
342 | (1) |
|
Changing the font size of text |
|
|
343 | (1) |
|
Changing the color of text |
|
|
343 | (1) |
|
Fun with Text Boxes and Text Box Shapes |
|
|
344 | (2) |
|
Controlling How Text Fits in Text Frames and Text Boxes |
|
|
346 | (3) |
|
Choosing how PowerPoint "AutoFits" text in text frames |
|
|
346 | (2) |
|
Choosing how PowerPoint "AutoFits" text in text boxes |
|
|
348 | (1) |
|
Positioning Text in Frames and Text Boxes |
|
|
349 | (1) |
|
Handling Bulleted and Numbered Lists |
|
|
350 | (2) |
|
Creating a standard bulleted or numbered list |
|
|
350 | (1) |
|
Choosing a different bullet character, size, and color |
|
|
351 | (1) |
|
Choosing a different list-numbering style, size, and color |
|
|
352 | (1) |
|
Putting Footers (and Headers) on Slides |
|
|
352 | (5) |
|
Some background on footers and headers |
|
|
353 | (1) |
|
Putting a standard footer on all your slides |
|
|
353 | (1) |
|
Creating a nonstandard footer |
|
|
354 | (1) |
|
Removing a footer from a single slide |
|
|
355 | (2) |
|
Chapter 4 Making Your Presentations Livelier |
|
|
357 | (16) |
|
Suggestions for Enlivening Your Presentation |
|
|
357 | (2) |
|
Exploring Transitions and Animations |
|
|
359 | (3) |
|
Showing transitions between slides |
|
|
359 | (1) |
|
Animating parts of a slide |
|
|
360 | (2) |
|
Making Audio Part of Your Presentation |
|
|
362 | (3) |
|
Inserting an audio file on a slide |
|
|
363 | (1) |
|
Telling PowerPoint when and how to play an audio file |
|
|
364 | (1) |
|
Playing audio during a presentation |
|
|
365 | (1) |
|
|
365 | (2) |
|
Inserting a video on a slide |
|
|
366 | (1) |
|
Fine-tuning a video presentation |
|
|
366 | (1) |
|
Recording a Voice Narration for PowerPoint |
|
|
367 | (6) |
|
Testing your computer's microphone |
|
|
368 | (2) |
|
Recording a voice narration in PowerPoint |
|
|
370 | (3) |
|
Chapter 5 Delivering a Presentation |
|
|
373 | (20) |
|
|
373 | (1) |
|
Rehearsing and Timing Your Presentation |
|
|
374 | (1) |
|
Showing Your Presentation |
|
|
375 | (4) |
|
Starting and ending a presentation |
|
|
376 | (1) |
|
Going from slide to slide |
|
|
376 | (3) |
|
Tricks for Making Presentations a Little Livelier |
|
|
379 | (2) |
|
Wielding a pen or highlighter in a presentation |
|
|
380 | (1) |
|
Hiding and erasing pen and highlighter markings |
|
|
380 | (1) |
|
|
381 | (1) |
|
Delivering a Presentation When You Can't Be There in Person |
|
|
381 | (12) |
|
Providing handouts for your audience |
|
|
381 | (2) |
|
Creating a self-running, kiosk-style presentation |
|
|
383 | (1) |
|
Creating a user-run presentation |
|
|
384 | (2) |
|
Packaging your presentation on a CD |
|
|
386 | (3) |
|
Creating a presentation video |
|
|
389 | (4) |
|
|
393 | (78) |
|
Chapter 1 Up and Running with Excel |
|
|
395 | (18) |
|
Creating a New Excel Workbook |
|
|
395 | (2) |
|
Getting Acquainted with Excel |
|
|
397 | (2) |
|
Rows, columns, and cell addresses |
|
|
399 | (1) |
|
|
399 | (1) |
|
Entering Data in a Worksheet |
|
|
399 | (5) |
|
The basics of entering data |
|
|
399 | (2) |
|
|
401 | (1) |
|
|
401 | (1) |
|
Entering date and time values |
|
|
402 | (2) |
|
Quickly Entering Lists and Serial Data with the AutoFill Command |
|
|
404 | (2) |
|
Formatting Numbers, Dates, and Time Values |
|
|
406 | (1) |
|
Conditional Formats for Calling Attention to Data |
|
|
407 | (2) |
|
Establishing Data-Validation Rules |
|
|
409 | (4) |
|
Chapter 2 Refining Your Worksheet |
|
|
413 | (12) |
|
|
413 | (1) |
|
Moving around in a Worksheet |
|
|
414 | (1) |
|
Getting a Better Look at the Worksheet |
|
|
415 | (2) |
|
Freezing and splitting columns and rows |
|
|
415 | (2) |
|
|
417 | (1) |
|
Comments for Documenting Your Worksheet |
|
|
417 | (2) |
|
Selecting Cells in a Worksheet |
|
|
419 | (1) |
|
Deleting, Copying, and Moving Data |
|
|
419 | (1) |
|
Handling the Worksheets in a Workbook |
|
|
420 | (1) |
|
Keeping Others from Tampering with Worksheets |
|
|
421 | (4) |
|
|
422 | (1) |
|
|
422 | (3) |
|
Chapter 3 Formulas and Functions for Crunching Numbers |
|
|
425 | (20) |
|
|
425 | (5) |
|
Referring to cells in formulas |
|
|
425 | (2) |
|
Referring to formula results in formulas |
|
|
427 | (1) |
|
|
428 | (2) |
|
The Basics of Entering a Formula |
|
|
430 | (1) |
|
Speed Techniques for Entering Formulas |
|
|
431 | (5) |
|
Clicking cells to enter cell references |
|
|
431 | (1) |
|
|
431 | (1) |
|
Naming cell ranges so that you can use them in formulas |
|
|
432 | (3) |
|
Referring to cells in different worksheets |
|
|
435 | (1) |
|
Copying Formulas from Cell to Cell |
|
|
436 | (1) |
|
Detecting and Correcting Errors in Formulas |
|
|
437 | (3) |
|
Correcting errors one at a time |
|
|
437 | (1) |
|
Running the error checker |
|
|
438 | (1) |
|
|
439 | (1) |
|
|
440 | (5) |
|
Using arguments in functions |
|
|
442 | (1) |
|
Entering a function in a formula |
|
|
442 | (3) |
|
Chapter 4 Making a Worksheet Easier to Read and Understand |
|
|
445 | (16) |
|
|
445 | (5) |
|
Aligning numbers and text in columns and rows |
|
|
445 | (2) |
|
Inserting and deleting rows and columns |
|
|
447 | (1) |
|
Changing the size of columns and rows |
|
|
448 | (2) |
|
Decorating a Worksheet with Borders and Colors |
|
|
450 | (4) |
|
Cell styles for quickly formatting a worksheet |
|
|
450 | (2) |
|
Formatting cells with table styles |
|
|
452 | (1) |
|
Slapping borders on worksheet cells |
|
|
453 | (1) |
|
Decorating worksheets with colors |
|
|
454 | (1) |
|
Getting Ready to Print a Worksheet |
|
|
454 | (7) |
|
Making a worksheet fit on a page |
|
|
455 | (3) |
|
Making a worksheet more presentable |
|
|
458 | (1) |
|
Repeating row and column headings on each page |
|
|
459 | (2) |
|
|
461 | (10) |
|
Managing Information in Lists |
|
|
461 | (3) |
|
|
461 | (1) |
|
|
462 | (1) |
|
|
462 | (2) |
|
Forecasting with the Goal Seek Command |
|
|
464 | (2) |
|
Performing What-If Analyses with Data Tables |
|
|
466 | (5) |
|
Using a one-input table for analysis |
|
|
466 | (2) |
|
Using a two-input table for analysis |
|
|
468 | (3) |
|
|
471 | (38) |
|
Chapter 1 Up and Running with OneNote |
|
|
473 | (12) |
|
|
473 | (1) |
|
Finding Your Way around the OneNote Screen |
|
|
474 | (1) |
|
|
474 | (1) |
|
Section (and section group) tabs |
|
|
475 | (1) |
|
|
475 | (1) |
|
|
475 | (1) |
|
Units for Organizing Notes |
|
|
475 | (1) |
|
|
476 | (2) |
|
Creating Sections and Section Groups |
|
|
478 | (1) |
|
|
478 | (1) |
|
|
478 | (1) |
|
Creating Pages and Subpages |
|
|
479 | (1) |
|
|
479 | (1) |
|
|
480 | (1) |
|
Renaming and Deleting Groups and Pages |
|
|
480 | (1) |
|
Getting from Place to Place in OneNote |
|
|
480 | (1) |
|
Changing Your View of a Page |
|
|
481 | (4) |
|
|
485 | (16) |
|
|
485 | (2) |
|
Moving and resizing note containers |
|
|
486 | (1) |
|
|
486 | (1) |
|
|
486 | (1) |
|
Getting more space for notes on a page |
|
|
486 | (1) |
|
Entering a Typewritten Note |
|
|
487 | (1) |
|
|
487 | (4) |
|
Drawing with a pen or highlighter |
|
|
488 | (1) |
|
|
489 | (1) |
|
Changing the size and appearance of drawings and shapes |
|
|
490 | (1) |
|
Converting a Handwritten Note to Text |
|
|
491 | (1) |
|
Writing a Math Expression in a Note |
|
|
491 | (1) |
|
Taking a Screen-Clipping Note |
|
|
492 | (1) |
|
Recording and Playing Audio Notes |
|
|
493 | (2) |
|
|
494 | (1) |
|
|
495 | (1) |
|
Attaching, Copying, and Linking Files to Notes |
|
|
495 | (3) |
|
Attaching an Office file to a note |
|
|
495 | (1) |
|
Copying an Office file into OneNote |
|
|
496 | (1) |
|
Linking a Word or PowerPoint file to OneNote |
|
|
497 | (1) |
|
Copying a note into another Office program |
|
|
498 | (1) |
|
Formatting the Text in Notes |
|
|
498 | (1) |
|
Docking the OneNote Screen |
|
|
499 | (2) |
|
Chapter 3 Finding and Organizing Your Notes |
|
|
501 | (8) |
|
|
501 | (2) |
|
Searching by word or phrase |
|
|
501 | (1) |
|
|
502 | (1) |
|
Tagging Notes for Follow Up |
|
|
503 | (3) |
|
|
504 | (1) |
|
Arranging tagged notes in the task pane |
|
|
504 | (1) |
|
Creating and modifying tags |
|
|
505 | (1) |
|
Color-Coding Notebooks, Sections, and Pages |
|
|
506 | (1) |
|
Merging and Moving Sections, Pages, and Notes |
|
|
507 | (2) |
|
Book VI Office 2010: One Step Beyond |
|
|
509 | (108) |
|
Chapter 1 Customizing an Office Program |
|
|
511 | (12) |
|
|
511 | (5) |
|
Displaying and selecting tab, group, and command names |
|
|
513 | (1) |
|
Moving tabs and groups on the Ribbon |
|
|
513 | (1) |
|
Adding, removing, and renaming tabs, groups, and commands |
|
|
514 | (1) |
|
Creating new tabs and groups |
|
|
515 | (1) |
|
Resetting your Ribbon customizations |
|
|
515 | (1) |
|
Customizing the Quick Access Toolbar |
|
|
516 | (2) |
|
Adding buttons to the Quick Access toolbar |
|
|
516 | (1) |
|
Changing the order of buttons on the Quick Access toolbar |
|
|
517 | (1) |
|
Removing buttons from the Quick Access toolbar |
|
|
518 | (1) |
|
Placing the Quick Access toolbar above or below the Ribbon |
|
|
518 | (1) |
|
Customizing the Status Bar |
|
|
518 | (1) |
|
Changing the Color Scheme |
|
|
519 | (1) |
|
Customizing Keyboard Shortcuts in Word |
|
|
520 | (3) |
|
Chapter 2 Ways of Distributing Your Work |
|
|
523 | (8) |
|
Printing---the Old Standby |
|
|
523 | (1) |
|
Distributing a File in PDF Format |
|
|
524 | (2) |
|
|
524 | (1) |
|
Saving an Office file as a PDF |
|
|
525 | (1) |
|
Saving an Office File as a Web Page |
|
|
526 | (2) |
|
Choosing how to save the component parts |
|
|
526 | (1) |
|
Turning a file into a Web page |
|
|
526 | (2) |
|
Opening a Web page in your browser |
|
|
528 | (1) |
|
Blogging from inside Word |
|
|
528 | (3) |
|
Describing a blog account to Word |
|
|
529 | (1) |
|
Posting an entry to your blog |
|
|
529 | (1) |
|
Taking advantage of the Blog Post tab |
|
|
530 | (1) |
|
Chapter 3 Handling Graphics |
|
|
531 | (20) |
|
All about Picture File Formats |
|
|
531 | (3) |
|
Bitmap and vector graphics |
|
|
531 | (2) |
|
|
533 | (1) |
|
|
533 | (1) |
|
Choosing file formats for graphics |
|
|
534 | (1) |
|
The All-Important Copyright Issue |
|
|
534 | (1) |
|
Inserting a Picture in an Office File |
|
|
535 | (1) |
|
|
536 | (7) |
|
Softening and sharpening pictures |
|
|
537 | (1) |
|
Correcting a picture's brightness and contrast |
|
|
537 | (1) |
|
|
538 | (1) |
|
Choosing an artistic effect |
|
|
539 | (1) |
|
Selecting a picture style |
|
|
540 | (1) |
|
Cropping off part of a picture |
|
|
540 | (2) |
|
|
542 | (1) |
|
Compressing Pictures to Save Disk Space |
|
|
543 | (1) |
|
Using Microsoft Office Picture Manager |
|
|
544 | (7) |
|
Mapping the graphic files on your computer |
|
|
545 | (1) |
|
Displaying the graphic file you want to work with |
|
|
545 | (1) |
|
|
546 | (5) |
|
Chapter 4 Decorating Files with Clip Art |
|
|
551 | (10) |
|
|
551 | (1) |
|
Inserting a Clip-Art Image |
|
|
552 | (1) |
|
Handling Media Files with the Clip Organizer |
|
|
553 | (8) |
|
Knowing your way around the Clip Organizer |
|
|
554 | (1) |
|
Locating the media file you need |
|
|
555 | (1) |
|
|
556 | (1) |
|
Storing your own files in the My Collections folders |
|
|
557 | (4) |
|
Chapter 5 Automating Tasks with Macros |
|
|
561 | (10) |
|
|
561 | (1) |
|
Displaying the Developer Tab |
|
|
561 | (1) |
|
Managing the Macro Security Problem |
|
|
562 | (2) |
|
|
564 | (3) |
|
Enabling your files for macros |
|
|
564 | (1) |
|
Ground rules for recording macros |
|
|
564 | (1) |
|
|
565 | (2) |
|
|
567 | (1) |
|
|
568 | (3) |
|
Opening a macro in the Visual Basic Editor |
|
|
568 | (1) |
|
Reading a macro in the Code window |
|
|
569 | (1) |
|
Editing the text that a macro enters |
|
|
570 | (1) |
|
Deleting parts of a macro |
|
|
570 | (1) |
|
Chapter 6 Linking and Embedding in Compound Files |
|
|
571 | (10) |
|
|
571 | (3) |
|
|
571 | (3) |
|
Pitfalls of linking and embedding |
|
|
574 | (1) |
|
Linking to Data in a Source File |
|
|
574 | (3) |
|
|
575 | (1) |
|
|
576 | (1) |
|
Editing data in the source file |
|
|
576 | (1) |
|
Embedding Data from Other Programs |
|
|
577 | (4) |
|
|
577 | (2) |
|
|
579 | (2) |
|
Chapter 7 Office Web Apps |
|
|
581 | (36) |
|
Introducing the Office Web Apps |
|
|
581 | (1) |
|
Storing and Sharing Files on the Internet |
|
|
582 | (1) |
|
Office Web Apps: The Big Picture |
|
|
583 | (1) |
|
Getting Ready to Use the Office Web Apps |
|
|
584 | (1) |
|
Signing In to Windows Live |
|
|
584 | (1) |
|
Navigating to the SkyDrive Window |
|
|
584 | (1) |
|
|
585 | (4) |
|
|
586 | (2) |
|
Going from folder to folder in SkyDrive |
|
|
588 | (1) |
|
Deleting, moving, and renaming folders |
|
|
589 | (1) |
|
Creating an Office File in SkyDrive |
|
|
589 | (1) |
|
Opening and Editing Office Files Stored on SkyDrive |
|
|
590 | (4) |
|
Opening and editing a file in an Office Web App |
|
|
590 | (2) |
|
Opening and editing a SkyDrive file in an Office 2010 program |
|
|
592 | (2) |
|
Managing Your Files on SkyDrive |
|
|
594 | (3) |
|
Making use of the Properties window |
|
|
594 | (2) |
|
Uploading files to a folder on SkyDrive |
|
|
596 | (1) |
|
Downloading files from SkyDrive to your computer |
|
|
596 | (1) |
|
Moving, copying, renaming, and deleting files |
|
|
597 | (1) |
|
Ways of Sharing Folders: The Big Picture |
|
|
597 | (1) |
|
Making Friends on Windows Live |
|
|
598 | (3) |
|
|
598 | (2) |
|
Fielding an invitation to be someone's friend |
|
|
600 | (1) |
|
Inviting someone to be your friend |
|
|
600 | (1) |
|
Understanding the Folder Types |
|
|
601 | (3) |
|
|
601 | (1) |
|
Knowing what kind of folder you're dealing with |
|
|
602 | (1) |
|
Public and shared folder tasks |
|
|
603 | (1) |
|
Establishing a Folder's Share With Permissions |
|
|
604 | (2) |
|
Sharing on a Public or Shared Folder |
|
|
606 | (4) |
|
Sharing with friends on Windows Live |
|
|
606 | (1) |
|
Sending out e-mail invitations |
|
|
607 | (2) |
|
Posting hyperlinks on the Internet |
|
|
609 | (1) |
|
Writing File Comments and Descriptions |
|
|
610 | (1) |
|
Coauthoring Files Shared on SkyDrive |
|
|
611 | (6) |
|
When you can and can't coauthor |
|
|
612 | (1) |
|
Finding out who your coauthors are |
|
|
613 | (1) |
|
Getting locked out of a shared file |
|
|
614 | (3) |
Index |
|
617 | |