| The Missing Credits |
|
xix | |
| Introduction |
|
1 | (14) |
|
|
|
|
Creating a Pages Document |
|
|
15 | (36) |
|
|
|
15 | (3) |
|
Meet Pages, the Word Processor |
|
|
16 | (1) |
|
Meet Pages, the Page-Layout Program |
|
|
17 | (1) |
|
|
|
17 | (1) |
|
Using Templates for Ready-to-Go Documents |
|
|
18 | (1) |
|
Your First Word-Processing Document |
|
|
19 | (7) |
|
Integration with Address Book |
|
|
20 | (2) |
|
|
|
22 | (1) |
|
|
|
22 | (3) |
|
Other Word-Processing Document Types |
|
|
25 | (1) |
|
Your First Page-Layout Document |
|
|
26 | (8) |
|
|
|
27 | (1) |
|
Adding Pictures from iPhoto |
|
|
28 | (3) |
|
Adding Pages and New Layouts |
|
|
31 | (3) |
|
In the Buff: The Blank Template |
|
|
34 | (1) |
|
Setting Your Default Template |
|
|
35 | (1) |
|
Opening an Existing Document |
|
|
35 | (3) |
|
Importing Files from Another Program |
|
|
37 | (1) |
|
Controlling the Document Window |
|
|
38 | (13) |
|
|
|
38 | (4) |
|
Shape Shifter: The Format Bar |
|
|
42 | (1) |
|
|
|
42 | (2) |
|
|
|
44 | (3) |
|
Editing in Full-Screen View |
|
|
47 | (4) |
|
|
|
51 | (42) |
|
Word Processor Text vs. Text Boxes |
|
|
51 | (1) |
|
Basic Text Editing in iWork |
|
|
52 | (6) |
|
|
|
52 | (1) |
|
|
|
53 | (1) |
|
|
|
53 | (2) |
|
Cutting, Copying, and Pasting |
|
|
55 | (1) |
|
Using Drag-and-Drop Editing |
|
|
56 | (1) |
|
|
|
56 | (2) |
|
|
|
58 | (1) |
|
Backing Up the Previous Version of a Document |
|
|
59 | (1) |
|
Changing Font Styles and Appearance |
|
|
59 | (8) |
|
|
|
62 | (3) |
|
Setting Colors and Character Spacing in the Text Inspector |
|
|
65 | (1) |
|
|
|
66 | (1) |
|
|
|
67 | (14) |
|
|
|
68 | (2) |
|
Between the Lines: Line Spacing |
|
|
70 | (1) |
|
|
|
71 | (1) |
|
|
|
72 | (3) |
|
|
|
75 | (2) |
|
Setting Paragraph Borders and Background Color |
|
|
77 | (2) |
|
|
|
79 | (2) |
|
Spaces, Invisibles, and Special Characters |
|
|
81 | (3) |
|
|
|
81 | (1) |
|
Inserting Special Characters and Symbols |
|
|
82 | (2) |
|
|
|
84 | (9) |
|
|
|
86 | (3) |
|
Organizing and Nesting Your Lists |
|
|
89 | (4) |
|
Creating and Using Styles |
|
|
93 | (14) |
|
When You Need Styles: Know the Warning Signs |
|
|
95 | (1) |
|
Style Central: Meet the Styles Drawer |
|
|
95 | (1) |
|
|
|
96 | (2) |
|
|
|
98 | (1) |
|
Creating Styles by Example |
|
|
98 | (4) |
|
Modifying Existing Paragraph and List Styles |
|
|
98 | (1) |
|
Creating New Paragraph and List Styles |
|
|
99 | (1) |
|
Modifying Existing Character Styles |
|
|
100 | (2) |
|
Creating New Character Styles |
|
|
102 | (1) |
|
Finding and Copying Styles |
|
|
102 | (3) |
|
|
|
103 | (1) |
|
Importing Styles from Another Document |
|
|
104 | (1) |
|
Changing the Default Font |
|
|
105 | (2) |
|
|
|
107 | (30) |
|
Changing Your Mind: Find & Replace |
|
|
107 | (6) |
|
|
|
108 | (2) |
|
|
|
110 | (3) |
|
|
|
113 | (5) |
|
Check Spelling as You Type |
|
|
114 | (1) |
|
Check Spelling in the Document or Selection |
|
|
115 | (1) |
|
Using Foreign-Language Dictionaries |
|
|
116 | (2) |
|
|
|
118 | (5) |
|
Look up Words in the Dictionary or Thesaurus |
|
|
118 | (2) |
|
Find It on the Web: Wikipedia or Google Search |
|
|
120 | (1) |
|
Find It on Your Computer: Spotlight Search |
|
|
121 | (1) |
|
For the Obsessive: Document Stats |
|
|
121 | (2) |
|
|
|
123 | (3) |
|
|
|
124 | (1) |
|
|
|
125 | (1) |
|
Auto-Correction and Text Substitution |
|
|
126 | (1) |
|
|
|
127 | (10) |
|
Starting and Stopping Change Tracking |
|
|
129 | (2) |
|
Reviewing, Accepting, and Rejecting Changes |
|
|
131 | (1) |
|
Controlling the Markup Display |
|
|
131 | (2) |
|
|
|
133 | (2) |
|
Wiping the Change History |
|
|
135 | (2) |
|
Document Format and Organization |
|
|
137 | (54) |
|
|
|
137 | (10) |
|
Password-Protecting Your Document |
|
|
138 | (2) |
|
|
|
140 | (1) |
|
|
|
140 | (1) |
|
Working with Headers and Footers |
|
|
141 | (2) |
|
The Fine Print: Footnotes and Endnotes |
|
|
143 | (4) |
|
|
|
147 | (1) |
|
|
|
147 | (1) |
|
Organizing Your Document with Sections |
|
|
147 | (13) |
|
|
|
149 | (2) |
|
Rearranging and Deleting Sections |
|
|
151 | (2) |
|
Layouts and Multiple Columns |
|
|
153 | (6) |
|
Capturing and Reusing Sections |
|
|
159 | (1) |
|
Auto-Entry: Formatted Text Fields |
|
|
160 | (5) |
|
Page Numbers and Page Counts |
|
|
161 | (3) |
|
Inserting the Date and Time |
|
|
164 | (1) |
|
|
|
165 | (1) |
|
Mail Merge with Address Book or Numbers |
|
|
165 | (9) |
|
Using Merge Fields in Templates |
|
|
166 | (1) |
|
Managing Mass Mailings with Address Book Groups |
|
|
167 | (2) |
|
Merging Data from a Numbers Spreadsheet |
|
|
169 | (3) |
|
Adding Merge Fields to Your Own Documents |
|
|
172 | (2) |
|
Adding a Table of Contents |
|
|
174 | (5) |
|
Modifying a Table of Contents |
|
|
177 | (2) |
|
|
|
179 | (4) |
|
|
|
179 | (2) |
|
Linking to Another Pages Document |
|
|
181 | (1) |
|
|
|
181 | (2) |
|
Adding Email Message Links |
|
|
183 | (1) |
|
Organizing Text with Outlines |
|
|
183 | (8) |
|
Getting Started: Outline Templates |
|
|
183 | (5) |
|
Building an Outline from Scratch |
|
|
188 | (3) |
|
Beyond Text: Laying Out Pages |
|
|
191 | (18) |
|
Templates: The Key to Prefab Page Designs |
|
|
192 | (3) |
|
Working with Placeholder Text |
|
|
193 | (1) |
|
Working with Media Placeholders |
|
|
193 | (2) |
|
Immovable Objects: Locked, Background, and Master Objects |
|
|
195 | (1) |
|
Planning a Layout from Scratch |
|
|
195 | (6) |
|
More or Less, ``Less is More'' |
|
|
196 | (2) |
|
Collecting Your Materials |
|
|
198 | (3) |
|
Creating a Page-Layout Document |
|
|
201 | (1) |
|
Fine-Tuning Your Doucment Settings |
|
|
201 | (1) |
|
Page Layout vs. Word Processing |
|
|
201 | (1) |
|
|
|
202 | (7) |
|
|
|
203 | (2) |
|
Building a Grid of your Own |
|
|
205 | (4) |
|
Objects Up Close: Adding, Modifying, and More |
|
|
209 | (70) |
|
Floating vs. Inline Objects |
|
|
209 | (7) |
|
|
|
211 | (2) |
|
|
|
213 | (1) |
|
Converting an Object's Layout Style |
|
|
214 | (2) |
|
|
|
216 | (33) |
|
|
|
216 | (12) |
|
|
|
228 | (13) |
|
|
|
241 | (6) |
|
|
|
247 | (2) |
|
|
|
249 | (15) |
|
|
|
249 | (1) |
|
|
|
250 | (1) |
|
|
|
251 | (1) |
|
Wrapping Text Around Objects |
|
|
252 | (3) |
|
Rotating and Flipping Objects |
|
|
255 | (2) |
|
|
|
257 | (1) |
|
Distributing and Aligning Objects |
|
|
258 | (1) |
|
|
|
259 | (5) |
|
|
|
264 | (11) |
|
Filling with Colors, Gradients, and Images |
|
|
265 | (6) |
|
|
|
271 | (2) |
|
Adding Shadows and Reflections |
|
|
273 | (2) |
|
|
|
275 | (1) |
|
Copying Objects and Graphic Styles |
|
|
275 | (4) |
|
Building Tables and Charts |
|
|
279 | (42) |
|
|
|
280 | (23) |
|
|
|
281 | (1) |
|
Inserting Floating Tables |
|
|
282 | (2) |
|
Selecting Tables, Cells, and Text |
|
|
284 | (2) |
|
|
|
286 | (3) |
|
Adding and Deleting Rows and Columns |
|
|
289 | (3) |
|
Setting the Data Type with Cell Format |
|
|
292 | (2) |
|
|
|
294 | (1) |
|
|
|
295 | (7) |
|
|
|
302 | (1) |
|
Making Mini-Spreadsheets with Formulas |
|
|
303 | (7) |
|
``Quick Formulas'' for Common Calculations |
|
|
304 | (1) |
|
|
|
305 | (4) |
|
|
|
309 | (1) |
|
Using Numbers Tables in Pages and Vice Versa |
|
|
309 | (1) |
|
|
|
310 | (11) |
|
|
|
311 | (3) |
|
Entering Data in the Chart Data Editor |
|
|
314 | (1) |
|
Using Charts from Numbers |
|
|
315 | (3) |
|
Changing the Type of Chart |
|
|
318 | (1) |
|
|
|
319 | (2) |
|
|
|
321 | (24) |
|
|
|
321 | (5) |
|
|
|
322 | (1) |
|
|
|
323 | (3) |
|
|
|
326 | (6) |
|
|
|
327 | (1) |
|
|
|
328 | (1) |
|
|
|
329 | (1) |
|
|
|
330 | (1) |
|
|
|
330 | (1) |
|
|
|
331 | (1) |
|
|
|
332 | (10) |
|
Sending Your Document to iWork.com |
|
|
333 | (2) |
|
Viewing the Document on iWork.com |
|
|
335 | (2) |
|
Adding and Viewing Comments |
|
|
337 | (1) |
|
Adding Notes to iWork.com |
|
|
338 | (1) |
|
|
|
339 | (1) |
|
|
|
339 | (1) |
|
Reviewing Your Shared Documents |
|
|
340 | (1) |
|
|
|
340 | (2) |
|
Publishing Online with iWeb |
|
|
342 | (3) |
|
Streamline Your Projects: Creating Templates |
|
|
345 | (20) |
|
|
|
345 | (2) |
|
Modifying an Existing Template |
|
|
347 | (2) |
|
Creating Templates from Scratch |
|
|
349 | (11) |
|
|
|
350 | (1) |
|
Setting Document Formatting |
|
|
350 | (1) |
|
|
|
351 | (4) |
|
|
|
355 | (3) |
|
Building Multipage Templates |
|
|
358 | (2) |
|
|
|
360 | (1) |
|
Sharing, Exchanging, and Buying Templates |
|
|
360 | (5) |
|
|
|
361 | (4) |
|
|
|
|
Planning and Giving Great Presentations |
|
|
365 | (26) |
|
Planning the Presentation |
|
|
366 | (5) |
|
The Goals of Your Presentation |
|
|
367 | (1) |
|
|
|
367 | (2) |
|
The Slideshow's Role in Your Presentation |
|
|
369 | (2) |
|
Building the Presentation |
|
|
371 | (8) |
|
|
|
371 | (2) |
|
|
|
373 | (1) |
|
Design Your Keynote Slideshow |
|
|
374 | (3) |
|
|
|
377 | (2) |
|
|
|
379 | (1) |
|
Delivering the Presentation |
|
|
379 | (4) |
|
|
|
380 | (1) |
|
|
|
380 | (1) |
|
|
|
381 | (2) |
|
|
|
383 | (1) |
|
Presentation Setting and Gear |
|
|
383 | (8) |
|
|
|
383 | (1) |
|
|
|
384 | (1) |
|
|
|
385 | (2) |
|
|
|
387 | (4) |
|
Creating a Keynote Slideshow |
|
|
391 | (30) |
|
|
|
391 | (2) |
|
Your First Keynote Slideshow |
|
|
393 | (16) |
|
Familiar Faces: The Toolbar, Format Bar, and Inspectors |
|
|
393 | (3) |
|
Slide Size and Slide View |
|
|
396 | (1) |
|
|
|
396 | (2) |
|
Changing the Slide Layout with Master Slides |
|
|
398 | (1) |
|
|
|
398 | (2) |
|
Slide Design Works Just Like Page Layout |
|
|
400 | (3) |
|
Adding and Inserting Slides |
|
|
403 | (2) |
|
|
|
405 | (1) |
|
|
|
405 | (1) |
|
Using the Presenter Notes Pane |
|
|
406 | (2) |
|
|
|
408 | (1) |
|
Browsing and Organizing Your Slides |
|
|
409 | (9) |
|
|
|
409 | (1) |
|
|
|
410 | (4) |
|
|
|
414 | (3) |
|
|
|
417 | (1) |
|
|
|
418 | (1) |
|
|
|
418 | (1) |
|
Opening an Existing Slideshow |
|
|
419 | (2) |
|
Importing Files from Another Program |
|
|
419 | (2) |
|
|
|
421 | (44) |
|
Setting Up the Keynote Document |
|
|
422 | (2) |
|
Choosing a Presentation Style |
|
|
422 | (1) |
|
Password-Protecting Your Slideshow |
|
|
423 | (1) |
|
|
|
424 | (9) |
|
|
|
424 | (1) |
|
Moving and Copying Objects |
|
|
425 | (1) |
|
Resizing, Rotating, and Flipping Objects |
|
|
426 | (1) |
|
|
|
427 | (1) |
|
|
|
427 | (1) |
|
Copying and Reusing Objects Styles |
|
|
428 | (1) |
|
|
|
429 | (1) |
|
|
|
429 | (4) |
|
Grouping and Locking Objects |
|
|
433 | (1) |
|
Adding and Formatting Text Boxes |
|
|
433 | (9) |
|
Inserting Title and Body Text Boxes |
|
|
434 | (1) |
|
Inserting Free Text Boxes |
|
|
435 | (1) |
|
|
|
435 | (2) |
|
|
|
437 | (5) |
|
Inserting Photos and Other Graphics |
|
|
442 | (6) |
|
Replacing Media Placeholders |
|
|
442 | (2) |
|
Adding and Editing Pictures |
|
|
444 | (2) |
|
Managing File Sizes for Image-Heavy Slideshows |
|
|
446 | (2) |
|
|
|
448 | (1) |
|
Building Tables and Charts |
|
|
449 | (2) |
|
Using Numbers Charts in your Slideshow |
|
|
449 | (2) |
|
|
|
451 | (4) |
|
|
|
452 | (2) |
|
Managing Multimedia Files |
|
|
454 | (1) |
|
Making Noise: Sounds Clips and Narration |
|
|
455 | (3) |
|
|
|
455 | (1) |
|
Adding Sound to a Single Slide |
|
|
456 | (2) |
|
|
|
458 | (3) |
|
|
|
459 | (1) |
|
|
|
459 | (1) |
|
Linking to Other Slideshows |
|
|
460 | (1) |
|
|
|
460 | (1) |
|
Note to Self: Add a Comment |
|
|
461 | (2) |
|
Changing Slide Backgrounds |
|
|
463 | (1) |
|
|
|
464 | (1) |
|
|
|
465 | (30) |
|
|
|
465 | (9) |
|
Switching Slides with 2D and 3D Effects |
|
|
467 | (3) |
|
|
|
470 | (1) |
|
Wordplay with Text Effects |
|
|
471 | (1) |
|
|
|
472 | (2) |
|
|
|
474 | (1) |
|
|
|
474 | (10) |
|
Creating Build Ins and Build Outs |
|
|
474 | (7) |
|
Controlling Movies and Sounds with Builds |
|
|
481 | (1) |
|
Using Smart Builds for Single-Slide Slideshows |
|
|
482 | (2) |
|
Ordering and Automating Builds |
|
|
484 | (5) |
|
Playing Builds Automatically or Simultaneously |
|
|
486 | (1) |
|
Mingling Builds of Text, Tables, Charts, and Images |
|
|
487 | (2) |
|
Adding Animations with Action Builds |
|
|
489 | (5) |
|
Moving Objects Along a Path |
|
|
491 | (1) |
|
|
|
492 | (2) |
|
Copying Builds to Other Objects |
|
|
494 | (1) |
|
|
|
495 | (42) |
|
Setting Up the Presentation |
|
|
495 | (9) |
|
Setting Slideshow Preferences |
|
|
496 | (2) |
|
Setting Up the Presenter Display |
|
|
498 | (3) |
|
Connecting a Second Display |
|
|
501 | (2) |
|
Connecting Your Audio Output |
|
|
503 | (1) |
|
Set Up the Remote Control |
|
|
504 | (1) |
|
Playing Keynote Slideshows |
|
|
504 | (6) |
|
Controlling the Presentation |
|
|
504 | (3) |
|
Keynote Remote with iPhone or iPod Touch |
|
|
507 | (3) |
|
Creating Self-Playing Slideshows |
|
|
510 | (4) |
|
|
|
511 | (1) |
|
|
|
512 | (2) |
|
Setting Up Hyperlinks-Only Slideshows |
|
|
514 | (1) |
|
Printing Slides and Handouts |
|
|
515 | (2) |
|
Exporting to Other Formats |
|
|
517 | (10) |
|
|
|
518 | (1) |
|
|
|
518 | (1) |
|
Creating a Quick Time Movie |
|
|
519 | (4) |
|
|
|
523 | (1) |
|
Exporting Slides as Image Files |
|
|
523 | (2) |
|
Exporting a Slideshow as a Web Page |
|
|
525 | (2) |
|
Exporting to iPod or iPhone via iTunes |
|
|
527 | (1) |
|
|
|
527 | (1) |
|
Sharing Your Slides Online |
|
|
528 | (5) |
|
Using iWork.com with Keynote |
|
|
528 | (3) |
|
|
|
531 | (1) |
|
|
|
532 | (1) |
|
Shipping Your Slides to Other iApps |
|
|
533 | (4) |
|
Sharing Slides in iChat Theater |
|
|
533 | (1) |
|
|
|
534 | (1) |
|
|
|
534 | (1) |
|
|
|
535 | (2) |
|
Customizing Keynote Themes |
|
|
537 | (14) |
|
|
|
538 | (1) |
|
|
|
538 | (6) |
|
|
|
538 | (1) |
|
|
|
539 | (3) |
|
|
|
542 | (1) |
|
Changing Standard Object Styles |
|
|
542 | (2) |
|
Reverting to the Original Theme |
|
|
544 | (1) |
|
Building Themes from Scratch |
|
|
544 | (3) |
|
Create a ``Master'' Master Slide |
|
|
544 | (1) |
|
Adding Text and Media Placeholders |
|
|
545 | (1) |
|
Adding Object Placeholders |
|
|
546 | (1) |
|
Defining Your Theme's Object Styles |
|
|
547 | (1) |
|
|
|
547 | (1) |
|
Sharing and Buying Themes |
|
|
548 | (3) |
|
|
|
|
Creating a Numbers Spredsheet |
|
|
551 | (30) |
|
Picking a Numbers Template |
|
|
553 | (1) |
|
Your First Basic Spreadsheet |
|
|
554 | (12) |
|
|
|
555 | (1) |
|
The Toolbar and Inspectors |
|
|
556 | (1) |
|
Working with Table Rows, Columns, and Cells |
|
|
557 | (7) |
|
Fast Math: Quick Formulas and Instant Calculations |
|
|
564 | (1) |
|
|
|
565 | (1) |
|
Fancy Formulas and Glizty Graphics |
|
|
566 | (2) |
|
Organizing Your Data with Sheets |
|
|
568 | (2) |
|
Shuffling Sheets in the Sheets Pane |
|
|
569 | (1) |
|
|
|
570 | (1) |
|
|
|
570 | (1) |
|
Password-Protecting Your Spreadsheet |
|
|
570 | (1) |
|
|
|
571 | (1) |
|
Opening an Existing Spreadsheet |
|
|
571 | (2) |
|
Importing Files from Another Program |
|
|
572 | (1) |
|
Previewing Your Spreadsheet in Print View |
|
|
573 | (8) |
|
|
|
574 | (1) |
|
|
|
575 | (4) |
|
Printing Your Spreadsheet |
|
|
579 | (2) |
|
Editing Tables in Numbers |
|
|
581 | (50) |
|
Working with Table Objects |
|
|
581 | (7) |
|
|
|
582 | (1) |
|
|
|
582 | (4) |
|
Moving and Copying Tables |
|
|
586 | (1) |
|
|
|
587 | (1) |
|
|
|
588 | (2) |
|
Hopping Rows with the Return Key |
|
|
589 | (1) |
|
|
|
590 | (12) |
|
|
|
591 | (1) |
|
Handling Data That Doesn't Fit |
|
|
592 | (2) |
|
Paragraphs, Line Breaks, and Tabs |
|
|
594 | (1) |
|
|
|
595 | (5) |
|
|
|
600 | (1) |
|
|
|
601 | (1) |
|
Using Different Types of Data |
|
|
602 | (14) |
|
|
|
604 | (7) |
|
Creating a Custom Cell Format |
|
|
611 | (4) |
|
Managing Custom Cell Formats |
|
|
615 | (1) |
|
Add It Quick: Data-Entry Shortcuts |
|
|
616 | (15) |
|
|
|
616 | (2) |
|
Auto-Correction and Smart Quotes |
|
|
618 | (1) |
|
|
|
618 | (2) |
|
|
|
620 | (1) |
|
Adding Special Controls to Cells |
|
|
621 | (4) |
|
|
|
625 | (4) |
|
Importing OFX Files for Bank Data |
|
|
629 | (2) |
|
Organizing Tables in Numbers |
|
|
631 | (38) |
|
Working with Rows and Columns |
|
|
631 | (11) |
|
Adding and Deleting Rows or Columns |
|
|
632 | (2) |
|
Working with Header Rows and Columns |
|
|
634 | (3) |
|
|
|
637 | (1) |
|
Resizing Rows and Columns |
|
|
638 | (2) |
|
|
|
640 | (1) |
|
Hiding and Unhiding Rows and Columns |
|
|
641 | (1) |
|
Reorganize: Sort, Filter, Categorize |
|
|
642 | (11) |
|
|
|
642 | (2) |
|
|
|
644 | (2) |
|
|
|
646 | (7) |
|
|
|
653 | (3) |
|
Finding Data from the Search Pane |
|
|
653 | (1) |
|
The Find & Replace Window |
|
|
654 | (2) |
|
Make It Pretty: Borders and Backgrounds |
|
|
656 | (5) |
|
Styling Cell and Table Borders |
|
|
656 | (3) |
|
Background Colors and Images |
|
|
659 | (2) |
|
Conditional Formats for ``Content Alerts'' |
|
|
661 | (2) |
|
Working with Table Styles |
|
|
663 | (4) |
|
Applying Predefined Table Styles |
|
|
664 | (1) |
|
Creating and Modigfying Table Styles |
|
|
665 | (2) |
|
Capturing Reusable Tables |
|
|
667 | (2) |
|
|
|
669 | (30) |
|
|
|
670 | (1) |
|
|
|
671 | (3) |
|
Creating Formulas from Instant Calculations |
|
|
672 | (2) |
|
|
|
674 | (6) |
|
Using Quick Formulas with Header and Footer Cells |
|
|
675 | (2) |
|
Using Quick Formulas with Body Cells |
|
|
677 | (3) |
|
|
|
680 | (5) |
|
|
|
680 | (3) |
|
|
|
683 | (2) |
|
|
|
685 | (1) |
|
Copying and Moving Formulas |
|
|
685 | (11) |
|
Using Relative and Absolute Cell References |
|
|
693 | (3) |
|
Copying the Value, Not the Formula |
|
|
696 | (1) |
|
Copying with Formula Errors |
|
|
696 | (1) |
|
Browsing and Searching Formulas |
|
|
697 | (2) |
|
Advanced Data Crunching with Functions |
|
|
699 | (58) |
|
|
|
699 | (3) |
|
Adding Functions with the Function Browser |
|
|
702 | (4) |
|
Pasting Examples from the Function Browser |
|
|
705 | (1) |
|
Using Cell Ranges in Functions |
|
|
706 | (3) |
|
Adding Cell Ranges to Formulas |
|
|
708 | (1) |
|
|
|
709 | (8) |
|
The Quick-Formula Functions and Basic Math |
|
|
710 | (5) |
|
|
|
715 | (2) |
|
Transforming Text in Formulas |
|
|
717 | (9) |
|
Working with Portions of Strings |
|
|
720 | (3) |
|
|
|
723 | (1) |
|
Formatting Numbers in Text |
|
|
724 | (2) |
|
Working with Dates and Times |
|
|
726 | (5) |
|
Doing Math with Dates and Times |
|
|
726 | (4) |
|
Building Dates and Times in Formulas |
|
|
730 | (1) |
|
Extracting Date and Time Info |
|
|
731 | (1) |
|
What IF: Adding Logic to Formulas |
|
|
731 | (13) |
|
Setting Conditions with the IF Function |
|
|
732 | (5) |
|
Countif, Sumif, and Averageif for Smart Summaries |
|
|
737 | (7) |
|
Looking Up and Fetching Cell Data |
|
|
744 | (13) |
|
Using Vlookup and Hlookup |
|
|
745 | (6) |
|
Using Lookup for Easier but Inexact Matches |
|
|
751 | (2) |
|
Using Match and Index to Fetch Any Cell |
|
|
753 | (3) |
|
|
|
756 | (1) |
|
Charts: Giving Shape to Numbers |
|
|
757 | (44) |
|
Adding a Chart to Your Spreadsheet |
|
|
758 | (14) |
|
|
|
760 | (3) |
|
|
|
763 | (8) |
|
|
|
771 | (1) |
|
Working with a Chart's Table Data |
|
|
772 | (7) |
|
Choosing the Charted Cell Range |
|
|
773 | (1) |
|
Removing Data Series from a Chart |
|
|
773 | (1) |
|
Adding Data Series from Other Tables |
|
|
774 | (3) |
|
Changing the Order of Data Series |
|
|
777 | (1) |
|
Working with Scatter Charts |
|
|
777 | (2) |
|
Editing Chart Text and Labels |
|
|
779 | (5) |
|
|
|
780 | (1) |
|
|
|
780 | (1) |
|
|
|
780 | (3) |
|
|
|
783 | (1) |
|
|
|
784 | (1) |
|
|
|
784 | (12) |
|
|
|
785 | (1) |
|
Adjusting Color, Shadow, and Opacity |
|
|
786 | (2) |
|
Formatting the X- and Y-Axis |
|
|
788 | (2) |
|
|
|
790 | (2) |
|
Spacing Bar and Column Charts |
|
|
792 | (1) |
|
Formatting Data-Point Symbols |
|
|
793 | (1) |
|
Choosing Chart Types for Mixed and Two-Axis Charts |
|
|
793 | (1) |
|
|
|
794 | (1) |
|
|
|
795 | (1) |
|
|
|
796 | (5) |
|
The Right Chart (or Table) for Your Data |
|
|
798 | (3) |
|
Designing Your Speadsheet Report |
|
|
801 | (14) |
|
|
|
802 | (1) |
|
Identifying ``Back Page'' Data |
|
|
803 | (3) |
|
Hiding Charts' Source Tables |
|
|
804 | (2) |
|
|
|
806 | (1) |
|
|
|
806 | (3) |
|
|
|
809 | (4) |
|
Adding Pictures to Table Cells |
|
|
811 | (1) |
|
Working with Placeholder Images |
|
|
812 | (1) |
|
|
|
812 | (1) |
|
|
|
813 | (2) |
|
Sharing Your Spreadsheets |
|
|
815 | (14) |
|
Printing Your Spreadsheet |
|
|
815 | (2) |
|
Exporting to Other Formats |
|
|
817 | (6) |
|
|
|
817 | (3) |
|
|
|
820 | (2) |
|
|
|
822 | (1) |
|
Saving Spreadsheets for Numbers '08 |
|
|
822 | (1) |
|
Sharing with Pages and Keynote |
|
|
823 | (1) |
|
|
|
823 | (1) |
|
|
|
823 | (1) |
|
Pasting Tables into Pages or Keynote |
|
|
823 | (1) |
|
Distributing Your Spreadsheet Online |
|
|
824 | (5) |
|
|
|
824 | (3) |
|
Emailing your Spreadsheet |
|
|
827 | (1) |
|
Adding Spreadsheets to Your iWeb Site |
|
|
827 | (2) |
|
Creating Custom Numbers Templates |
|
|
829 | (8) |
|
Anatomy of a Numbers Template |
|
|
830 | (1) |
|
Building Your Own Template |
|
|
831 | (6) |
|
|
|
831 | (1) |
|
Changing Standard Object Styles |
|
|
832 | (1) |
|
|
|
833 | (1) |
|
Creating the Template Content |
|
|
833 | (1) |
|
Saving and Organizing Your Templates |
|
|
834 | (3) |
|
|
|
| Appendix A: Installing and Upgrading iWork |
|
837 | (4) |
| Index |
|
841 | |
Lisainfo e-raamatute kohta